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

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.
Richard ComitoDirector of ITAsked:
Who is Participating?
 
Richard ComitoDirector of ITAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
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
 
mlmccCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.