Sql Exception
ASP.NET
2
Posts
2
Posters
0
Views
1
Watching
-
Hello while I am trying to connect/bind my datagrid to my database it throws SqlException, and I have the feeling as if I am getting the user name wrong because the message for sqlexception is "Login failed for user 'SYSTEMNAME\ASPNET'. Thanks in advance.
-
Hello while I am trying to connect/bind my datagrid to my database it throws SqlException, and I have the feeling as if I am getting the user name wrong because the message for sqlexception is "Login failed for user 'SYSTEMNAME\ASPNET'. Thanks in advance.
hai in SQl Enterprise manager go to users and add new user to the database.
step1: select users in tree view and right click select new database user, step2: a dialog box appers , In login name conbo select step3: in the name filed select ... in the right corner. step4: it opens another dialog, select list names from filed to your machine name. step5: Aspnet user will available in the list select that and click ok. step6: select server roles tab and check true to system administrator step7: select database access tab and check true to the database which you want the user to access. step8: then check true to db_owner in the below list.click ok step9: the user was added sucessfully and all dialog box closes except new user box. step10: check the database userlist for confirmation.