Database connection error

[jmedidi]

I am using this Connect In-DB Tool , getting the below error if i select the connection. I dont see any issue with DB connection at all. Able to connect to it.

Error: Connect In-DB (113): Error opening connect string: Microsoft OLE DB Provider for SQL Server: Login failed for user 'test'.

Hope this is clear.

[jrgo]

@jmedidi 

The connection failed to login using the user "test". If that user name is valid, then the password entered is not valid. If "test" is NOT a valid user then you'll need to reconfigure the the In-DB connection used and modify the connection string so that it's stored with valid credentials. May also be easier to just delete the existing In-DB connection and recreate. 

If updating the connection string, look for these to parameters and update the value (highlighted part). If you don't see the Password parameter, you can add it in. The password value will change to that __EncPwd1__ after you OK your changes.

If delete and recreate route is preferred, just be sure that you enter in valid username and password (and be sure to check the option to save pw) in addition to the other option that need to be included.

Both these suggestions are under the assumption that your SQL Server is configured to use SQL Authentication, not Windows Authentication. However, if Win Auth is what your DB requires, then be sure you select the "Use Windows NT Integrates security" radio button under option 2.