How to connect MSSQL database with MS SQL Management studio

[mike_01]

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 database of my website 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 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...

[flesso]

Hi,

Please email 'windows [at] eukhost.com' regarding this. This is something which needs to be set on the server and can only be done via a ticket.

Thanks.

[mike_01]

Okie Flesso,

Though i did emailed at windows @ eukhost.com and have also raised a ticket.

Thanks

[mike_01]

Got it resolved.

Thanks

[flesso]

Originally Posted by mike_01

Got it resolved.

Thanks

Glad to hear it.

/thread

[Rock]

Ok... The fix was that the MSSQL instance installed on KingAir is 91.186.30.8 [ie: without the \SQLEXPRESS part]