SQL Backup at a domain network drive from NON doma

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

SQL Backup at a domain network drive from NON doma

Author

Topic

kouliscon
Starting Member

7 Posts

Posted - 2011-06-16 : 03:53:35

Hello

With a NON domain user account (administrator) I log on to Windows 2008 and to MS-SQL 2008, I want to define to backup the db at the SERVER OBJECTS a BACKUP DEVICE which will be the folder at another Windows 2003 server but which is in the domain.

Even if in Windows I map the network drive with letter Z i cannot see it at the BACKUP DEVICES destinations.
If i put the complete path \\192.168.1.10\folder1\ still it doesn't allow me and gives me the error (OPERATING SYSTEM ERROR 5- ACCESS IS DENIED).

Anybody know a solution?

thx in advance

Kostas

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-06-16 : 04:08:49

Open up a cmd-window and use the runas-comamnd to start another cmd-window as the local administrator. Then try to map the drive.

C:\>runas /profile /user:machinename\administrator cmd

- Lumbago
My blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/

kouliscon
Starting Member

7 Posts

Posted - 2011-06-16 : 04:17:00

Hello All

i found the solution by reading the following

http://support.microsoft.com/kb/207187

thx in advance

Kostas

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-06-16 : 04:24:37

Did you seriously need a kb-article to understand why you can't write to a folder you don't have permission to...??

- Lumbago
My blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/

kouliscon
Starting Member

7 Posts

Posted - 2011-06-16 : 04:44:41

Hello

Well nobody could give me the correct answer. This article did and is working :)

thx

Kostas

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-06-16 : 04:48:27

I'm not trying to be a wisea$$ here but the _error message_ gave you the correct answer... my answer was "implicitly" suggesting that maybe you've mapped the drive using the wrong user account.

- Lumbago
My blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources