Database Query

[eggtimer]

Hi

This is not entirely an Excel question, but as it is affecting my Excel sheets
I figured if there is a solution you guy's will probably know it.

For a few years now I have been creating views in SQL Server 2000 and importing them into Excel via New Database Query and saving them in a folder that colleagues could access.

I never had automatic login access to the SQL server, I would access via a password, every time I wanted to import a new query i had to enter the password.

As my role has just changed I have been given direct login access to the server meaning I no longer have to enter the password when importing query's into excel. But this means that when I now create a query spreadsheet my colleagues are prompted for the password, which they do not know.

When I look at the data range properties there is a save password tickbox, which is always ticked, but I assume as I no longer have a password to enter, there is no password for Excel to save.

How can I get over this?

Cheers

 

[sunnyland]

Hello,

I am not an expert of SQl but I may have a go at trying to give my opinion on the question.

In Sql, there is 2 way to identify with a password and user name created in SQL or via the windows login, so if you don't have to provide a password anymore it may mean that the administrator is using your windows authentification.

One idea, will be to see if the SQL administrator could create a user kind of Guest with password restricted access to the data in SQL with multiples logons allowed. Then when you create your excel spreadsheet to query the data in SQL, you will use the kind of Guest user.

This is an idea, but you may want to find out if this approach is possible.
I am not sure creating a user in SQL allows multiple logins. But if possible and read only and password protected then data will remain pretty safe.