Friday, February 10, 2012

Cannot find my SQL Server

I have installed SQL Express in my server with SQL Browser enabled. I also added an exception to the window firewall to port 1433.

My client application is installed in another machine on the same workgroup. But I cannot see the SQL Express unless I disabled the server's firewall.

Without disabling the firewall, what else should I do?

Thanks

sqlexpress is a named instance of sqlserver. thus, it does not listen on tcp 1433 by default. you can follow the below article to configure sqlexpress for accepting remote connect through the firewall.
http://support.microsoft.com/kb/914277|||If it would be on port 1433 you wouldn′t need the SQL Browser as the client always assumes this dfault port. SQL Browser is for routing the request to the appopiate port which *could* be port 1433. But the port can differ from 1433 as there can be many instances hosted on the same server, every instance taking one TCP port.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||By default, when any version of SQL Server 2005 is installed it will not talk to the network. You must use the SQL Server Configuration Manager and enable TCP/IP to talk to the network.|||See my screencast section on my site for more information.

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de|||

I have done the following, but still cannot find my SQL Server 2005 Express installed on WinXP Prof.(SP2) server, My server only has one instance named "AppDefault"

Enable local and remote connections(in Surface Area Configuration for Services and Connections) on the instance of SQL Server that I want to connect to.

No comments:

Post a Comment