Pulling hair out : ASP.NET & SQL Server authentication
-
i cannot seem to get my asp.net app to connect to the sql server i get the error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. just like the old MACHINE\ASPNET error i got the first time i tried an sql app on my development windows xp machine but how am i supposed to add this user to a sql login? everytime i try, i always get "User does not exist" is there an alias i need to use or something? has anyone been able to add this user? :mad:
-
i cannot seem to get my asp.net app to connect to the sql server i get the error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. just like the old MACHINE\ASPNET error i got the first time i tried an sql app on my development windows xp machine but how am i supposed to add this user to a sql login? everytime i try, i always get "User does not exist" is there an alias i need to use or something? has anyone been able to add this user? :mad:
-
When you add a user in a enerprise manager , you can select from a list of users and aspnet account exist there too. How do you add it? In Security--> Login node and Add User? Mazy You're face to face, With the man who sold the world - David Bowie
i can add aspnet, but that doesn't resolve the issue, the asp.net apps still don't have access
-
When you add a user in a enerprise manager , you can select from a list of users and aspnet account exist there too. How do you add it? In Security--> Login node and Add User? Mazy You're face to face, With the man who sold the world - David Bowie
For security reasons I would not recommend adding the aspnet account to your SQL Server logins.
-
For security reasons I would not recommend adding the aspnet account to your SQL Server logins.
figured out how to add it... its the IIS_WGP account on win2k3 why is it bad for security reasons? i have added it just as a user on the database i need, with read-only permissions... how would you recommend i use sql from asp.net then?
-
figured out how to add it... its the IIS_WGP account on win2k3 why is it bad for security reasons? i have added it just as a user on the database i need, with read-only permissions... how would you recommend i use sql from asp.net then?
aspnet is an anonymous account. It would be tighter to have a specific user login for each database. If you have several databases, all of which aspnet has rights to, how do you contol access? The potential is there for a security breach. If it isn't a concern for you then fine, but why expose the risk if you don't need to.
-
aspnet is an anonymous account. It would be tighter to have a specific user login for each database. If you have several databases, all of which aspnet has rights to, how do you contol access? The potential is there for a security breach. If it isn't a concern for you then fine, but why expose the risk if you don't need to.
ok, thanks... but this application is the sole purpose of the server, so i am not worried about cross application security, especially since i am only allowing reading