System.Data.SqlClient.SqlException: Login failed for user 'xxx\ASPNET'
-
hello, i get this error-> System.Data.SqlClient.SqlException: Login failed for user 'xxx\ASPNET' do some one knows how to solve it? i am new to sql and i use msde. thank u in advance
You basically have three options: 1) Get some SQL Server management tools, and set up login/user permissions in the SQL Server / Database for the ASPNET user. 2) Same as above, but create a separate SQL Login account, and don't use trusted connections to the database. 3) Add the ASPNET user to the Administrators group. This, however, is not at all secure, and can have very serious side-effects.
Grim
(aka Toby)
MCDBA, MCSD, MCP+SB
-
hello, i get this error-> System.Data.SqlClient.SqlException: Login failed for user 'xxx\ASPNET' do some one knows how to solve it? i am new to sql and i use msde. thank u in advance
It sounds like your connection string is setup using Integrated Security. Avoid this and use a dedicated username and password for SQL access. You'll also have to setup that username and password for the database using SQLManager. RageInTheMachine9532 "...a pungent, gastly, stinky piece of cheese!" -- The Roaming Gnome