Showing posts with label sudden. Show all posts
Showing posts with label sudden. Show all posts

Thursday, March 29, 2012

Failed to obtain TransactionDispenserInterface and invalid LSN, databases suspec

All of a sudden I have 4 of my databases, including pubs that are all marked suspect and seem to be un-recoverable. I have followed the Resetting the suspect status directions as well as trying to attach only the .mdf files but still run into problems reading the .ldf file. I have not tried to do the procedure of creating another database with the same name and structure then swapping the files to trick SQl but will do so if I need to. Does anyone know why this happens all of a sudden to multile databases, of which Pubs I have never used for anything??

In my log files during startup I get this error

Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b

Then this error for every database that is suspect, (the actual LSN numbers are different for each one).

The LSN (4:517:1) passed to log scan in database 'pubs' is invalid..
Is there anything else I can do to prevent this from happening or recover the DB's

ThanksThe log file is corrupted. The only good prevention is to have a good backup strategy. You need to look at whether your .mdf is also corrupted or not.|||Why would these become corrupted? Should I look for a SQL problem or a disk error??... Do you know the best way to track this?? I found it odd that 4 databases would end up like this at the same time

Thanks

Wednesday, March 21, 2012

Failed to access IIS metabase?

Please help!

All of sudden, I cannot connect to the reporting services through MS SQL Server management studio. error message is "Failed to access IIS metabase".

As I checked the system:

1. reporting services is working properly (status is "started")

2. cannot access http://localhost/ReportServer$SQL2005 , the same error

3. Run:"C:\>cscript metaacl.vbs IIS://localhost/w3svc", it shows:
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.

XP\ASPNET
Access: R E
BUILTIN\Administrators
Access: RWSUED
Everyone
Access: E
XP\VS Developers
Access: RWSUE
XP\ASPNET
Access: R
XP\ASPNET
Access: R

I reinstall IIS and it doesn't work. Please help, thank you so much!

Are you able to access http://localhost/reportserver from IE? Are you able to access any web pages from IE?|||

Thank you for your reply.

The first answer is no, I cannot access http://localhost/reportserver from IE(The instance of SQL server 2005 is "SQL2005".)

The second answer is yes, I can access IIS' default web page and the other web pages.

|||Anybody can help, please?|||

I think you need to figure out what are the required ACLs. Maybe you can start by giving everybody full access. If that works start reducing the permissions.

BTW, I thought the error message would give you more details about what ACLs are missing, but I could be wrong.

|||One more thing, if you uninstalled IIS, you may run into some problem when you try to uninstall RS later on: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=735b5260-f6bf-4ea5-94b2-6c41ae387a9a