Help with MSDE Install

Installed MSDE on windowsxp pro.
When computer restarts, icon seen at System Tray.
Click on icon and SQL Server Service Manager.
Server field blank
Services field blank
typed in computername for Server field
select start/continue button.
error message that no service has been selected.
Where did I go wrong?
Walter Wu
Logfile:
2005-06-30 07:26:25.64 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
2005-06-30 07:26:25.64 server Copyright (C) 1988-2002 Microsoft
Corporation.
2005-06-30 07:26:25.64 server All rights reserved.
2005-06-30 07:26:25.64 server Server Process ID is 540.
2005-06-30 07:26:25.64 server Logging SQL Server messages in file
'G:\MSSQL$MYFIRSTSQLSERVER\LOG\ERRORLOG'.
2005-06-30 07:26:25.67 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2005-06-30 07:26:26.54 server SQL Server configured for thread mode
processing.
2005-06-30 07:26:26.54 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2005-06-30 07:26:26.70 spid2 Starting up database 'master'.
2005-06-30 07:26:27.07 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-06-30 07:26:27.07 spid5 Starting up database 'model'.
2005-06-30 07:26:27.10 spid2 Server name is 'MASTER\MYFIRSTSQLSERVER'.
2005-06-30 07:26:27.10 spid2 Skipping startup of clean database id 4
2005-06-30 07:26:27.21 server SQL server listening on Shared Memory.
2005-06-30 07:26:27.25 spid5 Clearing tempdb database.
2005-06-30 07:26:27.67 spid5 Starting up database 'tempdb'.
2005-06-30 07:26:27.75 spid2 Recovery complete.
2005-06-30 07:26:27.75 spid2 SQL global counter collection task is
created.
2005-06-30 07:26:28.57 server SQL Server is ready for client connections
"NoOne" <NoOne@.NoName.com> wrote in message
news:%238pclQQfFHA.268@.TK2MSFTNGP15.phx.gbl...
> Installed MSDE on windowsxp pro.
> When computer restarts, icon seen at System Tray.
> Click on icon and SQL Server Service Manager.
> Server field blank
> Services field blank
> typed in computername for Server field
> select start/continue button.
> error message that no service has been selected.
> Where did I go wrong?
>
> Walter Wu
>
|||hi Walter,
NoOne wrote:
> Installed MSDE on windowsxp pro.
> When computer restarts, icon seen at System Tray.
> Click on icon and SQL Server Service Manager.
> Server field blank
> Services field blank
> typed in computername for Server field
> select start/continue button.
> error message that no service has been selected.
> Where did I go wrong?
>
from your log file, your MSDE is runnig... but you probably installed MSDE
without network protocols support, and this unfortunately can cause the
corresponding instance not to show up in the SQL Server Service Manager, as
reported in http://support.microsoft.com/default...b;EN-US;814132
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||-
/kj
"NoOne" <NoOne@.NoName.com> wrote in message
news:ekke%23fQfFHA.2384@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Logfile:
> 2005-06-30 07:26:27.10 spid2 Server name is 'MASTER\MYFIRSTSQLSERVER'.
> "NoOne" <NoOne@.NoName.com> wrote in message
> news:%238pclQQfFHA.268@.TK2MSFTNGP15.phx.gbl...
Trying entering
MASTER\MYFIRSTSQLSERVER
on the server line of SQL Server Manager, wait a painfully long time with
the hour glass, and eventually you should see your services state.
Unfortunately, you'll have to do this everytime as it won't stick. ( Don't
you wish you had shortened that instance name now? ;-) )
/kj
|||Change the instance name and removed the password and it works.
Thanks everyone.
"NoOne" <NoOne@.NoName.com> wrote in message
news:ekke%23fQfFHA.2384@.TK2MSFTNGP15.phx.gbl...
> Logfile:
> 2005-06-30 07:26:25.64 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
> 2005-06-30 07:26:25.64 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2005-06-30 07:26:25.64 server All rights reserved.
> 2005-06-30 07:26:25.64 server Server Process ID is 540.
> 2005-06-30 07:26:25.64 server Logging SQL Server messages in file
> 'G:\MSSQL$MYFIRSTSQLSERVER\LOG\ERRORLOG'.
> 2005-06-30 07:26:25.67 server SQL Server is starting at priority class
> 'normal'(2 CPUs detected).
> 2005-06-30 07:26:26.54 server SQL Server configured for thread mode
> processing.
> 2005-06-30 07:26:26.54 server Using dynamic lock allocation. [500] Lock
> Blocks, [1000] Lock Owner Blocks.
> 2005-06-30 07:26:26.70 spid2 Starting up database 'master'.
> 2005-06-30 07:26:27.07 server Using 'SSNETLIB.DLL' version '8.0.766'.
> 2005-06-30 07:26:27.07 spid5 Starting up database 'model'.
> 2005-06-30 07:26:27.10 spid2 Server name is 'MASTER\MYFIRSTSQLSERVER'.
> 2005-06-30 07:26:27.10 spid2 Skipping startup of clean database id 4
> 2005-06-30 07:26:27.21 server SQL server listening on Shared Memory.
> 2005-06-30 07:26:27.25 spid5 Clearing tempdb database.
> 2005-06-30 07:26:27.67 spid5 Starting up database 'tempdb'.
> 2005-06-30 07:26:27.75 spid2 Recovery complete.
> 2005-06-30 07:26:27.75 spid2 SQL global counter collection task is
> created.
> 2005-06-30 07:26:28.57 server SQL Server is ready for client
> connections
> "NoOne" <NoOne@.NoName.com> wrote in message
> news:%238pclQQfFHA.268@.TK2MSFTNGP15.phx.gbl...
>