Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Linked server b/w sql server 2005 and 2008
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Constraint Violating Yak Guru

498 Posts

Posted - 01/21/2013 :  15:05:55  Show Profile  Reply with Quote

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?

Posting Yak Master

160 Posts

Posted - 01/21/2013 :  20:34:19  Show Profile  Reply with Quote
We cannot establish link server connection from a lower version to higher version, it gives compatibility error.
Go to Top of Page

Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 01/22/2013 :  10:01:44  Show Profile  Visit jackv's Homepage  Reply with Quote
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
Go to Top of Page

Starting Member

2 Posts

Posted - 01/22/2013 :  10:16:01  Show Profile  Reply with Quote
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]
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

Constraint Violating Yak Guru

498 Posts

Posted - 01/22/2013 :  10:52:54  Show Profile  Reply with Quote
HI Robert,

I think it is kerberos/SPN issue. Do you have some steps how to resolve it?

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000