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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies