hi,

i am using MSDE 2000 with Visual Studio.Net 2003. I am not able to
connect to the sql server with Ado.net. When i test with a odbc data
source, the test connection works fine. I am using Windows
authentication and have granted login and database access to my
username also.

I have also read the msdn article abt the potential causes, but of no
avail.

thanks,
srini

If you are developing WebApp (ASP.Net), you will have to grant servername\ASPNET
NT user account access to the data.

--
-oj
http://www.rac4sql.net


"srini" <srinivasan_a@hotmail.com> wrote in message
news:23d9e809.0401051005.28b915c5@posting.google.c om...
> hi,
>
> i am using MSDE 2000 with Visual Studio.Net 2003. I am not able to
> connect to the sql server with Ado.net. When i test with a odbc data
> source, the test connection works fine. I am using Windows
> authentication and have granted login and database access to my
> username also.
>
> I have also read the msdn article abt the potential causes, but of no
> avail.
>
> thanks,
> srini