Re: [ADSM-L] SQL Database Agent error
2008-12-18 14:18:54
Del,
We are using mixed authentication. My id has the sysadmin role on the
database. I also tried using integrated security with the sa userid and had
the same result.
Thanks,
Mike
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Del Hoobler
Sent: Thursday, December 18, 2008 11:08 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] SQL Database Agent error
Are you using SQL Server Windows mixed authentication or SQL Server
authentication?
Has your userid been granted "sysadmin" role to the SQL Server?
In the User's Guide, the "security" is documented like this:
-------------------
Security
Data Protection for SQL requires certain settings in order to perform
operations in a secure environment.
Windows administrator authority is required for installation. Data
Protection for SQL must be registered to the Tivoli Storage Manager server
and the appropriate node name and password must be used when connecting to
the Tivoli Storage Manager server. In addition, standard Tivoli Storage
Manager security requirements apply to Data Protection for SQL.
Three options are provided when specifying SQL Server logon information:
Accept the default sa account and blank password.
Use SQL user ID security and specify both the SQL user name and password.
With SQL user ID security, the SQL Server administrator provides the logon
ID and the password that provides access to the SQL Server.
Use a trusted connection and let Windows authenticate the logon.
Note: The SQL logon user or Windows user name must be added to the SQL
Server SYSADMIN fixed server role before it can be used by Data Protection
for SQL.
------------------
Thanks,
Del
----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 12/18/2008
09:44:15 AM:
> [image removed]
>
> SQL Database Agent error
>
> Hizny, Michael
>
> to:
>
> ADSM-L
>
> 12/18/2008 09:47 AM
>
> Sent by:
>
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> Please respond to "ADSM: Dist Stor Manager"
>
> Hi,
>
>
>
> We just installed Data Protection for SQL on a windows 2008 server
> running SQL 2005. We are getting the following error when we try a
> backup. Has anyone seen this before?
>
> Thanks,
>
> Mike
>
>
>
> Backup Failed. ACO5402E . The virtual device set could not be created.
>
>
>
> In the Event logs we get:
>
>
>
> SQLVDI:Loc=CVDS::CreateEx,Desc=Create Memory, Error Code=(5)Access is
denied.
>
>
>
>
>
> We believe that it is a permissions error, but we can’t figure out
> what permission needs to change. We are running the backup from an
> administrative account on the server and the scheduled backups run
> as a system level account.
>
>
>
>
>
|
|
|