M
Michael MacGregor
I have multiple Excel report spreadsheets that connect to SQL Server 2005.
Up until recently only internal staff were accessing these and so when the
DSN was setup for use by the Excel spreadsheets it was based on Windows
login permissions. However, now we have requirement to provide these report
spreadsheets to external clients who will run the reports themselves,
however that would mean having to add them to the appropriate Windows domain
group which has login permissions, something we don't want to do. What I
would prefer to do is to create a SQL login and update all of the report
spreadsheets to use that instead of Windows logins. My question is can I
simply update the embedded queries to use that login or do I actually have
to create a new DSN and recreate all of the queries?
TIA
Michael MacGregor
Database Architect
Up until recently only internal staff were accessing these and so when the
DSN was setup for use by the Excel spreadsheets it was based on Windows
login permissions. However, now we have requirement to provide these report
spreadsheets to external clients who will run the reports themselves,
however that would mean having to add them to the appropriate Windows domain
group which has login permissions, something we don't want to do. What I
would prefer to do is to create a SQL login and update all of the report
spreadsheets to use that instead of Windows logins. My question is can I
simply update the embedded queries to use that login or do I actually have
to create a new DSN and recreate all of the queries?
TIA
Michael MacGregor
Database Architect