Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.
Solved
SQL - errir connect to SQL Server
Posted on 2013-01-25
I just install a SQL Server 2008 R2 on a VM. As I try to login, I got the following error message. I check the Task Manager (See file attached). SQL Server is running. Does anyone can tell me what is the problem?
Thanks.
==========================
Cannot connect to TempoTangoSQL.
==========================
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
--------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476
--------------------------
Error Number: 53
Severity: 20
State: 0
--------------------------
Program Location:
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlC
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.SqlClient.SqlC
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
Capture01.PNG
Thanks.
==========================
Cannot connect to TempoTangoSQL.
==========================
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
--------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476
--------------------------
Error Number: 53
Severity: 20
State: 0
--------------------------
Program Location:
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlC
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.SqlClient.SqlC
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
Capture01.PNG
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
3
7 Comments
Active today
I believe you have to enable remote connections, TCP/IP connections, and SQL Authentication. And you need to create a user other than 'sa' to connect with. It is not recommended to use 'sa' because it has the highest privileges and can do anything.
In SSMS, the Properties page for the server let you set Enable Remote Connections and on the Security tab, you can enable SQL Authentication.
In the SQL Server Configuration Manage, you can set the IP addresses and port number you need to use.
You also need to enable the 'sqlbrowser.exe' service if you are trying to connect by 'named instances'.
In SSMS, the Properties page for the server let you set Enable Remote Connections and on the Security tab, you can enable SQL Authentication.
In the SQL Server Configuration Manage, you can set the IP addresses and port number you need to use.You also need to enable the 'sqlbrowser.exe' service if you are trying to connect by 'named instances'.
Active today
I cannot even able to login yet. Hence, I can not get to the property of the server instance.
(See Capture02.png)
I try to browse for server name, nothing appear in Local or Network (See Capture03,png)
I have enable the NamePiped of SQL Server Network Configuration.
I did stop and restart the SQL Server. Problem still exists.
Capture02.PNG
Capture03.PNG
(See Capture02.png)
I try to browse for server name, nothing appear in Local or Network (See Capture03,png)
I have enable the NamePiped of SQL Server Network Configuration.
I did stop and restart the SQL Server. Problem still exists.
Capture02.PNG
Capture03.PNG
Active today
Sorry forget to attach in the above post
Capture04.PNG
Capture04.PNG
Active today
On my machine in the login for SSMS, the servername is shown as "MACHINENAME\SQLSERVERNAME
Featured Post
This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
How to fix incompatible JVM issue while installing Eclipse
While installing Eclipse in windows, got one error like above and unable to proceed with the installation.
This video describes how to successfully install Eclipse.
How to solve incompa…
Suggested Courses
Course of the Month8 days, 8 hours left to enroll
721 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.