EnumAvailableSqlServers() fails to detect LOCAL installed instance when disconnected from networ

I am using EnumAvailableSqlServer to build the standard select Sql Server dialog with controls to select the server, instance and database. This all works fine - other than the well reported problem of detected multiple instances - however I have noticed that when disconnected from the network the call fails to even detect the locally installed sql servers.

What is the recommended method of determine whether an instance of sql server is installed locally. I can call Server->Databases, but this leads to a timeout / excpetion if no instances are detected which is slow. Is there a recommended registry key I can check that won't change between versions or another API I can try.

hx, Nick

Checking registry seems the simplest ...

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

with InstalledInstances value.

Thx, Nick

EnumAvailableSqlServers() fails to detect LOCAL installed instance when disconnected from ne

I am using EnumAvailableSqlServer to build the standard select Sql Server dialog with controls to select the server, instance and database. This all works fine - other than the well reported problem of detected multiple instances - however I have noticed that when disconnected from the network the call fails to even detect the locally installed sql servers.

What is the recommended method of determine whether an instance of sql server is installed locally. I can call Server->Databases, but this leads to a timeout / excpetion if no instances are detected which is slow. Is there a recommended registry key I can check that won't change between versions or another API I can try.

hx, Nick

Checking registry seems the simplest ...

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

with InstalledInstances value.

Thx, Nick

Enterprise Mgr SQL 2000 doesn't list databases

I have something strange with my Enterprise Manager (SQL 2000). When in my
local server i cannot see my databases. The list is empty. If I go to Query
Analyzer on the same box, I can see all of them. Also in EM, under the
Management folder there is nothing to view. Any ideas what has happened?
Thanks in advance.Does the registration in Enterprise manager use the same login as the one you
use in Query Analyzer? Does the user you login with to create your
registration have access to all of the tables and the management folder?
--
Russel Loski, MCSD.Net
"doug" wrote:
> I have something strange with my Enterprise Manager (SQL 2000). When in my
> local server i cannot see my databases. The list is empty. If I go to Query
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.|||Yes.
When I try to create a new database through EM I get an arithmetic overflow
error. Do I have something corrupt in the master database? If I try a
'select * from sysdatabases' in the master database I get a row count and an
arithmetic overflow errror. See below.
"(21 row(s) affected)
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 32789."
This is on a test SQL box, and I am not sure when the problem started. If I
cannot restore the master db from backup is there any way to repair it?
Thanks.
"RLoski" wrote:
> Does the registration in Enterprise manager use the same login as the one you
> use in Query Analyzer? Does the user you login with to create your
> registration have access to all of the tables and the management folder?
> --
> Russel Loski, MCSD.Net
>
> "doug" wrote:
> > I have something strange with my Enterprise Manager (SQL 2000). When in my
> > local server i cannot see my databases. The list is empty. If I go to Query
> > Analyzer on the same box, I can see all of them. Also in EM, under the
> > Management folder there is nothing to view. Any ideas what has happened?
> >
> > Thanks in advance.|||doug wrote:
> I have something strange with my Enterprise Manager (SQL 2000). When in my
> local server i cannot see my databases. The list is empty. If I go to Query
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.
Do you have any databases currently "offline"? Do you also get the
error if you run:
SELECT * FROM master.dbo.sysdatabases
but not if you do:
SELECT dbid, name FROM master.dbo.sysdatabases
?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Yes, I do have 2 databases 'offline'.
I do not get the arithmetic overflow error if I just select the dbid and the
name.
"Tracy McKibben" wrote:
> doug wrote:
> > I have something strange with my Enterprise Manager (SQL 2000). When in my
> > local server i cannot see my databases. The list is empty. If I go to Query
> > Analyzer on the same box, I can see all of them. Also in EM, under the
> > Management folder there is nothing to view. Any ideas what has happened?
> >
> > Thanks in advance.
> Do you have any databases currently "offline"? Do you also get the
> error if you run:
> SELECT * FROM master.dbo.sysdatabases
> but not if you do:
> SELECT dbid, name FROM master.dbo.sysdatabases
> ?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||doug wrote:
> Yes, I do have 2 databases 'offline'.
> I do not get the arithmetic overflow error if I just select the dbid and the
> name.
>
Bring those databases online, then see if your problem goes away. Take
them offline again, and see if it continues to work after that. I
recall some obscure issue where the "version" column in the master
database gets corrupted when a database is taken offline. I don't
recall if this was fixed in a service pack or not.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Bringing the 2 'online' and then taking 'offline' has solved my problem.
Thank you for your help.
"Tracy McKibben" wrote:
> doug wrote:
> > Yes, I do have 2 databases 'offline'.
> >
> > I do not get the arithmetic overflow error if I just select the dbid and the
> > name.
> >
> Bring those databases online, then see if your problem goes away. Take
> them offline again, and see if it continues to work after that. I
> recall some obscure issue where the "version" column in the master
> database gets corrupted when a database is taken offline. I don't
> recall if this was fixed in a service pack or not.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

