Hi,
Problem description:
For taking transactional log backup of sql sever2005, I need to put database
into "RECOVERY FULL" mode. To do that I am using the following query in
master database as:
---
ALTER DATABASE <Your database name>
SET RECOVERY FULL
----
but I am getting the following error:
----
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database 'ipr_qxcr239146' or the
database does not exist.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
----
I am using windows authentication while connecting to SQL server and
database name is also correct in query. But not able to find where is the
problem
Please help me out.
Regards,
RajeshIt looks like a permission issue. Are you a member of sysadmin, dbcreator
or db_owner?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Rajesh" <Rajesh@.discussions.microsoft.com> wrote in message
news:4EC91AF7-A227-4A52-86F1-C4F0529A8AAD@.microsoft.com...
Hi,
Problem description:
For taking transactional log backup of sql sever2005, I need to put database
into "RECOVERY FULL" mode. To do that I am using the following query in
master database as:
---
ALTER DATABASE <Your database name>
SET RECOVERY FULL
----
but I am getting the following error:
----
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database 'ipr_qxcr239146' or the
database does not exist.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
----
I am using windows authentication while connecting to SQL server and
database name is also correct in query. But not able to find where is the
problem
Please help me out.
Regards,
Rajesh
Showing posts with label description. Show all posts
Showing posts with label description. Show all posts
Wednesday, March 21, 2012
Friday, February 17, 2012
Error source KDC
I'm getting errors in the W2000 SystemLog containing a error with source
KDC. The description of the alert is:
There are multiple accounts with name MSSQLSvc/TEST-SERVER.didoc.local:1433
of type 10
And guess what? This user doesn't even exist.
The questions are:
what is KDC? and what does this alert mean?
Thanks,
Ruud.Originally posted by Ruud
> I'm getting errors in the W2000 SystemLog containing a error
> with source
> KDC. The description of the alert is:
> There are multiple accounts with name
> MSSQLSvc/TEST-SERVER.didoc.local:1433
> of type 10
> And guess what? This user doesn't even exist.
> The questions are:
> what is KDC? and what does this alert mean?
> Thanks,
> Ruud.
KDC = Key Distirbution Centre ?
--
Posted via http://dbforums.com|||From: Charles Allard -
Date: 03-14-02 02:03
Subject:
----
--
>>
| I am getting the following entry in my system log every 30 minutes.
|
| The description is as follows Event Type: Error Event Source: KDC
| Event Category:
| None Event ID: 11 Date: 1/3/2002 Time: 11:55:18 AM User: N/A
| Computer: SERVER NAME
| Description: There are multiple accounts with name
| MSSQLSvc/SERVERNAME.DOMAINNAME.com:1232 of type 10.
|
| In the System log I get this
|
| Event Type: Failure Audit Event Source: Security Event Category:
| Account Logon
| Event ID: 677 Date: 1/3/2002 Time: 12:44:02 PM User: NT
| AUTHORITY\SYSTEM Computer:
| servername Description: Service Ticket Request Failed: User Name:
| ebjsql User
| Domain: EBIZJETS.COM Service Name:
| MSSQLSvc/servername.domainname.com:1232 Ticket
| Options: 0x40810010 Failure Code: 0x7 Client Address: 127.0.0.1
|
| Any ideas on how to solve this would be greatly appreciated.
<<<<<<<<<<< Multiply Accounts with the Domain have been configured as a
SQL Service
account for the Servername server. This causes both service accounts to
have the same
SPN registered.
If the accounts are known then use ADSI (Active Directory Serivces) edit
and remove
then SPN on the account that is no longer used to start the service on
servername. An
approach you can take would be to run LDP.exe (a utility available from
the Windows
2000 resource kit). This utility is documented within the following
articles. I am
also posting possible steps you can take to resolve this using LDP:
Q224543 Using Ldp.exe to Find Data in the Active Directory
http://support.microsoft.com/defaul...b;EN-US;Q224543
Q260745 XADM: Using LDP to Modify Active Directory Object Attributes
http://support.microsoft.com/defaul...b;EN-US;Q260745
Use LDP.EXE to determine the location of the duplicate name:
1. Click Start & select Run.
2. Type LDP and click OK.
3. Click Connection and select Connect.
4. Leaving the Server field blank, click OK.
5. Click Connection and select Bind.
6. Leaving all fields blank, click OK.
7. Click View and select Tree.
8. Set the Base DN as DC=Home, DC=com
9. Click Browse and select Search.
10. Set the Base DN as DC=Home, DC=com.
11. Set the filter as the following:
(serviceprincipalname=HOST/BOT-PC0295.home.com )
12. Set Scope to Subtree.
13. Click Run.
In either case, this indicates that you have a duplicate machine name
registered
within the Active Directory on your domain.
HTH...
Sincerely,
Charles Allard Microsoft SQL Support
--
Posted via http://dbforums.com
KDC. The description of the alert is:
There are multiple accounts with name MSSQLSvc/TEST-SERVER.didoc.local:1433
of type 10
And guess what? This user doesn't even exist.
The questions are:
what is KDC? and what does this alert mean?
Thanks,
Ruud.Originally posted by Ruud
> I'm getting errors in the W2000 SystemLog containing a error
> with source
> KDC. The description of the alert is:
> There are multiple accounts with name
> MSSQLSvc/TEST-SERVER.didoc.local:1433
> of type 10
> And guess what? This user doesn't even exist.
> The questions are:
> what is KDC? and what does this alert mean?
> Thanks,
> Ruud.
KDC = Key Distirbution Centre ?
--
Posted via http://dbforums.com|||From: Charles Allard -
Date: 03-14-02 02:03
Subject:
----
--
>>
| I am getting the following entry in my system log every 30 minutes.
|
| The description is as follows Event Type: Error Event Source: KDC
| Event Category:
| None Event ID: 11 Date: 1/3/2002 Time: 11:55:18 AM User: N/A
| Computer: SERVER NAME
| Description: There are multiple accounts with name
| MSSQLSvc/SERVERNAME.DOMAINNAME.com:1232 of type 10.
|
| In the System log I get this
|
| Event Type: Failure Audit Event Source: Security Event Category:
| Account Logon
| Event ID: 677 Date: 1/3/2002 Time: 12:44:02 PM User: NT
| AUTHORITY\SYSTEM Computer:
| servername Description: Service Ticket Request Failed: User Name:
| ebjsql User
| Domain: EBIZJETS.COM Service Name:
| MSSQLSvc/servername.domainname.com:1232 Ticket
| Options: 0x40810010 Failure Code: 0x7 Client Address: 127.0.0.1
|
| Any ideas on how to solve this would be greatly appreciated.
<<<<<<<<<<< Multiply Accounts with the Domain have been configured as a
SQL Service
account for the Servername server. This causes both service accounts to
have the same
SPN registered.
If the accounts are known then use ADSI (Active Directory Serivces) edit
and remove
then SPN on the account that is no longer used to start the service on
servername. An
approach you can take would be to run LDP.exe (a utility available from
the Windows
2000 resource kit). This utility is documented within the following
articles. I am
also posting possible steps you can take to resolve this using LDP:
Q224543 Using Ldp.exe to Find Data in the Active Directory
http://support.microsoft.com/defaul...b;EN-US;Q224543
Q260745 XADM: Using LDP to Modify Active Directory Object Attributes
http://support.microsoft.com/defaul...b;EN-US;Q260745
Use LDP.EXE to determine the location of the duplicate name:
1. Click Start & select Run.
2. Type LDP and click OK.
3. Click Connection and select Connect.
4. Leaving the Server field blank, click OK.
5. Click Connection and select Bind.
6. Leaving all fields blank, click OK.
7. Click View and select Tree.
8. Set the Base DN as DC=Home, DC=com
9. Click Browse and select Search.
10. Set the Base DN as DC=Home, DC=com.
11. Set the filter as the following:
(serviceprincipalname=HOST/BOT-PC0295.home.com )
12. Set Scope to Subtree.
13. Click Run.
In either case, this indicates that you have a duplicate machine name
registered
within the Active Directory on your domain.
HTH...
Sincerely,
Charles Allard Microsoft SQL Support
--
Posted via http://dbforums.com
Subscribe to:
Posts (Atom)