![]() ![]() Likewise, it will from a non-domain machine using Windows Authentication if I use "runas" to launch Excel with domain credentials, as follows: runas /netonly /user:domain\user %path-to-excel%\excel.exe But we are trying to move away from that. It will work from a non-domain / un-trusted workstation, if I use SQL Authentication. It doesn't even ask for credentials it just works flawlessly when I hit Refresh. This works perfectly fine from a domain-joined / trusted machine. SERVER=10.x.y.z UID=domain_user Trusted_Connection=Yes ĪPP=Microsoft Office 2010 DATABASE=DatabaseNameĪnd the Authentication Settings are set to "Windows Authentication" Here is a sample of the connection string (with revealing info obfuscated): Description=DataConnection DRIVER=SQLServer The database server is joined to our domain, and Windows Authentication is enabled. We have an Excel spreadsheet that uses a Data Connection to a SQL Server database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |