Rather urgent: Cannot open user default database. Login failed.
- From: "JimCinLA" <jimcolli@xxxxxxxxxxx>
- Date: 16 Jan 2007 10:48:43 -0800
On an ASP.Net 2.0 appliaction, I use ASPNETDB.mdf in the project's
App_Data subdirectory for forms authentication. This works fine inside
Visual Studio 2005.
When I deploy the application to an IIS server on the same computer,
I cannot open ASPNETDB.mdf. I get the usual message:
Cannot open user default database. Login failed.
On that particular computer, I have MS SQL 2005 Express installed.
I assume the solution is an easy one. It may be that ASPNETDB.mdf
should be attached to the database server for use outside
Visual Studio, but I just can't get there. Also, what settings should
be made, assuming it should be attached? For instance, do I add
[computer name]\ASPNET as a user for ASPNETDB.mdf?
Thanks in advance for any help!
.
- Follow-Ups:
- Prev by Date: Broken connection timeout
- Next by Date: Re: What is Causing a Sudden Increase in User Connections?
- Previous by thread: Broken connection timeout
- Next by thread: Re: Rather urgent: Cannot open user default database. Login failed.
- Index(es):
Relevant Pages
|