uyear - 2007-12-13 01:50:00
SQL2000新建用户安装不成功,然后直接用SA了,没想到直接就出现一下错误:
System.Data.SqlClient.SqlException: 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) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Foosun.Install.Comm.ExecuteSql(String connStr, String DatabaseName, String Sql) in D:\dotNETCMS\Foosun.Install\Comm.cs:line 51 at Foosun.Web.Install.step3.CreateDataBase(String server, String user, String pwd, String dbname, String tbpre, String adminname, String adminpwd) in D:\dotNETCMS\Foosun.Web\Install\step3.aspx.cs:line 69
建议对在教程中出于安全考虑,录制一个文件夹不需要添加或是改变用户组的操作,仅是添加或改变用户权限,数据库方面,建议在测试连接数据库的时候更加人性化,给出更多出错提示,今晚我是没安装成功,但还是支持风讯,希望漫骂风讯的用户,要么你不喜欢就不要用,用就要给于开发人员的支持与鼓励,换做是你,可能你连开偶发风讯1%的能力都没有,在此希望风讯能尽快完善,许多用户在等待你们的好消息。
很多用户都是虚拟主机的,他们并没机会去操作服务器,所以尽可能将程序安装兼容大部分环境。