Showing posts with label configuration. Show all posts
Showing posts with label configuration. Show all posts

Friday, March 23, 2012

MMC for SQL Server 2005?

I would like to add SQL Server 2005 management console to my custom built MM
C
– but the only snap in I can find is SQL Server Configuration Manager. Is
there a snap-in for SQL Server 2005 available or do I have to use SQL Server
Management Studio?
Cheers,
NinaHi Nina
AFAIK there is no MMC other than Configuration Manager, in general MMCs have
been replaced by more reliable managed code, therefore you would need to
write your own that uses SMO.
John
"Nina" wrote:

> I would like to add SQL Server 2005 management console to my custom built
MMC
> – but the only snap in I can find is SQL Server Configuration Manager. I
s
> there a snap-in for SQL Server 2005 available or do I have to use SQL Serv
er
> Management Studio?
> Cheers,
> Nina|||Thanks for confirming that John.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Nina
> AFAIK there is no MMC other than Configuration Manager, in general MMCs ha
ve
> been replaced by more reliable managed code, therefore you would need to
> write your own that uses SMO.
> John
> "Nina" wrote:
>sql

Friday, March 9, 2012

missing SSIS configurations...pls help.

http://img96.imageshack.us/my.php?image=untitled5ia1.jpg

how come my SQL 2005 surface area configuration don't have the configuration for SIS and other settings? seems to be missing alot of settings...it only say SQL 2005 Express when I m using SQL 2005 enterprise....

It would indicate that you have not installed any other services. What OS is this, Enterprise requires a server OS. Check Services in Control Panle, Admin Toosl, and see how many SQL services there are.|||

these are the services running in my computer...

SQL server (SQLExpress)

SQL Server active directory helper

SQL Server Browser

SQL Server VSS Writer

SQLServerAgent

MSSQLSERVER

I am using SQL 2005 enterprise in winxp professsional.