Enterprise Mgr quits after SQL2005 registering

I have both SQL2000 (default) and SQL2005 (second instance) on my laptop. Just to see if it could be done, I registered my (Local) SQL2000 default instance in the Registered Servers part of SQL2005 Mgmt Studio. It worked fine. I can see all the SQL2000 databases, etc in the Mgmt Studio.

But now the SQL2000 default instance will not connect in Enterprise Mgr nor can any of the programs that used to connect to the SQL2000 databases now connect to them. The (local) instance shows in Ent Mgr with the green arrow like it is there but Ent Mgr cannot connect when icon is clicked.

Is there anything I can do to bring the default SQL2000 instance back to be able to connect with anything other than the SQL2005 Mgmt Studio?

Do you get an error ? Which one ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

The local node shows in the tree with a white circle with a green arrowhead inside the circle. Which indicates to me that the SQL instance is running and the Ent Mgr sees it. But when I click on the plus beside the node, I get the error:

A connection could not be established to (LOCAL)

Reason: SQL Server does not exist or access denied
ConnectionOpen(Connect())....

Please verify SQL Server is running and check your SQLServer registration properties (by right-clicking on the (LOCAL) node) and try again.

But I can go to the SQL2005 Mgmt Studio and click on (LOCAL) and see all the stuff in it. In Mgmt Studio, the properties for (LOCAL) show version 8.x of SQLServer.

Enterprise manager performance

Hello,
When I use EM to examine a local db in SQLServer, it takes 1 - 3 minutes to
display the stored procedures (for example).
I just clicked on the "Tables" node in the treeview, and it took over a
minute to list the tables.
Is there any way to improve the performance? As it stands, it borders on
the unusable...
Thanks for any suggestions.
Check the properties of your database. Is autoclose turned on?
By the way, you can find out lots of information via Query Analyzer. It can
do almost everything that Enterprise Manager does -- often it can do it
faster.
you can execute stored procedures to find out information
exec sp_tables
exec sp_stored_procedures
or you can execute queries
SELECT * FROM INFORMATION_SCHEMA.TABLES /*WHERE ...*/
SELECT * FROM INFORMATION_SCHEMA.COLUMNS /*WHERE ...*/
use northwind
go
exec sp_tables
go
exec sp_columns 'Orders'
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'Orders'
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Orders'
Keith
"Developer" <wanderer@.mapinfo.nope.com> wrote in message
news:uXmNY7bwEHA.3716@.TK2MSFTNGP15.phx.gbl...
> Hello,
> When I use EM to examine a local db in SQLServer, it takes 1 - 3 minutes
to
> display the stored procedures (for example).
> I just clicked on the "Tables" node in the treeview, and it took over a
> minute to list the tables.
> Is there any way to improve the performance? As it stands, it borders on
> the unusable...
> Thanks for any suggestions.
>
|||Thanks for the reply. I'll try Query Analyzer.
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:uwwAbcewEHA.1988@.TK2MSFTNGP12.phx.gbl...
> Check the properties of your database. Is autoclose turned on?
> By the way, you can find out lots of information via Query Analyzer. It
can[vbcol=seagreen]
> do almost everything that Enterprise Manager does -- often it can do it
> faster.
> you can execute stored procedures to find out information
> exec sp_tables
> exec sp_stored_procedures
> or you can execute queries
> SELECT * FROM INFORMATION_SCHEMA.TABLES /*WHERE ...*/
> SELECT * FROM INFORMATION_SCHEMA.COLUMNS /*WHERE ...*/
>
> use northwind
> go
> exec sp_tables
> go
> exec sp_columns 'Orders'
> SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'Orders'
> SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Orders'
> --
> Keith
>
> "Developer" <wanderer@.mapinfo.nope.com> wrote in message
> news:uXmNY7bwEHA.3716@.TK2MSFTNGP15.phx.gbl...
> to
on
>
|||Hi,
Have you found any valueable information in Query Analyzer? If you have
many tables, it might really be time-consuming.
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||QA will be sufficient.
""Michael Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:XQ5gLYwwEHA.2916@.cpmsftngxa10.phx.gbl...
> Hi,
> Have you found any valueable information in Query Analyzer? If you have
> many tables, it might really be time-consuming.
> I wanted to post a quick note to see if you would like additional
> assistance or information regarding this particular issue. We appreciate
> your patience and look forward to hearing from you!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||This is ridiculous -- I just waited 4 minutes for EM to open the property
sheet for a local database.
P4, 2.8 gig, 1 gig o' ram and a big hard disk.
There must be some sort of tuning of SQLServer (or EM) available to make it
respond like a modern application.
"Developer" <wanderer@.mapinfo.nope.com> wrote in message
news:uXmNY7bwEHA.3716@.TK2MSFTNGP15.phx.gbl...
> Hello,
> When I use EM to examine a local db in SQLServer, it takes 1 - 3 minutes
to
> display the stored procedures (for example).
> I just clicked on the "Tables" node in the treeview, and it took over a
> minute to list the tables.
> Is there any way to improve the performance? As it stands, it borders on
> the unusable...
> Thanks for any suggestions.
>
|||Hi,
I understood that it must be frustrating!
Would you please use Profiler to trace the process when SQL Server
Enterprise Manager was opening? Send the Profiler Logs directly to me
v-mingqc@.online.microsoft.com (please remove 'online' as it's only for
SPAM). I would like to make further investigate.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi,
Thanks for sending me the Profiler Trace!
1. I find the statement exec sp_dboption N'CareInsite', N'autoclose',
N'true' in the trace, so that please make sure AUTO_CLOSE option for the
database was set to false(Not Selected)
2. Check if ODBC Trace is turned off, using ODBCAD32.EXE and see Tracing tab
BTW, you are using SQL Server 2000 SP3?
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||1. I have unchecked "Auto close" on the Options tab in the property sheet
for my db.
2. It appears ODBC tracing was on; I clicked the "Stop Tracing Now" button
on the Tracing tab of "ODBC Data Source Administrator".
"About SQL Server Service Manager" says it is version 8.00.760. I believe
it is SQL Server 2000 SP3.
Thanks for following up...
""Michael Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:ta%23zQ%23IyEHA.3388@.cpmsftngxa10.phx.gbl...
> Hi,
> Thanks for sending me the Profiler Trace!
> 1. I find the statement exec sp_dboption N'CareInsite', N'autoclose',
> N'true' in the trace, so that please make sure AUTO_CLOSE option for the
> database was set to false(Not Selected)
> 2. Check if ODBC Trace is turned off, using ODBCAD32.EXE and see Tracing
tab
> BTW, you are using SQL Server 2000 SP3?
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||I suspect that turning off ODBC tracing made the difference; EM and Query
Analyzer are responsive and useful.
Thanks.
""Michael Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:ta%23zQ%23IyEHA.3388@.cpmsftngxa10.phx.gbl...
> Hi,
> Thanks for sending me the Profiler Trace!
> 1. I find the statement exec sp_dboption N'CareInsite', N'autoclose',
> N'true' in the trace, so that please make sure AUTO_CLOSE option for the
> database was set to false(Not Selected)
> 2. Check if ODBC Trace is turned off, using ODBCAD32.EXE and see Tracing
tab
> BTW, you are using SQL Server 2000 SP3?
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>

