SQL Server 2008 R2的连接问题
大家好:)
尝试连接到SQL Server数据库时收到此消息
如何解决呢? :\
无法连接到MSA-PC \ MSASQL.
------------------------------
其他信息:
建立与SQL Server的连接时发生与网络相关或特定于实例的错误.服务器未找到或无法访问.验证实例名称正确,并且已将SQL Server配置为允许远程连接. (提供程序:TCP提供程序,错误:0-无法建立连接,因为目标计算机主动拒绝了它.)(Microsoft SQL Server,错误:10061)
谢谢大家
hi all :)
I got this message when I tried to connect to my sql server data base
how to fix it ? :\
Cannot connect to MSA-PC\MSASQL.
------------------------------
ADDITIONAL INFORMATION:
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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)
thank you all
此错误表示
要么您提供了错误的凭据
或您无权访问该服务器.
This error means that
either you are giving wrong credentials
or you have no permission to access that server.
我在这里找到了答案:
转到配置管理器,然后在左窗格中展开SQL Server服务.然后在右窗格中选择"SQL Server服务",然后单击右键,然后单击开始...".
谢谢大家
I found the answer here:
Go to Configuration Manager and expand SQL Server services on the left pane. Then on the right pane select SQL Server service right click and the Start......
thank you all