Saturday, September 15, 2012

Enabling Remote Connections for MSsql

unable to connect with sql server remotely (using sql developer or other jdbc connections)

 “Cannot connect to SQL-Server-Instance-Name
Login failed for user ‘username‘.

1.Open SQL Server Configuration Manager.
         Click Start -> Programs -> Microsoft SQL Server 2008 -> Configuration Tools ->SQL Server   Configuration Manager.
2.Start sqlserver services.
3.On the left window, expand SQL Server Network Configuration -> Protocols for                                  SQLEXPRESS. You see that TCP/IP protocol status is disabled.
4.Right-click on TCP/IP and select Enable to enable the protocol.
5.There is a pop-up shown up that you have to restart the SQL Service to apply changes.
6.On the left window, select SQL Server Services. Select SQL Server (SQLEXPRESS) on the right window -> click Restart. The SQL Server service will be restarted.

No comments:

Post a Comment

web stats