Go to the command prompt and type in:
osql -S [servername]\instancename -E -q
You will have a 1> prompt.
use yourdatabasename
goEXEC sp_grantlogin '[servername]\ASPNET'
goEXEC sp_grantdbaccess '[servername]\ASPNET''
go
You can also read this post by David Wier:Error Using Trusted Connection in DB Connection String. I don't recommend adding the ASPNET account as a db_owner, however, so I'd leave off that command at the end.
Terri
No comments:
Post a Comment