Hia,
A newbie developer looking for some help from the experts, hope i get the problem resolved.
I am trying to use the SQL Server Management Studio Express to connect my MS SQL Server database of my
website hosting which is hosted on 91.186.30.8
Now while tring to connect using the following details; (correct me if i am wrong)
Server name: 91.186.30.8\SQLEXPRESS
Authentication: SQL Server Authentication
Login: LoginID (of database)
Password: Password (of database)
-----------------------------------------------------
I am getting the following error:
Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Server Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
-----------------------------------------------------
Please revert and let me know what is the best possible solution for the same.
Thanks,
Mike...