The ASP.NET account doesn't have access to SQL Server. In Management Studio, under the database, then under security then users, create a new user. I call mine "aspnet-account", then attach that the the local ASPNET account, then give it the required level of access to your database.
>I have:
>
>(1) A new SQL Server 2005 Database installed on a Windows 2003 Member server.
>(2) I'm using VS .NET 2005 to test a new sample Web project.
>(3) From within my VS project, I can access the SQL data (Read-Only).
>(4) I successfully copied my project to the virtual directory on my member server. (SQL & IIS are on the same box).
>(5) From outside my project, running IE, I cannot get access to the SQL data.
>
>"Login Failed for User NT_AUTHORITY\NETWORK SERVICE"
>
>(6) I am convinced this is an authentication problem, but I have run out of ideas on how to correct it.
>
>I wouldn't think it is a problem inside my web.config file since I can access the SQL data from within VS.
>
>I've searched all over the WEB & the Microsoft Site for solutions and nothing that I've tried has been successful.
>
>Does anyone, who works with SQL and VB.NET routinely have any thoughts or ideas on what needs to be done? At this point, I'll even take another link suggestion if it contains a successful solution.
>
>Thanks in Advance for any advice as I am very new to SQL and VS.NET.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only