CODEWITHSUNDEEP
sqlexcelvbaconnection-stringadodb
notnot
notnot

Reputation: 4642

Excel VBA - connect to sql with a trusted connection (no uid/pwd)

Is there a way to have Excel connect to Sql Server using the current user's network windows authentication (trusted connection/integrated security)? I don't want to rely on a sql login or have a uid/password in my code.

Upvotes: 12

Views: 94293

Answers (4)

Stefan Michev
Stefan Michev

Reputation: 5093

Working sample for VBA Excel 2010

Provider=SQLOLEDB;Data Source=ServerIPOrName;Initial Catalog=DatabaseName;Trusted_connection=yes;

Upvotes: 1

El Ronnoco
El Ronnoco

Reputation: 11922

I have this connectionstring in an Excel 2003 VBA project...

"Provider=SQLOLEDB;Data Source=[You DB Name];Trusted_connection=yes;"

And it works for me! (I'm using ADODB)

Upvotes: 17

Cade Roux
Cade Roux

Reputation: 89651

Driver={SQL Native Client};server=servernamehere;database=dbnamehere;Trusted_Connection=yes;

http://www.sqlstrings.com/SQL-Server-connection-strings.htm

http://www.connectionstrings.com/sql-server

Try this one:

Provider=sqloledb;Data Source=myServerName;Initial Catalog=myDatabaseName;Integrated Security=SSPI

Upvotes: 10

Tomalak
Tomalak

Reputation: 338118

See: http://www.connectionstrings.com/

Especially http://www.connectionstrings.com/sql-server-2005, for example:

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

or any other suitable connection string you find there.

Upvotes: 3

Related Questions