Non-existent SQL servers showing up in Server dropdown

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Non-existent SQL servers showing up in Server dropdown

Postby bringland » Mon Aug 19, 2013 11:51 pm

I apologize is this is a duplicate but I did a search and couldn't find a similar issue. With SQL Compare version (10.4.8.87) there are several servers in the drop-down list that no longer exist on the netwrok. I have cleaned out any and all registry entries for these items & rebooted but no avail. What am I missing? Thanks in advance.
bringland
 
Posts: 2
Joined: Mon Aug 19, 2013 11:43 pm

Postby Brian Donahue » Thu Aug 22, 2013 11:48 am

Red Gate SQL Tools call the NetServerEnum function in windows to get a list of SQL Servers from the network:
http://msdn.microsoft.com/en-us/library ... 23(v=vs.85).aspx

It doesn't say so but I assume this means you have some SRV records in your DNS that identify some SQL Servers.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby bringland » Thu Aug 22, 2013 5:02 pm

Thanks for the info. I will review with Network team and get the obsolete servers removed and retry the list of servers.
bringland
 
Posts: 2
Joined: Mon Aug 19, 2013 11:43 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests