Thursday, August 2, 2007

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'xxxxxxx\ASPNET' in C#, VB.NET, ASP.NET

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'SANTOSH_LAPTOP\ASPNET' in C#, VB.NET, ASP.NET: "Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'xxxxxx\ASPNET'"



Open SQL Enterprise Manager
Locate Server
Open Security Folder => Logins
Now right-click and select “New Login…”
1) Create user with Name : ASPNET
2) Select Domain : “ServerName” to connect
3) Grant permissions to access database with “Server Roles” tab
4) Also permit database access with “Database Access” tab.



www.svdeals.com access database deals

No comments: