July 21, 2008 at 2:02 pm
I am having trouble getting an SQL2000 server (Windows2000) to link to Sql2005 server (Standard) running on Windows2003 Server. Linking to Sql2005 on a Windows XP pro computer works just fine.
Can anyone help?
July 21, 2008 at 2:37 pm
I had to solve that once. I think it was a permissions issue, but I'm not sure. Check that out, and hopefully someone who's solved this more recently than 2 years ago will come along if that doesn't work.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 21, 2008 at 6:15 pm
I had a similar problem, also two years ago. Unfortunately, my recall is worse than Gus's, but I do remember that I had to pitch Window's authentication and use explicit SQL logins that I made specifically for this.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 22, 2008 at 11:40 am
Yeah, that solution sounds familiar. I think I did the same.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 23, 2008 at 7:50 am
Hi,
I have created a linked server recently from SQL server 2005 to SQL server 2000. Can you give some more information on where exactly you are having the problem?
Regards,
Prakash
---------------------------------------------------------------------------------
July 23, 2008 at 12:19 pm
I have Sql2000 on a Window2000 operating system. (1) I also have Sql2005 operating on a Windows XP machine (2) and also on a Windows 2003 Server machine (3).
Links:
1 to 2 OK
1 to 3 Does not work.
2 to 1 OK
2 to 3 OK
3 to 1 OK
3 to 2 OK
On 1 to 3 I get this msg: Error 17:SQL Server does not exist or access denied.
All connections use SQL security.
I can connect from 1 to 3 just fine using the Query Analyzer or with an ODBC.
The linked server just won't connect.
Any help is greatly appreciated.
July 23, 2008 at 12:32 pm
What account is it using? Can you logon to (1) in that account and connect to (3) yourself with SSMS or EM?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 23, 2008 at 12:56 pm
All three logon to SQL as "sa" with a password. I'm not sure what SSMS or EM is?
July 23, 2008 at 1:24 pm
SSMS = SqlServer Management studio
EM = Enterprise Manager
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply