sql连接错误

[free1879]

程序如下：
<%@ Import Namespace = "System.Data.SqlClient"%>
<%@ Import Namespace = "System.Data"%>
<script language = "C#" runat = "server">
protected void Page_Load(Object sender,EventArgs e)
{

string strConn = " server = (LENOVO-06164154);database = pubs; uid =sa; pwd =admin ";
SqlConnection Conn = new SqlConnection(strConn);
string sql = "select * from Authors";
SqlDataAdapter Comm = new SqlDataAdapter(sql,Conn);
DataSet ds = new DataSet();
Comm.Fill(ds,"Authors");
MyDataGrid.DataSource = ds.Tables["Authors"].DefaultView;
MyDataGrid.DataBind();
}
</script>

<asp:DataGrid ID="MyDataGrid" Runat = "server" />
错误信息如下：

源错误:


行 10： SqlDataAdapter Comm = new SqlDataAdapter(sql,Conn);
行 11： DataSet ds = new DataSet();
行 12： Comm.Fill(ds,"Authors");
行 13： MyDataGrid.DataSource = ds.Tables["Authors"].DefaultView;
行 14： MyDataGrid.DataBind();


源文件: D:\web\dababase\6-02.aspx 行: 12

堆栈跟踪:


[SqlException: SQL Server 不存在或访问被拒绝。]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
ASP._6_02_aspx.Page_Load(Object sender, EventArgs e) in D:\web\dababase\6-02.aspx:12
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()

[周公]

SqlException: SQL Server 不存在或访问被拒绝。]
这句话已经很明确了，确认SQL Server服务器是否存在，名字是否正确，用来登录的用户名和密码是否正确，对要进行的数据库是否有相应权限。

另外如果是SQL Server2000的话安装一下SP4补丁。

[amandag]

string strConn = " server = (LENOVO-06164154);database = pubs; uid =sa; pwd =admin ";
====================================================================================
string strConn = " server =LENOVO-06164154;database = pubs; uid =sa; pwd =admin ";

[EYESPACE]

代码是没有问题

[BearRui]

链接字符串写错了，server对应的计算机名写错了吧

[free1879]

已经解决
string strConn = " server =LENOVO-06164154;database = pubs; uid =sa; pwd =admin ";
为什么有时候能加，有时候不能加括号？

[NqIceCoffee]

string strConn = "server=.;database =pubs;uid =sa;pwd =admin";

一般我这么写

[onlyadou]

如果不得
试换成：string strConn = " data source=LENOVO-06164154;initial catalog= pubs; uid =sa; pwd =admin ";看看。。。

[free1879]

我是个初学者，server =. 代表什么呢？ 当前服务器么？
另外：initial catalog 和 database的区别是什么？

[onlyadou]

应该是这个user id=sa吧

[静_心]

打开SQLSERVER服务器把上面的服务器名字拷到你的SERVER后面啦 。

[amandag]

如果数据库服务器就是本机

string strConn = " server=.;database = pubs; uid =sa; pwd =admin";

就可以

[yqwaxyq]

server=(local),这样写要加