StrataFrame Forum

Deploy to Server

http://forum.strataframe.net/Topic19110.aspx

By Rafael - 9/5/2008

Why Dont found SqlServer ?
By Edhy Rijo - 9/5/2008

Rafael,

I believe that form relies on the SQL Server Agent to be running to find the SQL servers instance.  Also I think you can type in your SQL Server instance name there too.

By Greg McGuffey - 9/5/2008

I think it only finds instances on the local machine. I always just type the server\instance in.
By StrataFrame Team - 9/5/2008

It will broadcast to the network to find services listening on TCP 1433, which is generally your SQL Server instance, or the SQL Browser Service if you have more than one instance running on the machine.  It's code that is part of Microsoft SMO, so we're not in control of the network traffic; we just call a method, and it enumerates the servers for us. 

So, some things that can kill the process of broadcasting to the network are:

1) SQL Server Browse services not running, so therefore, won't respond

2) Firewalls (on your own machine, too) that block the broadcast requests

3) Servers not on your local network (IP subnet) will never be found since an IP broadcast doesn't get routed