MSDE - Unknown Server

Hello,
I installed software called AutoAPP on a users desktop and this software
automatically installs MSDE (No idea what version). When run under the
administrator account everything is fine. When the user logs on under their
account (power user) SQL Icon is on the task bar, but it is blank \\ -
Unknown Server. I have to manually type in the laptop name in the server
field of the SQL Server Service Manager and then the arrow will go green.
Does anyone know why under Administrator account the server name is there,
but not under the users profile? It is annoying having to type in the
computer each time the computer reboots, giving the user Administrative
access to their computer is not really an option. Once the computer name is
entered under the user account everything seems to function normally.
Laptop is running Windows XP Pro SP1
Thank You.
hi John,
"John J. Rambone" <lgm_rambone@.remove.hotmail.com> ha scritto nel
messaggio news:uANQsnFuEHA.1472@.TK2MSFTNGP10.phx.gbl
> Hello,
> I installed software called AutoAPP on a users desktop and this
> software automatically installs MSDE (No idea what version). When
> run under the administrator account everything is fine. When the
> user logs on under their account (power user) SQL Icon is on the task
> bar, but it is blank \\ - Unknown Server. I have to manually type in
> the laptop name in the server field of the SQL Server Service Manager
> and then the arrow will go green. Does anyone know why under
> Administrator account the server name is there, but not under the
> users profile? It is annoying having to type in the computer each
> time the computer reboots, giving the user Administrative access to
> their computer is not really an option. Once the computer name is
> entered under the user account everything seems to function normally.
> Laptop is running Windows XP Pro SP1
is the Service Manager only that does not enlist the local server, or is the
MSDE service itself that is not running when logging as a power user?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||> is the Service Manager only that does not enlist the local server, or is
> the
> MSDE service itself that is not running when logging as a power user?
I uninstalled everything, but once I reinstall I will check under the
Services and Applications -> Services to make sure it is running. I'm
almost positive it is running and the Service manager does load on boot up,
but the circle will not have the green arrow. If I open the Service Manager
the drop down for the Server field will be empty. I type in the name of the
local comptuer i.e. laptop1 and it arrow goes green and the application can
access the database. It is just annoying to have to type in the computer
name each time. I will very 100% for sure if the service is running in the
next day or so, once I get a chance to work on the users laptop again.
Thanks You.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2u4493F26ob6nU1@.uni-berlin.de...
> hi John,
> "John J. Rambone" <lgm_rambone@.remove.hotmail.com> ha scritto nel
> messaggio news:uANQsnFuEHA.1472@.TK2MSFTNGP10.phx.gbl
>

> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

MSDE

I'm trying to install MSDE so I can use MSQL with web matrix. On trying the install I'm getting a message about using SAPWD switch. I've got no idea what that's about, but obviously need to do something somewhere!

I'm running WINXP PRO

ThankxHi, it means that you need to set up a password for the sa account when installing MSDE. Read this:
http://msdn.microsoft.com/library/en-us/distsql/distsql_84xl.asp?frame=true|||how can you tell if you have msde installed or not?|||It will install itself in the c:\program files folder as Microsoft SQL Server|||Follow the instruction in the readme.ntml file. I believe it's section 3.8. Careful when typing the installation string it can be tricky. No spaces between the "="|||Thankx.

I entered the following and ran it. The installation started

C:\sql2ksp3\MSDE\setup SECURITYMODE=SQL SAPWD=my password

After the install ran I got a message saying that : "setup failed to configure the server. Reger to the server error and setup logs"

any clues?|||What do the error logs look like - can you try installing a named instance of msde - your command prompt should look as follows

setup SAPWD="AStrongSAPwd" SECURITYMODE=SQL INSTANCENAME=MyInstance

-Kashif|||I don't know where to access the error logs!

I tried the command that you suggested, I get the message: Please go to the Control Panel to install and configure system components

Thanks|||try this

setup SAPWD="AStrongSAPwd" SECURITYMODE=SQL /l* install.log

to get the logs.

-Kashif|||Kashif, thanks a lot, the following got it all going, my ASP.net apps are all working fine!

setup SAPWD= mypassword SECURITYMODE=SQL INSTANCENAME=MyInstance|||2003-09-02 16:41:40.29 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 1)

2003-09-02 16:41:40.29 server Copyright (C) 1988-2002 Microsoft Corporation.
2003-09-02 16:41:40.29 server All rights reserved.
2003-09-02 16:41:40.29 server Server Process ID is 164.
2003-09-02 16:41:40.29 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2003-09-02 16:41:40.30 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2003-09-02 16:41:40.40 server SQL Server configured for thread mode processing.
2003-09-02 16:41:40.40 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2003-09-02 16:41:40.47 spid3 Warning ******************
2003-09-02 16:41:40.47 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2003-09-02 16:41:40.48 spid3 Starting up database 'master'.
2003-09-02 16:41:40.67 server Using 'SSNETLIB.DLL' version '8.0.766'.
2003-09-02 16:41:40.67 spid5 Starting up database 'model'.
2003-09-02 16:41:40.72 spid3 Server name is 'IANO-SMXPDT'.
2003-09-02 16:41:40.72 spid3 Skipping startup of clean database id 5
2003-09-02 16:41:40.73 spid3 Skipping startup of clean database id 6
2003-09-02 16:41:40.73 spid3 Starting up database 'msdb'.
2003-09-02 16:41:40.76 server SQL server listening on Shared Memory.
2003-09-02 16:41:40.76 server SQL Server is ready for client connections
2003-09-02 16:41:40.83 spid5 Clearing tempdb database.
2003-09-02 16:41:41.20 spid5 Starting up database 'tempdb'.
2003-09-02 16:41:41.27 spid3 Recovery complete.
2003-09-02 16:41:41.27 spid3 SQL global counter collection task is created.
2003-09-02 16:41:41.29 spid3 Warning: override, autoexec procedures skipped.
2003-09-02 16:43:45.56 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.

What do I need to do to make this work?|||Are you having problems connecting to msde - what is the error that you see? The log file looks fine. Also can you check the version of ssnetlib.dll and post it here.

-Kashif|||Thanks for getting back to me.

Is this it ?
2000.80.766.0

I did a search and got SSnetlib.dll.CC1A8C58_27D1_4D38_BF11_C0A5CCB90616
It did not allow me to right click for properties so I copied it to a Temp directory
Where I go the above version.

Question:
At the end of the posted log file where it says
2003-09-03 09:54:23.12 spid5 Clearing tempdb database.
2003-09-03 09:54:23.51 spid5 Starting up database 'tempdb'.
2003-09-03 09:54:23.61 spid3 Recovery complete.
2003-09-03 09:54:23.61 spid3 SQL global counter collection task is created.
2003-09-03 09:54:23.64 spid3 Warning: override, autoexec procedures skipped.
2003-09-03 09:56:28.14 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.

Doesn't that 'stop' request mean that I have some service that needs starting or something?

- IanO -|||I forgot to post this. It may help you"
cnfgsvr.out

###############################################################################

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

An error occurred while attempting to start the service (1460)

SQL Server configuration failed.

###############################################################################|||Hasn't this gone on long enough?

How about disclosing the checks that the MSDE installer make and tell us what we have to do to our systems so it will pass the checks?

I and I suspect many others are beyond "just try this" suggestions.

I am appealing to the staff people who KNOW how the MSDE install script is written.
It is an obsurd waste of time and energy on this item and it delays getting into the purpose of this site - Allowing developers to get some experience building some .Net web applications.

So what say you?
Tell us how it works so we can move on?
Please include what service must be running etc.

IanOwm