MMSQL 7.0 on MMC

Hi all,

I'm facing an inconvinience with an MSSQL 7.0 installation, regarding it's accessibility in MMC. The case is as such:

When accessing the installation instance, I can navigate wihthin the tree without problems; accessing and viewing all the database, the tables, users etc within each databse. However, when highlighting a database, when it should display a summary on the right panel, it instead displays "an error occurred when trying to access the database information". Note that the puzzling thing is that accessing the database tables, users, rules etc is perfectly fine, and there is no problem with the application using the database either, in terms of accessing it.

There are also no error logged under Applications in the Event Viewer.

If you must know, an MSDE as been installed into the same machine after the MSSQL 7.0 installation.

I have not been able to find any resources on fixing this, and would appreciate if anyone can help on this matter.

Thanks.

Hi all,

Some progress report, and updates on what I've tried so far...

I've been searching and comparing this faulty MMC with a working one, and everything (setting wise) seem to be in order. I've checked registry settings, and config.ini files in the MSSQL directory, they look the same. I've even tried replacing the MSSQLServer.msc file in hopes that it was corrupted. Nothing.

I've also tried registering said MSDE into the MMC. The result? The same problem. Database, user and otherwise full access without problems. Except for the summary page when I have the database highlighted and the "Access Error" is shown. There should be none, since I can still access the database tables, users, etc by simply navigating down the explorer tree.

I would like to know though, if anyone can point me to where I might be able to see the MMC log files? Does one exist? Can I activate logging somewhere? I've been unable to find it, and am quite surmised that there is no such thing, but the programmer in me feels that something is not quite right to that. There has to be some form of logging somewhere for to troubleshoot from.

Is there a known version incompatibility between SQL7.0 and MSDE? With certain MMC/OD version? Patch levels?

Would appreciate if anyone can provide new insights.

Thanks.

mmc.exe-Entry Point Not Found

WHEN I start enterprise manager on SQL 2000, ERROR message
occurred as folows:
mmc.exe-Entry Point Not Found
The procedure entry point wNetCachePassword could not be
located in the dynamic link library MPR.DLL.
Please tell me if you experienced !
thanksCan you find the dll mpr.dll on that server? If not, copy it from another
server.
Once you have located it, go to
http://www.microsoft.com/windows2000/downloads/servicepacks/SP4/supporttools.asp
There is a great tool that is part of the package you can download at that
site -- dependency walker (also you can use the dependency tool from Visual
Studio). Open the dll with the dependency walker and it will tell you what
is missing from your server. Then you can get the appropriate files. Good
luck.
Another thing to is to go to http://www.microsoft.com/mmc, and try
reinstalling the management console.
--
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
*******************************************************************
"Matthew Jin" <jinmz@.yahoo.com> wrote in message
news:2a4401c3fc92$e82ec5b0$a101280a@.phx.gbl...
> WHEN I start enterprise manager on SQL 2000, ERROR message
> occurred as folows:
> mmc.exe-Entry Point Not Found
> The procedure entry point wNetCachePassword could not be
> located in the dynamic link library MPR.DLL.
> Please tell me if you experienced !
> thanks
>

mmc.exe writes a lot to SQL.LOG when working with Enterprise Manag

I noticed that mmc.exe wrote a lot of information to SQL.LOG file, which was
generated by mmc.exe, when I was working with Enterprise Manager. For
instance, a double-click a database name or the server name would write abou
t
330K to the file. Thus, I had to wait for about 40 seconds per click. It
happended only on my Windows 2000 Server (SP4). Other servers do not even
generate the file. The following is sample of information written to the fil
e:
sqlstp 17c-840 ENTER SQLAllocHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 00000000
SQLHANDLE * 00794460
Any idea about it? How to turn off it? Thanks.I found a solution: Turning off ODBC tracing. It's the ODBC tracing that
writes trace to the file.
"Kathy" wrote:

> I noticed that mmc.exe wrote a lot of information to SQL.LOG file, which w
as
> generated by mmc.exe, when I was working with Enterprise Manager. For
> instance, a double-click a database name or the server name would write ab
out
> 330K to the file. Thus, I had to wait for about 40 seconds per click. It
> happended only on my Windows 2000 Server (SP4). Other servers do not even
> generate the file. The following is sample of information written to the f
ile:
> sqlstp 17c-840 ENTER SQLAllocHandle
> SQLSMALLINT 1 <SQL_HANDLE_ENV>
> SQLHANDLE 00000000
> SQLHANDLE * 00794460
> Any idea about it? How to turn off it? Thanks.
>

mmc.exe writes a lot to SQL.LOG when working with Enterprise Manag

I noticed that mmc.exe wrote a lot of information to SQL.LOG file, which was
generated by mmc.exe, when I was working with Enterprise Manager. For
instance, a double-click a database name or the server name would write about
330K to the file. Thus, I had to wait for about 40 seconds per click. It
happended only on my Windows 2000 Server (SP4). Other servers do not even
generate the file. The following is sample of information written to the file:
sqlstp 17c-840ENTER SQLAllocHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 00000000
SQLHANDLE * 00794460
Any idea about it? How to turn off it? Thanks.
I found a solution: Turning off ODBC tracing. It's the ODBC tracing that
writes trace to the file.
"Kathy" wrote:

> I noticed that mmc.exe wrote a lot of information to SQL.LOG file, which was
> generated by mmc.exe, when I was working with Enterprise Manager. For
> instance, a double-click a database name or the server name would write about
> 330K to the file. Thus, I had to wait for about 40 seconds per click. It
> happended only on my Windows 2000 Server (SP4). Other servers do not even
> generate the file. The following is sample of information written to the file:
> sqlstp 17c-840ENTER SQLAllocHandle
> SQLSMALLINT 1 <SQL_HANDLE_ENV>
> SQLHANDLE 00000000
> SQLHANDLE * 00794460
> Any idea about it? How to turn off it? Thanks.
>

mmc.exe writes a lot to SQL.LOG when working with Enterprise Manag

I noticed that mmc.exe wrote a lot of information to SQL.LOG file, which was
generated by mmc.exe, when I was working with Enterprise Manager. For
instance, a double-click a database name or the server name would write about
330K to the file. Thus, I had to wait for about 40 seconds per click. It
happended only on my Windows 2000 Server (SP4). Other servers do not even
generate the file. The following is sample of information written to the file:
sqlstp 17c-840 ENTER SQLAllocHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 00000000
SQLHANDLE * 00794460
Any idea about it? How to turn off it? Thanks.I found a solution: Turning off ODBC tracing. It's the ODBC tracing that
writes trace to the file.
"Kathy" wrote:
> I noticed that mmc.exe wrote a lot of information to SQL.LOG file, which was
> generated by mmc.exe, when I was working with Enterprise Manager. For
> instance, a double-click a database name or the server name would write about
> 330K to the file. Thus, I had to wait for about 40 seconds per click. It
> happended only on my Windows 2000 Server (SP4). Other servers do not even
> generate the file. The following is sample of information written to the file:
> sqlstp 17c-840 ENTER SQLAllocHandle
> SQLSMALLINT 1 <SQL_HANDLE_ENV>
> SQLHANDLE 00000000
> SQLHANDLE * 00794460
> Any idea about it? How to turn off it? Thanks.
>sql

mmc.exe - .dll files are corrupted

Windows NT 4.0 operating system SQL 7.0 is loaded. Sql enterprise manager is opend mmc.exe - .dll files are corrupted. Please giveme advice

ThankyouHi there,

welcome to thescipts, take care my fren.. :)

MMC SQL Server

Hello all,
I know this may be a basic question, and that the short answer is probably
"Yes"; but the File menu on the Computer Management console doesn't have an
Add or Remove Snap In choice. When I run MMC (from the run command), I get
a new/blank console, the Add or Remove Snap In choice is there, but there
are no snap-ins shown to choose from.
What I want is to manage sql servers on my network from the Computer
Management Console.
Can someone please help me do this?
TIA
Jake
Hi
Have you installed the client tools? The msc files should be in the
tools\binn directory!
Client tools are not available with MSDE!!!!
John
"GitarJake" <wiekiewatchee@.spamkiller.net> wrote in message
news:Z65Wc.47$4o.29@.fed1read01...
> Hello all,
> I know this may be a basic question, and that the short answer is probably
> "Yes"; but the File menu on the Computer Management console doesn't have
an
> Add or Remove Snap In choice. When I run MMC (from the run command), I
get
> a new/blank console, the Add or Remove Snap In choice is there, but there
> are no snap-ins shown to choose from.
> What I want is to manage sql servers on my network from the Computer
> Management Console.
> Can someone please help me do this?
> TIA
> Jake
>
>
|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.server:357881 microsoft.public.management.mmc:17348
Hi
Have you installed the client tools? The msc files should be in the
tools\binn directory!
Client tools are not available with MSDE!!!!
John
"GitarJake" <wiekiewatchee@.spamkiller.net> wrote in message
news:Z65Wc.47$4o.29@.fed1read01...
> Hello all,
> I know this may be a basic question, and that the short answer is probably
> "Yes"; but the File menu on the Computer Management console doesn't have
an
> Add or Remove Snap In choice. When I run MMC (from the run command), I
get
> a new/blank console, the Add or Remove Snap In choice is there, but there
> are no snap-ins shown to choose from.
> What I want is to manage sql servers on my network from the Computer
> Management Console.
> Can someone please help me do this?
> TIA
> Jake
>
>
sql

