无法使用SQL Server管理工作室连接到数据库引擎

时间:2021-03-22 01:43:59

I installed SQLManagementStudio_x64_ENU from Microsoft site on my Windows 7 Home Premium. It gave me compatibility warnings but I still installed because Microsoft site specified that I would receive warnings but suggested to click on Run Program, which I did.

我在Windows 7 Home Premium上从Microsoft站点安装了SQLManagementStudio_x64_ENU。它给了我兼容性警告,但我仍然安装,因为微软网站指定我会收到警告,但建议点击运行程序,我做了。

It was successfully installed. I checked Services.msc, and I can see two SQL Server services are running. I checked SQL Server Configuration, and I can see services running under automatic mode, and the agent is off.

它已成功安装。我检查了Services.msc,我可以看到两个SQL Server服务正在运行。我检查了SQL Server配置,我可以看到在自动模式下运行的服务,并且代理已关闭。

When I open my management studio and try to connect using "Server name" option, I can't see any server instance in browse option. There are no servers to connect. I am not able to connect to the database engine. I have tried at least 10 times, but still, it's not allowing me to connect.

当我打开管理工作室并尝试使用“服务器名称”选项进行连接时,我在浏览选项中看不到任何服务器实例。没有要连接的服务器。我无法连接到数据库引擎。我已经尝试了至少10次,但仍然不允许我连接。

I get the following error:

我收到以下错误:

A network-related or instance-specific error occurred while establishing a 
connectionto 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)

允许远程连接。 (提供程序:命名管道提供程序,错误:40 - 无法打开与SQL Server的连接)(。Net SqlClient数据提供程序)

Can someone help me with this problem?

有人可以帮我解决这个问题吗?

1 个解决方案

#1


2  

In the Connect to server dialog of the SQL Server Management Studio (SSMS), type <your machine name>\SQLServer2008 to connect to SQLServer2008 instance. Otherwise, type <your machine name> alone in the server name text box to connect to the default instance SQLExpress.

在SQL Server Management Studio(SSMS)的“连接到服务器”对话框中,键入 <您的计算机名称> \ SQLServer2008以连接到SQLServer2008实例。否则,在服务器名称文本框中单独键入 <您的计算机名称> 以连接到默认实例SQLExpress。

Following link discusses how to fix the error Microsoft.SqlServer.Management.Dmf.PolicyStore

以下链接讨论了如何修复错误Microsoft.SqlServer.Management.Dmf.PolicyStore

SSMS 2008 on Windows 7 throws exception when connecting Object Explorer

连接对象资源管理器时,Windows 7上的SSMS 2008会抛出异常

#1


2  

In the Connect to server dialog of the SQL Server Management Studio (SSMS), type <your machine name>\SQLServer2008 to connect to SQLServer2008 instance. Otherwise, type <your machine name> alone in the server name text box to connect to the default instance SQLExpress.

在SQL Server Management Studio(SSMS)的“连接到服务器”对话框中,键入 <您的计算机名称> \ SQLServer2008以连接到SQLServer2008实例。否则,在服务器名称文本框中单独键入 <您的计算机名称> 以连接到默认实例SQLExpress。

Following link discusses how to fix the error Microsoft.SqlServer.Management.Dmf.PolicyStore

以下链接讨论了如何修复错误Microsoft.SqlServer.Management.Dmf.PolicyStore

SSMS 2008 on Windows 7 throws exception when connecting Object Explorer

连接对象资源管理器时,Windows 7上的SSMS 2008会抛出异常