tag:blogger.com,1999:blog-6046577960778787715.post437631274484105193..comments2023-11-03T01:45:15.374-07:00Comments on Sanjay Saini's Tech World with Coding Articles for Geeks: How to create ASPNET Accountsanjay sainihttp://www.blogger.com/profile/03018435962450831911noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-6046577960778787715.post-9262957720263550172009-09-14T04:44:26.713-07:002009-09-14T04:44:26.713-07:00Thanks Man It worksThanks Man It worksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6046577960778787715.post-45665789445307046522009-06-17T10:03:40.013-07:002009-06-17T10:03:40.013-07:00Ivan, what I understood if that you are using &quo...Ivan, what I understood if that you are using "Integrated Security=SSPI" in the connection string that means integrated windows authentication so want to know how to make ASPNET access sql server that might be happening in your case and getting access denied error.<br />There are couple of ways to do it depend upon the requirement.<br />1. give admin right to machinename\ASPNET account, which is not a good idea.<br />2. Create machinename\ASPNET account in the sql server and give it proper permission on the sql objects.<br />3. Use impersonation - create a window account for sql server, give it proper permission on sql server and use it in the impersonation tag in web.config file. Like - < identity Impersonate='true' username='username' password='password' /><br /><br />I will suggest third option.<br />Hope this will solve your issue.sanjay sainihttps://www.blogger.com/profile/03018435962450831911noreply@blogger.comtag:blogger.com,1999:blog-6046577960778787715.post-31676943768268180232009-06-13T06:59:56.547-07:002009-06-13T06:59:56.547-07:00If you are running IIS 5.1, remote connections to ...If you are running IIS 5.1, remote connections to the server use the ASPNET service account to access SQL Server if you use SSPI integrated security. Unless you are specifying another account in the connection string, how else can you get remote connections to access the database?Ivannoreply@blogger.comtag:blogger.com,1999:blog-6046577960778787715.post-2056893069233730322009-06-13T02:24:24.476-07:002009-06-13T02:24:24.476-07:00No Ivan, its a special account it will not appear ...No Ivan, its a special account it will not appear in the User Accounts list.<br />Why do you want to give ASPNET account permission to access sql server?sanjay sainihttps://www.blogger.com/profile/03018435962450831911noreply@blogger.comtag:blogger.com,1999:blog-6046577960778787715.post-75954027324811310552009-06-12T21:27:28.246-07:002009-06-12T21:27:28.246-07:00So are we supposed to be able to see it as a User ...So are we supposed to be able to see it as a User Account under Control Panel->User Accounts?<br /><br />Also, how do we give ASPNET account permission to access a SQL Server database?Unknownhttps://www.blogger.com/profile/11432824718070191463noreply@blogger.comtag:blogger.com,1999:blog-6046577960778787715.post-47994225666006565412009-03-26T20:27:00.000-07:002009-03-26T20:27:00.000-07:00Great. Thx alotGreat. Thx alotAnonymousnoreply@blogger.com