I have a web server and database server which are not on a domain. The
web server has an app that is running on under the IUSR account and
there is a corresponding IUSR account on the database server. The web
app connects to the SQL server with the windows authentication and
everything works fine.
I also have a stored proc which does a file search using a linked
server to an index server on the very same web server. For now assume
that cannot change, the files must be on the web server (TRA is the
machine name). When attempting to execute the following query from the
database server, doing a RunAs on the SQL 2005 Management studio as the
IUSR account from the database server, everything works fine:
SELECT
Q.*
FROM
OPENQUERY(FTInd exPM, 'SELECT path, characterizatio n, rank, hitcount
FROM TRA.CatalogTest ..SCOPE(''DEEP TRAVERSAL OF "C:\Program
Files\dir1\File s\Project757\Do cMgmt"'') WHERE CONTAINS(''"tes t"'') > 0
OR FileName LIKE ''%test%'' ORDER BY rank DESC') AS Q
The IUSR_TRA account is an administrator on both the database and web
server for debugging reasons until we figure this out, but clearly it
shouldn't be a rights issue if both users are administrators on both
machines.
Now for the tricky, part. When the same query as above is executed from
the web server, it fails with the the below error:
OLE DB provider "MSIDXS" for linked server "FTIndexPM" returned message
"Invalid catalog name 'CatalogTest'. SQLSTATE=42000 ".
Using SQL Profiler, I have verified that both queries are actually
running under the IUSR_TRA account. Any ideas why the exact same query
running under the exact same NT login would behave differently when
executed from a web app as opposed to through a clinet request from a
web app?
web server has an app that is running on under the IUSR account and
there is a corresponding IUSR account on the database server. The web
app connects to the SQL server with the windows authentication and
everything works fine.
I also have a stored proc which does a file search using a linked
server to an index server on the very same web server. For now assume
that cannot change, the files must be on the web server (TRA is the
machine name). When attempting to execute the following query from the
database server, doing a RunAs on the SQL 2005 Management studio as the
IUSR account from the database server, everything works fine:
SELECT
Q.*
FROM
OPENQUERY(FTInd exPM, 'SELECT path, characterizatio n, rank, hitcount
FROM TRA.CatalogTest ..SCOPE(''DEEP TRAVERSAL OF "C:\Program
Files\dir1\File s\Project757\Do cMgmt"'') WHERE CONTAINS(''"tes t"'') > 0
OR FileName LIKE ''%test%'' ORDER BY rank DESC') AS Q
The IUSR_TRA account is an administrator on both the database and web
server for debugging reasons until we figure this out, but clearly it
shouldn't be a rights issue if both users are administrators on both
machines.
Now for the tricky, part. When the same query as above is executed from
the web server, it fails with the the below error:
OLE DB provider "MSIDXS" for linked server "FTIndexPM" returned message
"Invalid catalog name 'CatalogTest'. SQLSTATE=42000 ".
Using SQL Profiler, I have verified that both queries are actually
running under the IUSR_TRA account. Any ideas why the exact same query
running under the exact same NT login would behave differently when
executed from a web app as opposed to through a clinet request from a
web app?
Comment