MS SQL Server cannot connect to server
Question
-
I'm using SQL Server 2014 Express, I often encounter problems when connecting to Server. Help me please with tips and advices
- Modifié Jean Tshishimbi lundi 10 octobre 2016 14:35
Réponses
-
Hi Jean:
Below 5 different Ways to Start SQL Server Services
Windows Services
This is one of the most common way used by all DBAs. Top open services applet, we can either go to start > Run and type services.msc or by using the Windows Start, Programs, Administrative Tools, Services menu. Then, double-click (or right click) the MSSQLServer service, and right-click the required action. If we want to start a SQL Server named instance, look for the service called SQL Server (Instance Name). Let’s say our machine has named instance called SQL2014 then we would see SQL Server (SQL2014), as shown below:
If we wish to add some startup parameter, we can do that by going to properties and click on start.
The Net Start Command
Methods so far are the one to use User Interface, but we can also use the Net Start command. Type net start mssqlserver at the command prompt. To start a named instance, type net start MSSQL$instancename. In below command prompt, I have started default instance.
If we want to add additional startup parameters, we can append them in the command. For example, if we want to start SQL in single user mode then we can add /m as below
net start mssqlserver /m
If we want to use trace flag (let’s say Trace Flag 3608) then we can run below.
net start mssqlserver /T3608
We can also combine multiple startup parameter by appending them on same line.
Using Sqlservr.exe executable.
We can also use sqlservr.exe to start SQL Server when we want to enable debugging or troubleshoot etc. To start an instance of SQL Server, we must run the sqlservr.exe program from the \binn directory, where the SQL Server binary files are stored by default.
We have given -s parameter and given instance name to start particular instance. For default instance, we need to provide MSSQLSERVER. For complete list of startup parameters refer book online. http://technet.microsoft.com/en-US/library/ms190737.aspx
SQL Server Configuration Manager
This is the best way to control the services because we are using the tool which is designed for this purpose. Start > Programs > Microsoft SQL Server (version) > Configuration Tools > SQL Server Configuration Manager. Once we click on SQL Server Services on left, we can see all services on right pane. Then we can right-click SQL Server (MSSQLServer), and then choose required action. A green icon next to the server name and indicates that the service is running.
This tool can’t be used to control remote SQL Services.
AK
AO
L’information n’a de valeur que si elle est partagée!! AK |Mon Blog|
- Marqué comme réponse Jean Tshishimbi mardi 11 octobre 2016 07:37
-
Hi jean Tshishimbi,
Please can you check the rule in your local firewall? if the port SQL is Allow
SQL Server Network Configuration is set?
Héritier KANDOLO. Microsoft Certified Professional MCPs: Windows Server 2012 r2, MTA Windows Server Administration Fundamentals, MTA Networking Fundamentals. http://www.rootandadmin.com/
- Proposé comme réponse Heritier Kandolo mardi 11 octobre 2016 04:47
- Marqué comme réponse Jean Tshishimbi mardi 11 octobre 2016 07:52
Toutes les réponses
-
Hi Jean:
Below 5 different Ways to Start SQL Server Services
Windows Services
This is one of the most common way used by all DBAs. Top open services applet, we can either go to start > Run and type services.msc or by using the Windows Start, Programs, Administrative Tools, Services menu. Then, double-click (or right click) the MSSQLServer service, and right-click the required action. If we want to start a SQL Server named instance, look for the service called SQL Server (Instance Name). Let’s say our machine has named instance called SQL2014 then we would see SQL Server (SQL2014), as shown below:
If we wish to add some startup parameter, we can do that by going to properties and click on start.
The Net Start Command
Methods so far are the one to use User Interface, but we can also use the Net Start command. Type net start mssqlserver at the command prompt. To start a named instance, type net start MSSQL$instancename. In below command prompt, I have started default instance.
If we want to add additional startup parameters, we can append them in the command. For example, if we want to start SQL in single user mode then we can add /m as below
net start mssqlserver /m
If we want to use trace flag (let’s say Trace Flag 3608) then we can run below.
net start mssqlserver /T3608
We can also combine multiple startup parameter by appending them on same line.
Using Sqlservr.exe executable.
We can also use sqlservr.exe to start SQL Server when we want to enable debugging or troubleshoot etc. To start an instance of SQL Server, we must run the sqlservr.exe program from the \binn directory, where the SQL Server binary files are stored by default.
We have given -s parameter and given instance name to start particular instance. For default instance, we need to provide MSSQLSERVER. For complete list of startup parameters refer book online. http://technet.microsoft.com/en-US/library/ms190737.aspx
SQL Server Configuration Manager
This is the best way to control the services because we are using the tool which is designed for this purpose. Start > Programs > Microsoft SQL Server (version) > Configuration Tools > SQL Server Configuration Manager. Once we click on SQL Server Services on left, we can see all services on right pane. Then we can right-click SQL Server (MSSQLServer), and then choose required action. A green icon next to the server name and indicates that the service is running.
This tool can’t be used to control remote SQL Services.
AK
AO
L’information n’a de valeur que si elle est partagée!! AK |Mon Blog|
- Marqué comme réponse Jean Tshishimbi mardi 11 octobre 2016 07:37
-
Hi jean Tshishimbi,
Please can you check the rule in your local firewall? if the port SQL is Allow
SQL Server Network Configuration is set?
Héritier KANDOLO. Microsoft Certified Professional MCPs: Windows Server 2012 r2, MTA Windows Server Administration Fundamentals, MTA Networking Fundamentals. http://www.rootandadmin.com/
- Proposé comme réponse Heritier Kandolo mardi 11 octobre 2016 04:47
- Marqué comme réponse Jean Tshishimbi mardi 11 octobre 2016 07:52
