为何VS2005中运行良好的网站,放到IIS中就连不上数据库了?数据库打不开
private static void openConnection()
{
if (conn.State == ConnectionState.Closed )
{
conn = new SqlConnection("Server=E5833BF1621E4C4;Integrated Security=SSPI;database=student");
comm.Connection = conn;
try
{
conn.Open();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
}
连接时报错 但是在vs下能带开 把网站放到iis下就不行了
private static void openConnection()
{
if (conn.State == ConnectionState.Closed )
{
conn = new SqlConnection("Server=E5833BF1621E4C4;Integrated Security=SSPI;database=student");
comm.Connection = conn;
try
{
conn.Open();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
}
连接时报错 但是在vs下能带开 把网站放到iis下就不行了
这样试下
检查Server database 是否正确 用户是否有权限
conn = new SqlConnection("Server=E5833BF1621E4C4;database=student ;USER=SA;PWD=SA;");