Problem Connecting to VSDOTNET instance from Visual Studio 2003
I'm getting desparate. For weeks now I 've been trying to establish a connection to an MSDE instance named VSDOTNET from the Server Explorer in Visual Studio .Net 2003. I've followed the guidlines for installation of both Visual Studio and MSDE instance but still I only get errors when I attempt to connect to VSDOTNET. This is the only instance of MSDE I have installed. I installed from the cmd prompt using command;
"Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=YOUR SA PASSWORD"
I then rebooted and checked that theMSSQL$VSDOTNET service was running.
I then installed the Pubs database using
Then, using the osql utility for MSDE, I installed the Pubs database and granted ASPNET login to instance and access to Pubs database.
I then opened Visual Studio and created a new ASP.NET project and then when I attempt to use Windows NT integrated security as per the instructions in my text book I receive an error when trying to select the Pubs database from the drop down labelled "Select the database on the server". The error states;
"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied"
Followed by a subsequent message box stating
"Login failed. Catalog information cannot be retrieved."
I'm at a complete loss why this is happening. I am logged into XP Pro using an user account with Administrative priviledges but I can't get beyond this point.
Please help I'm going mad. The setup of both products seems straight forward so I'm now wondering if some other piece of software is preventing this access or a required service is missing or switched off.
Thanks
Mike
