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
 General SQL Server Forums
 New to SQL Server Programming
 Problem registering SQL Server

Author  Topic 

vaddi
Posting Yak Master

145 Posts

Posted - 2007-05-01 : 15:39:50
Hello

I am trying to register a SQL Server 2000 on a client machine. It was workig fine , until yestarday when he moved and got a different system IP. But one of the SQL Server 'A' is getting connected. But when I try to register the server 'B' its giving an error " SQL Server does not exist or access denied". I am giving correct login credintels. When I tried to ping ( using cmd) the Server 'B' , the system was able to connect.

What might be the problem.

Thanks for the help.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-01 : 15:52:54
Able to register it with ip address instead of host name? Which netlib did you use to connect to it?
Go to Top of Page

vaddi
Posting Yak Master

145 Posts

Posted - 2007-05-01 : 16:04:35
I did not register with the IP. I was able to ping the server by giving the ip address in the command line.

And the netlib , I have used was tcp/ip. ( I am not sure , both named pipes and tcp/ip are present when I check the client network utility - network libraries.)

Thanks
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-02 : 09:53:13
Try register with ip address. If works, you have dns and/or wins issue on your network. Ensure sql port is open when use tcp/ip netlib.
Go to Top of Page
   

- Advertisement -