Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
- From: "Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 5 May 2005 14:58:21 +0200
Post private conversation via Mail:
-E will connect to your local defaut instance, if only a named one is
installed you have to type in something like -SServername/NameOfInstance,
the fact that no servers can be listed could result in the network settings,
does the SQL server listen to TCPIP ? Did you check that via the network
Config Tool of SQL Server ? There is also a checkbox in there which says
Hide Server, therefor you cannot see it in the LIST via the -L switch..
Another way should be to ceck wheter the service is listening on the
appopiate port with a portscanner like superscan.
We will find your problem ;-) !
Let me know if thi fixed it.
HTH, Jens Suessmeyer.
> Jens,
> I discovered within Visual Studio.Net 2003 something called the Server
> Explorer. In expanding it, it had two lines for servers listed.
> HUGHDANC-BIWWOS
> HUGHDANC-BIWWOS\NETSDK
>
> I realized that HughDanc-Biwwos was the name given to my PC when I
> recently installed Win/XP Pro. It makes sense that my PC name is the name
> of my server created by VS.Net. I tried to expand the first and got a
> not authorized message. But I suspect that because I did not create a
> default instance, there really is no first instance.
>
> I expanded the second and it showed all of the SQL databases. However it
> did not show the PUBs database. I remembered that you had emailed me a
> link to download the PUBs database. I executed the link and performed the
> download. Then I copied and pasted the created PUBs.mdf and PUBS.log file
> into the folder that contained the other NETSDK databases.
>
> I thought that would add the PUBS database and maybe I could continue
> using the VS.Net WalkThroughs. However it did not list the PUBS database
> as a option for the dropdowns for the specified SQL instance even after I
> rebooted my system.
>
> I then tried to use one the other databases instead of the PUBS and it
> looked like it worked. It actually did not really work, but it failed
> because it was not the PUBs database. It actually connected to the
> database that I selected. If I had installed a PUBs Database successfully
> it would have worked.
>
> There fore I have decided that I will uninstall and re-install MSDE as
> best that I can and then checked to make sure all of the components have
> been removed. Then I will reinstall the SQL2KSP3.exe that I received to
> create the VS. samples. After that I will use the Setup parameters to
> reinstall the NETSDK instance and specify a log file. If it works that
> will be great but if it stops without a completion notice, I will search
> the log file of some clues. If it bombs out and I find a specific error
> message, I will open a new Post on MSDE Newsgroup. I think I have been
> confusing you with the multiple posts and sending you emails direct for
> this one problem.
>
> FYI,
> Once I learned my server name, I did try a OSQL command using -E and -S
> and it accepted it creating an entry so that I could enter SQL Transaction
> statements. I did not know what to enter. I plan on reading up on that
> via the online SQL books. I believe that if I knew the correct
> statements, I would have been able to verify that the databases displayed
> in the VS.Net Server Explorer are really part of MSDE NETSDK instance.
>
> I was not able to check the other things that you suggested. I could not
> find where the Network SQL Config Tool is located nor any documentation
> about it. I assume that the Docs will be in the SQL online books.
>
> Thanks for your help. I have been more than a little dense through most
> of this. But I have learned a good bit. And will learn whatever it will
> take. I really believe in my planned Web Application, if I ever get to it.
> :O)
>
> thanks,
> hugh
> ----- Original Message -----
> From: "Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxx>
> To: "Hugh O" <hughishere@xxxxxxxxxxx>
> Sent: Friday, April 29, 2005 7:23 PM
> Subject: Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
>
>
>> -E will connect to your local defaut instance, if only a named one is
>> installed you have to type in something like -SServername/NameOfInstance,
>> the fact that no servers can be listed could result in the network
>> settings, does the SQL server listen to TCPIP ? Did you check that via
>> the network Config Tool of SQL Server ? There is also a checkbox in there
>> which says Hide Server, therefor you cannot see it in the LIST via the -L
>> switch.. Another way should be to ceck wheter the service is listening on
>> the appopiate port with a portscanner like superscan.
>>
>> We will find your problem ;-) !
>>
>> Let me know if thi fixed it.
>>
>> HTH, Jens Suessmeyer.
>>
>> ---
>> http://www.sqlserver2005.de
>> ---
>>
>>
>> ----- Original Message -----
>> From: "Hugh O" <hughishere@xxxxxxxxxxx>
>> To: "Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxx>
>> Sent: Friday, April 29, 2005 2:29 PM
>> Subject: Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
>>
>>
>>> Jens,
>>> I need to do something here. My initial objective was simply to use the
>>> VS.Net 2003 WalkThroughs to get me started in creating a Web
>>> application. I think that I would like to back off this failed MSDE
>>> environment and try a reinstall and check the Setup Log files
>>> immediately after execution to see if there is any errors or warnings.
>>> You asked about the command response. From a DOS command prompt I typed
>>>
>>> osql -L
>>> the response was
>>> Servers:
>>> -- NONE --
>>>
>>> When I typed osql -E the response was
>>>
>>> [Shared Memory]SQL Servr does not exist or access denied.
>>> [Shared Memory]ConnectionOpen <Connect<>>.
>>>
>>> I was planning on using Control Panel Add/Remove to uninstall the MS SQL
>>> NETSDK environment that is listed. Will take care of everything for a
>>> complete Uninstall or do I have to do something else?
>>>
>>> thanks,
>>> hugh
>>>
>>> ----- Original Message -----
>>> From: "Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxx>
>>> To: "Hugh O" <hughishere@xxxxxxxxxxx>
>>> Sent: Thursday, April 28, 2005 1:17 AM
>>> Subject: Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
>>>
>>>
>>>> Hi Hugh,
>>>>
>>>> If you wanna write me an E-Mail, you have to Remove_the_String out of
>>>> the E-Mail thats for to avoid any Spam Harvesters collecting my EMail
>>>> Adress.
>>>>
>>>> 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
>>>> ---
>>>>
>>>> ----- Original Message -----
>>>> From: "Hugh O" <hughishere@xxxxxxxxxxx>
>>>> To: <Jens@xxxxxxxxxxxxxxxx>
>>>> Sent: Thursday, April 28, 2005 1:37 AM
>>>> Subject: Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
>>>>
>>>>
>>>>> 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. I tried
>>>>> sending a
>>>>> new post. This one I tried using your address without the
>>>>> "RemoveThisInsertion".
>>>>>
>>>>> 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@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
>>>>> wrote in
>>>>> message news:%2351vgpqSFHA.2304@xxxxxxxxxxxxxxxxxxxxxxx
>>>>>> 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@xxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
>>>>>> news:OtF%23gsnSFHA.2132@xxxxxxxxxxxxxxxxxxxxxxx
>>>>>>> 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.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> MS.Net Framework SDK QuickStart Tutorials
>>>>>>>
>>>>>>> The samples configuration has completed with errors. Review log for
>>>>>>> more
>>>>>>> details.
>>>>>>>
>>>>>>> And it offers an option to launch.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> The log had all pass condition codes except these copied statements
>>>>>>>
>>>>>>> 6:43:39 AM Monday, April 25, 2005: [Info] Could not detect NetSDK
>>>>>>> instance
>>>>>>> of SQL Server. Databases will not be installed.
>>>>>>>
>>>>>>> 10:45:39 AM Tuesday, April 26, 2005: [Fail] Error executing SQL
>>>>>>> script.
>>>>>>> (Script/ExitCode): InstPubs.sql/1
>>>>>>>
>>>>>>> 10:45:41 AM Tuesday, April 26, 2005: [Fail] Could not add QuickStart
>>>>>>> user
>>>>>>> to database.: Pubs: Cannot open database requested in login 'Pubs'.
>>>>>>> Login
>>>>>>> fails.
>>>>>>>
>>>>>>> Login failed for user 'HUGHDANC-BIWWOS\HughBoss'.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> I believe that first warning message was left over from an attempt
>>>>>>> yesterday. I was able to launch the QuickStart and launch the
>>>>>>> MS.Net
>>>>>>> Framework SDK Tutorials. But when I tried to execute the VS.Net 2003
>>>>>>> WalkThroughs and connect to the Pubs database I get the following
>>>>>>> error
>>>>>>> message
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Error enumerating data servers. Enumerator reports "Unspecified
>>>>>>> error"
>>>>>>> (there was nothing listed in the server dropdown in the Connection
>>>>>>> Wizard)
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> What can I do to rectify this. All that I really want to do
>>>>>>> initially is
>>>>>>> to be able to use the Walk Throughs for VS.Net and maybe try the
>>>>>>> QuickStarts for MS.Net Framework SDK tutorials. I have an
>>>>>>> application I
>>>>>>> want to make into a Web based software.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Thanks,
>>>>>>>
>>>>>>> hugh
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
"Hugh O" <HughLD@xxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
news:%232GBri%23SFHA.3980@xxxxxxxxxxxxxxxxxxxxxxx
> Jens,
>
> Please excuse my ignorance. This is my first experience with a public
> newsgroup. I was not trying to communicate outside of the newsgroup. When
> I tried the ReplyGroup Option on my OutLook Express, the message made me
> concerned that my response would be going to everyone in the group. I
> thought that would have me bothering a lot of people unnecessarily.
>
> Since your email I have read up a little on the OSQL utility.
>
> From a DOS command prompt I typed
>
> osql -L
> the response was
> Servers:
> -- NONE --
>
> When I typed osql -E the response was
>
> [Shared Memory]SQL Servr does not exist or access denied.
> [Shared Memory]ConnectionOpen <Connect<>>.
>
> thanks,
> hugh
>
>
>
> "Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote
> in message news:%2351vgpqSFHA.2304@xxxxxxxxxxxxxxxxxxxxxxx
>> 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@xxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
>> news:OtF%23gsnSFHA.2132@xxxxxxxxxxxxxxxxxxxxxxx
>>> 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.
>>>
>>>
>>>
>>> MS.Net Framework SDK QuickStart Tutorials
>>>
>>> The samples configuration has completed with errors. Review log for more
>>> details.
>>>
>>> And it offers an option to launch.
>>>
>>>
>>>
>>> The log had all pass condition codes except these copied statements
>>>
>>> 6:43:39 AM Monday, April 25, 2005: [Info] Could not detect NetSDK
>>> instance of SQL Server. Databases will not be installed.
>>>
>>> 10:45:39 AM Tuesday, April 26, 2005: [Fail] Error executing SQL script.
>>> (Script/ExitCode): InstPubs.sql/1
>>>
>>> 10:45:41 AM Tuesday, April 26, 2005: [Fail] Could not add QuickStart
>>> user to database.: Pubs: Cannot open database requested in login 'Pubs'.
>>> Login fails.
>>>
>>> Login failed for user 'HUGHDANC-BIWWOS\HughBoss'.
>>>
>>>
>>>
>>> I believe that first warning message was left over from an attempt
>>> yesterday. I was able to launch the QuickStart and launch the MS.Net
>>> Framework SDK Tutorials. But when I tried to execute the VS.Net 2003
>>> WalkThroughs and connect to the Pubs database I get the following error
>>> message
>>>
>>>
>>>
>>> Error enumerating data servers. Enumerator reports "Unspecified error"
>>> (there was nothing listed in the server dropdown in the Connection
>>> Wizard)
>>>
>>>
>>>
>>> What can I do to rectify this. All that I really want to do initially
>>> is to be able to use the Walk Throughs for VS.Net and maybe try the
>>> QuickStarts for MS.Net Framework SDK tutorials. I have an application I
>>> want to make into a Web based software.
>>>
>>>
>>>
>>> Thanks,
>>>
>>> hugh
>>>
>>>
>>
>>
>
>
.
- Prev by Date: Re: Cannot Install DB
- Next by Date: Re: Install MSDE2000 failed
- Previous by thread: Cannot Install DB
- Next by thread: Table permissions
- Index(es):
Relevant Pages
|
