469,899 Members | 1,435 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,899 developers. It's quick & easy.

Error when connecting remote SQL SERVER


I have been assigned to make a database in some remote machine.The machine has MSSQL 2005.I need to connect to that remote machine's sql server via my pc using my SQL Management express.I do have that computer's IP address(say,123.456.789.000),and the username and password.But when i try to connect to the server ,I get the following error:

Cannot connect to 123.456.789.000\sqlexpress

An error has occured while establishing a connection to the server.When connecting to SQL server 2005,this failure may be caused by the fact that unser the default settings SQL server does not allow remote connections,(provider: SQL Network Interfaces,error:26-Error Locating Server/Instance specified)(Microsoft SQL Server)

I am a new programmer and dont know much.But i guess the problem is not in my server but in that server to which i am trying to connect.I guess that server has some instance created or it does not allow remote connections.But i am not sure.Is it so?Or is anything wrong in my server.Any ideas?
Oct 4 '07 #1
1 1495
Shashi Sadasivan
1,435 Expert 1GB
IF you put these errors into a search engine you should get a series of answers.
Anyhows...check this out.

I faced this issue , found out that I was under the Vista client category.

Oct 4 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by John Shadel | last post: by
5 posts views Thread by James | last post: by
1 post views Thread by NEWS | last post: by
8 posts views Thread by =?Utf-8?B?U3JpcmFtIE1hbGxhanlvc3VsYQ==?= | last post: by
13 posts views Thread by AAaron123 | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.