SQL Server Connectivity Error - SQL Server Forums

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

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Server Connectivity Error

Author

Topic

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2009-07-01 : 19:00:32

Hi Guys,

I am getting this error very frequently , when i am getting connected to SQL Server from command line. But iam able to connect to the Instance using Management Studio with any problems.

Check the ErrorLog but could'nt figure out what is the actual problem.

Can anybody explain how to fix this problem?

Here is the error what am getting!!

C:\>net start mssql$sql_02
The requested service has already been started.

More help is available by typing NET HELPMSG 2182.

C:\>sqlcmd -Smssql$sql_02 -E
HResult 0x35, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [53].
Sqlcmd: Error: Microsoft 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..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

C:\>

Thanks in Advance.

ahmad.osama
Posting Yak Master

183 Posts

Posted - 2009-07-02 : 02:53:52

quote:
Originally posted by frank.svs

Hi Guys,

I am getting this error very frequently , when i am getting connected to SQL Server from command line. But iam able to connect to the Instance using Management Studio with any problems.

Check the ErrorLog but could'nt figure out what is the actual problem.

Can anybody explain how to fix this problem?

Here is the error what am getting!!

C:\>net start mssql$sql_02
The requested service has already been started.

More help is available by typing NET HELPMSG 2182.

C:\>sqlcmd -Smssql$sql_02 -E
HResult 0x35, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [53].
Sqlcmd: Error: Microsoft 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..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

C:\>

Thanks in Advance.

set remote connections in surface are management.

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2009-07-07 : 13:17:41

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources