We're converting from SQL Server 2000 to 2008. We've set up a new DB server (Windows 2003 Server), we've installed SQL Server 2008. We've installed a few databases. Things seemed to be going well. Then...
I'm trying to move over a database from the old server to the new. I've tried detach/copy/attach and backup/copy/restore. I'm putting the file in the default database location (D:\MSSQL\Data or D:\MSSQL\Backup). But then I find that SQL Server can no longer
access that location! I get a message that says:
"Cannot access the specified path or file on the server. Verify that you have the necessary security priveleges and that the path or file exists".
This as soon as I click on Add on the Specify Backup dialog or on the Attach database dialog.
I've tried: logging in with SQL Server authent. and Windows authent.; checking and changing permission on the folder and file; basically everything I can think of.
View Complete Post