all groups > sql server msde > april 2005 >
You're in the

sql server msde

group:

2nd Post - Trouble Getting VS.Net 2003 WalkThrough working


2nd Post - Trouble Getting VS.Net 2003 WalkThrough working Hugh O
4/27/2005 11:29:14 AM
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]
Re: 2nd Post - Trouble Getting VS.Net 2003 WalkThrough working Jens Süßmeyer
4/28/2005 12:00:00 AM
Hi Hugh,

if you need the pubs database, that can be downloaded via:

http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en

The fact that the other databases exists phyiscally doesn´t mean that they
are already online (due to a failure in the installion ?), TO Check that you
can try to connect to SQL Server using OSL or a GUI.

The Command OSQL ist for the commandline under DOS. There you can list all
availale servers and Istances on the network, the Command is a following:
OSQL -L
If you don´t got any GUI Tool to connect to SQL Server you can propably use
the OSQL as well, jzs connect via

OSQL
=====

options

-E (--> integrated Security)
-UUsername -PPassword (--> Sql Security)
-SServername (to connect to a remote server)

With that you can try connectivity to SQL Server.


HTH, Jens Suessmeyer.

---
hhtp://www.sqlserver2005.de
---
"Hugh O" <HughLD@newsgroup.nospam> schrieb im Newsbeitrag
news:uiUwd3zSFHA.3056@TK2MSFTNGP14.phx.gbl...
[quoted text, click to view]
AddThis Social Bookmark Button