December 20, 2007 at 3:22 pm
This is probably a stupid noob question and I apologize in advance.
We're in the process of upgrading to SQL2005 from SQL2000. Still have 2000 installed on a separate box, until we get things perfected. I have several Excel spreadsheets that are simply using an ODBC connection to SQL 2000 to select all rows from a table. SQL sprocs update the SQL table and the users can simply open their Excel spreadsheet and Refresh the data.
My problem is this: I've created an ODBC connection to SQL2005 specifying Windows authentication and created a domain\domain users account in SQL2005, but when a user tries to refresh the Excel data, they get a "select permission denied" error. The domain\domain users account has connect and select access.
Any ideas?
Much appreciated!
December 26, 2007 at 3:12 pm
Greich,
Make sure that the Domain user that you just created with the ODBC connection is attached to Microsoft Query that retrieves the data into Excel.
I am assuming you use the MS Query add-on piece to Excel. In your Excel query contains a connection
string.
Adjust the user ID connection here and then do a data refresh.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply