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".

PatG042800

"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

shikamoo

ASKER

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?

PatG042800

Is there an MSSQLServer service?

PatG042800

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.

http://www.microsoft.com/downloads/details.aspx?familyid=413744d1-a0bc-479f-bafa-e4b278eb9147&displaylang=en

shikamoo

ASKER

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

or

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
            Quiet mode, no user interaction
      /passive
            Unattended mode - progress bar only
      /q[n|b|r|f]
            Sets user interface level
            n - No UI
            b - Basic UI
            r - Reduced UI
            f - Full UI (default)
      /help
            Help information
Restart Options
      /norestart
            Do not restart after the installation is complete
      /promptrestart
            Prompts the user for restart if necessary
      /forcerestart
            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
      [PROPERTY=PropertyValue]

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.

PatG042800

I think it is

c:> setup.exe SAPWD=mypasswd

ASKER CERTIFIED SOLUTION

PatG042800

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

shikamoo

ASKER

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.

shikamoo

ASKER

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.

PatG042800

We are making progress then, are the services started?

shikamoo

ASKER

Yes, sir! It's listed in the services and it's listed in the System Tray.

PatG042800

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
>go
... you should get some names here
>quit

If you get a list of names then SQLServer is up and running.

shikamoo

ASKER

'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.

PatG042800

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

shikamoo

ASKER

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.

PatG042800

My bad, MSDE uses osql.exe, try that. Or is your application connecting to the DB now?

shikamoo

ASKER

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.