Showing posts with label snap-in. Show all posts
Showing posts with label snap-in. Show all posts

Friday, March 23, 2012

MMC Snap-in for SQL 2005

I'm looking for an MMC Snap-in for SQL 2005. I found reference to on for SQL
2000 here http://msdn2.microsoft.com/en-us/library/aa174466(SQL.80).aspx but
can't seem to location one form 2005. Can anyone tell me if there is one
and if so where I can find it?The corresponding tool for 2005 is named "SQL Server Management Studio". It
is not an MMC snap-in,
though (it is an exe file).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Mark" <user@.domain.com> wrote in message news:F6F80E86-3780-4428-AE06-FF0A640D0ED6@.microsof
t.com...
> I'm looking for an MMC Snap-in for SQL 2005. I found reference to on for S
QL 2000 here
> http://msdn2.microsoft.com/en-us/library/aa174466(SQL.80).aspx but can't s
eem to location one form
> 2005. Can anyone tell me if there is one and if so where I can find it?|||SQL Enterprise Manager is the MMC snap-in for SQL 2000. SQL 2005 uses a
Visual Studio based management console, SQL Server Management Studio. There
is no MMC-based management console for SQL 2005.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Mark" <user@.domain.com> wrote in message
news:F6F80E86-3780-4428-AE06-FF0A640D0ED6@.microsoft.com...
> I'm looking for an MMC Snap-in for SQL 2005. I found reference to on for
> SQL 2000 here
> http://msdn2.microsoft.com/en-us/library/aa174466(SQL.80).aspx but can't
> seem to location one form 2005. Can anyone tell me if there is one and if
> so where I can find it?|||Ok. Thank you.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:CF235AB0-9596-48E9-B33E-01C00D61EE24@.microsoft.com...
> The corresponding tool for 2005 is named "SQL Server Management Studio".
> It is not an MMC snap-in, though (it is an exe file).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Mark" <user@.domain.com> wrote in message
> news:F6F80E86-3780-4428-AE06-FF0A640D0ED6@.microsoft.com...
>|||Thank you. I'll stop searching and just install the Management Studio.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23dNYt08HIHA.4808@.TK2MSFTNGP05.phx.gbl...
> SQL Enterprise Manager is the MMC snap-in for SQL 2000. SQL 2005 uses a
> Visual Studio based management console, SQL Server Management Studio.
> There is no MMC-based management console for SQL 2005.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Mark" <user@.domain.com> wrote in message
> news:F6F80E86-3780-4428-AE06-FF0A640D0ED6@.microsoft.com...
>

MMC Snap-in for SQL 2005

I'm looking for an MMC Snap-in for SQL 2005. I found reference to on for SQL
2000 here http://msdn2.microsoft.com/en-us/library/aa174466(SQL.80).aspx but
can't seem to location one form 2005. Can anyone tell me if there is one
and if so where I can find it?
SQL Enterprise Manager is the MMC snap-in for SQL 2000. SQL 2005 uses a
Visual Studio based management console, SQL Server Management Studio. There
is no MMC-based management console for SQL 2005.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Mark" <user@.domain.com> wrote in message
news:F6F80E86-3780-4428-AE06-FF0A640D0ED6@.microsoft.com...
> I'm looking for an MMC Snap-in for SQL 2005. I found reference to on for
> SQL 2000 here
> http://msdn2.microsoft.com/en-us/library/aa174466(SQL.80).aspx but can't
> seem to location one form 2005. Can anyone tell me if there is one and if
> so where I can find it?
|||Ok. Thank you.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:CF235AB0-9596-48E9-B33E-01C00D61EE24@.microsoft.com...
> The corresponding tool for 2005 is named "SQL Server Management Studio".
> It is not an MMC snap-in, though (it is an exe file).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Mark" <user@.domain.com> wrote in message
> news:F6F80E86-3780-4428-AE06-FF0A640D0ED6@.microsoft.com...
>
|||Thank you. I'll stop searching and just install the Management Studio.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23dNYt08HIHA.4808@.TK2MSFTNGP05.phx.gbl...
> SQL Enterprise Manager is the MMC snap-in for SQL 2000. SQL 2005 uses a
> Visual Studio based management console, SQL Server Management Studio.
> There is no MMC-based management console for SQL 2005.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Mark" <user@.domain.com> wrote in message
> news:F6F80E86-3780-4428-AE06-FF0A640D0ED6@.microsoft.com...
>
sql

MMC Snap-in for SQL 2005

I'm looking for an MMC Snap-in for SQL 2005. I found reference to on for SQL
2000 here http://msdn2.microsoft.com/en-us/library/aa174466(SQL.80).aspx but
can't seem to location one form 2005. Can anyone tell me if there is one
and if so where I can find it?
SQL Enterprise Manager is the MMC snap-in for SQL 2000. SQL 2005 uses a
Visual Studio based management console, SQL Server Management Studio. There
is no MMC-based management console for SQL 2005.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Mark" <user@.domain.com> wrote in message
news:F6F80E86-3780-4428-AE06-FF0A640D0ED6@.microsoft.com...
> I'm looking for an MMC Snap-in for SQL 2005. I found reference to on for
> SQL 2000 here
> http://msdn2.microsoft.com/en-us/library/aa174466(SQL.80).aspx but can't
> seem to location one form 2005. Can anyone tell me if there is one and if
> so where I can find it?
|||Ok. Thank you.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:CF235AB0-9596-48E9-B33E-01C00D61EE24@.microsoft.com...
> The corresponding tool for 2005 is named "SQL Server Management Studio".
> It is not an MMC snap-in, though (it is an exe file).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Mark" <user@.domain.com> wrote in message
> news:F6F80E86-3780-4428-AE06-FF0A640D0ED6@.microsoft.com...
>
|||Thank you. I'll stop searching and just install the Management Studio.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23dNYt08HIHA.4808@.TK2MSFTNGP05.phx.gbl...
> SQL Enterprise Manager is the MMC snap-in for SQL 2000. SQL 2005 uses a
> Visual Studio based management console, SQL Server Management Studio.
> There is no MMC-based management console for SQL 2005.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Mark" <user@.domain.com> wrote in message
> news:F6F80E86-3780-4428-AE06-FF0A640D0ED6@.microsoft.com...
>

MMC Snap-in for SQL 2005

I'm looking for an MMC Snap-in for SQL 2005. I found reference to on for SQL
2000 here http://msdn2.microsoft.com/en-us/library/aa174466(SQL.80).aspx but
can't seem to location one form 2005. Can anyone tell me if there is one
and if so where I can find it?The corresponding tool for 2005 is named "SQL Server Management Studio". It is not an MMC snap-in,
though (it is an exe file).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Mark" <user@.domain.com> wrote in message news:F6F80E86-3780-4428-AE06-FF0A640D0ED6@.microsoft.com...
> I'm looking for an MMC Snap-in for SQL 2005. I found reference to on for SQL 2000 here
> http://msdn2.microsoft.com/en-us/library/aa174466(SQL.80).aspx but can't seem to location one form
> 2005. Can anyone tell me if there is one and if so where I can find it?|||SQL Enterprise Manager is the MMC snap-in for SQL 2000. SQL 2005 uses a
Visual Studio based management console, SQL Server Management Studio. There
is no MMC-based management console for SQL 2005.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Mark" <user@.domain.com> wrote in message
news:F6F80E86-3780-4428-AE06-FF0A640D0ED6@.microsoft.com...
> I'm looking for an MMC Snap-in for SQL 2005. I found reference to on for
> SQL 2000 here
> http://msdn2.microsoft.com/en-us/library/aa174466(SQL.80).aspx but can't
> seem to location one form 2005. Can anyone tell me if there is one and if
> so where I can find it?|||Thank you. I'll stop searching and just install the Management Studio.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23dNYt08HIHA.4808@.TK2MSFTNGP05.phx.gbl...
> SQL Enterprise Manager is the MMC snap-in for SQL 2000. SQL 2005 uses a
> Visual Studio based management console, SQL Server Management Studio.
> There is no MMC-based management console for SQL 2005.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Mark" <user@.domain.com> wrote in message
> news:F6F80E86-3780-4428-AE06-FF0A640D0ED6@.microsoft.com...
>> I'm looking for an MMC Snap-in for SQL 2005. I found reference to on for
>> SQL 2000 here
>> http://msdn2.microsoft.com/en-us/library/aa174466(SQL.80).aspx but can't
>> seem to location one form 2005. Can anyone tell me if there is one and
>> if so where I can find it?
>|||Ok. Thank you.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:CF235AB0-9596-48E9-B33E-01C00D61EE24@.microsoft.com...
> The corresponding tool for 2005 is named "SQL Server Management Studio".
> It is not an MMC snap-in, though (it is an exe file).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Mark" <user@.domain.com> wrote in message
> news:F6F80E86-3780-4428-AE06-FF0A640D0ED6@.microsoft.com...
>> I'm looking for an MMC Snap-in for SQL 2005. I found reference to on for
>> SQL 2000 here
>> http://msdn2.microsoft.com/en-us/library/aa174466(SQL.80).aspx but can't
>> seem to location one form 2005. Can anyone tell me if there is one and
>> if so where I can find it?
>

MMC Snap-in Failed to initialize

I am getting this problem when I try to open a DTS package.
MMC: Snap-in Failed to Initialize: Name: Meta Data Services:
CLSID(xxxxxxxxxxx)
Have anyone encountered this problem?
LystraDoes anyone have any ideas regarding this problem?|||More regarding this problem:

Once I go to open meta data services I get this message:

An error occurred while trying to access the information. The msdb DB could not be open.

Please help.

Thanks

Lystra|||this might be helpful:

http://www.examnotes.net/article44826.html

mojza|||Thanks, I was able to solve the problem.

There was some dll's missing in the repository folder once I copied them over and register the files I was able to get rid of that problem.

However another problem developed which is once I click on a dts package to open up it just hang with only white space. I check to see if all of the dll's for the dts package was there, which it is. Doesn't any one know what this problem is?

Thanks

MMC Snap-In Doesn't allow Full-Text Index...

Yet if I pull up sql server under Computer Management it does and allows me
to configure it.
What's wrong here?
Kyle!
Are you registering the server with an administrative login which would give
you permissions?
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:O1qAC%23l1EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Yet if I pull up sql server under Computer Management it does and allows
me
> to configure it.
> What's wrong here?
> Kyle!
>
|||The server registration is using the sa account and password.
Kyle!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23r7x%234t1EHA.2716@.TK2MSFTNGP14.phx.gbl...
> Are you registering the server with an administrative login which would
> give
> you permissions?
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
> news:O1qAC%23l1EHA.1404@.TK2MSFTNGP11.phx.gbl...
> me
>
|||Also the sa is the dbo.
Kyle!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23r7x%234t1EHA.2716@.TK2MSFTNGP14.phx.gbl...
> Are you registering the server with an administrative login which would
> give
> you permissions?
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
> news:O1qAC%23l1EHA.1404@.TK2MSFTNGP11.phx.gbl...
> me
>
sql

MMC Snap-In Doesn't allow Full-Text Index...

Yet if I pull up sql server under Computer Management it does and allows me
to configure it.
What's wrong here?
Kyle!Are you registering the server with an administrative login which would give
you permissions?
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:O1qAC%23l1EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Yet if I pull up sql server under Computer Management it does and allows
me
> to configure it.
> What's wrong here?
> Kyle!
>|||The server registration is using the sa account and password.
Kyle!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23r7x%234t1EHA.2716@.TK2MSFTNGP14.phx.gbl...
> Are you registering the server with an administrative login which would
> give
> you permissions?
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
> news:O1qAC%23l1EHA.1404@.TK2MSFTNGP11.phx.gbl...
>> Yet if I pull up sql server under Computer Management it does and allows
> me
>> to configure it.
>> What's wrong here?
>> Kyle!
>>
>|||Also the sa is the dbo.
Kyle!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23r7x%234t1EHA.2716@.TK2MSFTNGP14.phx.gbl...
> Are you registering the server with an administrative login which would
> give
> you permissions?
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
> news:O1qAC%23l1EHA.1404@.TK2MSFTNGP11.phx.gbl...
>> Yet if I pull up sql server under Computer Management it does and allows
> me
>> to configure it.
>> What's wrong here?
>> Kyle!
>>
>

MMC Snap-In Doesn't allow Full-Text Index...

Yet if I pull up sql server under Computer Management it does and allows me
to configure it.
What's wrong here?
Kyle!Are you registering the server with an administrative login which would give
you permissions?
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:O1qAC%23l1EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Yet if I pull up sql server under Computer Management it does and allows
me
> to configure it.
> What's wrong here?
> Kyle!
>|||The server registration is using the sa account and password.
Kyle!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23r7x%234t1EHA.2716@.TK2MSFTNGP14.phx.gbl...
> Are you registering the server with an administrative login which would
> give
> you permissions?
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
> news:O1qAC%23l1EHA.1404@.TK2MSFTNGP11.phx.gbl...
> me
>|||Also the sa is the dbo.
Kyle!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23r7x%234t1EHA.2716@.TK2MSFTNGP14.phx.gbl...
> Are you registering the server with an administrative login which would
> give
> you permissions?
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
> news:O1qAC%23l1EHA.1404@.TK2MSFTNGP11.phx.gbl...
> me
>

MMC initialize error

I have SQL server 2000. when I try to open Enterprise Manager, I am geting
this error message.
"snap-in failed to Initialize Name: Microsoft SQL Enterprise Manager
CLSID: {00100100-1816-8EF5-00AA0062C58F}"
Please help me how to reslove this problem. Thanks.
"Error Messages When You Install Office Server Extensions on Computer with
SQL Server 2000"
http://support.microsoft.com/default...&Product=sql2k
"Why does SQL Server 2005 break SQL Server 2000 tools?"
http://www.aspfaq.com/sql2005/show.asp?id=4 (maybe the solution of
re-register sqldmo.dll for SQL Server 2000 works in your situation)
Cristian Lefter, SQL Server MVP
"Kumar" <ravik_v@.hotmail.com> wrote in message
news:BDA694A0-E055-49CA-A1F8-C32BD6282966@.microsoft.com...
>I have SQL server 2000. when I try to open Enterprise Manager, I am geting
> this error message.
> "snap-in failed to Initialize Name: Microsoft SQL Enterprise Manager
> CLSID: {00100100-1816-8EF5-00AA0062C58F}"
> Please help me how to reslove this problem. Thanks.

MMC initialize error

I have SQL server 2000. when I try to open Enterprise Manager, I am geting
this error message.
"snap-in failed to Initialize Name: Microsoft SQL Enterprise Manager
CLSID: {00100100-1816-8EF5-00AA0062C58F}"
Please help me how to reslove this problem. Thanks."Error Messages When You Install Office Server Extensions on Computer with
SQL Server 2000"
http://support.microsoft.com/default.aspx?scid=kb;en-us;281460&Product=sql2k
"Why does SQL Server 2005 break SQL Server 2000 tools?"
http://www.aspfaq.com/sql2005/show.asp?id=4 (maybe the solution of
re-register sqldmo.dll for SQL Server 2000 works in your situation)
Cristian Lefter, SQL Server MVP
"Kumar" <ravik_v@.hotmail.com> wrote in message
news:BDA694A0-E055-49CA-A1F8-C32BD6282966@.microsoft.com...
>I have SQL server 2000. when I try to open Enterprise Manager, I am geting
> this error message.
> "snap-in failed to Initialize Name: Microsoft SQL Enterprise Manager
> CLSID: {00100100-1816-8EF5-00AA0062C58F}"
> Please help me how to reslove this problem. Thanks.

MMC initialize error

I have SQL server 2000. when I try to open Enterprise Manager, I am geting
this error message.
"snap-in failed to Initialize Name: Microsoft SQL Enterprise Manager
CLSID: {00100100-1816-8EF5-00AA0062C58F}"
Please help me how to reslove this problem. Thanks."Error Messages When You Install Office Server Extensions on Computer with
SQL Server 2000"
http://support.microsoft.com/defaul...0&Product=sql2k
"Why does SQL Server 2005 break SQL Server 2000 tools?"
http://www.aspfaq.com/sql2005/show.asp?id=4 (maybe the solution of
re-register sqldmo.dll for SQL Server 2000 works in your situation)
Cristian Lefter, SQL Server MVP
"Kumar" <ravik_v@.hotmail.com> wrote in message
news:BDA694A0-E055-49CA-A1F8-C32BD6282966@.microsoft.com...
>I have SQL server 2000. when I try to open Enterprise Manager, I am geting
> this error message.
> "snap-in failed to Initialize Name: Microsoft SQL Enterprise Manager
> CLSID: {00100100-1816-8EF5-00AA0062C58F}"
> Please help me how to reslove this problem. Thanks.