I am on the verge of completing a project and I am stuck on establishing database connection with SQL Server. I have installed SQL Server Management Studio 2005 and whenever I try to make query from Client system to Server Server, it gives an error of Access Denied. Any idea on what the error can be?
我马上就要完成一个项目了，而且我还在与SQL Server建立数据库连接。我已经安装了SQL Server Management Studio 2005，每当我试图从客户端系统到服务器端进行查询时，它都会给出一个拒绝访问的错误。知道误差是多少吗?
Data Source=NEWNAME\SQLEXPRESS;AttachDbFilename=D:\DB\test1.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True
1 个解决方案
#1
0
Have you checked to see that TCP-IP connections are enabled from the server? A lot of the time when testing locally on the server vs externally this can cause confusion.
您是否检查了从服务器启用TCP-IP连接?很多时候，当在服务器上进行本地测试时，这可能会引起混乱。
http://msdn.microsoft.com/en-us/library/bb909712(v=vs.90).aspx
http://msdn.microsoft.com/en-us/library/bb909712(v =应用程序). aspx
It's also worth double checking that the server exists and you can connnect to it locally via management studio.
同样值得仔细检查服务器是否存在，并且您可以通过management studio在本地连接到它。
#1
0
Have you checked to see that TCP-IP connections are enabled from the server? A lot of the time when testing locally on the server vs externally this can cause confusion.
您是否检查了从服务器启用TCP-IP连接?很多时候，当在服务器上进行本地测试时，这可能会引起混乱。
http://msdn.microsoft.com/en-us/library/bb909712(v=vs.90).aspx
http://msdn.microsoft.com/en-us/library/bb909712(v =应用程序). aspx
It's also worth double checking that the server exists and you can connnect to it locally via management studio.
同样值得仔细检查服务器是否存在，并且您可以通过management studio在本地连接到它。