| Author |
Message |
Rick Gomez
Guest
|
 Posted:
Sat Jan 15, 2005 2:19 am Post subject:
SQL Administration in SBS2003. |
|
|
I am completely new to SQL administration.
I have a client who is migrating their accounting package to a SQL Server
based version. They currently have SBS 2003 Premium running and SQL is being
used for Sharepoint & Veritas Backup.
According to documentation, there should be a plug-in in IIS that allows you
to manage SQL, but there isn't one listed. Is there something else I need to
install via the CDs? I know there are some web based utilities that look
awesome to use, but my client would rather not spend the $350+ for software
they will only ocassionally use.
Thank you.
--
Rick Gomez - Owner/Consultant
fiona Systems Integration
www.fionasystems.com |
|
| Back to top |
|
 |
Susan Bradley, CPA aka Eb
Guest
|
| Posted:
Sat Jan 15, 2005 2:35 am Post subject:
Re: SQL Administration in SBS2003. |
|
|
You can use the Enterprise manager from the SQL tools?
Rick Gomez wrote:
| Quote: | I am completely new to SQL administration.
I have a client who is migrating their accounting package to a SQL Server
based version. They currently have SBS 2003 Premium running and SQL is being
used for Sharepoint & Veritas Backup.
According to documentation, there should be a plug-in in IIS that allows you
to manage SQL, but there isn't one listed. Is there something else I need to
install via the CDs? I know there are some web based utilities that look
awesome to use, but my client would rather not spend the $350+ for software
they will only ocassionally use.
Thank you. |
|
|
| Back to top |
|
|
Rick Gomez
Guest
|
| Posted:
Sat Jan 15, 2005 2:47 am Post subject:
Re: SQL Administration in SBS2003. |
|
|
There is nothing in the Programs folder that has any reference to SQL tools.
Nothing in the Server Administration box either. This is why I am so
confused. Is there an option in server installation to install SQL tools? I
knew my client would be using SQL and wouldn't have opted to not install SQL
tools, but maybe I did.
"Susan Bradley, CPA aka Ebitz - SBS Rocks" wrote:
| Quote: | You can use the Enterprise manager from the SQL tools?
Rick Gomez wrote:
I am completely new to SQL administration.
I have a client who is migrating their accounting package to a SQL Server
based version. They currently have SBS 2003 Premium running and SQL is being
used for Sharepoint & Veritas Backup.
According to documentation, there should be a plug-in in IIS that allows you
to manage SQL, but there isn't one listed. Is there something else I need to
install via the CDs? I know there are some web based utilities that look
awesome to use, but my client would rather not spend the $350+ for software
they will only ocassionally use.
Thank you.
|
|
|
| Back to top |
|
|
Henry Craven
Guest
|
| Posted:
Sat Jan 15, 2005 5:03 am Post subject:
Re: SQL Administration in SBS2003. |
|
|
Run the SQL Server CD on the Workstation where the SQL Server will be
administered from and it will give you the option to install the Admin
Tools. - They do not install by default on the Server as Part of the SQL
Server install.
There is also a Web Admin for SQL Server:
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en
Also be aware that your Sharepoint & Veritas Backup are probably running
MSDE unless you have specifically upgraded these databases to SQL
Server.
Do not forget to Backup the SQL Server and MSDE Databases and to keep
them Service Packed.
--
Henry Craven {SBS-MVP}
Melbourne Australia
"Rick Gomez" <RickGomez@discussions.microsoft.com> wrote in message
news:6EACA423-FF80-4ABF-A348-D084ED243FAB@microsoft.com...
| Quote: | There is nothing in the Programs folder that has any reference to SQL
tools.
Nothing in the Server Administration box either. This is why I am so
confused. Is there an option in server installation to install SQL
tools? I
knew my client would be using SQL and wouldn't have opted to not
install SQL
tools, but maybe I did.
"Susan Bradley, CPA aka Ebitz - SBS Rocks" wrote:
You can use the Enterprise manager from the SQL tools?
Rick Gomez wrote:
I am completely new to SQL administration.
I have a client who is migrating their accounting package to a SQL
Server
based version. They currently have SBS 2003 Premium running and
SQL is being
used for Sharepoint & Veritas Backup.
According to documentation, there should be a plug-in in IIS that
allows you
to manage SQL, but there isn't one listed. Is there something else
I need to
install via the CDs? I know there are some web based utilities
that look
awesome to use, but my client would rather not spend the $350+ for
software
they will only ocassionally use.
Thank you.
|
|
|
| Back to top |
|
|
Kevin Weilbacher [SBS-MVP
Guest
|
| Posted:
Sat Jan 15, 2005 7:22 am Post subject:
Re: SQL Administration in SBS2003. |
|
|
SQL nor ISA install automatically when SBS2003 is installed. You have to
insert the 5th CD and install each manually.
--
Kevin Weilbacher [SBS-MVP]
"The days pass by so quickly now, the nights are seldom long"
"Rick Gomez" <RickGomez@discussions.microsoft.com> wrote in message
news:CDCE3F1D-55D2-429D-A9A3-738A191F0A5C@microsoft.com...
| Quote: | I am completely new to SQL administration.
I have a client who is migrating their accounting package to a SQL Server
based version. They currently have SBS 2003 Premium running and SQL is
being
used for Sharepoint & Veritas Backup.
According to documentation, there should be a plug-in in IIS that allows
you
to manage SQL, but there isn't one listed. Is there something else I need
to
install via the CDs? I know there are some web based utilities that look
awesome to use, but my client would rather not spend the $350+ for
software
they will only ocassionally use.
Thank you.
--
Rick Gomez - Owner/Consultant
fiona Systems Integration
www.fionasystems.com |
|
|
| Back to top |
|
|
Rick Gomez
Guest
|
| Posted:
Sun Jan 16, 2005 3:41 am Post subject:
Re: SQL Administration in SBS2003. |
|
|
Thank you everyone. I'll give this a try on Tuesday and will let you know
how it goes.
Rick Gomez
"Kevin Weilbacher [SBS-MVP]" wrote:
| Quote: | SQL nor ISA install automatically when SBS2003 is installed. You have to
insert the 5th CD and install each manually.
--
Kevin Weilbacher [SBS-MVP]
"The days pass by so quickly now, the nights are seldom long"
"Rick Gomez" <RickGomez@discussions.microsoft.com> wrote in message
news:CDCE3F1D-55D2-429D-A9A3-738A191F0A5C@microsoft.com...
I am completely new to SQL administration.
I have a client who is migrating their accounting package to a SQL Server
based version. They currently have SBS 2003 Premium running and SQL is
being
used for Sharepoint & Veritas Backup.
According to documentation, there should be a plug-in in IIS that allows
you
to manage SQL, but there isn't one listed. Is there something else I need
to
install via the CDs? I know there are some web based utilities that look
awesome to use, but my client would rather not spend the $350+ for
software
they will only ocassionally use.
Thank you.
--
Rick Gomez - Owner/Consultant
fiona Systems Integration
www.fionasystems.com
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in