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会抛出异常