在Lan上连接到Sql Server 2005
大家好，
我首先使用EMS 2008构建软件并在本地主机上创建数据库，并且一切正常.然后，我想在局域网上的服务器上创建相同的数据库.我使用EMS并在服务器上创建了一个数据库.我将SQL Server 2005配置为接受通过TCP/IP和名称管道的连接. SQL Server Browser服务正在运行，我认为服务器上的所有配置都很好.
当我在本地主机上使用EMS 2008并尝试连接到服务器时，它不起作用.
我是与LAN上服务器具有相同域名的用户.
我尝试注册一个新主机，所以我添加了主机名:
QN-SRV01.Qatarnavigator.com \ ACRONIS
而且我也尝试过:QN-SRV01 \ ACRONIS
还尝试过:QN-SRV01
它们都不起作用，其中QN-SRV0是服务器名称
Qatarnavigator.com是域名
而ACRONIS是Sql数据库引擎...
它正在使用Windows身份验证...
请帮助我解决此问题.
最好的问候！
Hi everybody,
I first build a software and creates a database on my local host using EMS 2008 and every thing worked fine. Then I wanted to create the same database on the server on our LAN. I used EMS and created a database on the server. I configured SQL Server 2005 to accept connections via TCP/IP and name pipes. SQL Server Browser service is running and I think all configuration on server is fine.
When I use my EMS 2008 on my local host and try to connect to the server it doesn''t work.
I am a user on the same domain name as the server on the LAN.
I try to register a new host, so I add the host name :
QN-SRV01.Qatarnavigator.com\ACRONIS
and I also tried : QN-SRV01\ACRONIS
and also tried that : QN-SRV01
They''re all not working , where QN-SRV0 is the server name
and Qatarnavigator.com is the domain name
and ACRONIS is the Sql database engine...
and it is using windows authentication...
Kindly help me solve this issue.
Best Regards!
在您的本地计算机上打开命令提示符，然后尝试以下操作:nslookup QN-SRV01.Qatarnavigator.com
这只是为了验证主机是否可以解析.telnet QN-SRV01.Qatarnavigator.com 1433
这将测试您是否可以连接到SQL Server.
仅当您的SQL Server在端口1433上侦听时，此方法才有效.
这是每个安装的默认端口.
您可以尝试这些检查并返回结果吗?
干杯
曼弗雷德(Manfred)
On your local machine open up a command prompt and try the following:nslookup QN-SRV01.Qatarnavigator.com
This is just to verify that the host can be resolved.telnet QN-SRV01.Qatarnavigator.com 1433
This will test if you can connect to the SQL Server.
This only works if your SQL Server is listening on port 1433,
which is the default port of every installation.
Can you try these checks and come back with your results?
Cheers
Manfred
在与我的服务器长期斗争之后，我发现了以下问题:
如果我在工作组中，则必须使用SQL身份验证.然后我做了什么:
删除SQL Server 2005，然后删除所有引擎，然后在启用混合身份验证并定义sa用户和密码的情况下再次安装它.
然后创建我的数据库
配置远程连接，并启用sql浏览器.
然后在TCP/Ip服务上双击并指定端口，之后，我在启用Internet共享的LAN配置中发现了一些错误，因此我从lan属性中禁用了Internet共享.
然后我写连接字符串LIke:192.168.1.8,1433 \ SQLEXPRESS
那就完美了..
然后在我的软件上，我首先尝试使用以下连接字符串:
After Long struggle with my server, I have found the following Issues :
That If I am on workgroup I have to use SQL Authentication. Then what I have done :
Remove the SQL server 2005 and delete all the engines before, then Install it again with enabling the Mixed authentication and defining a sa user and password.
then creating my database
configuration for remote connections , and enabling the sql browser.
then On the the TCP/Ip service double click and assgin the port , after that I found some errors in my LAN Configuration which the internet sharing is enabled, So I disable the internet sharing from the lan properties.
then I write the connection string LIke : 192.168.1.8,1433\SQLEXPRESS
then it works perfectly..
then on my software I try first to use this connection string :
string myconn = "Data Source=192.168.1.8,1433\\SQLENGINE;Initial Catalog=qn_archive;Integrated Security=True;User ID=sa;Password=password";但是它给用户不信任，所以我从字符串中删除了集成安全性，它工作得很好....
终于可以了..非常感谢您的帮助.
but it gives user is not trusted , so I remove the Integrated security fromt the string and it works fine....
Finally It works .. I appretiate your help man thanks a lot...