Network Protocols Configuration in SQL Server Express
Posted by decipherinfosys on October 12, 2007
SQL Server Express Edition is typically used in those applications which access data locally i.e. the SQL Server Express Edition is installed on the same machine where the application is running. Because of this, the “Shared Memory” protocol is the only one that is enabled by default. However, if you have an application that needs to connect to the SQL Server Express Edition Instance from outside of that machine, you would need to enable the other protocols namely: TCP/IP and/or Named Pipes. VIA (Virtual Interface Architecture) is not supported for this edition.
If you know before-hand at the time of the installation that you would need this support, you can run setup.exe from the command line and use the parameter “DisableNetworkProtocols=0” to enable the TCP/IP and the Named Pipes network protocols. If you need to do it after the install is done, then you can do so from SQL Server Configuration Manager.
In the two images shown above, you can see that the TCP/IP and the Named Pipes protocols are disabled by default. You can right click and choose properties and enable it and do further configuration if you need to. Re-start the services and you will be in business. And you should also start up the SQL Server Browser Service. You can do so either from the services panel (start/run and then services.msc and then enter) and then look for SQL Server Browser service or you can start it using the SQL Server Configuration Manager by using the SQL Server 2005 Services panel. We will cover the importance of the SQL Server Browser service in one of the upcoming blog posts.
Sorry, the comment form is closed at this time.