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 .
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.