Connection to SQL Server on Vista



I have VB6 application which connects to SQL Server 2000 (installed on the
developer machine) database.
I use this code to connect:
strConnectionString = "DRIVER=SQL
Server;SERVER=(local);UID=;DATABASE=Coordinator;Trusted_Connection=Yes"
objConn.Properties("Extended Properties") = strConnectionString
objConn.Open

Everything works fine on Windows XP
I installed everything I need on my laptop with Vista Business and tried to
run my application.
I'm getting an error saying 'Login failed for user 'NameOfMyLaptop\MyName'

I installed everything I need on the same laptop but I replaced Vista with
XP. Everything works.

So, the only difference I see it's OS.

Any suggestion please

Thank you

vovan


.


Loading