Thursday, 28 February 2013

Error while connecting to Remote SQLEXPRESS

Today i installed SQLEXPRESS in a VM, and tried accessing it thru SQL Studio that was installed on different machine. It throws me one of those connection error. So I did two things

Go to SQL Server Configuration Manager

1. Start 'SQL Server Browser' service, if not already started.
2. Enable TCP/IP for SQLEXPRESS('Protocols for SQLEXPRESS).

Restart the SQLEXPRESS service. It worked for me:)

No comments: