August 16, 2002 at 6:38 am
Guys i don't know if i am posting this in the correct place or not but, i am having connection problems with my database. When i go to the DSN manager and try to add my SQL database i get a login failed error stating that i am not associated with a trusted SQL server connection. Can anyone help me. PLEASE!!
August 16, 2002 at 6:57 am
Do you want to use SQL Server security or Windows Security?
Check your Logins (Security) and Users (Database) in Enterprise Manager, and add the user if needed.
August 16, 2002 at 7:09 am
i would like to use SQL Server security.
August 16, 2002 at 7:19 am
In that case, create a Login with the appropriate Name (and password), and assign sufficient rights to it for the databases you want the user to access.
Also check which type of network library you are using (under the Client Configuration button). If it is NamedPipes, I think you also have to log on to Windows with a (windows-)user that has access to the machine where SQL Server is running.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply