Embedding the Password into the Microsoft Query Data Source
Is it possible to embed the password into the Microsoft Query Data Source that you create? Specifically, in Excel 2007, I'm going to the Data menu and choosing "From Other Sources" and then "From Microsoft Query".
Afterward, in the "Choose Data Source" window, I choose the SQL data source that I previously created and click the "OK" button.
The "SQL Server Login" window appears and asks me for my Login ID and Password. Is there not a way to embed this information in this window so that you do not have to keep entering these credentials?
Solutions to the Problem Embedding the Password into the Microsoft Query Data Source
Download SmartPCFixer to Fix It (Free)
If you don't want to type your logon name and password when you use the data source, try selecting the ‘Save my user ID and password in the data source definition’ check box.
The saved password is not encrypted.
If the check box
is unavailable, see your database administrator to determine whether this option can be made available.
Refer the following link for more information on this
Cleaning your computer, components, and peripherals help keep everything in good working condition and helps prevent germs from spreading. You can't image how dirty the inside of your computer case can get. All the dust and dirt is going to prevent proper air flow and may even prevent the fan from working.
Another Safe way to Repair the Problem: Embedding the Password into the Microsoft Query Data Source:
How to Fix Embedding the Password into the Microsoft Query Data Source with SmartPCFixer?
1. You can Download SmartPCFixer here. Install it on your system. When you open SmartPCFixer, it will perform a scan.
2. After the scan is finished, you can see the errors and problems which need to be repaired.
3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed
Related: Download SONY SVE1512H1RB Synaptics PS/2 Port ClickPad driver
,Method to Download SONY VGC-LT10E SigmaTel Audio Driver Update v.6.10.5614.0
,Way to Download SONY VGN-CS118E/R AV Mode Button Utility v.1.1.01.09140 driver
,Method to Download SONY VGN-FW375J/B Alps Pointing Device Driver v.220.127.116.11
,Where to Download SONY VGN-NS270J/S Pioneer BD-ROM BDC-TD01 Firmware Update v.1.03
,Data Export From Quickbooks To Excel
,Date Format In Formula Bar And In The Cell Is Not The Same
,Deleted The Snipping Tool
,Desktop - Open Program Issues
,Desktop Windows Manager Keeps Poping Up & It Reads That There Is A Problem & That Windows Will Check It Out & Send Me An Answer .
Read More: Troubleshoot:EPG updates 3/21/2014 Error
,Error "unable to cast the object of type of the 'system boolean to type system string" at startup
,Troubleshooter of Error: Error 1325 while installing Flight Simulator X demo
,Envelope printing problem in Word 2010
,Ending a Process Tech Support
,does anyone know what the dialog means "System.Media.FontFamily' threw an exception windows is checking for a solution?
,Does Log Me In Ignition for my Android with Windows 7 Home Premium?
,Download failure for my Blackberry and the process stops during the install
,Display settings keep changing when I come back from sleep mode
,Downloaded files are not saved