Hello all. I will be as short as possible explaining the issue I am having. We use a VB 5 application to write and retrieve records from a SQL 2000 database. The application was created 10 years ago, and the source code is lost.Now that we are in the testing phase of converting the database to SQL 2008, we get a ‘sa’ password error when trying to run the VB 5 application. Here is a copy of the error:
Run time error – 2147217843 (80040e4d)
Login failed for user ‘sa’
The VB application consists of an executable file and a folder named “controls” which has an ini file with the settings for the connection as follows:
[Connection]
Server=Myservername
Database=InstanceDatabase
I have changed the server as well as the database, and the VB application works as long as the ‘sa’ password is empty. I also try to add a couple of lines to the ini file stating the User as ‘sa’ and the password, but the application gives me the login failed error. I tried other sa and password lines from connectionstrings.com without luck.
Any ideas?
