SQL Server 2005连接问题 [英] SQL Server 2005 Connection Problem

问题描述

你好，我叫Vikas Gohil.

我有一个在VB.net 2005中创建的软件，数据库为SQL Server 2005 Express版.

当此软件和数据库安装在同一台PC上时，它可以完美运行.

但是有时，当数据库在另一台PC上并且软件在另一台PC上时，它显示服务器或实例错误，并且无法连接到数据库.

该问题主要发生在Windows 7 PC上，在XP计算机上没有问题.

谁能告诉我问题可能出在哪里.或是什么原因导致Sql Server无法从其他PC连接.

我的SQL Server有一个用户创建的实例，并且正在本地系统"帐户下运行.我是否需要将其更改为网络"帐户才能访问网络?

任何帮助都会很棒.

谢谢.

Hello, this is Vikas Gohil.

I have a software created in VB.net 2005, with database as SQL server 2005 Express edition.

When this software and database are installed on same PC, it works perfectly.

But sometimes when the Database is on another PC and software is on another, it shows server or instance error and it does not connect to database.

The problem occurs mostly on windows 7 PC, on XP machines there is no problem.

Can anyone tell me what the problem could be. OR what might be the causes the Sql Server is not connecting from other PC.

My SQL Server has a User created instance and is running under Local System account. Do I need to change it to Network account for network accessibility?

Any help would be great.

Thanks.

推荐答案

如果您确定自己的连接字符串并且在XP上可以正常使用，我怀疑Windows 7防火墙会阻止通信.要进行测试，请尝试将其禁用.

If you''re sure about your connection string and it works fine on XP, I would suspect that Windows 7 firewall is preventing the communication. For a test, try disabling it.

这篇关于SQL Server 2005连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！