MMC SQL Server

Hello all,

I know this may be a basic question, and that the short answer is probably
"Yes"; but the File menu on the Computer Management console doesn't have an
Add or Remove Snap In choice. When I run MMC (from the run command), I get
a new/blank console, the Add or Remove Snap In choice is there, but there
are no snap-ins shown to choose from.

What I want is to manage sql servers on my network from the Computer
Management Console.

Can someone please help me do this?

TIA

JakeHi

Have you installed the client tools? The msc files should be in the
tools\binn directory!
Client tools are not available with MSDE!!!!

John

"GitarJake" <wiekiewatchee@.spamkiller.net> wrote in message
news:Z65Wc.47$4o.29@.fed1read01...
> Hello all,
> I know this may be a basic question, and that the short answer is probably
> "Yes"; but the File menu on the Computer Management console doesn't have
an
> Add or Remove Snap In choice. When I run MMC (from the run command), I
get
> a new/blank console, the Add or Remove Snap In choice is there, but there
> are no snap-ins shown to choose from.
> What I want is to manage sql servers on my network from the Computer
> Management Console.
> Can someone please help me do this?
> TIA
> Jake
>|||Hi

Have you installed the client tools? The msc files should be in the
tools\binn directory!
Client tools are not available with MSDE!!!!

John

"GitarJake" <wiekiewatchee@.spamkiller.net> wrote in message
news:Z65Wc.47$4o.29@.fed1read01...
> Hello all,
> I know this may be a basic question, and that the short answer is probably
> "Yes"; but the File menu on the Computer Management console doesn't have
an
> Add or Remove Snap In choice. When I run MMC (from the run command), I
get
> a new/blank console, the Add or Remove Snap In choice is there, but there
> are no snap-ins shown to choose from.
> What I want is to manage sql servers on my network from the Computer
> Management Console.
> Can someone please help me do this?
> TIA
> Jake
>

MMC SQL Server

Hello all,
I know this may be a basic question, and that the short answer is probably
"Yes"; but the File menu on the Computer Management console doesn't have an
Add or Remove Snap In choice. When I run MMC (from the run command), I get
a new/blank console, the Add or Remove Snap In choice is there, but there
are no snap-ins shown to choose from.
What I want is to manage sql servers on my network from the Computer
Management Console.
Can someone please help me do this?
TIA
JakeHi
Have you installed the client tools? The msc files should be in the
tools\binn directory!
Client tools are not available with MSDE!!!!
John
"GitarJake" <wiekiewatchee@.spamkiller.net> wrote in message
news:Z65Wc.47$4o.29@.fed1read01...
> Hello all,
> I know this may be a basic question, and that the short answer is probably
> "Yes"; but the File menu on the Computer Management console doesn't have
an
> Add or Remove Snap In choice. When I run MMC (from the run command), I
get
> a new/blank console, the Add or Remove Snap In choice is there, but there
> are no snap-ins shown to choose from.
> What I want is to manage sql servers on my network from the Computer
> Management Console.
> Can someone please help me do this?
> TIA
> Jake
>
>|||Hi
Have you installed the client tools? The msc files should be in the
tools\binn directory!
Client tools are not available with MSDE!!!!
John
"GitarJake" <wiekiewatchee@.spamkiller.net> wrote in message
news:Z65Wc.47$4o.29@.fed1read01...
> Hello all,
> I know this may be a basic question, and that the short answer is probably
> "Yes"; but the File menu on the Computer Management console doesn't have
an
> Add or Remove Snap In choice. When I run MMC (from the run command), I
get
> a new/blank console, the Add or Remove Snap In choice is there, but there
> are no snap-ins shown to choose from.
> What I want is to manage sql servers on my network from the Computer
> Management Console.
> Can someone please help me do this?
> TIA
> Jake
>
>

