Error whn trying a restore through SQL Mgmt Studio

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

frankm - 21 Jul 2008 17:54 GMT

The system is a Windows 2003 R2 Enterprise Edition cluster running SQL
Server 2005 9.00.1399.
I am in process of trying to get this upgraded past SP2 but I have run into
a 11009 error when trying to patch SQL Server.

I get this error either on my own desktop or when logged directly into the
server.
"an attempt was made to reference a token that does not exist"

I am able to do a restore using the [restore database] command but not
through Mgmt Studio.

Any ideas,
frankm

Reply to this Message

Uri Dimant - 22 Jul 2008 06:32 GMT

Hi
http://www.eggheadcafe.com/software/aspnet/29753567/sql-server-2005-sp2-faili.aspx

> The system is a Windows 2003 R2 Enterprise Edition cluster running SQL
> Server 2005 9.00.1399.
[quoted text clipped - 10 lines]
> Any ideas,
> frankm

Reply to this Message

Charles Wang [MSFT] - 22 Jul 2008 08:18 GMT

Hi Frankm,
Thank you for your post.

The error you saw may still be caused by your SQL Server 2005 SP2 installation failure. I would like
to know what the SQL login account you were using to restore database from SSMS. Does it work if
you use SQL login such as sa to log on your SQL Server cluster instance and perform a database
restore?
What is the result if you re-create the SQ login from Windows user account in your SQL Server?

Look forward to your response. If you have any other questions or concerns, please feel free to let
me know.

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@microsoft.com.
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notifications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

=========================================================

Reply to this Message

frankm - 22 Jul 2008 16:26 GMT

I am using my domain account.
This account has local admin rights on bothe servers in the cluster.
This account has sysadmin.

The restore attempt was done with my account through the GUI SSMS and
failed.
I used my account to run T-SQL code (restore database...) to restore through
SSMS and it worked.

> Hi Frankm,
> Thank you for your post.
[quoted text clipped - 42 lines]
> rights.
> =========================================================

Reply to this Message

Charles Wang [MSFT] - 23 Jul 2008 12:43 GMT

Hi Frankm,
Thank you for your response.

From your descriptions and combined with those from your other thread, I think that this issue was most likely caused by the same known issue mentioned in the KB article 925976,
http://support.microsoft.com/kb/925976/en-us, "An operation has changed the security identifiers (SID) for the local groups". I recommend that we continue working on this issue after your
other issue of installing SQL Server 2005 SP2 is fixed. Would you mind waiting some time on this issue before we fix your other issue, SQL Server 2005 SP2 installation?

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@microsoft.com.
=========================================================

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

=========================================================

Reply to this Message

frankm - 23 Jul 2008 13:28 GMT

Athat makes sense, this isn't a big issue, because I get get everything done
I need through T-SQL.

I will take a little time, our new admin starts in a week.
He doens't have domain admin but he has most of the priveleges a domain
admin has.

Thanks!!!

> Hi Frankm,
> Thank you for your response.
[quoted text clipped - 22 lines]
> rights.
> =========================================================

Reply to this Message