enterprise manager login to local server

I'm running a local MSSQL 2000 server and everything has worked fine until
this week... when it suddenly stopped working and to fix it I had to
reinstall the master database... which now allows the server to run.
My problem is however that I cannot login to the database using windows
authentication mode... and when selecting new sql server registration within
enterprise manager and then clicking on the browse feature nothing is
returned as an active server.
Does anyone have any ideas as to how to resolve this?
For instance as I have reinstalled all the default databases do I have to
reset default usernames, etc... and if so how... as you can see I'm lost...
help?
Steve
Whats the exact error or your problem ? Did you thought abou thte
orphaned users ?
http://support.microsoft.com/default.aspx?kbid=246133
HTH, jens Suessmeyer.

enterprise manager login to local server

I'm running a local MSSQL 2000 server and everything has worked fine until
this week... when it suddenly stopped working and to fix it I had to
reinstall the master database... which now allows the server to run.
My problem is however that I cannot login to the database using windows
authentication mode... and when selecting new sql server registration within
enterprise manager and then clicking on the browse feature nothing is
returned as an active server.
Does anyone have any ideas as to how to resolve this?
For instance as I have reinstalled all the default databases do I have to
reset default usernames, etc... and if so how... as you can see I'm lost...
help?
SteveWhats the exact error or your problem ? Did you thought abou thte
orphaned users ?
http://support.microsoft.com/default.aspx?kbid=246133
HTH, jens Suessmeyer.

enterprise manager login to local server

I'm running a local MSSQL 2000 server and everything has worked fine until
this week... when it suddenly stopped working and to fix it I had to
reinstall the master database... which now allows the server to run.
My problem is however that I cannot login to the database using windows
authentication mode... and when selecting new sql server registration within
enterprise manager and then clicking on the browse feature nothing is
returned as an active server.
Does anyone have any ideas as to how to resolve this?
For instance as I have reinstalled all the default databases do I have to
reset default usernames, etc... and if so how... as you can see I'm lost...
help?
SteveWhats the exact error or your problem ? Did you thought abou thte
orphaned users ?
http://support.microsoft.com/default.aspx?kbid=246133
HTH, jens Suessmeyer.

Enterprise Manager Hangs

