Null User

[Erics44]

Hi
I am getting the error -

"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection"

when trying to connect to my server, my connection string is -

data source=" & strServer & ";initial catalog=" & SourceDatabase & ";Trusted_Connection = False;User ID=" & strUser & ";"

I have searched through many posts that touch the subject on this forum and this (I think) is what I need to do -

"Ensure that a Windows authentication SQL Server login exists for the Windows NT/Windows 2000 user account that IIS uses to process the request for the ASP page. If a login does not exist, use SQL Server Enterprise Manager to create it"

I am not sure how to do this, can anyone please help
Thanks very much

 

[mrdenny]

Your connection string isn't using Windows Auth. You are passing a username and have trusted_connection = false.

To get the current connection string to work you need to add the password field to the connection string and ensure that the account you are trying to use exists in the SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com