setting up a database in msde

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Daniel (dwbnews_at_hotmail.com)
Date: 06/05/04 

Date: Fri, 4 Jun 2004 21:51:01 -0500

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?

Relevant Pages

  • setting up a database in msde
    ... installed MSDE 2000. ... 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? ...
    (microsoft.public.sqlserver.tools)
  • setting up a database in msde
    ... installed MSDE 2000. ... 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? ...
    (microsoft.public.sqlserver.programming)
  • register database
    ... installed MSDE 2000. ... 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? ...
    (microsoft.public.sqlserver.server)
  • Re: Restore of DB
    ... I think the .ldf and .mdf files would be on a different ... C coz of some issues and Installed the SQL Server again. ... >there a way to recreate the DB, ...
    (microsoft.public.sqlserver.server)
  • Re: ms sql server 2000 security too weak ?
    ... About the monitoring data traffic is not very easy do that if the ... My suggestion is when attaching the MDF files will require the original ... > If the user is an administrator of the SQL Server, ...
    (microsoft.public.sqlserver.server)