Deploying SQL Server Express to host databases off a mapped drive

Tags:
Mapped drives
SQL Server databases
SQL Server Express
Windows Server 2003
I am trying to deploy SQL Server Express to be able to host a database off a mapped drive. In an open lab environment, I can get it to open and run a database off a mapped shared drive on a Windows 2003 server. However, when I take it to a client and their area is considerably less open, I can’t get it running. They have tried to create an account that gives me local administrator rights on the desktop, along with on the server, and access to the shared drive, but it still does not work. Any ideas?

Answer Wiki

Thanks. We'll let you know when a new response is added.

SQL Server (including Express) doesn’t like using shared drives for a number of reasons. Copy the files to the local disk then attach them to the database.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Apickel
    i know this sounds whacked but go to internet explorer, click on options, click on security tab, click on trusted sites, click on sites and the add the complete path including backslashes for the server/directory where the database files are stored
    350 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following