hi all sorry for my last post without any message in that..
i am having the same problem connecting to sql server 2005 and it is giving
the same error as was mentioned in all the above posts .. i tried all the
solutions that were described in the posts but of little luck.. what ever i
do i still get the same message.
i have enabled remote connection via tcp/ip and named pipes and put the
authentication mode to windows but i am still getting the same problem.
My connection string is correct ..
please post some more solutions as it is urgent..
thanks in advance
sush
"isha" wrote:
> Hi
> i had a same problem.......
>
> but solved it!
> check your Connection String ... chnage the server name to the SQl server
> instance name n do trusted_connection = yes
>
> eg;
> "server=MainServer-01;database=Test Database;Trusted_Connection=yes";
>
> it works!
>
> isha
>