When testing the connection for Wise Integration Component, I receive the error "Login failed for user WiseSvc Ole DB invalid connection string attribute."
When connecting to the Wise Software Manager Database, we look at the config.ini file in the share point and use the values in the ServiceSqlUser and ServiceSqlPassword fields to connect to the database.
The ServiceSqlPassword field contains the encrypted value of the password. This error message occurs if the actual password in SQL and the decrypted password do not match.
In the event that the encrypted password and the actual password got out of synch, you can reset the password by doing the following:
Open Wise Repository Manager.
Click on Databases > Wise Services > Wise Services Database.
Click the Settings button in the lower-right corner.
On the Change Database Settings dialog, either select Windows NT authentication from the first set of radio buttons if your Windows login is a DBA on your SQL Server or select SQL Server Authentication and specify the user name and password of a SQL DBA.
Specify a new password in the Password field. This will update the config.ini to have the correct encrypted password. It will also change the password on the SQL server to the password specified.
Applies To Wise Package Studio 6.01 Wise Integration Component 6.1.126
This is machine translated content
Login to Subscribe
Please login to set up your subscription.
Didn't find the article you were looking for? Try these resources.