StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Deploy to Server

Deploy to Server

Rafael — Fri, 05 Sep 2008 16:28:15 GMT

Why Dont found SqlServer ?

RE: Deploy to Server

StrataFrame Team — Fri, 05 Sep 2008 16:28:15 GMT

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

RE: Deploy to Server

Greg McGuffey — Fri, 05 Sep 2008 11:40:49 GMT

I think it only finds instances on the local machine. I always just type the server\instance in.

RE: Deploy to Server

Edhy Rijo — Fri, 05 Sep 2008 11:38:08 GMT

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.