Friday, March 30, 2012

log in failed for user [servername]\ASPNET

can anyone help me with this error message, i follow the instruction of someone in other forum, but i cant find where the SQL Server Enterprise manager is, i am using MSDE.One way To see SQL Server Enterprise manager is to install SQL server :)|||If you don't have Enterprise Manage, you can use the command-line utility OSQL that comes with SQL Server.

Go to the command prompt and type in:

osql -S [servername]\instancename -E -q

You will have a 1> prompt.

use yourdatabasename
go

EXEC sp_grantlogin '[servername]\ASPNET'
go

EXEC 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