AVOID MESSAGE TO CONNECT TO SERVER TO RUN QUERYS
Hi,
Trought a remote conection with my server (SERVIDOR) I made an excel workbook whit five different querys (made with the get external data tool in excel) and all remote users that connect to my server could use the workbook without problem.
My problem starts when an user on the local network (not remote) try to open the same workbook. (I tried with a shorcut and with the file itself in the local computer)
The excel fail to connect to the database and a Window "SQL SERVER LOGIN" is open with the name of the server and all details for the conection and the box "use trusted connection" is selected...the only way to get the querys working is to uncheck this box and write "sa" in the user field....and this must be made 5 times (one for each query)...
How should I fix this in order that the computers in the local network could connect without have to login each time the workbook is opened ?
See attached picture of the windows I´m talking about.
Thank you for your help.
Roberto.
prompt.jpg
Trought a remote conection with my server (SERVIDOR) I made an excel workbook whit five different querys (made with the get external data tool in excel) and all remote users that connect to my server could use the workbook without problem.
My problem starts when an user on the local network (not remote) try to open the same workbook. (I tried with a shorcut and with the file itself in the local computer)
The excel fail to connect to the database and a Window "SQL SERVER LOGIN" is open with the name of the server and all details for the conection and the box "use trusted connection" is selected...the only way to get the querys working is to uncheck this box and write "sa" in the user field....and this must be made 5 times (one for each query)...
How should I fix this in order that the computers in the local network could connect without have to login each time the workbook is opened ?
See attached picture of the windows I´m talking about.
Thank you for your help.
Roberto.
prompt.jpg
ASKER
Sorry J,
Where or when should I do that ?
If I right click on the query area at the excel spreadsheet the option: external data range properties there is no box for password or save query definition....only keep cell format and save password....
Maybe is due that I used New data base query instead of Import data ?
Any idea on how to change this will be really helpfull.
Thank for your time,
Roberto.
Where or when should I do that ?
If I right click on the query area at the excel spreadsheet the option: external data range properties there is no box for password or save query definition....only keep cell format and save password....
Maybe is due that I used New data base query instead of Import data ?
Any idea on how to change this will be really helpfull.
Thank for your time,
Roberto.
ASKER
help !!!
ASKER
These Querys are making me thirsty...
run the query.. set it up.. manually type in your password and all that. and have it shoot the data back to excel.
Even if it has no data.. you'll still get headers. Then right click near the headers.
Even if it has no data.. you'll still get headers. Then right click near the headers.
ASKER
J,
The problem I think is not that Simple...
It has to be with this:
http://support.microsoft.com/kb/327572
And a problem to change in SQL SERVER that the conection from the local computers to get querys could use a TRUSTED CONNECTION.
Thanks for your time.
Roberto.
The problem I think is not that Simple...
It has to be with this:
http://support.microsoft.com/kb/327572
And a problem to change in SQL SERVER that the conection from the local computers to get querys could use a TRUSTED CONNECTION.
Thanks for your time.
Roberto.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There are two boxes 'save query definition' and 'save password'.. to be honest I don't know if you need both checked or only the password box, but on my queries have I both checked, and it never prompts me.