MSDE 2000 Administration tool

Hi all,

I have installed MSDE on my computer but it's missing, as all you already
know, a serious (well, osql IS TOO serious but not very newbie friendly)
admin tool.

I have downloaded http://www.asql.biz/DbaMgr.shtm and i'm quite happy with
it but was wondering if there's something better or that may complete what
DbaMgr2k is missing... and preferably is as free as DbaMgr2k.

Thank You,
LorenzoHi

There is a list at:
http://www.aspfaq.com/show.asp?id=2442

John

"Lorenzo Bolognini" <lorenzo@.mysurname.net> wrote in message
news:pkd_a.43324$an6.1479482@.news1.tin.it...
> Hi all,
> I have installed MSDE on my computer but it's missing, as all you already
> know, a serious (well, osql IS TOO serious but not very newbie friendly)
> admin tool.
> I have downloaded http://www.asql.biz/DbaMgr.shtm and i'm quite happy with
> it but was wondering if there's something better or that may complete what
> DbaMgr2k is missing... and preferably is as free as DbaMgr2k.
> Thank You,
> Lorenzo|||Thank you very much John.

Lorenzo

MSDE - Setting up security

I am just missing the big picture. I am having some problems that I think I
can correct by entering sp_grantlogin to grant a login to the SQL Server and
sp_adduser to add a user to the database.
I have no idea where these commands go. What tool/process am I using to get
the commands into MSDE to change the security? I tried cranking up OSSQL but
it just kept showing me the list of commands.
Sorry to be dumb.
Jan F wrote:
> I am just missing the big picture. I am having some problems that I
> think I can correct by entering sp_grantlogin to grant a login to the
> SQL Server and sp_adduser to add a user to the database.
> I have no idea where these commands go. What tool/process am I using
> to get the commands into MSDE to change the security? I tried
> cranking up OSSQL but it just kept showing me the list of commands.
> Sorry to be dumb.
You can use OSQL's command-line interface. The MSDE does not include the
SQL Server Client Tools, but you can use the web data administrator or
any third-party management tool:
http://www.microsoft.com/downloads/d...displaylang=en
David G.
|||Hi Jan,
There's a tool at our site (MSDE Manager) that's free for personal use.
It'll help you do all these sorts of things.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jan F" <JanF@.discussions.microsoft.com> wrote in message
news:7F184178-D650-4B0B-9BD1-A1DE4C12FD44@.microsoft.com...
>I am just missing the big picture. I am having some problems that I think I
> can correct by entering sp_grantlogin to grant a login to the SQL Server
> and
> sp_adduser to add a user to the database.
> I have no idea where these commands go. What tool/process am I using to
> get
> the commands into MSDE to change the security? I tried cranking up OSSQL
> but
> it just kept showing me the list of commands.
> Sorry to be dumb.
>

msdbdata.mdf missing after installing an instance of MSDE

Hi all,
msdbdata.mdf is missing after I install an instance of MSDE.
What could be causing this?
Thanks
hi Jason,
Jason Fischer wrote:
> Hi all,
> msdbdata.mdf is missing after I install an instance of MSDE.
> What could be causing this?
are you sure you correctly installed MSDE? no error has been reported? the
verbose log file shows no problems?
msdb database is a system database and is part of a proper installation...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
Yes, there was no error reported while installing.
I know that msdb is a system DB, that's what is bugging me.
I will check the log file again and see if there is anything funny reported
even though an error isn't logged.
Thanks,
Jason
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3kkk2oFuh3b0U1@.individual.net...
> hi Jason,
> Jason Fischer wrote:
> are you sure you correctly installed MSDE? no error has been reported? the
> verbose log file shows no problems?
> msdb database is a system database and is part of a proper installation...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>