March 25, 2008 at 12:18 pm
Hello-
I was hoping to create several reports using my SQL server and utilizing MSQuery in Excel. I planned on building the query and then having any user be able to read the data. I wish to avoid creating separate user accounts for each user. Is there a way to set up one account that is used by the shared Excel file so that any user may open it and access the information?
Thank you for your help.
April 23, 2008 at 2:45 am
Yes, there is, but it will require sending user credentials (login name and password) to the server. That's why using integrated (Windows NT) security is the preferred option.
Either way, you'd have to create a login (to access the server, i.e. CREATE LOGIN) and bind that to a database user (to access the database; i.e. CREATE USER...FOR LOGIN).
SQL Server security is a very broad subject - consult Books Online for an overview and all the details. You can also come back here with a more specific question later.
ML
---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply