Database restore on new server

[hcts]

Hi,

I have setup another server for a client that includes a SQL2000 server setup. The server name is NTSERVER and the database is current. I have setup the server and applied SP4 and detached the database and copied it over and reattached it to the new server.

My problem is that the new server has named the SQL server "local" instead of NTSERVER. This client uses an app that searches for the SQL server and attaches to it. When I am on the server the app finds it as "local" but none of the workstations can see it. Everything else seems to be the same so I am trolling for ideas.

Thanks,

James D. Howard

 

[mrdenny]

When you install SQL Server Enterprise Manager automatically sets up (Local) as a registered server. This is the local server that you are on not the server name. Use the actual server on the clients.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[hcts]

Thanks for the response,

I have already somewhat isolated the problem to a DNS issue. When I am trying to connect from the clients I can not by using the SQL server name, but I can by using the IP address. Do I need to put in a reverse lookup in my DNS to resolve this or what?

Thanks,

James D. Howard

 

[mrdenny]

If you can connect by IP and not by name then you need to put in a forward dns entry not a reverse dns entry.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[hcts]

Well thanks again, it's great to be able to find knowledge when you need it. It turned out to be the DNS setting on the DHCP server was not including the primary server for DNS lookups.

James D. Howard