question

mcrq123 avatar image
mcrq123 asked

Connecting between versions SQL

Having an issue connecting SQL Express 2008 R2(Version 10.50.4033) with SQL Server 2008 R2 (Version 10.50.1600). Am I able to make a connection to Express from SQL Server ? I am able to back up and restore to Server but cannot make a connection between from Server to Express but can go Express to Server. Any body any ideas thanks
sql-server-2008-r2sql-server-2008-r2-express
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
What are you trying to do? Make a linked server connection? an ad-hoc OPENROWSET query?
1 Like 1 ·

2 Answers

·
DenisT avatar image
DenisT answered
Have you seen this article? -- http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnSterrett avatar image
JohnSterrett answered
Assuming you are using linked server for you connection make sure the bits are the same on both editions. For example, if Express is 32bit and other instance is 64bit that Link Server connections won't play nice. Here is a good thread on this. http://www.sqlservercentral.com/Forums/Topic847626-149-1.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.