SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

Peter99
Constraint Violating Yak Guru

481 Posts

Posted - 01/21/2013 :  15:05:55  Show Profile  Reply with Quote
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 - 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

jackv
Flowing Fount of Yak Knowledge

United Kingdom
1912 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
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

Robert.haack
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]
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

481 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?

Thanks
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.05 seconds. Powered By: Snitz Forums 2000