Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Here is the situation: I have two servers, for simplicities sake we'll call them database-server and website-server. The database-server is to hold an Access database that we're using during development of a web application. The website server has it's own domain and is isolated from the database-server for security reasons, save for a VPN connection to the shared folder that the database is held in. I have confirmed that I can create, edit and delete files within that folder from the website-server. (The website, it's it's relevant is ASP.Net front end with VB.Net back end.)

When the database is put into the |DataDirectory| on the website server it works exactly as supposed to. However, if I modify my connection string to point at the database across the VPN, it doesn't work, saying there is either open exclusively or there is insufficient read/write permissions. It is definitely not opened exclusively.

Here is the connection string: "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=\database-server\database\db.accdb;"

Things I've tried:

Tried mapping the drive. This causes a different error; that the path is invalid. Tried giving EVERYONE full rights to the database share. Tried creating a UDL file that points at the database. Something about a multi-step oledb operation generating errors. Tried using the IP address of the database-server. The VPN allows for other users to connect via it.

All resources I've read (and since I've been trying to resolve this problem for days now, it's been a lot) indicate it should work.

share|improve this question
    
Solved this problem. I set up ASP.Net impersonation to a username and password that the database server recognised. –  Tom Apr 18 '13 at 3:44
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.