MMC SQL Server

Hello all,
I know this may be a basic question, and that the short answer is probably
"Yes"; but the File menu on the Computer Management console doesn't have an
Add or Remove Snap In choice. When I run MMC (from the run command), I get
a new/blank console, the Add or Remove Snap In choice is there, but there
are no snap-ins shown to choose from.
What I want is to manage sql servers on my network from the Computer
Management Console.
Can someone please help me do this?
TIA
JakeHi
Have you installed the client tools? The msc files should be in the
tools\binn directory!
Client tools are not available with MSDE!!!!
John
"GitarJake" <wiekiewatchee@.spamkiller.net> wrote in message
news:Z65Wc.47$4o.29@.fed1read01...
> Hello all,
> I know this may be a basic question, and that the short answer is probably
> "Yes"; but the File menu on the Computer Management console doesn't have
an
> Add or Remove Snap In choice. When I run MMC (from the run command), I
get
> a new/blank console, the Add or Remove Snap In choice is there, but there
> are no snap-ins shown to choose from.
> What I want is to manage sql servers on my network from the Computer
> Management Console.
> Can someone please help me do this?
> TIA
> Jake
>
>|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.server:357881 microsof
t.public.management.mmc:17348
Hi
Have you installed the client tools? The msc files should be in the
tools\binn directory!
Client tools are not available with MSDE!!!!
John
"GitarJake" <wiekiewatchee@.spamkiller.net> wrote in message
news:Z65Wc.47$4o.29@.fed1read01...
> Hello all,
> I know this may be a basic question, and that the short answer is probably
> "Yes"; but the File menu on the Computer Management console doesn't have
an
> Add or Remove Snap In choice. When I run MMC (from the run command), I
get
> a new/blank console, the Add or Remove Snap In choice is there, but there
> are no snap-ins shown to choose from.
> What I want is to manage sql servers on my network from the Computer
> Management Console.
> Can someone please help me do this?
> TIA
> Jake
>
>

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 Snapin failed to initialize

Hi there,
I have a problem when I start up the MMC of sql server :
"Snapin failed to initialize"
Thats the message when I add/remove the sql server snapin. When I try to
collapse sql server open in MMC it just hangs.
This problem is here for more then 10 days and I cant find a solution to it.
Google groups has many (old) suggestions but none of them work
I am suspecting that the followin update caused the problem (not 100% sure
though)
Security Update for Microsoft Data Access Components (KB832483)
Sql server runs fine but I cant administer it properly. Please help.
icq : 203284108Hi Tom,
Are you attempting to run the MMC at the server hosting SQL Server? Or are
you attempting to run the MMC remotely?
In either case, from the same machine you are running the MMC, attempt to
connect using Query Analyzer or simply create a test ODBC connnection to
the server. Does that connection work OK? If it does, we know ODBC
connectivity is OK. That would tend to eliminate MS04-003 as the root
cause of the issue.
If indeed ODBC connectivity fails that would explain why the MMC snapin is
failing. It uses ODBC for connectivity to the server.
If you are testing at the server hosting SQL Server, try an ODBC test from
another machine. You can accomplish this even if you do not have Query
Analyzer installed. Simply create a test ODBC DSN and test the connection.
Obviously if ODBC connectivity is OK using Query Analyzer or a test ODBC
DSN, there is a problem wikth the MMC Snapin itself. Let me know what you
discover.
Thank you.
Gary Whitley
This posting is provided "AS IS" with no warranties, and confers no rights.|||Lo Gary,
This is what I tried :
1) Connect with sql query analyzer : it works
2) Create odbc data source : it works
Querying the data from the website is also no problem.
So its realy is a problem with mmc itself I believe.
I reinstalled SQL server (server + cleint tools) and tried to start mmc
after some short prayers.
The problem is still there. It seems an uninstall leaves some settings
behind (in the registry maybe).
This was my last resort. I don't have the technical knowledge to track this
further down.
I hope some experienced people can advice me further.
I cant administer my sql server (via a remote mmc neither) and using the QA
is slowing me down tremendously.
Please advice. I see lots of other post about this prob (maybe its not the
same thing that triggers it).
But the MMC is a bit fragile so it seems :s
"Gary Whitley [MSFT]" <garyw@.online.microsoft.com> wrote in message
news:l#Su82O5DHA.568@.cpmsftngxa07.phx.gbl...

quote:

---

