sql server msde:
Jens,
My Outlook Express rejected a direct reply to you. It only offered a reply
to the entire group and I did not think that appropriate. So I am sending a
new post. Here is the error message that I received in sending to you.
The message could not be sent because one of the recipients was rejected by
the server. The rejected e-mail address was
'Jens@Remove_this_For_Contacting.sqlserver2005.de'. Subject 'Re: Trouble
Getting VS.Net 2003 WalkThroughs MSDE Connection', Account:
'mail.comcast.net', Server: 'smtp.comcast.net', Protocol: SMTP, Server
Response: '550 [PERMFAIL] destination not valid within DNS', Port: 25,
Secure(SSL): No, Server Error: 550, Error Number: 0x800CCC79
Now my response to your response:
I checked MyComputer, Managed, and then Services. There were only two items
related to MSSQL. MSSQL$NETSDK was Started, Automatic, and Local System.
SQLAgent$NETSDK had a blank status, Manual, and Local System. I guess that
means there is only the instance NETSDK that I requested no default
instance.
I checked the Event Viewer and there were no ERROR messages only this
Warning that seems to happen when I boot my PC.
The description for Event ID ( 19011 ) in Source ( MSSQL$NETSDK ) cannot be
found. The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer. You may be
able to use the /AUXSOURCE= flag to retrieve this description; see Help and
Support for details. The following information is part of the event:
(SpnRegister) : Error 1355.
I checked C:\Program Files and there was a MS SQL Server folder with two
folders within it. One was named 80 and the other MSSQL$NETSDK. I looked
in the log files for NetSDK. The most recent log from this mornings boot of
my PC did not have any warning or error messages. I am pasting the log file
from yesterday at the end of this email. It does have both Error and
Warning messages.
If you direct me how I could undo this install, maybe I could reinstall this
MSDE either from the Setup or from the SQL2KDeskSP3 execute. I clearly
remember that the setup executed and then simply disappeared with no
completion status message. I probably should have looked for a log file at
that time. Instead I simply continued on with the execution of the
ConfigSamples execute file that they sent me to create the samples
databases. If I reinstalled MSDE, this time I could look at the Setup log
file, it might tell us what went wrong.
By the way, it does look like some of the sample databases have been
created. Northwind, GrocerToGo, and Portal. But not the Pubs database that
I need.
Unfortunately, I do not understand your first question.
WHat does
OSQL -L say at the commandline ?
Where would I have seen this, on what command line?
Thank you for any advice or direction you can offer. Yesterday's error log
follows.
Hugh
2005-04-26 10:37:42.15 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-04-26 10:37:42.15 server Copyright (C) 1988-2002 Microsoft
Corporation.
2005-04-26 10:37:42.15 server All rights reserved.
2005-04-26 10:37:42.15 server Server Process ID is 2608.
2005-04-26 10:37:42.15 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$NETSDK\LOG\ERRORLOG'.
2005-04-26 10:37:42.17 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2005-04-26 10:37:42.51 server SQL Server configured for thread mode
processing.
2005-04-26 10:37:42.53 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2005-04-26 10:37:42.62 spid3 Warning ******************
2005-04-26 10:37:42.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2005-04-26 10:37:42.70 spid3 Starting up database 'master'.
2005-04-26 10:37:43.78 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-04-26 10:37:43.78 spid5 Starting up database 'model'.
2005-04-26 10:37:43.82 spid3 Server name is 'HUGHDANC-BIWWOS\NETSDK'.
2005-04-26 10:37:43.82 spid3 Skipping startup of clean database id 5
2005-04-26 10:37:43.82 spid3 Skipping startup of clean database id 6
2005-04-26 10:37:43.82 spid3 Starting up database 'msdb'.
2005-04-26 10:37:44.39 spid5 Clearing tempdb database.
2005-04-26 10:37:44.51 server SQL server listening on Shared Memory.
2005-04-26 10:37:44.51 server SQL Server is ready for client connections
2005-04-26 10:37:45.23 spid5 Starting up database 'tempdb'.
2005-04-26 10:37:45.32 spid3 Recovery complete.
2005-04-26 10:37:45.32 spid3 SQL global counter collection task is
created.
2005-04-26 10:37:45.34 spid3 Warning: override, autoexec procedures
skipped.
2005-04-26 10:37:56.85 spid51 Error: 15457, Severity: 0, State: 1
2005-04-26 10:37:56.85 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2005-04-26 10:37:56.93 spid51 Error: 15457, Severity: 0, State: 1
2005-04-26 10:37:56.93 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2005-04-26 10:37:57.35 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
"Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:%2351vgpqSFHA.2304@tk2msftngp13.phx.gbl...
[quoted text, click to view] > WHat does
>
> OSQL -L say at the commandline ?
>
> Is the instance running and ready, does the service come up without any
> error, do you have an named instance installed or just the standard
> instance
> ?
>
>
> HTH, Jens Suessmeyer.
>
> ---
>
http://www.sqlserver2005.de > ---
>
> "Hugh O" <HughLD@newsgroup.nospam> schrieb im Newsbeitrag
> news:OtF%23gsnSFHA.2132@TK2MSFTNGP14.phx.gbl...
>> Have successfully installed VS.Net 2003 and had started to use the VS
>> Startup WalkThroughs for Creating a Web app. It asked for the server
>> information for a Pub database. I asked the MS Newsgroup for VS.Net
>> Setup
>> and they directed me to install MSDE and they attached a ConfigSamples
>> app
>> to create the sample databases. I executed a SQL2KDeskSP3 exe and then
>> the related Setup asking to create an instance for NetSDK, that they said
>> was required for the ConfigSamples.
>>
>>
>>
>> The SQL2KDeskSP3 completed with no message. I rebooted and there is a
>> MSDE icon in the Systray. It does say Not connected though. When I
>> executed ConfigSamples it ended with the following window heading and
>> message.
>>