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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Linked server b/w sql server 2005 and 2008

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.
Go to Top of Page

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 2008

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

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 want
Provider: SQL Native Client
Product Name: sql_server
Data 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.
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -