Running SqlServer inside Visual Studio

HI ALL. I'M HAVING A PROBLEM WITH SQL 2000 THAT I JUST INSTALLED IN MY SYSTEM. WHEN I OPENED SERVER EXPLORER IN VISUAL STUDIO, I COULD USE THE ADD CONNECTION TO CONNECT TO MY SERVER. IT WORKED FINE. THEN I ADDED THE CONNECTION STRING IN THE WEB.CONFIG FILE LIKE THIS:
DATASOURCE=OSCAR\MAIN;INITIAL CATALOG=OSCARPARTS;TRUSTED_CONNECTION=SSPI.
I USED TO WORK WITH THE MSDE ENGINE AND THIS CONNECTION STRING WORKED FINE. I WAS ABLE TO RUN MY APPLICATION.
BUT NOW, I GET AN ERROR TELLING ME THAT THE LOGIN FAILS FOR ACCOUNT ASP.NET. I HAVE TRIED REPLACING THE LAST PART WITH MY WINDOWS LOGIN AS FOLLOW:
USER ID=OSCAR
PASSWORD=OPC
HOWEVER, I STILL GET A LOGIN ERROR. CAN YOU PLEASE HELP ME AND TELL ME WHAT I AM DOING WRONG. THANK YOU.

 

Thatmust be a lotof work keeping the shiftkey down on every key-stroke... or perhaps it is just caps-lock being left on.


I have the same problem. I just worked around it by hand-coding the web.config file. I would like to be able to use the drag-drop facility, so if you come up with anything please keep us informed.

 

Hi,


Are you sure thatASPNET is the correct worker process for your system? Win 2003 server (with IIS and native mode),uses a differnt WP than XP. Look up NETWORK SERVICE. I believe that's the WP for ASP.NET in Win 2003 server. BRN..