Link to home
Create AccountLog in
Avatar of Dovberman
DovbermanFlag for United States of America

asked on

How to fix the "Login failed for user" error when using Visual Studio and SQL Server

I have very little SQL Server experience.  When I use the Visual Studio.NET Walkthroughs Chapter 4 example I get the following error:

Login failed for user 'MARTIN-7C3B18F3\IUSR_MARTIN-7C3B18F3'

SQL Server and the web form app I am building are on the same machine.

I am attempting to populate a datagrid that is bound to a dataset that is filled by the codebehind.
Everything works until I try to run the app.

I have no idea what to change to avoid this error.

Thanks,

Dovberman
ASKER CERTIFIED SOLUTION
Avatar of Bob Learned
Bob Learned
Flag of United States of America image
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Dovberman
Dovberman
Flag of United States of America image

ASKER

I called Microsoft support after waiting 5 days for a response from Experts Exchange.  There seems to be a great need for ASP.NET experts here.

The SQL Server authentication mode was the key to this issue.

Thanks

Dovberman