Avatar of shikamoo
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".
Microsoft SQL Server

Avatar of undefined
Last Comment
shikamoo

8/22/2022 - Mon
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?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
PatG042800

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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?
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
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?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
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.