Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-20 : 07:36:08
|
| Paul writes "Dear All, I'm new to SQL server, and am setting up a sql2000 server on our intranet server ( so both IIS and sql on the same server for the time being ) now I need to let ASPNET user access to certain tables for read,Write activities, The sql server is set to both windows and SQl security ( not good I've heard or? ). The only way I could get my aspx pages to access the db's & tables within was to set up the Domainxxx\ASPNET user as a user on the sql server. Question is did I do the right thing or is there another way? I mean in respects to security and such.Thanx in advance Paul" |
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2003-02-20 : 08:02:50
|
| I use the DOMAIN\ASPNET account for trusted connections to my intranet sql server. Best way for us, that way the developers don't need to maintain user id's and passwords. |
 |
|
|
codehorse69
Starting Member
1 Post |
Posted - 2003-02-23 : 13:22:13
|
quote:
I use the DOMAIN\ASPNET account for trusted connections to my intranet sql server. Best way for us, that way the developers don't need to maintain user id's and passwords.
Hi, but have I set it up correct, If I take off the Domain/aspnet user from sql server then aspnet can not get to tables?can you give me a quick guide to how to set it up correct.Many thanks in advance. |
|
|
|
|
|
|
ASPNET user