SQL ACCESS FROM VISUAL STUDIO

[bruce]

are you getting this on our server or your local machine.
[b]quote:Originally posted by oscar_pena

HI ALL. I'M HAVING A PROBLEM WITH MY SQL2000 THAT I JUST INSTALLED ON MY SYSTEM. WHEN I OPEN SERVER EXPLORER IN VISUAL STUDIO, I CAN USE THE ADD CONNECTION TO CONNECT TO MY SERVER. IT WORKS 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.

</blockquote id="quote"></font id="quote">

[oscar_pena]

i get this error on my local machine. So far, I have no problems with your server. Thanks bruce.

[bruce]

I suggest you switch to use SQL authentication rather than windows authentication for SQL.

Also try do run aspnet_regiis.exe (Should be in your framework directory, C:\Windows\Microsoft.NET\Framework\v1.1.4322)

[b]quote:Originally posted by oscar_pena

i get this error on my local machine. So far, I have no problems with your server. Thanks bruce.
</blockquote id="quote"></font id="quote">

[oscar_pena]

HI ALL. I'M HAVING A PROBLEM WITH MY SQL2000 THAT I JUST INSTALLED ON MY SYSTEM. WHEN I OPEN SERVER EXPLORER IN VISUAL STUDIO, I CAN USE THE ADD CONNECTION TO CONNECT TO MY SERVER. IT WORKS 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.