SQL Server windows authentication...

[sabavno]

Hi

I have a SQL Server installed on my machine, the windows authentication is used to access that server.

I have tried:

db.open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Polina's;Data Source=MYSERVER"

and it did not work

I also created a DSN and used it in the code - did not work either.

The error that I get when I use DSN-less connection is:

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Login failed for user '\'.


Please suggest any solution.
I am desperate here.

Thanks