I want to import data from SQL Server to Excel. Because I want to use parameters in the query's, I use a Microsoft Query instead of the standard SQL Server connection.
When making a custom connection the following screen comes up:
My problem is that the connection string this creates contains my name. Is it possible to create a public connection string that everyone can use? Or can that be done with this connection string aswell?
Below the connection string:
DRIVER=SQL Server Native Client 11.0;SERVER=[SERVERNAME];UID=[MY LOGIN];Trusted_Connection=Yes;APP=Microsoft Office 2010;WSID=[PC NAME];DATABASE=[DATABASE NAME];