I got the folllowin error while trying to attach database. The directory is there...
TITLE: Locate Database Files - H001335\SQLEXPRESS
C:\Documents and Settings\Administrator.H001335\My Documents\Visual Studio 2005\WebSites\Import\App_Data
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.
If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.
BUTTONS:
OK
Moving thread to a more appropriate forum.|||where is it?|||please help, no idea why I can't attach this database|||Make sure you do not have VS open (as server manager creates a connection to sql server), and try stopping and restarting the sqlserver agen service. Then try to attach the database. Is the nme the same as the db name? You may need to copy over the log file aswell (daname_log.ldf).|||Are you using "User Instance=True" in your connection string?
If so, you need to make sure that the user who is running the task has appropriate permissions to access files in that directory (by the looks ASPNET might be the user).
If you're not, then I try running the the sql server service as "Local System" instead of the default "Network Service", or give "Network Service" appropriate permissions for that location.
|||Yes you are right, seems this was related to the user ASP.NEt not having enough rights in the directory...
No comments:
Post a Comment