HOW CAN I CONNECT QTP 11 WITH SQL SERVER 2005 IN WINDOWS AUTHENTICATION

Replies to This Discussion

Permalink Reply by Garvin on January 24, 2011 at 11:42pm

This connection string should work but I am having the same problem where it says the connection is invalid

SQL Server ODBC Connection String - Trusted Connection(Windows Authentication)

Driver={SQL Server};Server=mysername;Database=mydemodb;Trusted_Connection=yes;

 

• ▶ Reply

Permalink Reply by Garvin on January 27, 2011 at 8:39pm

I resolved my issue.  I was given an incorrect server name.  The connection string above is what one needs when dealing with SQL Server Windows Authentication.

• ▶ Reply