@"Login failed for user '\'."

[Guest]

I have a .NET 1.1 component trying to connect to a database but I keep
getting the following message when the exception is thrown:

@"Login failed for user '\'."

It appears that no user and role are being passed to the connection object,
otherwise it would surely give the name of the user who was being denied.

Has anyone come up against this before? A search told me to set both SQL
and Windows authorisation on the SQL Server, but that was already in place.
I have ensured that the user is valid in SQL server and cannot think of where
to go from here.

Any help would be much appreciated.

 

[VJ]

If you are sure the name/password is being passed, then the user may be
valid SQL User, but does the user have access to the specific Database you
are trying to access?

Also use ISQLW and see if you can login with same name/password to the
specified DB.. that is a cross - check

VJ

 

[Todos Menos [MSFT]]

you really should just use the sa username and a blank password

-Todos