473,219 Members | 2,137 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,219 software developers and data experts.

Help setting up SQL Express as Membership Provider (ASP.NET 2.0 beta 2)

[Cross-posted to the ASP.NET Security forum on forums.asp.net, but that
forum is moderated and I really need an answer soon!]
I'm trying to set up a Membership/Role Provider for an ASP.NET 2.0 beta 2
site using SqlMembershipProvider, and am having problems configuring SQL
Server.

I'm comfortable with ASP.NET but very new at databases, so please help me
out on the database side!

When I run aspnet_regsql I get this error:

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.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner,
Boolean& failoverDemandDone, String host, String failoverPartner, String
protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean
encrypt, Boolean integratedSecurity, SqlConnection owningObject, Boolean
aliasLookup)
at
System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ct or(SqlConnectionString
connectionOptions, Object providerInfo, String newPassword, SqlConnection
owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection
owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(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)
--- End of inner exception stack trace ---
at System.Web.Management.SqlServices.GetSqlConnection (String server,
String user, String password, Boolean trusted, String connectionString)
at System.Web.Management.SqlServices.SetupApplication Services(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,
SqlFeatures features, String connectionString)
at System.Web.Management.ConfirmPanel.Execute()

I'm using the default installation of SQL Server 2005 Express as it was
installed automatically along with Visual Studio 2005. On the third page of
the aspnet_regsql wizard I didn't really know what kind of authentication to
use so I've tried Windows authentication as well as SQL Server
authentication (but what username/password should I use? How do I set up
users for a database that hasn't been created yet?) and get the same error
in both cases.

The SQL Server Configuration Manager shows that "SQL Server (SQLEXPRESS)" is
Running, but "SQL Browser" is Stopped. Under "Protocols for SQLEXPRESS",
"Shared Memory" is Enabled but all others are Disabled.

I don't know where to start in debugging this. All the documentation and
blogs I read about setting up SqlMembershipProvider just say to run the
aspnet_regsql wizard, they don't talk about having to do any kind of setup
or configuration of the SQL Server installation first.

Any help is appreciated! Thank you.

Nate Hekman


Nov 19 '05 #1
0 2531

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: lanem | last post by:
Has anyone gotten the membership stuff to work in Beta 2. I am going through examples/walkthroughts on this stuff, and it just doesn't work. All the examples are using beta 1, so I was wondering...
8
by: RCS | last post by:
All, OK, so I'm working on a template for our new ASP.NET applications. Part of this, includes using the new menu and breadcrumbs control in ASP.NET 2.0 (I'm using beta 2). I put the...
1
by: Philipp Lenz | last post by:
I'm completely new to ASP.Net 2.0 and I'm baffled about what to do to get this to work. FYI, I'm not new at this, I've used asp.net 1.1 for allmost 4 years now. I'm running a development...
4
by: Bruno | last post by:
Hello, VS.net installs sql express as datastore for role/membership management. I don't like this! I'm not able to choose other databases like ms-access, in the Web Site Administration Tool ....
1
by: Keith | last post by:
If I understand correctly, the SQL script called "InstallMembership.sql" can be used to create a membership database that exists in the instance of SQL Server 2005 used for my main application....
0
by: Alan M Dunsmuir | last post by:
After some early aborted installations and botched de-installations of VS 2005, SQL Server Express no longer wants to install on my desktop machine, and doesn't even get mentioned during the...
4
by: Brad Isaacs | last post by:
I am working with ASP.NET 2.0 and using an SQL Server 2000 database. I am using Visual Studio 2005 and developing on my Local machine. I am working with Login controls ASP.Configuration, I...
10
by: Jonathan Wood | last post by:
I'm taking my first stab at using ASP.NET memberships and could use some help. I'm following along in a book, which recommends I use the Web Application Administration Tool in VS 2005. A...
10
by: Scott M. | last post by:
I've seen many posts and ready articles discussing how changing the membership & roles "provider" in VS .NET is easy, but have yet to see instructions on how to do it. If I already have SQL...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.