Problem using with ASPNETDB.MDF

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

Problem using with ASPNETDB.MDF

Author

Topic

Fatima980
Starting Member

1 Post

Posted - 2010-03-04 : 03:47:13

I m using ASP.NET with Visual Web Developer 2008 Express Edition and SQL Server 2008. As I am the Beginner. Recently I m facing problem while using Login control.

I am using two databases in my project :
1- ASPNETDB.MDF --- for Login,Security and authentication by using login controls

2- db_books.mdf --- for remaining use of the project

The path I am using for granting server permissions to ASPNETDB.MDF in Microsoft SQL Server Management Studio 2008 is:
ASPNETDB.MDF/properties/permissions/view server permissions/NT AUTHORITY\NETWORK SERVICE/....(where I checked all checkboxses for granting permissions to 'NT AUTHORITY\NETWORK SERVICE' of ASPNETDB.mdf)

My question is from Microsoft SQL Server Management Studio 2008 :

What permissions should I use to the ASPNETDB.mdf for 'NT AUTHORITY\NETWORK SERVICE in order to solve this error? (As I mention ealier I checked all checkboxes in permission section but still I got that Error....

As I got errors regarding login failed in ASP.NET Pages whenever i want to access the login.aspx file:

ERROR:

Server Error in '/P_ASP.NET' Application.

Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Cannot open user default database. Login failed.Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

What actullay I am missing or doing wrong ?? Help me for sorting out this error.

THANKS in ADVANCE!!..

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2010-03-04 : 10:16:14

first of all,i would advice you to use just one db.

paste you code here, without ur real passwords.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources