Re: register database
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 06/06/04
- Next message: Paul Ibison: "Re: Cannot install SQL Server 2000 Developer edition on Windows XP Pro"
- Previous message: Hari Prasad: "Re: service pack"
- In reply to: Daniel: "register database"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 6 Jun 2004 14:51:32 +0530
Hi,
MSDE will not come up with normal tools graphical tools. Follow the below
steps to attach the database in MSDE
1. From command prompt execute
OSQL -Usa -Ppassword -S servername (Enter Key)
This will go go to a sql prompt, there execute the sp_attach_db to attach
the MDF and LDF file to sql server
1> sp_attach_db
'dbname','c:\mssql\data\dname_data.mdf','c:\mssql\data\dname_log.ldf'
(enter Key)
2>go (enter key)
This will attach the database to sql server. After this you can access the
database. Provide the directory and MDF and LDF file names appropriately.
----------------------------------------------
Microsoft is giving a free tool named "SQL Server web data Administrator" to
manager and administrator the SQl server. This will be more useful to
MSDE users.
Download the free tool from below site.
http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
Thanks
Hari
MCDBA
"Daniel" <dwbnews@hotmail.com> wrote in message
news:OIsozWpSEHA.3332@tk2msftngp13.phx.gbl...
> 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?
>
>
- Next message: Paul Ibison: "Re: Cannot install SQL Server 2000 Developer edition on Windows XP Pro"
- Previous message: Hari Prasad: "Re: service pack"
- In reply to: Daniel: "register database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
