I am having problems with connecting to a SQL Database. When I setup the ODBC connection where I specified to use the SQL Server authentication for Login and Password on a client workstation. I entered the user name and password to use for this connection and when I tested the connection everything connects fine.
The problem is when the client machine attempts to connect to the SQL Server, it prompts them for a user name and password even though both are filled in. If I hit enter I get connected and everything works correctly. I want the connection to be seamless where the end user never sees the login and password. Can anyone tell me what I’m doing wrong?
Thank You,
Wayne Benhart
The problem is when the client machine attempts to connect to the SQL Server, it prompts them for a user name and password even though both are filled in. If I hit enter I get connected and everything works correctly. I want the connection to be seamless where the end user never sees the login and password. Can anyone tell me what I’m doing wrong?
Thank You,
Wayne Benhart