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‘.
Step-by-step
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.
“Cannot connect to SQL-Server-Instance-Name
Login failed for user ‘username‘.
Step-by-step
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