Is this connection string formated correctly?

Data Source=**COMPUTERNAME**\SQLEXPRESS;Initial Catalog=*CAT NAME*;User ID=*USR*;Password=*PASS*;Min Pool Size=5;Max Pool Size=10000;Connect Timeout=5

I can't connect to the DB. Everythime I try to connect to a page within my site that uses DB data I get an: "The resource cannot be found." error.

Hi,

sems ok, dom′t know why you stared the USERNAME and COMPUTERNAME tey should just have no stars or quotes. You can just take also one of the connectionstrings here: http://www.connectionstrings.com they are work fine.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||"The resource cannot be found." error is not raised by sql server db connection driver. So there is someother place in your app that cause the failure. Possbile IIS.

is this a connection problem or am I going bonkers?

I have SQL installed locally, and it has been working fine for some time.
However, today when I went to Enterprise Manager I could see the tree view
but as soon as I selected "Databases" everything froze, Task Manager
reported that the application was not responding. I left it for 10 minutes
and the
screen stayed stuck with the hourglass.
I tried re-starting the SQL service and rebooting the box, but the same
problem occured.
When I try and use Query Analyser, I cannot select a database from the
drop down list, but, I can use the "Use" command to choose a database and I
can
run a query. It is unblievably slow though.
Just tried to create a new ODBC connection and the test failed because of a
timeout.
Does anyone have any clues?
I've posted the log below
thanks
J
2004-11-30 14:59:48.59 server Microsoft SQL Server 2000 - 8.00.194
(Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2004-11-30 14:59:48.60 server Copyright (C) 1988-2000 Microsoft
Corporation.
2004-11-30 14:59:48.60 server All rights reserved.
2004-11-30 14:59:48.60 server Server Process ID is 1636.
2004-11-30 14:59:48.60 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2004-11-30 14:59:48.66 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2004-11-30 14:59:49.44 server SQL Server configured for thread mode
processing.
2004-11-30 14:59:49.49 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2004-11-30 14:59:49.55 server Attempting to initialize Distributed
Transaction Coordinator.
2004-11-30 14:59:49.96 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2004-11-30 14:59:50.01 spid3 Starting up database 'master'.
2004-11-30 14:59:52.47 spid3 0 transactions rolled back in database
'master' (1).
2004-11-30 14:59:52.48 spid3 Recovery is checkpointing database 'master'
(1)
2004-11-30 14:59:52.62 server Using 'SSNETLIB.DLL' version '8.0.194'.
2004-11-30 14:59:52.63 spid5 Starting up database 'model'.
2004-11-30 14:59:52.76 spid3 Server name is 'OBIWAN'.
2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 7
2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 11
2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 12
2004-11-30 14:59:52.78 server SQL server listening on Shared Memory,
Named Pipes.
2004-11-30 14:59:52.78 server SQL Server is ready for client connections
2004-11-30 14:59:52.78 spid8 Starting up database 'msdb'.
2004-11-30 14:59:52.85 spid9 Starting up database 'pubs'.
2004-11-30 14:59:52.86 spid10 Starting up database 'Northwind'.
2004-11-30 14:59:52.99 spid11 Starting up database 'isoglobal'.
2004-11-30 14:59:53.80 spid5 Clearing tempdb database.
2004-11-30 14:59:54.18 spid9 Starting up database 'vmserver'.
2004-11-30 14:59:54.33 spid10 Starting up database 'vmserver_delivery'.
2004-11-30 14:59:56.76 spid5 Starting up database 'tempdb'.
2004-11-30 14:59:57.02 spid3 Recovery complete.
2004-11-30 15:35:06.94 spid52 Starting up database '3663'.
2004-11-30 15:35:07.47 spid52 Starting up database 'demo'.
2004-11-30 15:35:07.81 spid52 Starting up database 'fsspda'.
2004-11-30 15:35:10.27 spid51 Starting up database '3663'.
2004-11-30 15:35:26.30 spid51 Starting up database 'demo'.
2004-11-30 15:35:45.90 spid51 Starting up database 'fsspda'.
2004-11-30 15:36:09.88 spid51 Starting up database '3663'.
2004-11-30 15:36:27.73 spid51 Starting up database 'demo'.
2004-11-30 15:36:45.81 spid51 Starting up database 'fsspda'.
2004-11-30 15:37:24.86 spid51 Starting up database 'demo'.
2004-11-30 15:37:43.23 spid51 Starting up database 'demo'.
2004-11-30 15:38:03.14 spid51 Starting up database 'demo'.
2004-11-30 15:50:39.57 spid53 Using 'xpstar.dll' version '2000.80.194' to
execute extended stored procedure 'sp_MSgetversion'.
2004-11-30 15:50:56.32 spid53 Starting up database '3663'.
2004-11-30 15:50:56.79 spid53 Starting up database 'fsspda'.
2004-11-30 15:50:57.26 spid53 Starting up database '3663'.
2004-11-30 15:51:13.34 spid53 Starting up database 'fsspda'.
2004-11-30 15:51:27.99 spid53 Starting up database '3663'.
2004-11-30 15:51:43.49 spid53 Starting up database 'fsspda'.
2004-11-30 15:51:59.48 spid53 Starting up database '3663'.
2004-11-30 15:52:22.68 spid53 Starting up database 'fsspda'.
2004-11-30 15:52:40.95 spid53 Starting up database '3663'.
2004-11-30 15:53:01.00 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:16.65 spid53 Starting up database '3663'.
2004-11-30 15:53:33.17 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:48.53 spid53 Starting up database '3663'.
2004-11-30 15:53:49.39 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:50.02 spid53 Starting up database '3663'.
2004-11-30 15:53:50.78 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:51.56 spid53 Starting up database '3663'.
2004-11-30 15:53:52.22 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:52.53 spid53 Starting up database '3663'.
2004-11-30 15:53:52.87 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:53.16 spid53 Starting up database '3663'.
2004-11-30 15:53:53.52 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:53.87 spid53 Starting up database '3663'.
2004-11-30 15:53:54.19 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:54.49 spid53 Starting up database '3663'.
2004-11-30 15:53:54.97 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:55.33 spid53 Starting up database '3663'.
2004-11-30 15:53:55.68 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:56.01 spid53 Starting up database '3663'.
2004-11-30 15:53:56.90 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:57.45 spid53 Starting up database '3663'.
2004-11-30 15:53:57.81 spid53 Starting up database 'fsspda'.
2004-11-30 15:54:04.61 spid51 Starting up database 'fsspda'.
2004-11-30 15:54:05.02 spid51 Starting up database 'fsspda'.
2004-11-30 15:54:05.45 spid51 Starting up database 'fsspda'.
2004-11-30 15:54:09.62 spid51 Starting up database '3663'.
2004-11-30 15:54:10.05 spid51 Starting up database 'demo'.
2004-11-30 15:54:17.14 spid51 Starting up database 'demo'.
2004-11-30 15:54:17.46 spid51 Starting up database 'demo'.
2004-11-30 15:54:17.82 spid51 Starting up database 'demo'.
2004-11-30 15:54:33.58 spid53 Starting up database 'Route'.
2004-11-30 15:54:34.32 spid53 Starting up database '3663'.
2004-11-30 15:54:34.76 spid53 Starting up database 'fsspda'.
2004-11-30 15:54:35.07 spid53 Starting up database '3663'.
2004-11-30 15:54:35.38 spid53 Starting up database 'fsspda'.
2004-11-30 15:58:19.63 spid51 Starting up database '3663'.
2004-11-30 15:58:37.12 spid51 Starting up database 'fsspda'.
2004-11-30 15:58:52.46 spid51 Starting up database '3663'.
2004-11-30 15:59:09.98 spid51 Starting up database 'demo'.
2004-11-30 15:59:41.81 spid51 Starting up database 'fsspda'.
2004-11-30 15:59:59.34 spid51 Starting up database '3663'.
2004-11-30 16:00:15.76 spid51 Starting up database 'demo'.
2004-11-30 16:00:50.61 spid51 Starting up database 'fsspda'.
2004-11-30 16:00:51.36 spid51 Starting up database '3663'.
2004-11-30 16:01:10.96 spid51 Starting up database 'demo'.
2004-11-30 16:01:30.14 spid51 Starting up database 'fsspda'.
2004-11-30 16:01:45.79 spid51 Starting up database '3663'.
2004-11-30 16:02:01.59 spid51 Starting up database 'demo'.
2004-11-30 16:02:05.37 spid51 Starting up database 'fsspda'.
2004-11-30 16:02:21.41 spid51 Starting up database '3663'.
2004-11-30 16:02:38.84 spid51 Starting up database 'demo'.
2004-11-30 16:02:58.05 spid51 Starting up database 'fsspda'.
2004-11-30 16:03:13.71 spid51 Starting up database '3663'.
2004-11-30 16:03:34.68 spid51 Starting up database 'demo'.
2004-11-30 16:03:56.00 spid51 Starting up database 'fsspda'.
2004-11-30 16:04:12.85 spid51 Starting up database '3663'.
2004-11-30 16:04:29.93 spid51 Starting up database 'demo'.
2004-11-30 16:04:50.03 spid51 Starting up database 'fsspda'.
2004-11-30 16:05:06.56 spid51 Starting up database '3663'.
2004-11-30 16:05:24.32 spid51 Starting up database 'demo'.
2004-11-30 16:05:51.91 spid53 Starting up database '3663'.
2004-11-30 16:06:10.79 spid51 Starting up database 'fsspda'.
2004-11-30 16:06:26.38 spid53 Starting up database 'demo'.
2004-11-30 16:06:46.93 spid51 Starting up database '3663'.
2004-11-30 16:07:05.64 spid53 Starting up database 'fsspda'.
2004-11-30 16:07:21.08 spid51 Starting up database 'demo'.
2004-11-30 16:07:22.29 spid51 Starting up database 'fsspda'.
2004-11-30 16:07:40.60 spid51 Starting up database '3663'.
2004-11-30 16:07:59.85 spid51 Starting up database 'demo'.
2004-11-30 16:08:25.22 spid51 Starting up database 'fsspda'.
2004-11-30 16:08:44.40 spid51 Starting up database '3663'.
2004-11-30 16:09:02.97 spid51 Starting up database 'demo'.
2004-11-30 16:09:34.28 spid51 Starting up database 'fsspda'.
2004-11-30 16:12:52.66 spid51 Starting up database 'fsspda'.
2004-11-30 16:12:53.04 spid51 Starting up database 'demo'.
2004-11-30 16:12:53.45 spid51 Starting up database '3663'.
2004-11-30 16:12:56.66 spid52 Starting up database 'fsspda'.
Neither...it's from having auto close turned on. See my
posts to your same question in the server newsgroup.
-Sue
On Tue, 30 Nov 2004 09:45:07 -0800, "McFly"
<McFly@.discussions.microsoft.com> wrote:

> I have SQL installed locally, and it has been working fine for some time.
> However, today when I went to Enterprise Manager I could see the tree view
> but as soon as I selected "Databases" everything froze, Task Manager
> reported that the application was not responding. I left it for 10 minutes
>and the
> screen stayed stuck with the hourglass.
> I tried re-starting the SQL service and rebooting the box, but the same
> problem occured.
> When I try and use Query Analyser, I cannot select a database from the
> drop down list, but, I can use the "Use" command to choose a database and I
>can
> run a query. It is unblievably slow though.
>Just tried to create a new ODBC connection and the test failed because of a
>timeout.
>
> Does anyone have any clues?
>I've posted the log below
>thanks
>J
>2004-11-30 14:59:48.59 server Microsoft SQL Server 2000 - 8.00.194
>(Intel X86)
>Aug 6 2000 00:57:48
>Copyright (c) 1988-2000 Microsoft Corporation
>Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
>2004-11-30 14:59:48.60 server Copyright (C) 1988-2000 Microsoft
>Corporation.
>2004-11-30 14:59:48.60 server All rights reserved.
>2004-11-30 14:59:48.60 server Server Process ID is 1636.
>2004-11-30 14:59:48.60 server Logging SQL Server messages in file
>'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
>2004-11-30 14:59:48.66 server SQL Server is starting at priority class
>'normal'(1 CPU detected).
>2004-11-30 14:59:49.44 server SQL Server configured for thread mode
>processing.
>2004-11-30 14:59:49.49 server Using dynamic lock allocation. [2500] Lock
>Blocks, [5000] Lock Owner Blocks.
>2004-11-30 14:59:49.55 server Attempting to initialize Distributed
>Transaction Coordinator.
>2004-11-30 14:59:49.96 server Failed to obtain
>TransactionDispenserInterface: Result Code = 0x8004d01b
>2004-11-30 14:59:50.01 spid3 Starting up database 'master'.
>2004-11-30 14:59:52.47 spid3 0 transactions rolled back in database
>'master' (1).
>2004-11-30 14:59:52.48 spid3 Recovery is checkpointing database 'master'
>(1)
>2004-11-30 14:59:52.62 server Using 'SSNETLIB.DLL' version '8.0.194'.
>2004-11-30 14:59:52.63 spid5 Starting up database 'model'.
>2004-11-30 14:59:52.76 spid3 Server name is 'OBIWAN'.
>2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 7
>2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 11
>2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 12
>2004-11-30 14:59:52.78 server SQL server listening on Shared Memory,
>Named Pipes.
>2004-11-30 14:59:52.78 server SQL Server is ready for client connections
>2004-11-30 14:59:52.78 spid8 Starting up database 'msdb'.
>2004-11-30 14:59:52.85 spid9 Starting up database 'pubs'.
>2004-11-30 14:59:52.86 spid10 Starting up database 'Northwind'.
>2004-11-30 14:59:52.99 spid11 Starting up database 'isoglobal'.
>2004-11-30 14:59:53.80 spid5 Clearing tempdb database.
>2004-11-30 14:59:54.18 spid9 Starting up database 'vmserver'.
>2004-11-30 14:59:54.33 spid10 Starting up database 'vmserver_delivery'.
>2004-11-30 14:59:56.76 spid5 Starting up database 'tempdb'.
>2004-11-30 14:59:57.02 spid3 Recovery complete.
>2004-11-30 15:35:06.94 spid52 Starting up database '3663'.
>2004-11-30 15:35:07.47 spid52 Starting up database 'demo'.
>2004-11-30 15:35:07.81 spid52 Starting up database 'fsspda'.
>2004-11-30 15:35:10.27 spid51 Starting up database '3663'.
>2004-11-30 15:35:26.30 spid51 Starting up database 'demo'.
>2004-11-30 15:35:45.90 spid51 Starting up database 'fsspda'.
>2004-11-30 15:36:09.88 spid51 Starting up database '3663'.
>2004-11-30 15:36:27.73 spid51 Starting up database 'demo'.
>2004-11-30 15:36:45.81 spid51 Starting up database 'fsspda'.
>2004-11-30 15:37:24.86 spid51 Starting up database 'demo'.
>2004-11-30 15:37:43.23 spid51 Starting up database 'demo'.
>2004-11-30 15:38:03.14 spid51 Starting up database 'demo'.
>2004-11-30 15:50:39.57 spid53 Using 'xpstar.dll' version '2000.80.194' to
>execute extended stored procedure 'sp_MSgetversion'.
>2004-11-30 15:50:56.32 spid53 Starting up database '3663'.
>2004-11-30 15:50:56.79 spid53 Starting up database 'fsspda'.
>2004-11-30 15:50:57.26 spid53 Starting up database '3663'.
>2004-11-30 15:51:13.34 spid53 Starting up database 'fsspda'.
>2004-11-30 15:51:27.99 spid53 Starting up database '3663'.
>2004-11-30 15:51:43.49 spid53 Starting up database 'fsspda'.
>2004-11-30 15:51:59.48 spid53 Starting up database '3663'.
>2004-11-30 15:52:22.68 spid53 Starting up database 'fsspda'.
>2004-11-30 15:52:40.95 spid53 Starting up database '3663'.
>2004-11-30 15:53:01.00 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:16.65 spid53 Starting up database '3663'.
>2004-11-30 15:53:33.17 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:48.53 spid53 Starting up database '3663'.
>2004-11-30 15:53:49.39 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:50.02 spid53 Starting up database '3663'.
>2004-11-30 15:53:50.78 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:51.56 spid53 Starting up database '3663'.
>2004-11-30 15:53:52.22 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:52.53 spid53 Starting up database '3663'.
>2004-11-30 15:53:52.87 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:53.16 spid53 Starting up database '3663'.
>2004-11-30 15:53:53.52 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:53.87 spid53 Starting up database '3663'.
>2004-11-30 15:53:54.19 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:54.49 spid53 Starting up database '3663'.
>2004-11-30 15:53:54.97 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:55.33 spid53 Starting up database '3663'.
>2004-11-30 15:53:55.68 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:56.01 spid53 Starting up database '3663'.
>2004-11-30 15:53:56.90 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:57.45 spid53 Starting up database '3663'.
>2004-11-30 15:53:57.81 spid53 Starting up database 'fsspda'.
>2004-11-30 15:54:04.61 spid51 Starting up database 'fsspda'.
>2004-11-30 15:54:05.02 spid51 Starting up database 'fsspda'.
>2004-11-30 15:54:05.45 spid51 Starting up database 'fsspda'.
>2004-11-30 15:54:09.62 spid51 Starting up database '3663'.
>2004-11-30 15:54:10.05 spid51 Starting up database 'demo'.
>2004-11-30 15:54:17.14 spid51 Starting up database 'demo'.
>2004-11-30 15:54:17.46 spid51 Starting up database 'demo'.
>2004-11-30 15:54:17.82 spid51 Starting up database 'demo'.
>2004-11-30 15:54:33.58 spid53 Starting up database 'Route'.
>2004-11-30 15:54:34.32 spid53 Starting up database '3663'.
>2004-11-30 15:54:34.76 spid53 Starting up database 'fsspda'.
>2004-11-30 15:54:35.07 spid53 Starting up database '3663'.
>2004-11-30 15:54:35.38 spid53 Starting up database 'fsspda'.
>2004-11-30 15:58:19.63 spid51 Starting up database '3663'.
>2004-11-30 15:58:37.12 spid51 Starting up database 'fsspda'.
>2004-11-30 15:58:52.46 spid51 Starting up database '3663'.
>2004-11-30 15:59:09.98 spid51 Starting up database 'demo'.
>2004-11-30 15:59:41.81 spid51 Starting up database 'fsspda'.
>2004-11-30 15:59:59.34 spid51 Starting up database '3663'.
>2004-11-30 16:00:15.76 spid51 Starting up database 'demo'.
>2004-11-30 16:00:50.61 spid51 Starting up database 'fsspda'.
>2004-11-30 16:00:51.36 spid51 Starting up database '3663'.
>2004-11-30 16:01:10.96 spid51 Starting up database 'demo'.
>2004-11-30 16:01:30.14 spid51 Starting up database 'fsspda'.
>2004-11-30 16:01:45.79 spid51 Starting up database '3663'.
>2004-11-30 16:02:01.59 spid51 Starting up database 'demo'.
>2004-11-30 16:02:05.37 spid51 Starting up database 'fsspda'.
>2004-11-30 16:02:21.41 spid51 Starting up database '3663'.
>2004-11-30 16:02:38.84 spid51 Starting up database 'demo'.
>2004-11-30 16:02:58.05 spid51 Starting up database 'fsspda'.
>2004-11-30 16:03:13.71 spid51 Starting up database '3663'.
>2004-11-30 16:03:34.68 spid51 Starting up database 'demo'.
>2004-11-30 16:03:56.00 spid51 Starting up database 'fsspda'.
>2004-11-30 16:04:12.85 spid51 Starting up database '3663'.
>2004-11-30 16:04:29.93 spid51 Starting up database 'demo'.
>2004-11-30 16:04:50.03 spid51 Starting up database 'fsspda'.
>2004-11-30 16:05:06.56 spid51 Starting up database '3663'.
>2004-11-30 16:05:24.32 spid51 Starting up database 'demo'.
>2004-11-30 16:05:51.91 spid53 Starting up database '3663'.
>2004-11-30 16:06:10.79 spid51 Starting up database 'fsspda'.
>2004-11-30 16:06:26.38 spid53 Starting up database 'demo'.
>2004-11-30 16:06:46.93 spid51 Starting up database '3663'.
>2004-11-30 16:07:05.64 spid53 Starting up database 'fsspda'.
>2004-11-30 16:07:21.08 spid51 Starting up database 'demo'.
>2004-11-30 16:07:22.29 spid51 Starting up database 'fsspda'.
>2004-11-30 16:07:40.60 spid51 Starting up database '3663'.
>2004-11-30 16:07:59.85 spid51 Starting up database 'demo'.
>2004-11-30 16:08:25.22 spid51 Starting up database 'fsspda'.
>2004-11-30 16:08:44.40 spid51 Starting up database '3663'.
>2004-11-30 16:09:02.97 spid51 Starting up database 'demo'.
>2004-11-30 16:09:34.28 spid51 Starting up database 'fsspda'.
>2004-11-30 16:12:52.66 spid51 Starting up database 'fsspda'.
>2004-11-30 16:12:53.04 spid51 Starting up database 'demo'.
>2004-11-30 16:12:53.45 spid51 Starting up database '3663'.
>2004-11-30 16:12:56.66 spid52 Starting up database 'fsspda'.
>

is this a connection problem or am I going bonkers?

I have SQL installed locally, and it has been working fine for some time.
However, today when I went to Enterprise Manager I could see the tree view
but as soon as I selected "Databases" everything froze, Task Manager
reported that the application was not responding. I left it for 10 minutes
and the
screen stayed stuck with the hourglass.
I tried re-starting the SQL service and rebooting the box, but the same
problem occured.
When I try and use Query Analyser, I cannot select a database from the
drop down list, but, I can use the "Use" command to choose a database and I
can
run a query. It is unblievably slow though.
Just tried to create a new ODBC connection and the test failed because of a
timeout.
Does anyone have any clues?
I've posted the log below
thanks
J
2004-11-30 14:59:48.59 server Microsoft SQL Server 2000 - 8.00.194
(Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2004-11-30 14:59:48.60 server Copyright (C) 1988-2000 Microsoft
Corporation.
2004-11-30 14:59:48.60 server All rights reserved.
2004-11-30 14:59:48.60 server Server Process ID is 1636.
2004-11-30 14:59:48.60 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2004-11-30 14:59:48.66 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2004-11-30 14:59:49.44 server SQL Server configured for thread mode
processing.
2004-11-30 14:59:49.49 server Using dynamic lock allocation. [2500] L
ock
Blocks, [5000] Lock Owner Blocks.
2004-11-30 14:59:49.55 server Attempting to initialize Distributed
Transaction Coordinator.
2004-11-30 14:59:49.96 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2004-11-30 14:59:50.01 spid3 Starting up database 'master'.
2004-11-30 14:59:52.47 spid3 0 transactions rolled back in database
'master' (1).
2004-11-30 14:59:52.48 spid3 Recovery is checkpointing database 'master'
(1)
2004-11-30 14:59:52.62 server Using 'SSNETLIB.DLL' version '8.0.194'.
2004-11-30 14:59:52.63 spid5 Starting up database 'model'.
2004-11-30 14:59:52.76 spid3 Server name is 'OBIWAN'.
2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 7
2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 11
2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 12
2004-11-30 14:59:52.78 server SQL server listening on Shared Memory,
Named Pipes.
2004-11-30 14:59:52.78 server SQL Server is ready for client connections
2004-11-30 14:59:52.78 spid8 Starting up database 'msdb'.
2004-11-30 14:59:52.85 spid9 Starting up database 'pubs'.
2004-11-30 14:59:52.86 spid10 Starting up database 'Northwind'.
2004-11-30 14:59:52.99 spid11 Starting up database 'isoglobal'.
2004-11-30 14:59:53.80 spid5 Clearing tempdb database.
2004-11-30 14:59:54.18 spid9 Starting up database 'vmserver'.
2004-11-30 14:59:54.33 spid10 Starting up database 'vmserver_delivery'.
2004-11-30 14:59:56.76 spid5 Starting up database 'tempdb'.
2004-11-30 14:59:57.02 spid3 Recovery complete.
2004-11-30 15:35:06.94 spid52 Starting up database '3663'.
2004-11-30 15:35:07.47 spid52 Starting up database 'demo'.
2004-11-30 15:35:07.81 spid52 Starting up database 'fsspda'.
2004-11-30 15:35:10.27 spid51 Starting up database '3663'.
2004-11-30 15:35:26.30 spid51 Starting up database 'demo'.
2004-11-30 15:35:45.90 spid51 Starting up database 'fsspda'.
2004-11-30 15:36:09.88 spid51 Starting up database '3663'.
2004-11-30 15:36:27.73 spid51 Starting up database 'demo'.
2004-11-30 15:36:45.81 spid51 Starting up database 'fsspda'.
2004-11-30 15:37:24.86 spid51 Starting up database 'demo'.
2004-11-30 15:37:43.23 spid51 Starting up database 'demo'.
2004-11-30 15:38:03.14 spid51 Starting up database 'demo'.
2004-11-30 15:50:39.57 spid53 Using 'xpstar.dll' version '2000.80.194' to
execute extended stored procedure 'sp_MSgetversion'.
2004-11-30 15:50:56.32 spid53 Starting up database '3663'.
2004-11-30 15:50:56.79 spid53 Starting up database 'fsspda'.
2004-11-30 15:50:57.26 spid53 Starting up database '3663'.
2004-11-30 15:51:13.34 spid53 Starting up database 'fsspda'.
2004-11-30 15:51:27.99 spid53 Starting up database '3663'.
2004-11-30 15:51:43.49 spid53 Starting up database 'fsspda'.
2004-11-30 15:51:59.48 spid53 Starting up database '3663'.
2004-11-30 15:52:22.68 spid53 Starting up database 'fsspda'.
2004-11-30 15:52:40.95 spid53 Starting up database '3663'.
2004-11-30 15:53:01.00 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:16.65 spid53 Starting up database '3663'.
2004-11-30 15:53:33.17 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:48.53 spid53 Starting up database '3663'.
2004-11-30 15:53:49.39 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:50.02 spid53 Starting up database '3663'.
2004-11-30 15:53:50.78 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:51.56 spid53 Starting up database '3663'.
2004-11-30 15:53:52.22 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:52.53 spid53 Starting up database '3663'.
2004-11-30 15:53:52.87 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:53.16 spid53 Starting up database '3663'.
2004-11-30 15:53:53.52 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:53.87 spid53 Starting up database '3663'.
2004-11-30 15:53:54.19 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:54.49 spid53 Starting up database '3663'.
2004-11-30 15:53:54.97 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:55.33 spid53 Starting up database '3663'.
2004-11-30 15:53:55.68 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:56.01 spid53 Starting up database '3663'.
2004-11-30 15:53:56.90 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:57.45 spid53 Starting up database '3663'.
2004-11-30 15:53:57.81 spid53 Starting up database 'fsspda'.
2004-11-30 15:54:04.61 spid51 Starting up database 'fsspda'.
2004-11-30 15:54:05.02 spid51 Starting up database 'fsspda'.
2004-11-30 15:54:05.45 spid51 Starting up database 'fsspda'.
2004-11-30 15:54:09.62 spid51 Starting up database '3663'.
2004-11-30 15:54:10.05 spid51 Starting up database 'demo'.
2004-11-30 15:54:17.14 spid51 Starting up database 'demo'.
2004-11-30 15:54:17.46 spid51 Starting up database 'demo'.
2004-11-30 15:54:17.82 spid51 Starting up database 'demo'.
2004-11-30 15:54:33.58 spid53 Starting up database 'Route'.
2004-11-30 15:54:34.32 spid53 Starting up database '3663'.
2004-11-30 15:54:34.76 spid53 Starting up database 'fsspda'.
2004-11-30 15:54:35.07 spid53 Starting up database '3663'.
2004-11-30 15:54:35.38 spid53 Starting up database 'fsspda'.
2004-11-30 15:58:19.63 spid51 Starting up database '3663'.
2004-11-30 15:58:37.12 spid51 Starting up database 'fsspda'.
2004-11-30 15:58:52.46 spid51 Starting up database '3663'.
2004-11-30 15:59:09.98 spid51 Starting up database 'demo'.
2004-11-30 15:59:41.81 spid51 Starting up database 'fsspda'.
2004-11-30 15:59:59.34 spid51 Starting up database '3663'.
2004-11-30 16:00:15.76 spid51 Starting up database 'demo'.
2004-11-30 16:00:50.61 spid51 Starting up database 'fsspda'.
2004-11-30 16:00:51.36 spid51 Starting up database '3663'.
2004-11-30 16:01:10.96 spid51 Starting up database 'demo'.
2004-11-30 16:01:30.14 spid51 Starting up database 'fsspda'.
2004-11-30 16:01:45.79 spid51 Starting up database '3663'.
2004-11-30 16:02:01.59 spid51 Starting up database 'demo'.
2004-11-30 16:02:05.37 spid51 Starting up database 'fsspda'.
2004-11-30 16:02:21.41 spid51 Starting up database '3663'.
2004-11-30 16:02:38.84 spid51 Starting up database 'demo'.
2004-11-30 16:02:58.05 spid51 Starting up database 'fsspda'.
2004-11-30 16:03:13.71 spid51 Starting up database '3663'.
2004-11-30 16:03:34.68 spid51 Starting up database 'demo'.
2004-11-30 16:03:56.00 spid51 Starting up database 'fsspda'.
2004-11-30 16:04:12.85 spid51 Starting up database '3663'.
2004-11-30 16:04:29.93 spid51 Starting up database 'demo'.
2004-11-30 16:04:50.03 spid51 Starting up database 'fsspda'.
2004-11-30 16:05:06.56 spid51 Starting up database '3663'.
2004-11-30 16:05:24.32 spid51 Starting up database 'demo'.
2004-11-30 16:05:51.91 spid53 Starting up database '3663'.
2004-11-30 16:06:10.79 spid51 Starting up database 'fsspda'.
2004-11-30 16:06:26.38 spid53 Starting up database 'demo'.
2004-11-30 16:06:46.93 spid51 Starting up database '3663'.
2004-11-30 16:07:05.64 spid53 Starting up database 'fsspda'.
2004-11-30 16:07:21.08 spid51 Starting up database 'demo'.
2004-11-30 16:07:22.29 spid51 Starting up database 'fsspda'.
2004-11-30 16:07:40.60 spid51 Starting up database '3663'.
2004-11-30 16:07:59.85 spid51 Starting up database 'demo'.
2004-11-30 16:08:25.22 spid51 Starting up database 'fsspda'.
2004-11-30 16:08:44.40 spid51 Starting up database '3663'.
2004-11-30 16:09:02.97 spid51 Starting up database 'demo'.
2004-11-30 16:09:34.28 spid51 Starting up database 'fsspda'.
2004-11-30 16:12:52.66 spid51 Starting up database 'fsspda'.
2004-11-30 16:12:53.04 spid51 Starting up database 'demo'.
2004-11-30 16:12:53.45 spid51 Starting up database '3663'.
2004-11-30 16:12:56.66 spid52 Starting up database 'fsspda'.Neither...it's from having auto close turned on. See my
posts to your same question in the server newsgroup.
-Sue
On Tue, 30 Nov 2004 09:45:07 -0800, "McFly"
<McFly@.discussions.microsoft.com> wrote:

> I have SQL installed locally, and it has been working fine for some time.
> However, today when I went to Enterprise Manager I could see the tree view
> but as soon as I selected "Databases" everything froze, Task Manager
> reported that the application was not responding. I left it for 10 minute
s
>and the
> screen stayed stuck with the hourglass.
> I tried re-starting the SQL service and rebooting the box, but the same
> problem occured.
> When I try and use Query Analyser, I cannot select a database from the
> drop down list, but, I can use the "Use" command to choose a database and
I
>can
> run a query. It is unblievably slow though.
>Just tried to create a new ODBC connection and the test failed because of a
>timeout.
>
> Does anyone have any clues?
>I've posted the log below
>thanks
>J
>2004-11-30 14:59:48.59 server Microsoft SQL Server 2000 - 8.00.194
>(Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
>2004-11-30 14:59:48.60 server Copyright (C) 1988-2000 Microsoft
>Corporation.
>2004-11-30 14:59:48.60 server All rights reserved.
>2004-11-30 14:59:48.60 server Server Process ID is 1636.
>2004-11-30 14:59:48.60 server Logging SQL Server messages in file
>'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
>2004-11-30 14:59:48.66 server SQL Server is starting at priority class
>'normal'(1 CPU detected).
>2004-11-30 14:59:49.44 server SQL Server configured for thread mode
>processing.
>2004-11-30 14:59:49.49 server Using dynamic lock allocation. [2500]
Lock
>Blocks, [5000] Lock Owner Blocks.
>2004-11-30 14:59:49.55 server Attempting to initialize Distributed
>Transaction Coordinator.
>2004-11-30 14:59:49.96 server Failed to obtain
>TransactionDispenserInterface: Result Code = 0x8004d01b
>2004-11-30 14:59:50.01 spid3 Starting up database 'master'.
>2004-11-30 14:59:52.47 spid3 0 transactions rolled back in database
>'master' (1).
>2004-11-30 14:59:52.48 spid3 Recovery is checkpointing database 'master
'
>(1)
>2004-11-30 14:59:52.62 server Using 'SSNETLIB.DLL' version '8.0.194'.
>2004-11-30 14:59:52.63 spid5 Starting up database 'model'.
>2004-11-30 14:59:52.76 spid3 Server name is 'OBIWAN'.
>2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 7
>2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 11
>2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 12
>2004-11-30 14:59:52.78 server SQL server listening on Shared Memory,
>Named Pipes.
>2004-11-30 14:59:52.78 server SQL Server is ready for client connections
>2004-11-30 14:59:52.78 spid8 Starting up database 'msdb'.
>2004-11-30 14:59:52.85 spid9 Starting up database 'pubs'.
>2004-11-30 14:59:52.86 spid10 Starting up database 'Northwind'.
>2004-11-30 14:59:52.99 spid11 Starting up database 'isoglobal'.
>2004-11-30 14:59:53.80 spid5 Clearing tempdb database.
>2004-11-30 14:59:54.18 spid9 Starting up database 'vmserver'.
>2004-11-30 14:59:54.33 spid10 Starting up database 'vmserver_delivery'.
>2004-11-30 14:59:56.76 spid5 Starting up database 'tempdb'.
>2004-11-30 14:59:57.02 spid3 Recovery complete.
>2004-11-30 15:35:06.94 spid52 Starting up database '3663'.
>2004-11-30 15:35:07.47 spid52 Starting up database 'demo'.
>2004-11-30 15:35:07.81 spid52 Starting up database 'fsspda'.
>2004-11-30 15:35:10.27 spid51 Starting up database '3663'.
>2004-11-30 15:35:26.30 spid51 Starting up database 'demo'.
>2004-11-30 15:35:45.90 spid51 Starting up database 'fsspda'.
>2004-11-30 15:36:09.88 spid51 Starting up database '3663'.
>2004-11-30 15:36:27.73 spid51 Starting up database 'demo'.
>2004-11-30 15:36:45.81 spid51 Starting up database 'fsspda'.
>2004-11-30 15:37:24.86 spid51 Starting up database 'demo'.
>2004-11-30 15:37:43.23 spid51 Starting up database 'demo'.
>2004-11-30 15:38:03.14 spid51 Starting up database 'demo'.
>2004-11-30 15:50:39.57 spid53 Using 'xpstar.dll' version '2000.80.194' t
o
>execute extended stored procedure 'sp_MSgetversion'.
>2004-11-30 15:50:56.32 spid53 Starting up database '3663'.
>2004-11-30 15:50:56.79 spid53 Starting up database 'fsspda'.
>2004-11-30 15:50:57.26 spid53 Starting up database '3663'.
>2004-11-30 15:51:13.34 spid53 Starting up database 'fsspda'.
>2004-11-30 15:51:27.99 spid53 Starting up database '3663'.
>2004-11-30 15:51:43.49 spid53 Starting up database 'fsspda'.
>2004-11-30 15:51:59.48 spid53 Starting up database '3663'.
>2004-11-30 15:52:22.68 spid53 Starting up database 'fsspda'.
>2004-11-30 15:52:40.95 spid53 Starting up database '3663'.
>2004-11-30 15:53:01.00 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:16.65 spid53 Starting up database '3663'.
>2004-11-30 15:53:33.17 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:48.53 spid53 Starting up database '3663'.
>2004-11-30 15:53:49.39 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:50.02 spid53 Starting up database '3663'.
>2004-11-30 15:53:50.78 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:51.56 spid53 Starting up database '3663'.
>2004-11-30 15:53:52.22 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:52.53 spid53 Starting up database '3663'.
>2004-11-30 15:53:52.87 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:53.16 spid53 Starting up database '3663'.
>2004-11-30 15:53:53.52 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:53.87 spid53 Starting up database '3663'.
>2004-11-30 15:53:54.19 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:54.49 spid53 Starting up database '3663'.
>2004-11-30 15:53:54.97 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:55.33 spid53 Starting up database '3663'.
>2004-11-30 15:53:55.68 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:56.01 spid53 Starting up database '3663'.
>2004-11-30 15:53:56.90 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:57.45 spid53 Starting up database '3663'.
>2004-11-30 15:53:57.81 spid53 Starting up database 'fsspda'.
>2004-11-30 15:54:04.61 spid51 Starting up database 'fsspda'.
>2004-11-30 15:54:05.02 spid51 Starting up database 'fsspda'.
>2004-11-30 15:54:05.45 spid51 Starting up database 'fsspda'.
>2004-11-30 15:54:09.62 spid51 Starting up database '3663'.
>2004-11-30 15:54:10.05 spid51 Starting up database 'demo'.
>2004-11-30 15:54:17.14 spid51 Starting up database 'demo'.
>2004-11-30 15:54:17.46 spid51 Starting up database 'demo'.
>2004-11-30 15:54:17.82 spid51 Starting up database 'demo'.
>2004-11-30 15:54:33.58 spid53 Starting up database 'Route'.
>2004-11-30 15:54:34.32 spid53 Starting up database '3663'.
>2004-11-30 15:54:34.76 spid53 Starting up database 'fsspda'.
>2004-11-30 15:54:35.07 spid53 Starting up database '3663'.
>2004-11-30 15:54:35.38 spid53 Starting up database 'fsspda'.
>2004-11-30 15:58:19.63 spid51 Starting up database '3663'.
>2004-11-30 15:58:37.12 spid51 Starting up database 'fsspda'.
>2004-11-30 15:58:52.46 spid51 Starting up database '3663'.
>2004-11-30 15:59:09.98 spid51 Starting up database 'demo'.
>2004-11-30 15:59:41.81 spid51 Starting up database 'fsspda'.
>2004-11-30 15:59:59.34 spid51 Starting up database '3663'.
>2004-11-30 16:00:15.76 spid51 Starting up database 'demo'.
>2004-11-30 16:00:50.61 spid51 Starting up database 'fsspda'.
>2004-11-30 16:00:51.36 spid51 Starting up database '3663'.
>2004-11-30 16:01:10.96 spid51 Starting up database 'demo'.
>2004-11-30 16:01:30.14 spid51 Starting up database 'fsspda'.
>2004-11-30 16:01:45.79 spid51 Starting up database '3663'.
>2004-11-30 16:02:01.59 spid51 Starting up database 'demo'.
>2004-11-30 16:02:05.37 spid51 Starting up database 'fsspda'.
>2004-11-30 16:02:21.41 spid51 Starting up database '3663'.
>2004-11-30 16:02:38.84 spid51 Starting up database 'demo'.
>2004-11-30 16:02:58.05 spid51 Starting up database 'fsspda'.
>2004-11-30 16:03:13.71 spid51 Starting up database '3663'.
>2004-11-30 16:03:34.68 spid51 Starting up database 'demo'.
>2004-11-30 16:03:56.00 spid51 Starting up database 'fsspda'.
>2004-11-30 16:04:12.85 spid51 Starting up database '3663'.
>2004-11-30 16:04:29.93 spid51 Starting up database 'demo'.
>2004-11-30 16:04:50.03 spid51 Starting up database 'fsspda'.
>2004-11-30 16:05:06.56 spid51 Starting up database '3663'.
>2004-11-30 16:05:24.32 spid51 Starting up database 'demo'.
>2004-11-30 16:05:51.91 spid53 Starting up database '3663'.
>2004-11-30 16:06:10.79 spid51 Starting up database 'fsspda'.
>2004-11-30 16:06:26.38 spid53 Starting up database 'demo'.
>2004-11-30 16:06:46.93 spid51 Starting up database '3663'.
>2004-11-30 16:07:05.64 spid53 Starting up database 'fsspda'.
>2004-11-30 16:07:21.08 spid51 Starting up database 'demo'.
>2004-11-30 16:07:22.29 spid51 Starting up database 'fsspda'.
>2004-11-30 16:07:40.60 spid51 Starting up database '3663'.
>2004-11-30 16:07:59.85 spid51 Starting up database 'demo'.
>2004-11-30 16:08:25.22 spid51 Starting up database 'fsspda'.
>2004-11-30 16:08:44.40 spid51 Starting up database '3663'.
>2004-11-30 16:09:02.97 spid51 Starting up database 'demo'.
>2004-11-30 16:09:34.28 spid51 Starting up database 'fsspda'.
>2004-11-30 16:12:52.66 spid51 Starting up database 'fsspda'.
>2004-11-30 16:12:53.04 spid51 Starting up database 'demo'.
>2004-11-30 16:12:53.45 spid51 Starting up database '3663'.
>2004-11-30 16:12:56.66 spid52 Starting up database 'fsspda'.
>