C#代码
我这样写可以连接数据库
string source = @"Data Source=ZHENGSHAODONG\SQLEXPRESS;Initial Catalog=testing;Integrated Security=SSPI;";
SqlConnection conn = new SqlConnection(source);
conn.Open();
而我安装书中的写法这样写为什么无法连接?
string source="server=(local);"+"integrated security=SSPI;"+"database="testing";
"
conn.Open();
System.Data.SqlClient.SqlException: 在建立与服务器的连接时出错。在连接到 SQL Server 2005 时,在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (provider: 命名管道提供程序, error: 40 - 无法打开到 SQL Server 的连接)
在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
在 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
在 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
在 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
在 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
在 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
在 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
在 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
在 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
在 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
在 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
在 System.Data.SqlClient.SqlConnection.Open()
在 DataBase.Form1..ctor() 位置 C:\Documents and Settings\Administrator\桌面\DataBase\DataBase\Form1.cs:行号 22
我这样写可以连接数据库
string source = @"Data Source=ZHENGSHAODONG\SQLEXPRESS;Initial Catalog=testing;Integrated Security=SSPI;";
SqlConnection conn = new SqlConnection(source);
conn.Open();
而我安装书中的写法这样写为什么无法连接?
string source="server=(local);"+"integrated security=SSPI;"+"database="testing";
"
conn.Open();
System.Data.SqlClient.SqlException: 在建立与服务器的连接时出错。在连接到 SQL Server 2005 时,在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (provider: 命名管道提供程序, error: 40 - 无法打开到 SQL Server 的连接)
在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
在 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
在 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
在 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
在 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
在 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
在 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
在 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
在 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
在 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
在 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
在 System.Data.SqlClient.SqlConnection.Open()
在 DataBase.Form1..ctor() 位置 C:\Documents and Settings\Administrator\桌面\DataBase\DataBase\Form1.cs:行号 22
解决方案 »
- 怎么查询表结构的信息
- 再问淘宝上搜索的select语句及其它问题
- 继续请教一SQL语句
- 还原数据库遇到问题
- insert into 语句为什么不执行呀???
- 一个SQL server的题目,不太会
- top语句的问题
- SQL SERVER2000狂吃内存!对俺有启发就有分!
- 救命阿,, 恢复数据库时出错: 发生内部一致性错误,请与技术支持联系以寻求帮助. RESTORE DATABASE 操作异常终止.急...wait......
- 请教高手,在windows安装程序中使用合并模块安装sql实例
- sqlserver中抛出错误的问题, RaiseError(..) 请教!
- 请邹建等高手解答库表设计问题
SqlConnection conn = new SqlConnection(source);
conn.Open();
而我按照书中的写法这样写为什么无法连接?
string source="server=(local);"+"integrated security=SSPI;"+"database="testing";
"
conn.Open();
SqlConnection conn = new SqlConnection(source);
conn.Open();
这个无法打开数据库
SqlConnection conn = new SqlConnection(source);
conn.Open();
SqlConnection conn = new SqlConnection(source);
conn.Open();
---------------------
我用Windows验证方式验证的
SQL我安装的时候忘记这个ID和PWD了
conn.Open();
SqlConnection conn = new SqlConnection(source);
conn.Open();
conn.Open();
这个也不行哦
?server=.;是什么意思?
string source="server=local;Integrated Security=SSPI;Database=testing";
SqlConnection conn = new SqlConnection(source);
conn.Open();------------------------------------------------------------------------------
string source="server=(local);"+"integrated security=SSPI;"+"database=testing";
和
string source="server=local;Integrated Security=SSPI;Database=testing";
不是一样的吗?。
string source="Data Source=localhost;Integrated Security=SSPI;Initial Catalog=testing";
SqlConnection conn = new SqlConnection(source);
conn.Open();
或者string source="server=local;database=testing;Trusted_Connection=yes";
SqlConnection conn = new SqlConnection(source);
conn.Open();
conn.Open();
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dllAdditional information: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
for help.