troubleshooting Question

Data Connections | Add New Connection | Data Link Properties

Avatar of shikamoo
shikamoo asked on
Microsoft SQL Server
17 Comments1 Solution756 ViewsLast Modified:
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".

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 17 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros