今天在项目移植中,遇到这样的问题,SQL Server 不存在或访问被拒绝
这里很正常的问题,一般情况下,都有解决办法,检查1433-->检查连接符-->打sp3补丁
一般情况下在windows 2003下打sql server sp3的补丁后正常
但今天的情况不一样,为了把问题最简化,我拿最短的连接数据库的代码,这段代码由Microsoft ASP.NET Web Matrix生成
// Insert page code here
//
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
System.Data.DataSet MyQueryMethod()
{
string connectionString = "server=\'192.168.191.5\'; user id=\'DevUser\'; password=\DevUserPW\'; database=\'AIOA\'";
System.Data.IDbConnection dbConnection = new System.Data.SqlClient.SqlConnection(connectionString);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string queryString = "SELECT [aioa_Tabs].* FROM [aioa_Tabs]";
System.Data.IDbCommand dbCommand = new System.Data.SqlClient.SqlCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
System.Data.IDbDataAdapter dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
dataAdapter.SelectCommand = dbCommand;
System.Data.DataSet dataSet = new System.Data.DataSet();
dataAdapter.Fill(dataSet);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return dataSet;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
我们先看看在Microsoft ASP.NET Web Matrix中的运行情况
![](https://www.cnblogs.com/images/cnblogs_com/supercode/asp.net/Sql%20Conntent%20Err1.JPG)
注意,Matrix自带微型Web Server,不需要IIS对Asp.net解析
接着把同样的代码拷到VS中,再运行![](https://www.cnblogs.com/images/cnblogs_com/supercode/asp.net/Sql%20Conntent%20Err2.JPG)
环境不一样,难道是IIS有问题吗? 郁闷一下午的问题![](https://www.cnblogs.com/Emoticons/hitwall.gif)