MS access database is not accessible

[Rambutharaju]

Hi All,

Facing an issue with MS access Database, here are the details

I have the MS access database is in database.test.domain server.




And webserver is in webserver.prod.domain server.


I have established trust relationship between the both domains.


I have given share folder and file permissions database server to my user.


Now we are hosting through IIS,
Using the webserver.prod.domain


In web.config file of my IIS server, I have set dblocation as share path \\databaseserver\sharefolder (where my MS access DB exists)

<add key="InstallDir" value="\\database.test.domain\sharefolder" />
<add key="DatabaseLocation" value="\\database.test.domain\sharefolder" />


but its showing the error . Please refer to first screenshot.



Also tried,
Copied database file to webserver.prod.domain server and placed it in folder and shared the path, gave the same file and folder permissions.
and changed web.config configuration as below

<add key="InstallDir" value="\\webserver.test.domain\sharefolder" />
<add key="DatabaseLocation" value="\\webserver.test.domain\sharefolder" />

now the output is success and tried giving path as "C:\sharefolder" and also tried placing the database file other server which are in prod.domain. in all these casesoutput is success below is the output screenshot.Please refer to second screenshot.


But only issues is while accessing file from test.domain. I have checked the file share from webserver, \\database\sharefolder and I am able to access it.
I have also check is there any port restrictions stopping this access, but came to know that access doesn't use any port.
and since its file share, I have checked SMB ports(135,445) is these ports accessible from both ends.

I'm out of ideas. please help.


Regards,
Ram