needspace
asked on
aspnet_regsql.exe wizard fails
I am trying to install the aspnet database in SQL Express 2005 so I can develop a FBA application. When I run the wizard I get the following:
__________________________ __________ __________ __________ ________
Setup failed.
Exception:
Unable to connect to SQL Server database.
-------------------------- ---------- ----
Details of failure
-------------------------- ---------- ----
System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlE xception: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
at System.Data.SqlClient.SqlI nternalCon nection.On Error(SqlE xception exception, Boolean breakConnection)
at System.Data.SqlClient.TdsP arser.Thro wException AndWarning (TdsParser StateObjec t stateObj)
at System.Data.SqlClient.TdsP arser.Conn ect(Server Info serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlI nternalCon nectionTds .AttemptOn eLogin(Ser verInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlI nternalCon nectionTds .LoginNoFa ilover(Str ing host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlI nternalCon nectionTds .OpenLogin Enlist(Sql Connection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlI nternalCon nectionTds ..ctor(DbC onnectionP oolIdentit y identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlC onnectionF actory.Cre ateConnect ion(DbConn ectionOpti ons options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.D bConnectio nFactory.C reatePoole dConnectio n(DbConnec tion owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.D bConnectio nPool.Crea teObject(D bConnectio n owningObject)
at System.Data.ProviderBase.D bConnectio nPool.User CreateRequ est(DbConn ection owningObject)
at System.Data.ProviderBase.D bConnectio nPool.GetC onnection( DbConnecti on owningObject)
at System.Data.ProviderBase.D bConnectio nFactory.G etConnecti on(DbConne ction owningConnection)
at System.Data.ProviderBase.D bConnectio nClosed.Op enConnecti on(DbConne ction outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlC onnection. Open()
at System.Web.Management.SqlS ervices.Ge tSqlConnec tion(Strin g server, String user, String password, Boolean trusted, String connectionString)
--- End of inner exception stack trace ---
at System.Web.Management.SqlS ervices.Ge tSqlConnec tion(Strin g server, String user, String password, Boolean trusted, String connectionString)
at System.Web.Management.SqlS ervices.Se tupApplica tionServic es(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install)
at System.Web.Management.SqlS ervices.In stall(Stri ng database, SqlFeatures features, String connectionString)
at System.Web.Management.Conf irmPanel.E xecute()
__________________________ __________ __________ __________ __________ ________
I already have sql Express installed and I can in fact connect to the two database engines running under that instance without any problem. Remote connections are enabled, named pipes is enabled, as is tcp/ip connections. The SQL browser is running. This is on my local machine which is running Windows 7 RC.
When I run the wizard, I am accepting defaults.
__________________________
Setup failed.
Exception:
Unable to connect to SQL Server database.
--------------------------
Details of failure
--------------------------
System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlE
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlC
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.SqlClient.SqlC
at System.Web.Management.SqlS
--- End of inner exception stack trace ---
at System.Web.Management.SqlS
at System.Web.Management.SqlS
at System.Web.Management.SqlS
at System.Web.Management.Conf
__________________________
I already have sql Express installed and I can in fact connect to the two database engines running under that instance without any problem. Remote connections are enabled, named pipes is enabled, as is tcp/ip connections. The SQL browser is running. This is on my local machine which is running Windows 7 RC.
When I run the wizard, I am accepting defaults.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
HMMM. I think this is called a ID10T error....
I the wizard had my computer name as the server and it should have been my computer name\instance name - sqlexpress in this case.
Problem solved and I'm feeling sheepish now.
I the wizard had my computer name as the server and it should have been my computer name\instance name - sqlexpress in this case.
Problem solved and I'm feeling sheepish now.
ASKER
You sated the obvious but it was correct. It was as simple as the server name was incorrect....
ASKER
I am installing the asp database on my local computer - from my local computer. I can connect to the database engine through SSMS and through vs2005 - yet for some reason the ASPNet_sqlreg installer cannot.....