acces denied on IIS using sql server 2005
-
hi frns i am stuck with an odd problem, i hv an asp.net app wich uses sql server 2005 as backend , it runs fine on visual studio 2005 , but wen deployed on IIS , it gives the following error "Access Denied to sameer/ASPNET" ofcourse its abt certain rights to be given to aspnet user bt wat and hw? pls hlp tnx in advance sameer :-O
-
hi frns i am stuck with an odd problem, i hv an asp.net app wich uses sql server 2005 as backend , it runs fine on visual studio 2005 , but wen deployed on IIS , it gives the following error "Access Denied to sameer/ASPNET" ofcourse its abt certain rights to be given to aspnet user bt wat and hw? pls hlp tnx in advance sameer :-O
Hi there, Are you using the Windows Authentication mode? Basically, when you run the app in VS 2005 with the built-in web development server and it uses the log-on account which is more power than the ASP.NET process identity. So you can try to configure the aspnet user as below to access the SQL 2005. + You can use the admin account such as sa to open the Server Management Studio + Under the Security/Logins entry, make sure the sameer/ASPNET acount is there. If not, you can right click the item and choose New Login to add the account. + In the Properties window of the selected account, select the Status section, and check the access permission is granted and the Login status is Enabled.