Home

Saving data connection password

%3CLINGO-SUB%20id%3D%22lingo-sub-750766%22%20slang%3D%22en-US%22%3ESaving%20data%20connection%20password%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750766%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20goal%20is%20to%20create%20an%20Excel%20spreadsheet%20that%20connects%20to%20an%20SQL%20Server%20database%20using%20database%20credentials.%26nbsp%3B%20We%20have%20created%20a%20generic%20read%20only%20database%20login%20with%20access%20to%20the%20data%20so%20that%20we%20don't%20have%20to%20provide%20user%20specific%20access%20to%20the%20db.%26nbsp%3B%20However%2C%20I%20can%20create%20the%20spreadsheet%2C%20connect%20to%20the%20SQL%20Server%20database%2C%20retrieve%20and%20refresh%20the%20information%20fine%20but%20when%20I%20give%20the%20spreadsheet%20to%20a%20colleague%2C%20they%20can't%20refresh%20the%20data%20because%20the%20database%20username%20and%20password%20has%20disappeared.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20read%20some%20posts%20online%20where%20they%20indicate%20that%20there%20is%20a%20%22save%20login%2Fpassword%22%20somewhere%20when%20you%20create%20the%20connection%2C%20but%20I'm%20guessing%20these%20are%20for%20older%20versions%20of%20Excel%20as%20the%20walk-throughs%20they%20provide%20don't%20match%20up%20with%20what%20I'm%20seeing%20in%20the%20Office%20365%20for%20Business%20version%20of%20Excel%20I'm%20using.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-750766%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-751086%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20data%20connection%20password%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-751086%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F355849%22%20target%3D%22_blank%22%3E%40Shawn_Wesley%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20depends%20on%20how%20do%20you%20connect.%20If%20with%20Power%20Query%20it%20shall%20keep%20the%20credentials%20for%20Basic%20authentication%2C%20for%20Windows%2FOrganizational%20one%20it%20will%20use%20current%20user's%20account.%20With%20it%20asks%20to%20sign-in%20user%20first%20time%20and%20after%20that%20shall%20keep%20the%20credentials%20for%20that%20user%20and%20same%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Shawn_Wesley
Occasional Visitor

My goal is to create an Excel spreadsheet that connects to an SQL Server database using database credentials.  We have created a generic read only database login with access to the data so that we don't have to provide user specific access to the db.  However, I can create the spreadsheet, connect to the SQL Server database, retrieve and refresh the information fine but when I give the spreadsheet to a colleague, they can't refresh the data because the database username and password has disappeared.

 

I've read some posts online where they indicate that there is a "save login/password" somewhere when you create the connection, but I'm guessing these are for older versions of Excel as the walk-throughs they provide don't match up with what I'm seeing in the Office 365 for Business version of Excel I'm using.

 

Any suggestions?

1 Reply

@Shawn_Wesley 

 

It depends on how do you connect. If with Power Query it shall keep the credentials for Basic authentication, for Windows/Organizational one it will use current user's account. With it asks to sign-in user first time and after that shall keep the credentials for that user and same file.

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies