?
Solved

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

Posted on 2011-10-11
4
Medium Priority
?
393 Views
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.

Error:
     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.
0
Comment
Question by:Richard Comito
3 Comments
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 36952802
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?
0
 

Accepted Solution

by:
Richard Comito earned 0 total points
ID: 36953068
mwvisa1,

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
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 37144335
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

862 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