Help with MSDE Install -- sql server msde

sql server msde : Help with MSDE Install

NoOne
6/30/2005 12:00:00 AM

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

NoOne
6/30/2005 12:00:00 AM

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

[quoted text, click to view]

Andrea Montanari
6/30/2005 12:37:18 PM

hi Walter,
[quoted text, click to view]

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.aspx?scid=kb;EN-US;814132
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://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
6/30/2005 4:35:34 PM

-
/kj
[quoted text, click to view]

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

NoOne
7/2/2005 12:00:00 AM

Change the instance name and removed the password and it works.

Thanks everyone.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server msde

home · blog · groups

Questions? Comments? Contact the dn