User sets up a new connection but gets the following error when trying to connect in Spotlight on SQL Server...
1707 - network address invalid
This can happen for the following reasons:
1. If the name of the server is in the form "myserver.domain.com".
2. If the name of the Windows server the database is on has changed.
Resolution for #1
-----
First open a command prompt and enter 'ping myserver'.
If you get a response from the server, please note the IP address.
If you do not get a response, then try 'ping myserver.domain.com'
Again, please note the IP address.
** (If niether of these work consult your network administrator)
To resolve the error, please edit the "hosts" file with Notepad and add an alias for the host name using only the "server" name. In Windows2000 it should be in the following directory...
C:\WINNT\system32\drivers\etc
Your entry should look something like this...
192.168.17.22 myserver
You should now be able to connect with Spotlight on SQL Server.
This can happen for a few reasons...
1. If the name of the server is in the form "myserver.domain.com".
2. If the name of the Windows server the database is on has changed.
Resolution for #2.
-----
Open Query Analyzer and run the following...
select @@servername;
This is the name of the server the database has stored.
If this is different than the actual server name of your Windows Server, then do the following in Query Analyzer...
exec sp_dropserver '<WrongServerName>'
go
exec sp_addserver '<CorrectServerName>', local
go
You will need to stop and restart the MSSQLServer service for this change to take effect.
You should now be able to connect with Spotlight on SQL Server.