> Hi Tom,
> Are you attempting to run the MMC at the server hosting SQL Server? Or

---

are

quote:

---

> you attempting to run the MMC remotely?
> In either case, from the same machine you are running the MMC, attempt to
> connect using Query Analyzer or simply create a test ODBC connnection to
> the server. Does that connection work OK? If it does, we know ODBC
> connectivity is OK. That would tend to eliminate MS04-003 as the root
> cause of the issue.
> If indeed ODBC connectivity fails that would explain why the MMC snapin is
> failing. It uses ODBC for connectivity to the server.
> If you are testing at the server hosting SQL Server, try an ODBC test from
> another machine. You can accomplish this even if you do not have Query
> Analyzer installed. Simply create a test ODBC DSN and test the

---

connection.

quote:

---

> Obviously if ODBC connectivity is OK using Query Analyzer or a test ODBC
> DSN, there is a problem wikth the MMC Snapin itself. Let me know what you
> discover.
> Thank you.
> Gary Whitley
> This posting is provided "AS IS" with no warranties, and confers no

---

rights.

quote:

---

>

---

|||Hi Tom,
Thank you for using the Microsoft newsgroups as your source for technical
information. In this particular case the complexity of your issue will
require in-depth troubleshooting and will not be best served by newsgroup
support. Please go to;
http://support.microsoft.com/common...=fh;en-us;cntac
tms
Select your region from the map and follow the instructions for contacting
our telephone support centers in your area.
Thank you.
Gary Whitley
This posting is provided "AS IS" with no warranties, and confers no rights.|||Im hoping to solve this myself. I dont want my boss to pay...
I discovered something new today :
When I connect from the badly behaving pc with QA to a remotly sql server
2000 the QA waits indefinitly.
There is no locking going on it just waits. Even if I just say "use
nothwind".
I can connect to the local sql server with QA just fine. How can I see whats
going wrong if the remote pc is queried?
Thx for the help so far Gary.
Tom
"Gary Whitley [MSFT]" <garyw@.online.microsoft.com> wrote in message
news:pMsgiBd5DHA.2768@.cpmsftngxa07.phx.gbl...

quote:

---

> Hi Tom,
> Thank you for using the Microsoft newsgroups as your source for technical
> information. In this particular case the complexity of your issue will
> require in-depth troubleshooting and will not be best served by newsgroup
> support. Please go to;
>

---

http://support.microsoft.com/common...=fh;en-us;cntac

quote:

---

> tms
> Select your region from the map and follow the instructions for contacting
> our telephone support centers in your area.
> Thank you.
> Gary Whitley
> This posting is provided "AS IS" with no warranties, and confers no

---

rights.

quote:

---

>

---

|||Hi Tom,
There are two tools that may help you in this case.
First, you can use SQL Profiler at the SQL Server itself to track your
session on the server. This tool allows you to determine what commands, if
any, SQL receives and what occurs after it receives the command.
Second, you may want to get a network sniff between the client and server.
The best way to handle this is to get a trace at both the client and the
server at the same time. This allows you to analyze the requests from the
client, determine if the server gets the request and what response, if any,
is sent back to the client. The goal will be to find where the problem
occurs.
Thanks.
Gary
This posting is provided "AS IS" with no warranties, and confers no rights.

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 recovery

We recently lost our hard disk on disk c: It contained
Windows 2000 system files, but no SQL Server 7.0 files.
Our program files, data, and backups were on drive d:.
After rebuilding the W2K server, we ran regrebld.exe to
reestabish the W2K registry entries. We were able to
restart SQL Server and the Agent, but MMC (Microsoft
Management Console) will not start due to problems with
missing CLSIDs. We are able to access the database and
Agent info from remote MMCs, but not on the local server.
I don't see any option to reinstall/register MMC. Any
ideas of what to do?I found instmmc.exe on the installation disk. I'll try it
in the morning.
>--Original Message--
>We recently lost our hard disk on disk c: It contained
>Windows 2000 system files, but no SQL Server 7.0 files.
>Our program files, data, and backups were on drive d:.
>After rebuilding the W2K server, we ran regrebld.exe to
>reestabish the W2K registry entries. We were able to
>restart SQL Server and the Agent, but MMC (Microsoft
>Management Console) will not start due to problems with
>missing CLSIDs. We are able to access the database and
>Agent info from remote MMCs, but not on the local
server.
>I don't see any option to reinstall/register MMC. Any
>ideas of what to do?
>.
>