[dba-SQLServer] SQL Server not in list of servers

Gustav Brock Gustav at cactus.dk
Tue May 13 11:22:28 CDT 2008


Hi John

Maybe the upgrade has turned of the option (reset it to default) that allows external connections?

Or you may need - in the manager - to type in the IP address of Stonehenge for a beginning.

/gustav

>>> jwcolby at colbyconsulting.com 13-05-2008 18:10 >>>
I just upgraded Stonehenge, my main server to Windows 2003 x64 / SQL 
Server x64.  This morning I tried to do a copy database, which I have 
done dozens of times before and now it says that the "destination server 
is not running", the destination server being (default).

Further if I go into the list of servers combo, either source or 
destination, it does not show Stonehenge in the list of servers, though 
it does show Stonehenge / SQL Express and M90.  To my knowledge M90 (my 
laptop) is not running SQL Server at the moment.  So the

So it appears that the list of available servers is not correct.  I 
thought that the SQL Browser service was responsible for finding 
instances of SQL Server, and that service is running.

Any idea what might be going on or how to determine what is going on?

-- 
John W. Colby
www.ColbyConsulting.com 





More information about the dba-SQLServer mailing list