Running SqlServer inside Visual Studio

[oscar_pena]

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.

[jwize]

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.

[Briann]

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