Actually I MAP the Y: Drive from another Server and I would like to backup on this drive, but MS SQL Server 2005 is not displayed the MAP drive in the drive list. How I can backup on this MAP drive thru MS SQL server
It is OK to backup a database to the local drive (C:) on SQL Server 2005. But when I tried to backup a database to a mapped network drive (Y:) on the server, it failed. Here is the message:
System.Data.SqlClient.SqlError: Cannot open backup device ' networkpath\Y:\db.bak'. Operating system error 5(Access is Denied.). (Microsoft.SqlServer.Smo)
The network drive N: is accessible through Windows Explorer.
> Actually I MAP the Y: Drive from another Server and I would like to backup on this drive, but MS SQL Server 2005 is not displayed the MAP drive in the drive list. How I can backup on this MAP drive thru MS SQL server
Don't use mapped drive letters, they are user dependent. Use UNC names such as
> I used UNC as u suggest,( i.e. server name\sharename ) but till I got same error message, What I can do? How I can backup?
The user running the database (not the user you're logged on with) must be permitted to connect to the remote server. you have to configure the share on the remote system and give permissions.
but Its actaully work in windows explorer and command prompt, I can copy or move files from windows explorer, only not from MS SQL server. If I wrong, Please explain me how I can configure
> but Its actaully work in windows explorer and command prompt, I can copy or move files from windows explorer, only not from MS SQL server. If I wrong, Please explain me how I can configure
As I said, you have to configure it for the user running the database server process, not your logged on user; they are different. check your services who is running the Sql Server and for that user you have to configure permissions on the remote server.
If the SAP is not in "Windows Domain" environment and the backup destination system is non-domain system, you need to assign at least "Write" Permission to the share folder on target system.
For Everyone Group:
Share Permission = Change
NTFS Permission = Write
"It is not recommended to give change/write permission to EVERYONE group for security reason." But just for testing you can do it..
One more thing you need to create exactly same operating system user (with same password) on destination system as SAP system, to get authenticated as source (SAP) system under which the SQL server is running...
I give full permission to everyone of shared folder and my boths servers are login with Administrator with same password, I dont know where is wrong? till I got same message
it doesn't matter with which user you're logged on. The user running the process sqlservr.exe is the one connecting to the remote machine, not the user you're logging on.
So please check your services (start - execute - services.msc), doubleclick on SQL Server and look which user is running that service. This user must have permissions for the remote system.
I'm giving the permission,and check the user log in from services, administrator is the user login and both servers having same user and same password. and shared folder having full permission to every one. but till i'm getting same message.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.