Login Problem in SQL Server 2005

  • Hi Everyone,

    I deleted built in users in security-login except sa, then created users production and sales. Then assigns all related schemas and password and roles to each. Tested their connection. Production can access databases of sales but sales cannot access databases of production. But when I access my application, the runtime error was "The current identity(NT Authority\NETWORK SERVICE DOES NOT HAVE WRITE ACCESS TO ‘C:\WINDOWS\MICROSOFT.NET\FRAMEWORK\V2.0.50727\TEMPORARY ASP.NET FILES".

    How can this be since I already erased NT Authority users?

  • This sounds like a secuirty configuration issue with your application or IIS.

    Your ASP.net application is trying to connect to SQL Server using one of the builtin windows accounts rather than the SQL Server Login you have created.

  • I agree with John. This sounds like an issue outside of SQL Server.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply