无法连接来自Visual Studio 2008 9.0的SQL Server实例

问题描述：

即使我将Tools-> Options-> Database Tools-> Data Connections设置为“SIDEKICK”，我在32位XP Professional服务器上从VS获得以下错误“，这是我电脑的名字。换句话说，SIDEKICK应该默认为完整的SQLSERVER。无法连接来自Visual Studio 2008 9.0的SQL Server实例

换句话说，我希望VS使用SQLSERVER而不是SQLSERVER EXPRESS。我可以清楚地看到服务器资源管理器中的VS以及SSMS 2008中的数据库。此外，我可以从服务器资源管理器中查看此数据库的表。我没有得到任何生成错误。它看起来像我的web.config文件中的所有命名是一致的。

我正在开发我的网站根据微软的教程，所以我不应该得到一个错误。然而，我得到下面的异常，当我运行下面这段代码：

CreateAccounts.aspx.cs文件

protected void CreateAccountButton_Click(object sender, EventArgs e) 
    { 
     MembershipCreateStatus createStatus; 
//This line below is where the exception occurs 
     MembershipUser newUser = Membership.CreateUser(Username.Text, Password.Text, Email.Text, passwordQuestion, SecurityAnswer.Text, true, out createStatus);

这里是例外的样子：

System.Web.HttpException was unhandled by user code 
    Message="Unable to connect to SQL Server database." 
    Source="System.Web" 
    ErrorCode=-2147467259 
    StackTrace: 
     at System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString) 
     at System.Web.DataAccess.SqlConnectionHelper.EnsureSqlExpressDBFile(String connectionString) 
     at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) 
     at System.Web.Security.SqlMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) 
     at System.Web.Security.Membership.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) 
     at System.Web.Security.Membership.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, MembershipCreateStatus& status) 
     at Membership_CreatingUserAccounts.CreateAccountButton_Click(Object sender, EventArgs e) in c:\Documents and Settings\Admin\My Documents\Visual Studio 2008\WebSites\WebSite2\Membership\CreatingUserAccounts.aspx.cs:line 24 
     at System.Web.UI.WebControls.Button.OnClick(EventArgs e) 
     at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) 
     at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) 
     at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) 
     at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) 
     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 
    InnerException: System.Web.HttpException 
     Message="Unable to connect to SQL Server database." 
     Source="System.Web" 
     ErrorCode=-2147467259 
     StackTrace: 
      at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) 
      at System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install) 
      at System.Web.Management.SqlServices.Install(String database, String dbFileName, String connectionString) 
      at System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString) 
     InnerException: System.Data.SqlClient.SqlException 
      Message="The user instance login flag is not supported on this version of SQL Server. The connection will be closed." 
      Source=".Net SqlClient Data Provider" 
      ErrorCode=-2146232060 
      Class=14 
      LineNumber=65536 
      Number=18493 
      Procedure="" 
      Server="." 
      State=1 
      StackTrace: 
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) 
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 
       at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) 
       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.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) 
       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 System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) 
      InnerException:

的Web.config连接字符串看起来像：

<connectionStrings> 
    <add name="SecurityTutorialsConnectionString"  
     connectionString="data source=.;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|SecurityTutorialsDatabase3.mdf;User Instance=true"  
     providerName="System.Data.SqlClient"/> 

</connectionStrings> 
<system.web> 
    <membership defaultProvider="SecurityTutorialsSqlMembershipProvider"> 
     <providers> 
      <add name="SecurityTutorialsSqlMembershipProvider"     
       type="System.Web.Security.SqlMembershipProvider"     
       connectionStringName="SecurityTutorialsConnectionString"     
       enablePasswordRetrieval="false"     
       enablePasswordReset="true"     
       requiresQuestionAndAnswer="true"     
       applicationName="SecurityTutorials"     
       requiresUniqueEmail="true"     
       passwordFormat="Hashed"     
       maxInvalidPasswordAttempts="5"     
       minRequiredPasswordLength="7"     
       minRequiredNonalphanumericCharacters="1"     
       passwordAttemptWindow="10"     
       passwordStrengthRegularExpression=""/> 
     </providers> 
    </membership>

而且我也关闭防火墙，所以我知道th是不是原因。

你的连接字符串是什么样的？你可以使用asterix字符掩盖密码和IP地址等，但是请张贴完整的字符串。 – 2010-05-02 21:53:13

谢谢Lasse，我刚刚在上面添加了连接字符串。 – salvationishere 2010-05-02 22:06:15

答

您在“SQL Server配置管理器”中的“SQL Server网络配置”中启用了哪些协议？

共享内存和TCP/IP。我需要TCP/IP吗？ – salvationishere 2010-05-02 23:09:03

如果你在同一个盒子上，你不需要tcp/ip – 2010-05-02 23:10:13

现在我发现了这个问题。问题是我试图使用完整的SQL Server，而不是Express。完整的SQL Server不支持AttachDBFilename选项，它也不支持User Instance = true。但是，你知道是否选择TCP/IP的原因当我尝试从VS打开ASPNET_Users表，通过右键单击并选择Show Table DAta，我得到的错误：无法打开数据库...请求的登录。 – salvationishere 2010-05-02 23:12:28

答

如果您正在使用ASP.NET工作，那么我会建议你尝试喜欢用“aspnet_regsql.exe的”实用......基本上可以让我们改变默认的数据库连接（这是SQL Express的）东西到我们想要的任何数据库。此实用程序可以在“C：\ WINDOWS \ Microsoft.NET \ Framework \ v2.0.more- digits”目录中找到。

我希望这有助于。

杰克

无法连接来自Visual Studio 2008 9.0的SQL Server实例

相关推荐