这里有更多理由，所以也尝试这些。在这里你去

SQL Server 2005连接问题疑难解答 [ ^ ]

HI，







GO START - >所有程序 - > SQL SERVER 2008/2005/2008 R2

- > CONFIGURATION TOOLS->

- > SELECT SQL SERVER CONFIGURATION MANAGER

- &gt ; SELECT SQL SERVER NETWORK CONFIGURATION

- > MSSQLSERVER的选择协议（你的即时名称）

- >在正确的任务面板中

- >请确认以下内容：



禁用共享内存和VIA

启用命名管道和TCP / IP



- 同样的事情

- > SQL NATIVE CLIENT 10.0（服务器版本）配置 - 客户端协议



RESTART SQL SERVER（MSSQLSERVER [你的即时名称]）服务

hi


参考此链接

网络相关和实例指定错误的解决方案 [ ^ ]

Hello everyone,

I am working on a project using VS2010 SQL2008 and I saw an ODD behaviour ,
First let me tell you that the app runs without any problem in my developing pc (Windows Xp sp3 32bit)

But when I was trying the application in another pc (Windows 7 32bit)

I got this exception:

A network-related or instance-specific error occured while establishing a connection to SQL server.The server was not found or was not accessible.Verfiy that the instance name is correct and that SQl server is configured to allow remote connections.

Now what is weird in this exception; Is when the application reaches the DataAdpater.Fill(dataset) line I got this exception but when
the app reaches the DataAdpter.Insert(....) It runs without any problem .

And what is more weird is that I noticed that the dataset that is used in the previous insert procedure can later be filled with dataAdapter.Fill(...) procedure which it was giving me an exception .


Now I hope you understand my problem

I tried these things as a solution:

1)Checked SQlBrowser running..
2)No aliases to Sql server at all to remove...
3)remote area connection--OK
4)TCP and UDP port 1433,1434 exception in firewall
5)Unistalled my only antivirus Norton
6)Added Tcp/IP ports in Sql protocols
7)My connection String is : onnectionString="Data Source=ALI\SQLEXPRESS;Initial Catalog=PALMSDATABASE;Integrated Security=True"
8)Also tried using Sql Server authentication (user Id and password)


My question is what is the difference between fill and insert?
Is there a problem with my connection?
My app. runs smoothly on the original pc ,What should I do?
Please If anyone knows anything help me, I am very desperate.

Here more reasons so try those too. Here you go
SQL Server 2005 Connectivity Issue Troubleshoot[^]

HI,



GO START -> ALL PROGRAMS -> SQL SERVER 2008/2005/2008 R2
->CONFIGURATION TOOLS->
->SELECT SQL SERVER CONFIGURATION MANAGER
->SELECT SQL SERVER NETWORK CONFIGURATION
->SELECT PROTOCOLS FOR MSSQLSERVER(YOUR INSTANT NAME)
->IN RIGHT TASK PANEL
->MAKE SURE MENTION BELOW:

DISABLE SHARED MEMORY AND VIA
ENABLE NAMED PIPE AND TCP/IP

—-MAKE SAME THING IN
->SQL NATIVE CLIENT 10.0(SERVER VERSION) CONFIGURATION – CLIENT PROTOCOLS

RESTART SQL SERVER(MSSQLSERVER [YOUR INSTANT NAME]) SERVICE

hi
refer this link
Solution for a network related and instance specified error[^]