Problem with connection to sql server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Problem with connection to sql server

Author

Topic

mierdatuti
Starting Member

4 Posts

Posted - 2008-11-24 : 16:30:02

Hi,

I have installed a database microsoft sql server 2005 on my server.
I would like to connect from ms-dos (locally) on my server but it says me:

C:\Documents and Settings\Administrador>osql -U emuser -P temporal
[SQL Native Client]Named Pipes Provider: Could not open a connection to SQL
Server [2].
[SQL Native Client]Login timeout expired
[SQL Native Client]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

Any help?
Many thanks and sorry for my english!

pbguy
Constraint Violating Yak Guru

319 Posts

Posted - 2008-11-24 : 22:55:19

1. Go to Confguration manager (start -> Programs - MS SQl server 2005 ->Configuration Tools -> SQL server Configuration Manager)
2.For SQL server Network and Clien Configuration , enable the NamedPipes protocol.

--------------------------------------------------
S.Ahamed