Last post Mar 21, 2008 10:26 AM by Nai-Dong Jin - MSFT
Mar 18, 2008 11:31 PM|abdulbq|LINK
Mar 20, 2008 05:06 AM|Nai-Dong Jin - MSFT|LINK
Based on my understanding, this issue can occur because the login used to connect to the SQL Server does not have enough permission. Please add the following statement to your SP defination (below EXEC sp_addlinkedserver):
EXEC sp_addlinkedsrvlogin 'ExcelSource', 'false',NULL,'ADMIN',NULL
Then drop the existing SP and create a new SP to test the problem.
Mar 20, 2008 10:30 PM|abdulbq|LINK
Thanks, but in the "excel source", what should i type in ??? 'Microsoft.Jet.OLEDB.4.0'
or 'Excel 8.0'
Mar 21, 2008 10:26 AM|Nai-Dong Jin - MSFT|LINK
Here "ExcelSource" means the database name you want to add permissions to.
EXEC sp_addlinkedsrvlogin 'Northwind', 'false',NULL,'ADMIN',NULL