I have installed an application made with VB6 on a computer, and have
installed MSDE 2000. I've copied the .ldf and .mdf files in the appropriate
folder. However, the login information that is contained in the application
doesn't allow me to access the database. I was able to access the database
when I was designing the application. I used a dataenvironment. When I ran
the application on the user's computer, it asked for the password for the sa
account and also for the name of the instance of SQL Server to connect to.
I was able to give that information correctly. What is the problem? Was I
supposed to do more than copy the .ldf and .mdf files onto the hard drive.
Was I supposed to somehow register those files with SQL Server? MSDE
doesn't come with the same tools as SQL Server. Can someone help?

[quoted text, click to view]

Each SQL Server / MSDE as it's own login info. Check about the SQL Server
security at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_4fol.asp

[quoted text, click to view]

Yes, use the sp_attach_db system SP
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts
_sp_ae-az_52oy.asp).
Note that there are many free MSDE admin tools availble on the Web.

--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com