Link to home
Avatar of shikamoo

asked on

Data Connections | Add New Connection | Data Link Properties

I'm trying to get through the first walkthrough in the book that comes with VS 2002.  I created a VB ASP.NET Web Service.  Now I'm told

>> Right-click Data Connections and choose Add Connection.  In the Data Link Properties dislog box, specify the properties for the connection.  <<

From the connections tab, clicking on the drop-down for the server name gives a very long delay and then finally no result (Error enumerating data servers) so I back track . . .

I expand my computer's listing under "servers" on the Server Explorer and right-click SQL Servers, Leave the Instance Name field blank to stick with the same name as the server (the computer's name) but from there (after a long delay) the SQL Server Login comes up, and whether I go with the Windows NT Integrated Security (as the walkthrough advises elsewhere) or try my login and password, I get

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I'm a desktop developer, all of this stuff is totally new to me.  Why can't they just walk me through all the steps here.  I know it shouldn't be this hard.  I'm pretty sure I installed SQL Desktop Engine as one of the defaults on my VS 2002 install (not even sure how to check if I did.)

All I want to do is get a local SQL server happening on my machine and then try using a sample database that's supposed to be available called "Pubs".
Avatar of PatG042800
Flag of United States of America image

"I'm pretty sure I installed SQL Desktop Engine"

Look in services to see if you have SQLServer in the "Started" state. If it does not exist then you have not installed it.

Control Panel/ Adminstrative Tools/ Services
Avatar of shikamoo


Weird, there's a listing of my computer's name under SQL Servers in the Server Explorer in VS, but no, it's not listed in my Services in Administrative Tools.

It was checked when I installed Visual Studio.  What do I do then?

Is there an MSSQLServer service?
If it does not exist then I would suggest that you try to to a Reinstall/Modify of VS 2002.

Of you can download MSDE here and do a fresh install.
Shoot, I tried the download last time and couldn't get anywhere so I went with a fresh install.

I'll download it, get the following message on trying to install from Windows:

A strong SA password is required for security reasons. Please use SAPWD switch to supply the same . . . Setup will now exit.

So from the command prompt, from the proper folder I type:

setup.exe /sapwd=password


setup.exe /sapwd="password"

depending on how you read the readme and all I get is . . .


Windows ® Installer. V 3.01.4000.1823

msiexec /Option <Required Parameter> [Optional Parameter]

Install Options
      </package | /i> <Product.msi>
            Installs or configures a product
      /a <Product.msi>
            Administrative install - Installs a product on the network
      /j<u|m> <Product.msi> [/t <Transform List>] [/g <Language ID>]
            Advertises a product - m to all users, u to current user
      </uninstall | /x> <Product.msi | ProductCode>
            Uninstalls the product
Display Options
            Quiet mode, no user interaction
            Unattended mode - progress bar only
            Sets user interface level
            n - No UI
            b - Basic UI
            r - Reduced UI
            f - Full UI (default)
            Help information
Restart Options
            Do not restart after the installation is complete
            Prompts the user for restart if necessary
            Always restart the computer after installation
Logging Options
      /l[i|w|e|a|r|u|c|m|o|p|v|x|+|!|*] <LogFile>
            i - Status messages
            w - Nonfatal warnings
            e - All error messages
            a - Start up of actions
            r - Action-specific records
            u - User requests
            c - Initial UI parameters
            m - Out-of-memory or fatal exit information
            o - Out-of-disk-space messages
            p - Terminal properties
            v - Verbose output
            x - Extra debugging information
            + - Append to existing log file
            ! - Flush each line to the log
            * - Log all information, except for v and x options
      /log <LogFile>
            Equivalent of /l* <LogFile>
Update Options
      /update <Update1.msp>[;Update2.msp]
            Applies update(s)
      /uninstall <PatchCodeGuid>[;Update2.msp] /package <Product.msi | ProductCode>
            Remove update(s) for a product
Repair Options
      /f[p|e|c|m|s|o|d|a|u|v] <Product.msi | ProductCode>
            Repairs a product
            p - only if file is missing
            o - if file is missing or an older version is installed (default)
            e - if file is missing or an equal or older version is installed
            d - if file is missing or a different version is installed
            c - if file is missing or checksum does not match the calculated value
            a - forces all files to be reinstalled
            u - all required user-specific registry entries (default)
            m - all required computer-specific registry entries (default)
            s - all existing shortcuts (default)
            v - runs from source and recaches local package
Setting Public Properties

Consult the Windows ® Installer SDK for additional documentation on the
command line syntax.

Copyright © Microsoft Corporation. All rights reserved.
Portions of this software are based in part on the work of the Independent JPEG Group.


in a dialog box and no install and no service showing up in Services.
I think it is

c:> setup.exe SAPWD=mypasswd
Avatar of PatG042800
Flag of United States of America image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Oh my goodness.  Here I thought for sure the switch needed a forward slash!

Thanks a bunch, Pat.  There it is in my services.  The worst of it is, I purchased six different books and all of them assume you just know how to set all this stuff up.

Thanks a lot for all the help.
Crap.  Even though I've finally got new listings in Services for MSSQLSERVER and MSSQLServerADHelper, it's behaving exactly as it did with the original question.
We are making progress then, are the services started?
Yes, sir!  It's listed in the services and it's listed in the System Tray.
ok lets see if you have connectivity

open a command window

start/run  cmd  Ok

c:> isql -U sa -P yourpassword
>use pubs
>select au_fname from authors
... you should get some names here

If you get a list of names then SQLServer is up and running.
'isql' is not recognized as an internal or external command, operable program or batch file.

Strange because I can see the new server icon in the System Tray.
If you have not rebooted then the PATH setting may not have taken effect yet
Try rebooting and look in
C:\Program Files\Microsoft SQL Server\80\Tools\Binn for isql.exe
I was able to get to

C:\Program Files\Microsoft SQL Server\80\Tools\Binn

but there's no isql.exe in the folder

From Windows Explorer I did a search of the entire Microsoft SQL Server for isql.exe and nothing turned up.
My bad, MSDE uses osql.exe, try that. Or is your application connecting to the DB now?
I don't know why I'm having so much trouble just getting things up and running with Visual Studio and the SQL Server and the samples, but I tried another book (good thing I had a stack of them) and it came with a CD with the Microsoft "Samples and Quick Start Tutorials" and actually walked me through all the stuff I needed to install!  (What a concept, eh?)  It's based on the ASP.NET Web Matrix, but that'll be fine for starters.

I appreciate all your help though and if you have email notification turned on, you just might get the Comment Added email when I go back to trying to tackle the VS install.