Login failed for user 'FAMILY\ASPNET'.
this is the error message when i connect to database, FAMILY is my computer name.
my connection string is: "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=forum"
You will need to configure access on your database for the ASPNET account that is used to run your ASP.NET applications.
To do this, launch SQL Server Management Studio (or Management Studio Express), expand the Security item until you see the Logins node, right click on it and choose New Login...
In the resulting dialog, select the ASPNET account. You will then need to configure the database to allow access for that user (expand the database tree to find the db, check out the Security > Users and Security > Roles for more information).
Note that it is tempting to simply add the ASPNET account to the Administrators group on the machine, as Administrators tends to get full access to the db. Avoid doing this: it's not a great security option.
|||i've got it. thanks a lot
No comments:
Post a Comment