Wednesday, March 28, 2012

Newbie question : SQL Admin on Windows server 2003 small business edition.

I have noticed that although SQL server is packaged as part of windows 2003
server it does not include enterprise manager. How am i supposed to be able
to administor anythig, i thought i had seen an app mentioned that did it via
a web console but cannot find such an app.
I am trying to connect to my own SQL server and cannot, someone else has
tried to access it via their enterprise manager but they require a username
/ password, i have tried every password i can imagine that has been used for
the setup of the server, is there any way i can reset the pass or check what
it is?
As it's our server i have full admin rights on it.
Many thanks,
Moss
Assuming you mean SBS 2003 premium, did you select to install SQL Server in
the setup? Check under program files for Microsoft SQL Server directory. I
don't believe it installs automatically...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Moss" <koop@.o2.co.nsm> wrote in message
news:%23fn5$veWEHA.2340@.TK2MSFTNGP09.phx.gbl...
> I have noticed that although SQL server is packaged as part of windows
2003
> server it does not include enterprise manager. How am i supposed to be
able
> to administor anythig, i thought i had seen an app mentioned that did it
via
> a web console but cannot find such an app.
> I am trying to connect to my own SQL server and cannot, someone else has
> tried to access it via their enterprise manager but they require a
username
> / password, i have tried every password i can imagine that has been used
for
> the setup of the server, is there any way i can reset the pass or check
what
> it is?
> As it's our server i have full admin rights on it.
> Many thanks,
> Moss
>
sql

No comments:

Post a Comment