Hello,
I've configure "HP Omniback" to perform backups on=20
databases servers under the account "omni_acc", when i=20
configured this account i assign this account the "System=20
Administrators" Server Role because i can=B4t did backups if=20
the account wasn=B4t assign to this role.
Now i want to give to the omni_acc account other=20
previleges since we have the "db_backupoperator" database=20
role but... i cant do the backups if the user is only=20
assign to this role. Can anybody explain to me this=20
situation?
Is not supposed that a user assign to=20
the "db_backupoperator" database role perform backups and=20
restores to databases?
How can i give permissions to a user to make backups and=20
restores of databases?
Best regards
For RESTORE you cannot use db_backup operator if the database doesn't exist, as ... the database doesn't
exist! In this case, dbcreator server role should do.
Your problem is very likely that HP wrote their software so it requires this permissions. The place to start
is the documentation for the software. If there is no, ask the vendor of the software (HP).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:1919d01c44c8f$47eb8c30$a501280a@.phx.gbl...
Hello,
I've configure "HP Omniback" to perform backups on
databases servers under the account "omni_acc", when i
configured this account i assign this account the "System
Administrators" Server Role because i cant did backups if
the account wasnt assign to this role.
Now i want to give to the omni_acc account other
previleges since we have the "db_backupoperator" database
role but... i cant do the backups if the user is only
assign to this role. Can anybody explain to me this
situation?
Is not supposed that a user assign to
the "db_backupoperator" database role perform backups and
restores to databases?
How can i give permissions to a user to make backups and
restores of databases?
Best regards
Showing posts with label backups. Show all posts
Showing posts with label backups. Show all posts
Tuesday, March 27, 2012
Error executing Backup
Hello,
I've configure "HP Omniback" to perform backups on=20
databases servers under the account "omni_acc", when i=20
configured this account i assign this account the "System=20
Administrators" Server Role because i can=B4t did backups if=20
the account wasn=B4t assign to this role.
Now i want to give to the omni_acc account other=20
previleges since we have the "db_backupoperator" database=20
role but... i cant do the backups if the user is only=20
assign to this role. Can anybody explain to me this=20
situation?
Is not supposed that a user assign to=20
the "db_backupoperator" database role perform backups and=20
restores to databases?
How can i give permissions to a user to make backups and=20
restores of databases?
Best regardsFor RESTORE you cannot use db_backup operator if the database doesn't exist,
as ... the database doesn't
exist! In this case, dbcreator server role should do.
Your problem is very likely that HP wrote their software so it requires this
permissions. The place to start
is the documentation for the software. If there is no, ask the vendor of the
software (HP).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:1919d01c
44c8f$47eb8c30$a501280a@.phx.gbl...
Hello,
I've configure "HP Omniback" to perform backups on
databases servers under the account "omni_acc", when i
configured this account i assign this account the "System
Administrators" Server Role because i cant did backups if
the account wasnt assign to this role.
Now i want to give to the omni_acc account other
previleges since we have the "db_backupoperator" database
role but... i cant do the backups if the user is only
assign to this role. Can anybody explain to me this
situation?
Is not supposed that a user assign to
the "db_backupoperator" database role perform backups and
restores to databases?
How can i give permissions to a user to make backups and
restores of databases?
Best regards
I've configure "HP Omniback" to perform backups on=20
databases servers under the account "omni_acc", when i=20
configured this account i assign this account the "System=20
Administrators" Server Role because i can=B4t did backups if=20
the account wasn=B4t assign to this role.
Now i want to give to the omni_acc account other=20
previleges since we have the "db_backupoperator" database=20
role but... i cant do the backups if the user is only=20
assign to this role. Can anybody explain to me this=20
situation?
Is not supposed that a user assign to=20
the "db_backupoperator" database role perform backups and=20
restores to databases?
How can i give permissions to a user to make backups and=20
restores of databases?
Best regardsFor RESTORE you cannot use db_backup operator if the database doesn't exist,
as ... the database doesn't
exist! In this case, dbcreator server role should do.
Your problem is very likely that HP wrote their software so it requires this
permissions. The place to start
is the documentation for the software. If there is no, ask the vendor of the
software (HP).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:1919d01c
44c8f$47eb8c30$a501280a@.phx.gbl...
Hello,
I've configure "HP Omniback" to perform backups on
databases servers under the account "omni_acc", when i
configured this account i assign this account the "System
Administrators" Server Role because i cant did backups if
the account wasnt assign to this role.
Now i want to give to the omni_acc account other
previleges since we have the "db_backupoperator" database
role but... i cant do the backups if the user is only
assign to this role. Can anybody explain to me this
situation?
Is not supposed that a user assign to
the "db_backupoperator" database role perform backups and
restores to databases?
How can i give permissions to a user to make backups and
restores of databases?
Best regards
Error executing Backup
Hello,
I've configure "HP Omniback" to perform backups on databases servers under the account "omni_acc", when i configured this account i assign this account the "System Administrators" Server Role because i can=B4t did backups if the account wasn=B4t assign to this role.
Now i want to give to the omni_acc account other previleges since we have the "db_backupoperator" database role but... i cant do the backups if the user is only assign to this role. Can anybody explain to me this situation?
Is not supposed that a user assign to the "db_backupoperator" database role perform backups and restores to databases?
How can i give permissions to a user to make backups and restores of databases?
Best regardsFor RESTORE you cannot use db_backup operator if the database doesn't exist, as ... the database doesn't
exist! In this case, dbcreator server role should do.
Your problem is very likely that HP wrote their software so it requires this permissions. The place to start
is the documentation for the software. If there is no, ask the vendor of the software (HP).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:1919d01c44c8f$47eb8c30$a501280a@.phx.gbl...
Hello,
I've configure "HP Omniback" to perform backups on
databases servers under the account "omni_acc", when i
configured this account i assign this account the "System
Administrators" Server Role because i can´t did backups if
the account wasn´t assign to this role.
Now i want to give to the omni_acc account other
previleges since we have the "db_backupoperator" database
role but... i cant do the backups if the user is only
assign to this role. Can anybody explain to me this
situation?
Is not supposed that a user assign to
the "db_backupoperator" database role perform backups and
restores to databases?
How can i give permissions to a user to make backups and
restores of databases?
Best regards
I've configure "HP Omniback" to perform backups on databases servers under the account "omni_acc", when i configured this account i assign this account the "System Administrators" Server Role because i can=B4t did backups if the account wasn=B4t assign to this role.
Now i want to give to the omni_acc account other previleges since we have the "db_backupoperator" database role but... i cant do the backups if the user is only assign to this role. Can anybody explain to me this situation?
Is not supposed that a user assign to the "db_backupoperator" database role perform backups and restores to databases?
How can i give permissions to a user to make backups and restores of databases?
Best regardsFor RESTORE you cannot use db_backup operator if the database doesn't exist, as ... the database doesn't
exist! In this case, dbcreator server role should do.
Your problem is very likely that HP wrote their software so it requires this permissions. The place to start
is the documentation for the software. If there is no, ask the vendor of the software (HP).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:1919d01c44c8f$47eb8c30$a501280a@.phx.gbl...
Hello,
I've configure "HP Omniback" to perform backups on
databases servers under the account "omni_acc", when i
configured this account i assign this account the "System
Administrators" Server Role because i can´t did backups if
the account wasn´t assign to this role.
Now i want to give to the omni_acc account other
previleges since we have the "db_backupoperator" database
role but... i cant do the backups if the user is only
assign to this role. Can anybody explain to me this
situation?
Is not supposed that a user assign to
the "db_backupoperator" database role perform backups and
restores to databases?
How can i give permissions to a user to make backups and
restores of databases?
Best regards
Friday, March 9, 2012
Error ConnectionRead (WrapperRead())
Hi
When I ran the ran the backups of my databases I ahve the next error
ConnectionRead (WrapperRead()). [SQLSTATE 01000]
Msg 11, Sev 16: General network error. Check your network documentation.
[SQLSTATE 08S01]
I’m running windows2000 Server Standard Edition, SQL2000 Server Standard
Edition and MDAC2.6 version.
I found the article 827452 but this article
APPLIES TO
? Microsoft Data Access Components 2.8
? Microsoft SQL Server 2000 Standard Edition, when used with:
Microsoft Windows Server 2003, Standard Edition
Microsoft Windows 2000 Enterprise Edition
I want to know if this article applies for my case
I run the sproc for backup the databases
Thanks very much
See http://support.microsoft.com/default...b;en-us;827452
Adrian
"Valero" <Valero@.discussions.microsoft.com> wrote in message
news:DEE2A24E-F805-4E56-BDD6-265C6A217912@.microsoft.com...
> Hi
> When I ran the ran the backups of my databases I ahve the next error
> ConnectionRead (WrapperRead()). [SQLSTATE 01000]
> Msg 11, Sev 16: General network error. Check your network documentation.
> [SQLSTATE 08S01]
>
> I'm running windows2000 Server Standard Edition, SQL2000 Server Standard
> Edition and MDAC2.6 version.
> I found the article 827452 but this article
> APPLIES TO
> . Microsoft Data Access Components 2.8
> . Microsoft SQL Server 2000 Standard Edition, when used with:
> Microsoft Windows Server 2003, Standard Edition
> Microsoft Windows 2000 Enterprise Edition
> I want to know if this article applies for my case
> I run the sproc for backup the databases
> Thanks very much
>
When I ran the ran the backups of my databases I ahve the next error
ConnectionRead (WrapperRead()). [SQLSTATE 01000]
Msg 11, Sev 16: General network error. Check your network documentation.
[SQLSTATE 08S01]
I’m running windows2000 Server Standard Edition, SQL2000 Server Standard
Edition and MDAC2.6 version.
I found the article 827452 but this article
APPLIES TO
? Microsoft Data Access Components 2.8
? Microsoft SQL Server 2000 Standard Edition, when used with:
Microsoft Windows Server 2003, Standard Edition
Microsoft Windows 2000 Enterprise Edition
I want to know if this article applies for my case
I run the sproc for backup the databases
Thanks very much
See http://support.microsoft.com/default...b;en-us;827452
Adrian
"Valero" <Valero@.discussions.microsoft.com> wrote in message
news:DEE2A24E-F805-4E56-BDD6-265C6A217912@.microsoft.com...
> Hi
> When I ran the ran the backups of my databases I ahve the next error
> ConnectionRead (WrapperRead()). [SQLSTATE 01000]
> Msg 11, Sev 16: General network error. Check your network documentation.
> [SQLSTATE 08S01]
>
> I'm running windows2000 Server Standard Edition, SQL2000 Server Standard
> Edition and MDAC2.6 version.
> I found the article 827452 but this article
> APPLIES TO
> . Microsoft Data Access Components 2.8
> . Microsoft SQL Server 2000 Standard Edition, when used with:
> Microsoft Windows Server 2003, Standard Edition
> Microsoft Windows 2000 Enterprise Edition
> I want to know if this article applies for my case
> I run the sproc for backup the databases
> Thanks very much
>
Error ConnectionRead (WrapperRead())
Hi
When I ran the ran the backups of my databases I ahve the next error
ConnectionRead (WrapperRead()). [SQLSTATE 01000]
Msg 11, Sev 16: General network error. Check your network documentation.
[SQLSTATE 08S01]
Iâ'm running windows2000 Server Standard Edition, SQL2000 Server Standard
Edition and MDAC2.6 version.
I found the article 827452 but this article
APPLIES TO
â?¢ Microsoft Data Access Components 2.8
â?¢ Microsoft SQL Server 2000 Standard Edition, when used with:
Microsoft Windows Server 2003, Standard Edition
Microsoft Windows 2000 Enterprise Edition
I want to know if this article applies for my case
I run the sproc for backup the databases
Thanks very muchSee http://support.microsoft.com/default.aspx?scid=kb;en-us;827452
Adrian
"Valero" <Valero@.discussions.microsoft.com> wrote in message
news:DEE2A24E-F805-4E56-BDD6-265C6A217912@.microsoft.com...
> Hi
> When I ran the ran the backups of my databases I ahve the next error
> ConnectionRead (WrapperRead()). [SQLSTATE 01000]
> Msg 11, Sev 16: General network error. Check your network documentation.
> [SQLSTATE 08S01]
>
> I'm running windows2000 Server Standard Edition, SQL2000 Server Standard
> Edition and MDAC2.6 version.
> I found the article 827452 but this article
> APPLIES TO
> . Microsoft Data Access Components 2.8
> . Microsoft SQL Server 2000 Standard Edition, when used with:
> Microsoft Windows Server 2003, Standard Edition
> Microsoft Windows 2000 Enterprise Edition
> I want to know if this article applies for my case
> I run the sproc for backup the databases
> Thanks very much
>
When I ran the ran the backups of my databases I ahve the next error
ConnectionRead (WrapperRead()). [SQLSTATE 01000]
Msg 11, Sev 16: General network error. Check your network documentation.
[SQLSTATE 08S01]
Iâ'm running windows2000 Server Standard Edition, SQL2000 Server Standard
Edition and MDAC2.6 version.
I found the article 827452 but this article
APPLIES TO
â?¢ Microsoft Data Access Components 2.8
â?¢ Microsoft SQL Server 2000 Standard Edition, when used with:
Microsoft Windows Server 2003, Standard Edition
Microsoft Windows 2000 Enterprise Edition
I want to know if this article applies for my case
I run the sproc for backup the databases
Thanks very muchSee http://support.microsoft.com/default.aspx?scid=kb;en-us;827452
Adrian
"Valero" <Valero@.discussions.microsoft.com> wrote in message
news:DEE2A24E-F805-4E56-BDD6-265C6A217912@.microsoft.com...
> Hi
> When I ran the ran the backups of my databases I ahve the next error
> ConnectionRead (WrapperRead()). [SQLSTATE 01000]
> Msg 11, Sev 16: General network error. Check your network documentation.
> [SQLSTATE 08S01]
>
> I'm running windows2000 Server Standard Edition, SQL2000 Server Standard
> Edition and MDAC2.6 version.
> I found the article 827452 but this article
> APPLIES TO
> . Microsoft Data Access Components 2.8
> . Microsoft SQL Server 2000 Standard Edition, when used with:
> Microsoft Windows Server 2003, Standard Edition
> Microsoft Windows 2000 Enterprise Edition
> I want to know if this article applies for my case
> I run the sproc for backup the databases
> Thanks very much
>
Error ConnectionRead (WrapperRead())
Hi
When I ran the ran the backups of my databases I ahve the next error
ConnectionRead (WrapperRead()). [SQLSTATE 01000]
Msg 11, Sev 16: General network error. Check your network documentation.
[SQLSTATE 08S01]
I’m running windows2000 Server Standard Edition, SQL2000 Server Standard
Edition and MDAC2.6 version.
I found the article 827452 but this article
APPLIES TO
? Microsoft Data Access Components 2.8
? Microsoft SQL Server 2000 Standard Edition, when used with:
Microsoft Windows Server 2003, Standard Edition
Microsoft Windows 2000 Enterprise Edition
I want to know if this article applies for my case
I run the sproc for backup the databases
Thanks very muchSee http://support.microsoft.com/defaul...kb;en-us;827452
Adrian
"Valero" <Valero@.discussions.microsoft.com> wrote in message
news:DEE2A24E-F805-4E56-BDD6-265C6A217912@.microsoft.com...
> Hi
> When I ran the ran the backups of my databases I ahve the next error
> ConnectionRead (WrapperRead()). [SQLSTATE 01000]
> Msg 11, Sev 16: General network error. Check your network documentation.
> [SQLSTATE 08S01]
>
> I'm running windows2000 Server Standard Edition, SQL2000 Server Standard
> Edition and MDAC2.6 version.
> I found the article 827452 but this article
> APPLIES TO
> . Microsoft Data Access Components 2.8
> . Microsoft SQL Server 2000 Standard Edition, when used with:
> Microsoft Windows Server 2003, Standard Edition
> Microsoft Windows 2000 Enterprise Edition
> I want to know if this article applies for my case
> I run the sproc for backup the databases
> Thanks very much
>
When I ran the ran the backups of my databases I ahve the next error
ConnectionRead (WrapperRead()). [SQLSTATE 01000]
Msg 11, Sev 16: General network error. Check your network documentation.
[SQLSTATE 08S01]
I’m running windows2000 Server Standard Edition, SQL2000 Server Standard
Edition and MDAC2.6 version.
I found the article 827452 but this article
APPLIES TO
? Microsoft Data Access Components 2.8
? Microsoft SQL Server 2000 Standard Edition, when used with:
Microsoft Windows Server 2003, Standard Edition
Microsoft Windows 2000 Enterprise Edition
I want to know if this article applies for my case
I run the sproc for backup the databases
Thanks very muchSee http://support.microsoft.com/defaul...kb;en-us;827452
Adrian
"Valero" <Valero@.discussions.microsoft.com> wrote in message
news:DEE2A24E-F805-4E56-BDD6-265C6A217912@.microsoft.com...
> Hi
> When I ran the ran the backups of my databases I ahve the next error
> ConnectionRead (WrapperRead()). [SQLSTATE 01000]
> Msg 11, Sev 16: General network error. Check your network documentation.
> [SQLSTATE 08S01]
>
> I'm running windows2000 Server Standard Edition, SQL2000 Server Standard
> Edition and MDAC2.6 version.
> I found the article 827452 but this article
> APPLIES TO
> . Microsoft Data Access Components 2.8
> . Microsoft SQL Server 2000 Standard Edition, when used with:
> Microsoft Windows Server 2003, Standard Edition
> Microsoft Windows 2000 Enterprise Edition
> I want to know if this article applies for my case
> I run the sproc for backup the databases
> Thanks very much
>
Subscribe to:
Posts (Atom)