April 25, 2013 at 11:27 pm
I started sql server instance using single user mode by changing start up parameters in sql server configuration manager.Then when i try to connect to sql server in command line using "sqlcmd -s pcname\instancename" i get following error. So how to solve this?
HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server [2]. Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or in stance-specific error has occurred while establishing a connection to SQL Server . Server is not found or not accessible. Check if instance name is correct and i f SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.. Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.
April 26, 2013 at 1:11 am
By default SQL Server 2005 has TCP/IP connections disabled. To enable TCP/IP support, use the SQL Server Configuration Manager tool, select SQL Server 2005 Network Configuration, select Protocols, double-click on TCP/IP, and turn on Enabled.
AND
By default SQL Server 2005 has Named Pipes connections disabled. To enable Named Pipes support, use the SQL Server Configuration Manager tool, select SQL Server 2005 Network Configuration, select Protocols, double-click on Named Pipes, and turn on Enabled.
April 26, 2013 at 1:54 am
I already have tcp/ip and namedpipes enabled. So it is no the error i think.
April 26, 2013 at 3:22 am
To fix this problem I did change the Named pipe value from below \\.\pipe\MSSQL$SQLEXPRESS\sql\query to
\\.\pipe\sql\query using SQL Server Configuration Manager.
April 26, 2013 at 6:49 am
Below this may help you..
As of my knowledge before going to start SQL server in single user mode first we need to stop the server and start the server through command prompt by using
----Net start mssql$name of the instance /m
or it is a default instance
net start mssqlserver /m
April 26, 2013 at 6:49 am
Below this may help you..
As of my knowledge before going to start SQL server in single user mode first we need to stop the server and start the server through command prompt by using
----Net start mssql$name of the instance /m
or it is a default instance
net start mssqlserver /m
April 26, 2013 at 6:50 am
Below this may help you..
As of my knowledge before going to start SQL server in single user mode first we need to stop the server and start the server through command prompt by using
----Net start mssql$name of the instance /m
or it is a default instance
net start mssqlserver /m
April 26, 2013 at 6:51 am
Below this may help you..
As of my knowledge before going to start SQL server in single user mode first we need to stop the server and start the server through command prompt by using
----Net start mssql$name of the instance /m
or it is a default instance
net start mssqlserver /m
April 26, 2013 at 8:37 am
You can use -m switch in sqlcmd.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply