November 29, 2004 at 7:21 am
I recently created a new domain, then I moved the SQL 2000 and SQL 7 servers we have into that domain.
I am sure that this is a common problem, but I wasted 6 hours last night trying to fix it.
The SQL 2000 had a linked server connecting to a DB on the sql7 box. The link server quit working. I tried to recreate it and when I try to view the properties of it, they are blank.
I am getting the 'Error 17, Server does not exist or access denied' error. It is really weird because they worked fine before the move. We are using only SQL authentication even though the servers are set for mixed.
The Windows part of them talk just fine, it is just the sql part. I even put SP3 on the SQL2000 box to see if it'd help. No luck.
The only thing that changed on these boxes was the doamin membership.
Any help is appreciated.
Thanks in advance.
November 30, 2004 at 9:24 am
I think this is a name resolution problem. Check all network settings, WINS, DNS ect. Try to ping from both servers each other by the name. If ping will not be successful - name resolution is the problem.
November 30, 2004 at 9:44 am
Well, like stated before, the Windows part of the servers communicated just fine, but SQL did not. You could ping, browse, map drives, all that stuff, just not connect to another sql server using linked servers.
Anyway, I fixed the issue last night by installing the MDAC 2.8 on all servers in question.
After the install, they worked as they were supposed to.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply