August 31, 2007 at 4:01 am
Hi ,
Iam using ODBC connection to connect a Power builder 7 application (Third PArty Package ) to SQL Server 2000. The connection properties are mentioned in the INI File.
The sql database was restored from an old database and logins were created and refreshed by a DBA.
if I create the DSN with my domain id in the Windows authentication am able to logon to the application but the same DSN in the SQL mode is not working. This SQL logon has all access on the database. Also using this sql logon am able to connect to isql and my odbc connectivity test is success.
I don't know if the password is not sent to the db by the ODBC or it is sending a wrong password.
The error in ODBC trace log is
DIAG [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user XXXX.
Has anyone faced a similar issue and have fixed it ?
Thanks,
Sathya
August 31, 2007 at 7:40 am
Are you sure that Mixed mode is enabled on the server? Make sure you're connecting the same way, same name/IP and same protocol.
September 3, 2007 at 10:53 pm
yes i have couple of other databases in the same server and am able to logon to those applications with no issues. Mixed mode is enabled.
September 6, 2007 at 8:22 am
Are there any other PowerBuilder application accessing the SQL Server or is this the first ? I seem to remember a long time ago in a galaxy far, far away tha in order for PowerBuilder to use SQL Server there was a script tha needed to be executed against the master database or against each application database used by the application. It created a few application tables that PowerBuilder needed for its extended attributes.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 6, 2007 at 11:55 pm
hi all,
The issue is resolved now. Since it was third party application , the issue was due to the password read functionality of the application.
The application reads the password in a different format than what is stored in the SQL database. Once you know what logic you apply to encrypt the password, use the same to login.
This is one time issue because my database was restored and new passwords were created.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply