Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2013-01-21 : 15:05:55
|
| Hi,How to create linked server between sql server 2005 (9.0.5069) to sql server 2008 (10.0.5512). Any link?During linked server creation when I clicked "be made using the logn's current security context" there is error "Anonymous login failed" Any help? |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-01-21 : 20:34:19
|
| We cannot establish link server connection from a lower version to higher version, it gives compatibility error. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-01-22 : 10:01:44
|
| Go to the Security Context window, and apply appropriate security. Make sure the security is set on the target server. It is possible to create a Linked Server from 2005 to 2008Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
Robert.haack
Starting Member
2 Posts |
Posted - 2013-01-22 : 10:16:01
|
| This will work as I have several that link from 2005 to higher versions including 2012. Here is how I have things set.Linked Server: Whatever Name you wantProvider: SQL Native ClientProduct Name: sql_serverData Source: [insert your Server\instance here]Provider: Location:Catalog: [insert your database name here or leave it blank]If this does not work then try one first. If you can log onto the SQL server and test the link from there. If it works from the server but not your workstation then you are having a Kerberos/Double hop issue. Let me know and I think I can help with that as well but you will need a server admin to actually do the fix unless you have Domain Admin rights. |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2013-01-22 : 10:52:54
|
| HI Robert,I think it is kerberos/SPN issue. Do you have some steps how to resolve it?Thanks |
|
|
|
|
|
|
Linked server b/w sql server 2005 and 2008