Hi,
I'm using a Windows 2003 server with SQL Server 2000 with Service Pack 3a.
When I go to enterprise manager and click on (local) under server groups,
enterprise manager hangs and once that happens, all connections (query
analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
sqlsvr.exe and then start the server again using the Service Manager. (If I
try to stop the server after ending mmc.exe, the status of the Server just
stays as "Stopping").
If I don't go to Enterprise Manager, everything works fine. Also, just in
case you're wondering, I DO NOT have tracing enabled.
I used ProcExp from www.sysinternals.com and after clicking on (local)
with enterprise manager, I get the following data:
2 new events:
\BaseNamedObjects\Crypt32LogOff
\$SERVER$MSSQLSERVER(2427)_C_READPOSTED
when i look at the threads, i get the following:
RPCRT4.DLLNdrRangeUnmarshall
msvcrt.dll!end thread
Any thoughts/suggestions would be appreciated. Thanks.
(a) stop usng Enterprise Manager :-)
(b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
list...
http://www.aspfaq.com/
(Reverse address to reply.)
"JB" <JB@.discussions.microsoft.com> wrote in message
news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> Hi,
> I'm using a Windows 2003 server with SQL Server 2000 with Service Pack
3a.
> When I go to enterprise manager and click on (local) under server groups,
> enterprise manager hangs and once that happens, all connections (query
> analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
> sqlsvr.exe and then start the server again using the Service Manager. (If
I
> try to stop the server after ending mmc.exe, the status of the Server just
> stays as "Stopping").
> If I don't go to Enterprise Manager, everything works fine. Also, just
in
> case you're wondering, I DO NOT have tracing enabled.
> I used ProcExp from www.sysinternals.com and after clicking on (local)
> with enterprise manager, I get the following data:
> 2 new events:
> \BaseNamedObjects\Crypt32LogOff
> \$SERVER$MSSQLSERVER(2427)_C_READPOSTED
> when i look at the threads, i get the following:
> RPCRT4.DLLNdrRangeUnmarshall
> msvcrt.dll!end thread
> Any thoughts/suggestions would be appreciated. Thanks.
|||Thanks for the link and the advice... =)
Anyway, I have a few more details about the problem:
When I click on the (local) in the server groups in enterprise manager, I
hear a beep and the status bar msg is "Establishing connection to SQL Server
and Checking Windows Security".
Also, I reinstalled SQL Server 2000 Service Pack 3a but it didn't help.
"Aaron [SQL Server MVP]" wrote:

> (a) stop usng Enterprise Manager :-)
> (b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
> list...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> 3a.
> I
> in
>
>

Enterprise Manager Hangs

Hi,
I'm using a Windows 2003 server with SQL Server 2000 with Service Pack 3a.
When I go to enterprise manager and click on (local) under server groups,
enterprise manager hangs and once that happens, all connections (query
analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
sqlsvr.exe and then start the server again using the Service Manager. (If I
try to stop the server after ending mmc.exe, the status of the Server just
stays as "Stopping").
If I don't go to Enterprise Manager, everything works fine. Also, just in
case you're wondering, I DO NOT have tracing enabled.
I used ProcExp from www.sysinternals.com and after clicking on (local)
with enterprise manager, I get the following data:
2 new events:
\BaseNamedObjects\Crypt32LogOff
\$SERVER$MSSQLSERVER(2427)_C_READPOSTED
when i look at the threads, i get the following:
RPCRT4.DLLNdrRangeUnmarshall
msvcrt.dll!end thread
Any thoughts/suggestions would be appreciated. Thanks.(a) stop usng Enterprise Manager :-)
(b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
list...
http://www.aspfaq.com/
(Reverse address to reply.)
"JB" <JB@.discussions.microsoft.com> wrote in message
news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> Hi,
> I'm using a Windows 2003 server with SQL Server 2000 with Service Pack
3a.
> When I go to enterprise manager and click on (local) under server groups,
> enterprise manager hangs and once that happens, all connections (query
> analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
> sqlsvr.exe and then start the server again using the Service Manager. (If
I
> try to stop the server after ending mmc.exe, the status of the Server just
> stays as "Stopping").
> If I don't go to Enterprise Manager, everything works fine. Also, just
in
> case you're wondering, I DO NOT have tracing enabled.
> I used ProcExp from www.sysinternals.com and after clicking on (local)
> with enterprise manager, I get the following data:
> 2 new events:
> \BaseNamedObjects\Crypt32LogOff
> \$SERVER$MSSQLSERVER(2427)_C_READPOSTED
> when i look at the threads, i get the following:
> RPCRT4.DLLNdrRangeUnmarshall
> msvcrt.dll!end thread
> Any thoughts/suggestions would be appreciated. Thanks.|||Thanks for the link and the advice... =)
Anyway, I have a few more details about the problem:
When I click on the (local) in the server groups in enterprise manager, I
hear a beep and the status bar msg is "Establishing connection to SQL Server
and Checking Windows Security".
Also, I reinstalled SQL Server 2000 Service Pack 3a but it didn't help.
"Aaron [SQL Server MVP]" wrote:

> (a) stop usng Enterprise Manager :-)
> (b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for
a
> list...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> 3a.
> I
> in
>
>

Enterprise Manager Hangs

Hi,
I'm using a Windows 2003 server with SQL Server 2000 with Service Pack 3a.
When I go to enterprise manager and click on (local) under server groups,
enterprise manager hangs and once that happens, all connections (query
analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
sqlsvr.exe and then start the server again using the Service Manager. (If I
try to stop the server after ending mmc.exe, the status of the Server just
stays as "Stopping").
If I don't go to Enterprise Manager, everything works fine. Also, just in
case you're wondering, I DO NOT have tracing enabled.
I used ProcExp from www.sysinternals.com and after clicking on (local)
with enterprise manager, I get the following data:
2 new events:
\BaseNamedObjects\Crypt32LogOff
\$SERVER$MSSQLSERVER(2427)_C_READPOSTED
when i look at the threads, i get the following:
RPCRT4.DLLNdrRangeUnmarshall
msvcrt.dll!end thread
Any thoughts/suggestions would be appreciated. Thanks.(a) stop usng Enterprise Manager :-)
(b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
list...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"JB" <JB@.discussions.microsoft.com> wrote in message
news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> Hi,
> I'm using a Windows 2003 server with SQL Server 2000 with Service Pack
3a.
> When I go to enterprise manager and click on (local) under server groups,
> enterprise manager hangs and once that happens, all connections (query
> analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
> sqlsvr.exe and then start the server again using the Service Manager. (If
I
> try to stop the server after ending mmc.exe, the status of the Server just
> stays as "Stopping").
> If I don't go to Enterprise Manager, everything works fine. Also, just
in
> case you're wondering, I DO NOT have tracing enabled.
> I used ProcExp from www.sysinternals.com and after clicking on (local)
> with enterprise manager, I get the following data:
> 2 new events:
> \BaseNamedObjects\Crypt32LogOff
> \$SERVER$MSSQLSERVER(2427)_C_READPOSTED
> when i look at the threads, i get the following:
> RPCRT4.DLLNdrRangeUnmarshall
> msvcrt.dll!end thread
> Any thoughts/suggestions would be appreciated. Thanks.|||Thanks for the link and the advice... =)
Anyway, I have a few more details about the problem:
When I click on the (local) in the server groups in enterprise manager, I
hear a beep and the status bar msg is "Establishing connection to SQL Server
and Checking Windows Security".
Also, I reinstalled SQL Server 2000 Service Pack 3a but it didn't help.
"Aaron [SQL Server MVP]" wrote:
> (a) stop usng Enterprise Manager :-)
> (b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
> list...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> > Hi,
> > I'm using a Windows 2003 server with SQL Server 2000 with Service Pack
> 3a.
> > When I go to enterprise manager and click on (local) under server groups,
> > enterprise manager hangs and once that happens, all connections (query
> > analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
> > sqlsvr.exe and then start the server again using the Service Manager. (If
> I
> > try to stop the server after ending mmc.exe, the status of the Server just
> > stays as "Stopping").
> > If I don't go to Enterprise Manager, everything works fine. Also, just
> in
> > case you're wondering, I DO NOT have tracing enabled.
> >
> > I used ProcExp from www.sysinternals.com and after clicking on (local)
> > with enterprise manager, I get the following data:
> >
> > 2 new events:
> > \BaseNamedObjects\Crypt32LogOff
> > \$SERVER$MSSQLSERVER(2427)_C_READPOSTED
> >
> > when i look at the threads, i get the following:
> > RPCRT4.DLLNdrRangeUnmarshall
> > msvcrt.dll!end thread
> >
> > Any thoughts/suggestions would be appreciated. Thanks.
>
>

Enterprise Manager for DTS doesn't work

When I try to open a package in Server/Data transformation
Services/Local packages MMC opens a new window and displays
a warning with the following text: "The specified module
could not be found" The caption of the box says: "DTS
Designer error"
Anybody a solution?
Server: W2K, sp 4
Client: XPPro, sp1
SQL server 2000
Thanks in advance,
Tjalling
Can you re-apply the latest SP please, seems like one of the files is not
registered/config'd correctly.
-Euan
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tjalling" <t.ament@.go-tan.nl> wrote in message
news:347c01c47ebe$644f9680$a401280a@.phx.gbl...
> When I try to open a package in Server/Data transformation
> Services/Local packages MMC opens a new window and displays
> a warning with the following text: "The specified module
> could not be found" The caption of the box says: "DTS
> Designer error"
> Anybody a solution?
> Server: W2K, sp 4
> Client: XPPro, sp1
> SQL server 2000
> Thanks in advance,
> Tjalling
|||

Quote:

Originally posted by Euan Garden[MS]
Can you re-apply the latest SP please, seems like one of the files is not
registered/config'd correctly.
-Euan
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tjalling" <t.ament@.go-tan.nl> wrote in message
news:347c01c47ebe$644f9680$a401280a@.phx.gbl...
> When I try to open a package in Server/Data transformation
> Services/Local packages MMC opens a new window and displays
> a warning with the following text: "The specified module
> could not be found" The caption of the box says: "DTS
> Designer error"
> Anybody a solution?
> Server: W2K, sp 4
> Client: XPPro, sp1
> SQL server 2000
> Thanks in advance,
> Tjalling

I had the same error message.
I looked at the the sqlsp installation log "C:\WINDOWS\sqlsp.log" and found what seemed to be a warning about Microsoft Data Access Components (MDAC) and installed MDAC 2.8.
Log entry:
C:\Download\mdac26Sp2\sql2ksp3\x86\Other\sqlredis. exe /q:a /C:"setupre.exe MDACQFE=0 WARN=1 -s -SMS" ExitCode: 0
After installing it worked.
SQL Server 2000
XPPro, sp1
Nicole

Enterprise Manager connection to Local server very sloooow.

Hi,
I'm having a problem connecting to a local copy of SQL server 2000 using
enterprise manager (on Win2k). Doing anything, connecting, refreshing
list of tables etc. takes a very long time (>10secs) slower even than
remote connections.
Also, the enterprise manager itself becomes doggedly slow - eg. tringing
to move a window across the screen is difficult becuase it is so
stuttery. I have checked task manager, and it's not using much CPU time
though.
One other clue is that when you use something like the DTS wizard, the
local server is not explicitly displayed as one of the available servers.
This has only started happening recently. Any ideas on what is going on?
Thanks!Check to see if you have the Auto-Close option turned on any of your databases.
and check to see if OBDC tracing is turned on.|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>|||Sosh123 wrote:
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>> Check to see if you have the Auto-Close option turned on any of your
>> databases. and check to see if OBDC tracing is turned on.
Did you check all your databases for Auto-Close?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Also check to make sure that none of the network components between you and
the server have their network connections set to Auto-negotiate, especially
through a switch. The protocol is not standardize and oftentimes will set
everything to 10 Mb, Half-duplex.
Also check your SQLEM Options to NOT reconnect to last connection on
relauch.
Sincerely,
Anthony Thomas
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23BhAFC7ZFHA.3620@.TK2MSFTNGP09.phx.gbl...
Sosh123 wrote:
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>> Check to see if you have the Auto-Close option turned on any of your
>> databases. and check to see if OBDC tracing is turned on.
Did you check all your databases for Auto-Close?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com

Enterprise Manager connection to Local server very sloooow.

Hi,
I'm having a problem connecting to a local copy of SQL server 2000 using
enterprise manager (on Win2k). Doing anything, connecting, refreshing
list of tables etc. takes a very long time (>10secs) slower even than
remote connections.
Also, the enterprise manager itself becomes doggedly slow - eg. tringing
to move a window across the screen is difficult becuase it is so
stuttery. I have checked task manager, and it's not using much CPU time
though.
One other clue is that when you use something like the DTS wizard, the
local server is not explicitly displayed as one of the available servers.
This has only started happening recently. Any ideas on what is going on?
Thanks!
Check to see if you have the Auto-Close option turned on any of your databases.
and check to see if OBDC tracing is turned on.
|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?

> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>
|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?

> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>
|||Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Also check to make sure that none of the network components between you and
the server have their network connections set to Auto-negotiate, especially
through a switch. The protocol is not standardize and oftentimes will set
everything to 10 Mb, Half-duplex.
Also check your SQLEM Options to NOT reconnect to last connection on
relauch.
Sincerely,
Anthony Thomas

"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23BhAFC7ZFHA.3620@.TK2MSFTNGP09.phx.gbl...
Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com

Enterprise Manager connection to Local server very sloooow.

Hi,
I'm having a problem connecting to a local copy of SQL server 2000 using
enterprise manager (on Win2k). Doing anything, connecting, refreshing
list of tables etc. takes a very long time (>10secs) slower even than
remote connections.
Also, the enterprise manager itself becomes doggedly slow - eg. tringing
to move a window across the screen is difficult becuase it is so
stuttery. I have checked task manager, and it's not using much CPU time
though.
One other clue is that when you use something like the DTS wizard, the
local server is not explicitly displayed as one of the available servers.
This has only started happening recently. Any ideas on what is going on?
Thanks!Check to see if you have the Auto-Close option turned on any of your databas
es.
and check to see if OBDC tracing is turned on.|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?

> Check to see if you have the Auto-Close option turned on any of your datab
ases.
> and check to see if OBDC tracing is turned on.
>|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?

> Check to see if you have the Auto-Close option turned on any of your datab
ases.
> and check to see if OBDC tracing is turned on.
>|||Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Also check to make sure that none of the network components between you and
the server have their network connections set to Auto-negotiate, especially
through a switch. The protocol is not standardize and oftentimes will set
everything to 10 Mb, Half-duplex.
Also check your SQLEM Options to NOT reconnect to last connection on
relauch.
Sincerely,
Anthony Thomas
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23BhAFC7ZFHA.3620@.TK2MSFTNGP09.phx.gbl...
Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com

Enterprise Manager (Import Data) - DTS Error

You must verify that SQL service is starting with a domain
ID on both SQL Servers and that whatever that Id is, it is
in the local administrators group of both server you are
getting and retriving data from.
Let me know how it goes...
Jay
>--Original Message--
>I created a new database in Enterprise Manager and then
attempted to import data into this new database from an
existing database via the "import data" option. This
launches the Data Transformation Services Import/Export
Wizard. I select the data source. I select the
destination. I select 'Copy table(s) and view(s) from
source database." I select all tables. I select the 'run
immediatedly' option. When I click the 'Finish' button, I
receive the following message in a message box
entitled 'Initialize Com:"
>Could not create an instance of the DTS Package.
>Can anyone tell me what may be wrong? This is SQL Server
2000, SP3.
>.
>
Jay,
The two databases are on the same server. One is named TablesSQL and the other is named TablesSQL_empty. Everything works fine except for the import or export data functions. I always get the "Cannot create an instance of the DTS Package" error. It ha
s worked in the past, but I have not used it in quite awhile and now every attempt produces this error.
"Jay" wrote:

> You must verify that SQL service is starting with a domain
> ID on both SQL Servers and that whatever that Id is, it is
> in the local administrators group of both server you are
> getting and retriving data from.
> Let me know how it goes...
> Jay
> attempted to import data into this new database from an
> existing database via the "import data" option. This
> launches the Data Transformation Services Import/Export
> Wizard. I select the data source. I select the
> destination. I select 'Copy table(s) and view(s) from
> source database." I select all tables. I select the 'run
> immediatedly' option. When I click the 'Finish' button, I
> receive the following message in a message box
> entitled 'Initialize Com:"
> 2000, SP3.
>

Enterprise Manager (Import Data) - DTS Error

You must verify that SQL service is starting with a domain
ID on both SQL Servers and that whatever that Id is, it is
in the local administrators group of both server you are
getting and retriving data from.
Let me know how it goes...
Jay
>--Original Message--
>I created a new database in Enterprise Manager and then
attempted to import data into this new database from an
existing database via the "import data" option. This
launches the Data Transformation Services Import/Export
Wizard. I select the data source. I select the
destination. I select 'Copy table(s) and view(s) from
source database." I select all tables. I select the 'run
immediatedly' option. When I click the 'Finish' button, I
receive the following message in a message box
entitled 'Initialize Com:"
>Could not create an instance of the DTS Package.
>Can anyone tell me what may be wrong? This is SQL Server
2000, SP3.
>.
>Jay,
The two databases are on the same server. One is named TablesSQL and the ot
her is named TablesSQL_empty. Everything works fine except for the import o
r export data functions. I always get the "Cannot create an instance of the
DTS Package" error. It ha
s worked in the past, but I have not used it in quite awhile and now every a
ttempt produces this error.
"Jay" wrote:

> You must verify that SQL service is starting with a domain
> ID on both SQL Servers and that whatever that Id is, it is
> in the local administrators group of both server you are
> getting and retriving data from.
> Let me know how it goes...
> Jay
> attempted to import data into this new database from an
> existing database via the "import data" option. This
> launches the Data Transformation Services Import/Export
> Wizard. I select the data source. I select the
> destination. I select 'Copy table(s) and view(s) from
> source database." I select all tables. I select the 'run
> immediatedly' option. When I click the 'Finish' button, I
> receive the following message in a message box
> entitled 'Initialize Com:"
> 2000, SP3.
>

Enterprise Manager - Database list hangs

I have this problem on a couple of machines, where when I expand the
Database list under the server (typically the local server, i.e. the one EM
is installed on) it takes a very long time to respond and sometimes hangs
for over 10 minutes.
The only KB article I could find was referring to a problem with a large
number of databases, whereas these only have about 10-20 databases on them.
I assume it's some sort of name resolution problem - any ideas how to debug
what's happening?
Paul
See of you have ODBC tracing turned on...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul Hatcher" <phatcher@.nospam.cix.co.uk> wrote in message
news:%23zkR9x0wFHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have this problem on a couple of machines, where when I expand the Database list under the server
>(typically the local server, i.e. the one EM is installed on) it takes a very long time to respond
>and sometimes hangs for over 10 minutes.
> The only KB article I could find was referring to a problem with a large number of databases,
> whereas these only have about 10-20 databases on them.
> I assume it's some sort of name resolution problem - any ideas how to debug what's happening?
> Paul
>
|||Tibor, thanks but no cigar - not turned on.
I'll try using the profiler any see if I can see anything - there's no
obvious CPU actvitity whilst it's hanging so I think it might be down to
networking issues of some sort.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ObaZv60wFHA.720@.TK2MSFTNGP10.phx.gbl...
> See of you have ODBC tracing turned on...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul Hatcher" <phatcher@.nospam.cix.co.uk> wrote in message
> news:%23zkR9x0wFHA.2924@.TK2MSFTNGP15.phx.gbl...
>
|||Also make sure autoclose is turned off for the databases and
that you have applied the latest service packs on the client
where Enterprise Manager seems to hang. There were some
fixes for the issue you described in one of the service
packs.
-Sue
On Thu, 29 Sep 2005 10:24:30 +0100, "Paul Hatcher"
<phatcher@.nospam.cix.co.uk> wrote:

>Tibor, thanks but no cigar - not turned on.
>I'll try using the profiler any see if I can see anything - there's no
>obvious CPU actvitity whilst it's hanging so I think it might be down to
>networking issues of some sort.
>Paul
>"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
>message news:ObaZv60wFHA.720@.TK2MSFTNGP10.phx.gbl...
>
|||Paul
Check the service pack version of Enterprise Manager. There was a bug in an
earlier build (before sp3) where EM did a self join of sysdatabases, and if
that was combined with the autoclose option as Sue suggested, it could take
a LONG time to open the list. Make sure you check the version of the tools
on the client machine, not the version of the server. Sometimes people
forget to apply a sp to all the clients.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Paul Hatcher" <phatcher@.nospam.cix.co.uk> wrote in message
news:%23zkR9x0wFHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have this problem on a couple of machines, where when I expand the
>Database list under the server (typically the local server, i.e. the one EM
>is installed on) it takes a very long time to respond and sometimes hangs
>for over 10 minutes.
> The only KB article I could find was referring to a problem with a large
> number of databases, whereas these only have about 10-20 databases on
> them.
> I assume it's some sort of name resolution problem - any ideas how to
> debug what's happening?
> Paul
>

Enterprise log in issue

I am using SQL 2000 developer edition and all has been
working fine, until today. In Entrprise manager I can
not log into my local database however I can log into a
remote one. Additionally my local development
applications can access data and function fine they all
use SQL server authentaction.
In enterprise manager whenI try to log in I get the
following message-
Log In Filed for user "name"
please verify your SQL Server is running and check ....
I am sure you all get the idea.
I have tried everything and changed nothing, particularly
any passwords.
Any ideas?
Don
Hi,
Can you try re-registering the Enterprise manager using SQl Authentication
and try connecting. You could
also try connecting to sql server using Query Analyzer.
Since you are able to connect to the application which is accessing the same
sql server , I hope
there will not be any major issue. Still verify the sql server error logs in
\sql server prgram directory\log
Thanks
Hari
MCDBA
"Don Stull" <dstull1@.msn.com> wrote in message
news:OjUiIXMeEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I am using SQL 2000 developer edition and all has been
> working fine, until today. In Entrprise manager I can
> not log into my local database however I can log into a
> remote one. Additionally my local development
> applications can access data and function fine they all
> use SQL server authentaction.
> In enterprise manager whenI try to log in I get the
> following message-
> Log In Filed for user "name"
> please verify your SQL Server is running and check ....
> I am sure you all get the idea.
> I have tried everything and changed nothing, particularly
> any passwords.
> Any ideas?
> Don
>

Enterprise log in issue

I am using SQL 2000 developer edition and all has been
working fine, until today. In Entrprise manager I can
not log into my local database however I can log into a
remote one. Additionally my local development
applications can access data and function fine they all
use SQL server authentaction.
In enterprise manager whenI try to log in I get the
following message-
Log In Filed for user "name"
please verify your SQL Server is running and check ....
I am sure you all get the idea.
I have tried everything and changed nothing, particularly
any passwords.
Any ideas?
DonHi,
Can you try re-registering the Enterprise manager using SQl Authentication
and try connecting. You could
also try connecting to sql server using Query Analyzer.
Since you are able to connect to the application which is accessing the same
sql server , I hope
there will not be any major issue. Still verify the sql server error logs in
\sql server prgram directory\log
Thanks
Hari
MCDBA
"Don Stull" <dstull1@.msn.com> wrote in message
news:OjUiIXMeEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I am using SQL 2000 developer edition and all has been
> working fine, until today. In Entrprise manager I can
> not log into my local database however I can log into a
> remote one. Additionally my local development
> applications can access data and function fine they all
> use SQL server authentaction.
> In enterprise manager whenI try to log in I get the
> following message-
> Log In Filed for user "name"
> please verify your SQL Server is running and check ....
> I am sure you all get the idea.
> I have tried everything and changed nothing, particularly
> any passwords.
> Any ideas?
> Don
>