Re: MSDE 2000 and Default Database

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 03/20/04 

Date: Sat, 20 Mar 2004 13:22:40 +0530

Hi,

In your script execute use the OSQ utility,

OSQL -Uuser -Ppassword -Sserver -Q"TSQL Commands" -o <log file>

In the TSQL COmmands place you can fire a stored procedure which does all

1. Create your database with Attach option
2. Creation of logins and users .....

Thanks
Hari
MCDBA

"GerardoU" <gerardou@xygnus.com> wrote in message
news:30D08198-2025-47EB-AA2D-D0F46A519E34@microsoft.com...
> Hi friends...
>
> I hope this one is an easy one. I am deploying the MSDE 2000 along with my
application. That application uses a Database created for the application's
purpose. To let the end user install the MSDE on their PCs, I am using the
Setup /settings setup.ini command line... I don't know an easier way for my
end-users to do it. The problem is that that command line installs the
Master and Default databases but I can not find the way to make it install
mine (MDF and LDF files).
>
> I will really appreciate any help on how to do it without the end-user
intervention. The installer takes on the job from that point forward
configuring the ODBC data source and other stuff, but my installer can not
register the application's Database neither... well, I think so
(InstallShield Express 3.03). It can copy both files but can not register
the DB with the MSDE.
>
> Please help me. Thanks in advance.
>
> Regards
> gerardou@xygnus.com

Relevant Pages

  • Re: User Rights Assignment - not available - Resolved
    ... Then copy the security file from the \windows\repair ... If none of that works I would try an upgrade/repair install ... shows user rights and use the Resource Kit command line tool NTrights to ... This operation may find that this database is corrupt ...
    (microsoft.public.windowsxp.security_admin)
  • Re: User Rights Assignment - not available - Resolved
    ... Thanks Steve for your effort to help me here. ... If none of that works I would try an upgrade/repair install ... it shows user rights and use the Resource Kit command line tool ... This operation may find that this database is corrupt ...
    (microsoft.public.windowsxp.security_admin)
  • Re: MSDE to SQL2000 upgrade problem
    ... when I tried to upgrade from MSDE to SQL 2000 ... There where 4 production servers, each running MSDE, and my desktop ... Then I used the 'detach database' option, ... > after the Server2000 install is done. ...
    (microsoft.public.sqlserver.setup)
  • Re: Newbie - Help with VB.Net Install!
    ... > and install the MSDE the download works but the installation fails. ... > I have opened an MS-DOS command prompt and changed to the C:\MSDERelA ... where yourSAPassword is your actual system administrator password. ...
    (microsoft.public.dotnet.framework)
  • Re: Distribute app/database with SQL or Windows security?
    ... As for other applications using your instance - the MSDE license only allows ... database a simple way of protecting the licensing the program. ... > MSDE and won't install because I have set the SA password? ...
    (microsoft.public.sqlserver.msde)