Hey all.
Ive got Server 1 running IIS
Server 2 is my database server, running SQL + access databases
i just wrote a webservice to handle data to and from an access database, however i am getting some security issues saying the following
<?xml version="1.0" encoding="utf-8" ?>
<anyType xmlns:q1="http://www.w3.org/2001/XMLSchema" d1p1:type="q1:string" xmlns:d1p1="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://tempuri.org/WSMarketingSubscriber/Service1">System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file '\\dbserver\Databases\Db1.mdb'. It is already opened exclusively by another user, or you need permission to view its data. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at WSMarketingSubscriber.WSMarketingDI.Unsubscribe() in E:\Inetpub\wwwroot\WSMarketingSubscriber\WSMarketingDI.vb:line 46</anyType>
Can any one tell me what user account i need for the access database, in order for my webservice to work.....
Many ThanksOK ive done some checking and move the access db to local machine tested and it worked fine, so its got something to do with security account, i blocked the asp.net system account from the local access db and it gave same error, so when unblocked it worked fine, question is now how do i get the asp.net account to work on server 2
0 comments:
Post a Comment