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