Visual Studio 2005: Login failed for user '(null)'

Posted on 2011-10-11
Last Modified: 2012-05-12
From a Windows XP machine, I get the following error when trying to edit/access/run a report in Visual Studio 2005.  Data source is on SQL Server 2005 using mixed mode authentication.

     Login failed for user ''. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

This works fine for the same user on a different PC running Windows 7.  So we are thinking there is some local setting causing incorrect login to be passed instead of the expected Windows login.  NOTE: login to the source database using SQL Server Management Studio and Windows authentication works correctly on the same PC.

Please help.
Question by:GabicusC
    LVL 59

    Expert Comment

    by:Kevin Cross
    What connection string are you using? Do both machines have the same amount of client tools and/or drivers for SQL server installed? In other words, does one have any newer native clients or other VS/Database tools different than the one not working?

    Accepted Solution


    thanks for the reply.  It was with the credentials.  When opening the same SLN on a different computer we had to reset the DB credentials.

    Thank you again
    LVL 100

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
    A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    737 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

    19 Experts available now in Live!

    Get 1:1 Help Now