views:

1188

answers:

2

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.

+1  A: 
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
Cade Roux
Tried that already. Doesn't work from VBA.
notnot
What Data Access component are you using?
Cade Roux
ADODB.Connection
notnot
+1  A: 

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.

Tomalak
Doesn't work for VBA
notnot