I asked this question before but never received a decent answer. When a restore fails, what are the steps to re-start the restore? This should be a very common issue and for the life of me I have been unable to find it in BOL or the MS site! Please let me in on the secret!!
Thanks
How does one correctly go about restoring the MSDB database?
How/what should I do with the status (loading)?
I have a good backup of the MSDB.
Any help will be appreciated.
In SQL Server 7.0 I right click on the database, select Tasks, Select backup, then indicate backup of database (complete) to tape. Overwrite (I put tape into NT Server), OK, then it says backup in progress and then I get the message shown in the subject...
Any advice please? I have backed up NT files on this tape before and have tried a second tape...
Thanks much,
Steve Brown
One of the database in our SQL Server 2000 environment is in the suspect status. We need to bring it back to the normal status.
The problem occurred because the disk on which the data file and log file for this database were placed ran out of space.
Pls note other databases in the same server are working fine.
Later on more space was made available on this disk. We tried the following options but with no success.
1. Reset the status of database and restarted the SQL Server. After restarting the SQL Server, the database once again was showing the suspect status.
2. Used the same data and log file in another SQL Server and attached with the database in this another SQL Server.
3. Tried dbcc chkdb with repair_allow_data_loss.
Since the database is in suspect status, we are neither able to export the data nor able to back up the database.
Please suggest some options to recover the database from the suspect status. Also it would be great if we can get the commands, scripts to find if the data/log file is corrupt and a way to correct it (even with data loss is fine).
I performed a database restore this morning from a backup that I had
created yesterday - the database was backed up to a file, not a backup
device.
After the restore completed, the database was left in a LOADING status. I
checked the log and it stated 'Bypassing recovery for database X because
it is marked in load. I used the enterprise tools (all tasks/restore
database) to do the restore.
I asked one of our senior dba's for help, and he followed the same process
I did and it worked fine for him.
Any idea why my database was left in a loading status? The database was
fine prior to the restore.
I Restored the database from Backup with a Different database Name. I got a message the Restore Database was successful. Still the database has Loading Status. Can you let me know what I have to take that status.
View 1 Replies View Related
Hi..
I've 3 pc that have MS SQL 2000 database installed in it and connected to main server through merge replication.
At first it run fine all the time. But now, it doesn't. It's happen when the pc have to restart every night. When i come to the office and check resplication status it return failed. I try to manually start synchronize but it failed too. I've to restart the pc all over again untill it ok.
I hope some body out there can explain something to me and how to overcome the problem...
Transactional replication running via a pull subscription between a single subscriber and single publisher on Windows 2000 servers (all current service packs and patches) with SQL Server 2000.
Early on Sunday morning, the server hosting the publisher was rebooted...but SQL Server Agent failed to start fully, causing the log reader agent to not start and no alerts to trigger. Still trying to isolate the cause of the problem with SQL Server Agent, as it's been problematic to keep it up and running. For the most part, though, it's coming up properly after restarts of the service or reboots, and starting all agents/functions.
However, the snapshot agent ran a number of times pulling schema and batch copies for the articles in the replicated dataset, and the distribution agent now fails each time it runs with a reference to "not having the initial snapshot for the publication available". SQL Server Agent went down before this could complete, and I left it down until I could ascertain the best route to take...
Any chance I can circumvent having to reapply a initial snapshot of the publication db (this is a large set of data), and just apply transactions from the log since my downtime has only been about 60 hours? Or is there an agent setting, job run to reinitialize, or an inherent quality to SQL Server Agent that will demand a complete reapplication of the snapshots due to the down time?
I'm betting that the distribution agent will start moving data as soon as the snapshot agent finishes up (as I said, it has not completed yet), but I'm praying there's a way to get around this...
Thanks!
We were trying to restore our production server db backup in test server over LAN (due to space shortage on test server) . Test server hanged and did not respond for abt more than 15 hours (backup file 40 GB ) . The we restarted the server (resetting the power button) . Now it's showing the status 'Restoring' . According to me it's not doing anything (as seen in task manager workload ) . So how can I go ahead with checking the db .
Due to 'restoring' status I get following error
------------------------------------
Msg 927, Level 14, State 2, Line 1
Database 'envdb' cannot be opened. It is in the middle of a restore.
----------------------------------
I have a clean SQL 2005 Ent. x64 SP1 clean with no user db's.....applied SP2 and everything showed "Success" except the Database Services (Error 29534)......
Time: 02/22/2007 08:29:50.134
KB Number: KB921896
Machine: TORCA8
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x64
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.1.2047 x64
Database Services (MSSQLSERVER) ENU SP1 2005.090.2047.00 x64 ENTERPRISE
Analysis Services (MSSQLSERVER) ENU SP1 2005.090.2047.00 x64 ENTERPRISE
Reporting Services (MSSQLSERVER) ENU SP1 9.00.2047.00 x64 ENTERPRISE
Notification Services ENU SP1 9.00.2047.00 x64 ENTERPRISE
Integration Services ENU SP1 9.00.2047.00 x64 ENTERPRISE
SQL Server Native Client ENU 9.00.2047.00 x64
Client Components ENU SP1 9.1.2047 x64 ENTERPRISE
MSXML 6.0 Parser ENU 6.00.3890.0 x64
SQLXML4 ENU 9.00.2047.00 x64
Backward Compatibility ENU 8.05.1704 x64
Microsoft SQL Server VSS Writer ENU 9.00.2047.00 x64
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29534
Error Description : MSP Error: 29534 Service 'MSSQLSERVER' could not be started. Verify that you have sufficient privileges to start system services. The error code is (1067) The process terminated unexpectedly.
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB921896_sqlrun_as.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRS9_Hotfix_KB921896_sqlrun_rs.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Notification Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixNS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 3890
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 1704
Product Version (Final) : 2004
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 29534
Now SQL Server service won't restart.....
2007-02-22 10:16:31.28 Server Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-02-22 10:16:31.28 Server (c) 2005 Microsoft Corporation.
2007-02-22 10:16:31.28 Server All rights reserved.
2007-02-22 10:16:31.28 Server Server process ID is 2056.
2007-02-22 10:16:31.28 Server Authentication mode is MIXED.
2007-02-22 10:16:31.28 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2007-02-22 10:16:31.28 Server This instance of SQL Server last reported using a process ID of 576 at 2/22/2007 10:16:15 AM (local) 2/22/2007 3:16:15 PM (UTC). This is an informational message only; no user action is required.
2007-02-22 10:16:31.28 Server Registry startup parameters:
2007-02-22 10:16:31.28 Server -d E:SQLDatamaster.mdf
2007-02-22 10:16:31.28 Server -e C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2007-02-22 10:16:31.28 Server -l F:SQLLogsmastlog.ldf
2007-02-22 10:16:31.28 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-02-22 10:16:31.28 Server Detected 4 CPUs. This is an informational message; no user action is required.
2007-02-22 10:16:31.28 Server Cannot use Large Page Extensions: lock memory privilege was not granted.
2007-02-22 10:16:31.40 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-02-22 10:16:31.42 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-02-22 10:16:31.50 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 36200, committed (KB): 104760, memory utilization: 34%.
2007-02-22 10:16:33.45 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-02-22 10:16:33.45 Server Database mirroring has been enabled on this instance of SQL Server.
2007-02-22 10:16:33.47 spid5s Starting up database 'master'.
2007-02-22 10:16:33.47 spid5s SQL Trace ID 1 was started by login "sa".
2007-02-22 10:16:33.48 spid5s Starting up database 'mssqlsystemresource'.
2007-02-22 10:16:33.48 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-02-22 10:16:33.48 spid5s Error: 5173, Severity: 16, State: 1.
2007-02-22 10:16:33.48 spid5s One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.
2007-02-22 10:16:33.48 spid5s Error: 5173, Severity: 16, State: 1.
2007-02-22 10:16:33.48 spid5s One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.
2007-02-22 10:16:33.48 spid5s Log file 'F:SQLLogsmssqlsystemresource.ldf' does not match the primary file. It may be from a different database or the log may have been rebuilt previously.
2007-02-22 10:16:33.48 spid5s The log cannot be rebuilt when the primary file is read-only.
2007-02-22 10:16:33.48 spid5s Error: 945, Severity: 14, State: 2.
2007-02-22 10:16:33.48 spid5s Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
2007-02-22 10:16:33.48 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
Tried reinstalling SP 2 in quiet mode using sapwd parameter.....now everything is showing the correct SP2 version but SQL Server Service won't start.......anyone????????
Every so often I get an error when I pull up an ASP.NET 2.0 site using
SQL Express. It tells me that the login failed. If I go
into the server's administrative tools > services and restart SQL
Express and then refresh the site, it works just fine. Is this
some sort of bug or memory issue? Does the application need to
connect every so often or end up falling out somewhere?
Thanks
Hi all:
In order to test database restore, I create a backup driver and puporse delete one table, then I try to restore my databse use backup, but the delete table donot show up.
Thank you
I am facing the Database recovery problems sicne I have lost my MSDB db , only i have the Complete db backup and transactional backup.
How do i can recover the database since i don't have the MSDB database
I work on sql server 2000.
Is it possble to recover just one table from the database backup ???
I am new to this.
Please let me know.
thanks
Hi
I have a question concerning backup / restore / recover of a MS-SQL-Server-Database.
Following configuration exists:
MS-SQL-Server running on NT
OS, Server located on a mirrored Raid 0 Disk -> C:
Transactionlog-Files (.ldf) on the same physical mirrored Disk -> E:
Database-Files (.mdf) located on a separate pyhisical Disk (Disk-Set, Raid 5) -> D:
I take a full backup every night of all databases, no Transaction-Log backup is made during a day (never)
Assuming following situation:
During a day one Database became corrupt. The physical-file (.ldf) of corrupted database is still accessible
on Drive E:
1. Step: I make a copy of the .ldf-File and put it on a secure place or in an other directory
2. Step: I restore the DB from the last full backup
3. Step: ???? How is it now possible to recover from the physical available .ldf-File? I know it should be
possible but I don't now how.
Has anybody tips or suggestion or has someone ever had a similar situation? Feedback would be appreciated.
Kind regards
Gabi
Hello, everyone:
Does any body have the experience to execute data warehouse backup/recover? What I want to know is how to backup/recover database in data warehouse and cubes.
Thanks.
ZYT
I ran into a problem today where I had to pull a backup file from an older tape. The file was originally is a backup that was stored in a device like :
EXEC sp_addumpdevice
'disk', --type
'c2000_BackupDevice', --logical name
'\UNCPathackupFile.bak' --physical location
I put the file from the tape on a File Server and then tried to create a new backup device pointing to the file. That's easy enough, but when I try to restore from it I get an device error saying it's offline.
How can I get that device attached to my server and then extract the backup files stored inside it?
Please advise b/c this is an interesting problem I hadn't anticipated and it argues that I should change my backup strategy .
Thanks for any advice/experience you can provide,
alex8675
I created a new database and want to recover data from a backup this script
use master
go
restore database new
from disk='D:
ew.bak'
go
but get an error
Message 3141, Level 16, State 0, Line 1
The database to be restored was named 'ats342'. Reissue the statement using the WITH REPLACE option to overwrite the 'new' database.
Message 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Hi friends,
please help me with my urgent needs.
I have created a job. This job contains 6 steps.
All steps are sql querries.
In step no:3 i have an if condition in the script.
When the condition becomes true i have to run the script.
That is ok.
But the problem is when the condition becomes falls i have
to go to the step no 6 and at the same time the status
of step no:3 should be like "failed".
can you help me please
Please this is an urgent reqirement.
Thank you.
Hi Experts,
I am extracting data from SQL Server 2005 to flat file destination. I am using SQL Command to specify the data selection query. One of my query uses Replicate function to derive a column value. When I execute this package it fails with the error "Data conversion failed. The data conversion for column "value" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page".
The reason for the problem is that, it is taking the InputColumnWidth of the flat file destination as 8000 and I specified the OutputColumnWidth as 4.
If I change the OutputColumnWidth to 8000, it is working without any error but resulting in the column width of 8000.
I tried using DerivedColumn Transformation's Type cast and DataConversion Transformation but still I am getting the same error in the respective Transformation components.
Can anyone suggest how to solve this issue.
Other postings I know have asked about this error message, but none has quite been my particular experience.
Using Visual Studio 2005 I have developed an aspx (.NET 2.0) web page, which has embedded in it, a Report Viewer object. Clicking a button calls the Reporting Services report and populates the Report Viewer object. This web-page works fine when run from Visual Studio.
Once deployed to the Web Server however, the web page produces the 401 error message.
I can also run the report fine, when running it directly from the Reporting Services Report Manager, so I know I have the proper permissions on RS itself - it fails only when I try calling the report from the ASP page.
Any help greatly appreciated.
Thanks,
Mike.
Microsoft.Reporting.WebForms.ReportParameter[] RptParameters = new Microsoft.Reporting.WebForms.ReportParameter[3];
RptParameters[0] = new Microsoft.Reporting.WebForms.ReportParameter("spec_id", "24058");
RptParameters[1] = new Microsoft.Reporting.WebForms.ReportParameter("Meas_Details_id", "30");
RptParameters[2] = new Microsoft.Reporting.WebForms.ReportParameter("MeasID", "3");
this.ReportViewer1.ServerReport.SetParameters(RptParameters);
when am trying to run this code it is throwing this exception
The request failed with HTTP status 401: Unauthorized.
Can anyone pls help me on this
Thanks.
Hello All,
I am getting the mentioned error: The request failed with HTTP status 401: Unauthorized, when i tried to call ReportingService2005 reference in my IIS web project.
Below is my code:
string strReport;
string strRptUrl;
string strFormat;
string strFormatCode;
ReportingService2005 rs = new ReportingService2005();
// Pass Windows Authentication credentials to Web Service
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
// Call ListChildren method to get array of reports
CatalogItem[] itmReports = rs.ListChildren(strFolder, false);
foreach (CatalogItem itm in itmReports)
{
// ListChildren returns reports, subfolders, data sources, etc.
// so we need to filer for reports only
if (itm.Type == ItemTypeEnum.Report)
{
// Use description if it exists, otherwise fallback to name
if (itm.Description != null && itm.Description.Length > 0)
{
strReport = itm.Description;
}
else
{
strReport = itm.Name;
}
strRptUrl = itm.Name;
TemplateDropDown.Items.Add(new ListItem(strReport, strRptUrl));
}
}
}
catch (Exception ex)
{
throw ex;
}
Did i missed anything. Please assist me.
Thanks in advance.
Hi,
I have deployed the reports to the report server(centralized server). when i try to access the reports directly thru report server i.e http://servername//ReportServer in my local system. it asks for the username/password, when i give the username and password it accepts and shows me the report.
the same report i try to access in .NET Application, i do not know how to pass the credentials and it throws the error :"The request failed with HTTP status 401: Unauthorized ".
I am using VS 2005 and SQL Server 2005 and SQL Reporting Services 2005.
with regards
Hi,
I am using report viewer in my asp.net application When i try to access the reportserver page in my application i get this error
The request failed with HTTP status 401: Unauthorized
My webserver and the Sql server are in different computers.. The Report Server is been installed in the Webserver but in the database set up its talking to the sql server computer.. I have tried giving credentials in the webconfig file but i get the above error..
any help will appreciated.
Regards,
Karen
Hi, all experts here,
Thanks for your kind attention.
I am wondering why the loading of mining model for MTS failed in my case, the model has successfully processed and deployed? But when I clicked on the model viewer, the error message saying: failed to load model. Why is that? Is it because too many records for the table? Or why is that? (in my case, I got a case table and a nested table with over 1000,000 records)) Thank you very much and I am looking forward to hearing from you.
With best regards,
Yours sincerely,
I have programmatically deploy SQL server Reporting Services 2005 reports via msi file. The installation was success, I was able to run the reports on localhostReports at the target machine. But I get error "The request failed with HTTP status 401: Unauthorized." when I try to access it from the ASP.NET app report menu in the target machine.
It is Windows Server 2003 standard edition, it uses Windows Authentication. I have tried setting any combination below and still doesn't work. Anybody has any other ideas?
ReportingService2005 rs = new ReportingService2005();
rs.UseDefaultCredentials = true;
rs.PreAuthenticate = true;
rs.Credentials = System.Net.CredentialCache.DefaultCredentials; or
rs.Credentials = new System.Net.NetworkCredential("Admin", "psw");
"The request failed with HTTP status 405: Method Not Allowed"
That Error i have all the time i connect my Windows Server Sp1, MSSQL,IIS 6.0 computer
by adress http://localhost/Reports
when i`m trying to access the ReportServer by http://localhost/ReportServer it give me blank page with :
localhost/ReportServer - /
Microsoft SQL Server Reporting Services Version 9.00.2047.00
I don`t know what to do.... i try ALL, Giving Privileges to all user, Starting Report Server Service under Administrator,
Giving Privileges in DCOM utility in Event Viewer.... not any errors ALL services are working IIS Working i can connect to Web Sites which are under IIS,i tryed change Pool Identety==usless i spend 2 week trying to solve it
That error killing me pleace could any one help me.... pleace send an email :/ any advice ;(
in Reporting Services Log is only one message:
Code Block
w3wp!ui!1!11/6/2007-19:25:23:: e ERROR: The request failed with HTTP status 405: Method Not Allowed.
w3wp!ui!1!11/6/2007-19:25:24:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 405: Method Not Allowed.
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!11/6/2007-19:25:25:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
One of my MSSQL instances show me : The report server is not responding. Verify that the report server is running and can be accessed from this computer.
But all services are working
We are using sql server 2012. We have configured backup in our setup. We wanted to enable loggigng in such a way that when ever backup job runs it should log the status in error log. How to enable this. As of now it is creating seperate log file in log location after every execution. We wanted them to be logged in Error Log file it self.
View 8 Replies View Related
Hello, I am trying to schedule a report using the ReportingService2005 web service. It works in my local machine, but as soon as I deploy my web app to a server I get this exception:
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at ReportService.ReportingService2005.GetSubscriptionProperties(String SubscriptionID, ExtensionSettings& ExtensionSettings, String& Description, ActiveState& Active, String& Status, String& EventType, String& MatchData, ParameterValue[]& Parameters)
at ReportScheduling.SaveSubscription(String SubscriptionID, String ReportName, Int32 ReportID)
at ReportScheduling.ScheduleReport()
I see that a lot of people are having the same problem but no solutions are given, Answers like "use the default credentials" . Or "pass a user name and a password" are not doing anything. This has got to be a machine setting. Can anyone share the specific fix? Sad that this is not in Microsoft's standard documentation or MSDN. Very frustating.
I have a report server set up to use SSL and Basic authentication. I am trying to create an application that uses the ReportService2005 web service. I can add the web reference ok, but when I try to use it to list reports, I get the "The request failed with HTTP status 401: Unauthorized." error.
What steps do I need to take to get the authentication to work correctly? I have kerberos configured for the server, although I don't think that would matter here.
pjp
Hi,
I have deployed the reports to the report server(centralized server). when i try to access the reports directly thru report server i.e http://servername//ReportServer in my local system. it asks for the username/password, when i give the username and password it accepts and shows me the report.
the same report i try to access in .NET Application, i do not know how to pass the credentials and it throws the error :"The request failed with HTTP status 401: Unauthorized ".
I am using VS 2005 and SQL Server 2005 and SQL Reporting Services 2005.
with regards
Suresh Babu
I am using SQL Server Reporting. All reports are deployed on REPORTING SERVER.
I want to implement security roles as same as in Active directory. Currently reports are being accessed using Anonymous user setting in IIS.
I have added users in SQL Server security as well as data base level. But when user accesses report following error occurs:
The request failed with HTTP status 401: Unauthorized
Please reply with solution as soon as possible. I will be very thankful to you