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

Posted on 2006-03-23
Last Modified: 2010-04-23
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.


Question by:Dovberman
    LVL 96

    Accepted Solution

    What is the authentication mode for SQL Server?


    Author Comment

    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.



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
    It’s quite interesting for me as I worked with Excel using for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now