I am new to Microsoft SQL Server. I mostly use MySQL and Firebird databases in my projects.
I have a client who needs to restore some software after his computer crashed. All that is left is a pen drive with the application and database backup.
I have discovered that this application used Microsoft SQL Server 7 and it comes with three files: the executable, an .MDF
and a .LDF
file.
I installed the trial version of SQL Server 2012 and defined c:\mssql7\data
as the database folder in order to match the original files. I also set the user interface to work with Windows accounts, because I do not know if that application programmer changed the database default user and password.
But when I run the application, it displays this message:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server do not exist or access denied.
What should I do to restore the database and get it to work with the application? The original developer cannot be located.
Perhaps the login and password I am using does not match the ones in the restored database files? Perhaps I have a misconfiguration somewhere, for instance maybe I cannot simply copy the files into the data folder? Perhaps I need to register the database somehow?
Edit 1: The only thing I found by reading the contents of the executable file was:
Provider=SQLOLEDB
Itegrated Security=SSPI
Persiste Security Info=False
User ID=usuario
Initial Catalog=FVBraganca
DataSource=SCFRANGOS
If you guys want to see the original file, you can download it from my website:
http://alcantara.net.br/MS_SQL_APP_BUGGY.rar
http://alcantara.net.br/MS_SQL_APP_BUGGY.zip