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.
| Author |
Topic |
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2007-05-01 : 15:39:50
|
| HelloI 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? |
 |
|
|
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 |
 |
|
|
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. |
 |
|
|
|
|
|