Msdb Unavailable
Jul 13, 2007
I work on a SQL 2000 Standard server that is part of our SBS package. Two days ago we ran a set of MS updates on the server and the residual symptom is that DTS packages, the Import or Export wizard all will not run. The Sql Server Agent service runs under the local system account, however that was true prior to the updates.
The error when attempting to run an import is that the OLEDB connection object is not available. The error occurs when trying to use the Access driver or a DSN. Further investigation indicates that msdb could not be contacted.
Does anyone have an idea as to what might cause this and a workaround?
Thanks,
misdean
View 2 Replies
ADVERTISEMENT
Nov 21, 2005
Whenever I start my SQL Express 2005 database, I get the following in the logs :
View 10 Replies
View Related
Nov 4, 2003
I am selectively insert data from serverA databaseX to serverB databaseX.
(serverA is linked server on B.)
I could insert parent and child tables. But get error when insert to grand-child tables:
Server: Msg 8501, Level 16, State 3, Line1
MSDTC on server B is unavailable.
Don't think I need to turn on MSDTC on B. But I could copy and paste from source A server to target B server. Confusing on some table could insert while others with error....
thanks
-D
View 2 Replies
View Related
May 24, 2005
Hi
On W2K3 i have this message "Service Unavailable" when i'm trying browse to my Report Manager.
The ReportServer service is started.
What happend?
Thanks!!
View 4 Replies
View Related
Jul 1, 2002
Having to do contigency planning for a log shipping environment. Have the scenario covered for mdf's not being available (on a separate array), or complete server death. But what if the array the log files are on dies? Has anyone had to deal with this? I was wondering if you could just do a full backup of the current DB's and copy them over (I have my log files coming oer about evey 5 minutes) so I am not sure even if I can if I will gain much. Or if you lose your trans logs are you pretty much SOL.
Thanks
View 1 Replies
View Related
Jul 20, 2005
The following code:DECLARE @tsql varchar(1000)CREATE TABLE #Test (...)SET @tsql = 'SELECT * FROM OPENQUERY(MyDataSource, ...)'INSERT INTO #Test EXEC(@tsql)generates the following error message at the insert statement:Server: Msg 8501, Level 16, State 3, Line 4MSDTC on server 'MyComputer' is unavailable.Why?Thanks,Tony PerovicCompumation, Inc.
View 2 Replies
View Related
Jan 6, 2006
What is the RPC Server?
TITLE: SSIS Execution Properties
------------------------------
Connect to SSIS Service on machine "(local)" failed:
The RPC server is unavailable.
.
------------------------------
ADDITIONAL INFORMATION:
Connect to SSIS Service on machine "(local)" failed:
The RPC server is unavailable.
.
------------------------------
BUTTONS:
OK
------------------------------
View 1 Replies
View Related
Jul 13, 2007
So I've had some issues upgrading to SQL Server Mgmt Studio Dev from Express. I finally got everything upgraded / installed and I see the instances that I was using with Express in my Registered Servers window but I can't connect to any of them. After looking in my Microsoft SQL Server directory I noticed that there are no MSSQL.# folders. How can I recreate these or create a new instance on my local machine?
View 1 Replies
View Related
Dec 3, 2003
help.... whenever i do processing from my sql server, while the program is processing halfway the Server Application Unavailable occur.
**************************************************************************
Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the system event log of the web server. Please review this log entry to discover what caused this error to occur
**********************************************************************
i go to the IIS and it shows
************************************************************************
aspnet_wp.exe (PID: 1692) was recycled because it was suspected to be in a deadlocked state. It did not send any responses for pending requests in the last 180 seconds.
************************************************************************
i suspect that the processing took longer than 180 seconds. my connection string is as below.
What could be the problem???. thanks in advance
data source=127.0.0.1;initial catalog=test;persist security info=False;user id=sa;workstation id=test;packet size=4096;password=password;TimeOut=100000; connection reset=true;
View 1 Replies
View Related
Apr 4, 2002
Hi!
Do you now if it is possible to make database unavailable for users after business hours and how.
Thank you in advance,
Elena.
View 6 Replies
View Related
Apr 29, 2008
Hi.
I'm installing SQL Server 2005 on Vista Home Premium machines (I tried 2 machines and same problem).
It keeps giving the warning IIS not available / installed.
On both mahcines I've installed all IIS components via Control Panel > Programs & Features > Turn Windows Features On / Off. That includes the v 6.0 compatibility services
I can't find anything on MS besides "How to install IIS..." which provides no answer. I have installed Vista SP1 and all updates are installed. No other messages are given in the SQL installation.
Thanks,
Peter
View 1 Replies
View Related
Jul 23, 2007
Trying to install SQL 2005 Express Advanced on Vista x64 Business. IIS 7 installed, setup for 32-bit mode. No warnings, pass 15/15 tests, but when choosing components, Reporting services not available. Please help.
View 9 Replies
View Related
Apr 23, 2008
I have recently installed SQL 2005 Express Edition with Advanced Services and, after a couple of tries, got everthing to intall - Reporting Services and Business Development Studio. The Report Server appears to have configured correctly (green check marks) except when I go to access the Report Server (http://localhost), I get the 503 Error. I have tried restarting IIS (7.0) and ASP.Net 2.0, to no avail. I am running Windows Vista Ultimate. Everything is on one machine. Thanks in advance for any help.
View 7 Replies
View Related
Dec 18, 2007
Hi all,
Hope everyone finished their shopping lists for christmas.
anyways, I came across this error and looking into the event log, the error that I had gotten was the following:-
aspnet_wp.exe (PID: 3660) was recycled because memory consumption exceeded the 613 MB (60 percent of available RAM).
I am using ASP.NET 2.0 and I was wondering whether anyone could tell me how to intercept the files especially the ASMX or the webservice so that I can take a look at what is really going on between the transfers.
Thanks.
Bernard
View 3 Replies
View Related
Jul 9, 2002
I have a local server with a linked server.
Both servers are SQL2000 with SP/2.
I run an update like the following on the local server:
UPDATE LocalServer.Dbase1.dbo.Tab1
SET t1.Col1 = t2.Col2
FROM LocalServer.Dbase1.dbo.Tab1 t1
INNER JOIN LinkedServer.Dbase2.dbo.Tab2 t2
ON t1.Keycol = t2.ForeignKey
I get the following error on the local server:
Server: Msg 8501, Level 16, State 3, Line 1
MSDTC on server 'LocalServer' is unavailable.
Can anyone help me resolve this problem?
Thanks.
View 3 Replies
View Related
Apr 27, 2015
Working with a brand new environment. During install (both SQL 2012 and 2014) on any one of four servers, they all fail on the service accounts page with a "RPC server is unavailable" error and "The SQL Server service account login or password is not valid."
I've verified that RPC server is unavailable is related to only the agent, and the account invalid is only for the engine. Verified this by trying each one separately and putting the other back to default. For the latter (account login or password is not valid), that's definitely not accurate being that I can use that account & password successfully elsewhere.
The best article I've found so far is here - [URL] .....
I've verified all 5 are in place and changed the group policy. Still errors out every time. Even if I can fix the RPC issue, not sure what's wrong with the engine account? I think both issues still stem back to the RPC, even though the engine doesn't report it in the setup. In the detail log, I'm assuming "Slp: Sco.User.OpenRoot - root DirectoryEntry object already opened for this computer for this object" is the core of my problem.
Here's a full output of a failed run:
(08) 2015-04-27 18:28:19 Slp: Sco: Attempting to determine if the password is required for account 'MyDomainsvcSQLEngine'
(08) 2015-04-27 18:28:19 Slp: Sco: Attempting to determine if the account 'MyDomainsvcSQLEngine' is Virtual Account
(08) 2015-04-27 18:28:19 Slp: Sco: Attempting to get account sid for user account MyDomainsvcSQLEngine
(08) 2015-04-27 18:28:19 Slp: Sco: Attempting to get sid for user account MyDomainsvcSQLEngine
[Code] ....
View 8 Replies
View Related
Jul 16, 2007
Hi All:I need to make my database unavailable when i am loading the db. Thishappens daily and the db is not connected to any online app, to makethe app unavailable. It is queried thru an Access and hence availableall the time.The load happens daily for an hour in the morning.Is there anyway to make it inaccessible to users while loading dataand then make it accessibleThank youRS
View 1 Replies
View Related
Mar 18, 2007
Windows 2003 Server x64, SP1SQL Server 2005 x64, SP2Installed Books Online Feb 2007.
Error displayed when launching Books Online:
'Microsoft Document Explorer cannot be shown because the
specified help collection 'ms-help://MS.SQLCC.v9' is
invalid.'
Work-around detailed in KB here (http://support.microsoft.com/kb/913392/en-us) does not work.
Un-installing Feb 2007 BOL and installing original makes no difference.
Help!
View 3 Replies
View Related
Dec 13, 2006
Is it correct to say
in any case exept when data or log file not available pricipal db will be availabe
and manual failover could be done only from from principal?
View 1 Replies
View Related
Feb 7, 2007
Hi all,
Try to install sql 2005 x64 on a Win2003r2 x64 two node cluster.
All looks fine as far I get to the "cluster node configuration" dialog.
My second node is always displayed as "unavailable node" reason "unknown".
- I checked the logfiles but could not find any error.
- Installation user & cluster user are both local admins.
- Tried with sql 2005 x32 version -> same result.
What do I miss out here?
Any help is highly appreciated.
TIA
acki
View 7 Replies
View Related
Sep 6, 2006
We've recently attempted to get RS 2005 64bit up and running on MS Virtual Server and the installation seems to have worked properly (the RS Configuration all seemed fine also). However, when going to http://localhost/Reports or http://localhost/ReportsServer, it gives me the message "Service Unavailable". Everything looks good in IIS (using 2.0).
What else can I do to troubleshoot this issue?
View 5 Replies
View Related
Jul 14, 2015
I make a backup file from my database and than I opened it in notepad.
I find some data that I can't reach with query. I searched for this data in every varchar and text column but I don't find that.I scripted all database with data but still not find.
This database is very old and this unavailable data is from 2000. Now the database run on sql 2012 server.
I want to remove this data from the database. I tried to shrink the database or allocate the free space to 0% but nothing happened, the data is still there in the backup and the mdf file too.
View 14 Replies
View Related
Dec 14, 2007
All of a sudden I am getting an error when connecting to reporting services, not sure how long it has been going on, but I know reporting services was working when we moved to WSS3.0.
Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
And this is the error from the event log:
Failed to execute request because the App-Domain could not be created. Error: 0x80070005 Access is denied.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Has anyone seen this error come up before or know of a quick fix for it.
Recently we upgraded to TFS 2008 and WSS 3.0 but the reporting services was still working after that.
View 5 Replies
View Related
Sep 11, 2014
We have a stored procedure that makes a decision to pull records from one of two servers.
If one of these servers became unavailable but was no longer queried would the stored procedure still work? Doesn't SQL recompile stored procedures periodically?
Something like this:
If @ServerAIsDown=1
begin
select * from ServerB.dbo.MyTable
end
else
begin
select * from ServerA.dbo.MyTable
end
View 2 Replies
View Related
Oct 1, 2014
I want to use a certificate with 10-years expiration date. I created a new template certificate, based on default computer certificate, and I only change expiration date to 10 years.
In SQL Server SSL configuration, I dont view this certificate. In only view certificate created with the "Computer" template (with validity period of 365 days). All others certificates based on template are invisible to SQL Server
How can I use a custom template instead of the default "computer" template ?
View 0 Replies
View Related
Dec 22, 2006
Hi,
In a SSIS Data flow task, whatever you are doing with the input columns that come from a Data source like a Flat File Source, these columns are always visible and available as input columns for all Transformation and Destination components in the Data flow.
Our Custom Component is a column mapping component that transforms many input columns into many oputput columns and we would like that the used input columns are not available anymore to the downstream components...
Is that possible?
I saw that with the Unpivot component it is possible to make some input columns unavailable to downstream components...So I think there is a way to do the same in a custom component...
Thanks for any help,
David
View 1 Replies
View Related
Feb 22, 2008
Hi All -
There are times when I need to disable Reporting Services, which I do by stopping the ReportServer application pool service in IIS, temporarily. During these times if a user attempts to access reporting services they get the default Sevice Unavailable error message. I would like to create a custom Service Unavailabile message. Does anyone know how I can do this?
View 6 Replies
View Related
Aug 28, 2007
Hi
I am trying to create a scale-out deployment of Reporting Services
2005 on a NLB cluster web farm by following the instructions in:
http://technet.microsoft.com/en-us/library/ms159114.aspx
However, when I install and configure Reporting Services on the second
node, and then go back to the first node to join the second node to
the scale-out deployment (as described in step 11 under 'To install
and configure the second report server instance"), I get the following
exception:
ReportServicesConfigUI.WMIProvider.WMIProviderException: An unexpected
error has occurred. Details:
The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) ---
> System.Runtime.InteropServices.COMException (0x800706BA): The RPC
server is unavailable. (Exception from HRESULT: 0x800706BA)
at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at
ReportServicesConfigUI.WMIProvider.RSInstances.GetInstances(String
machineName)
--- End of inner exception stack trace ---
at
ReportServicesConfigUI.WMIProvider.RSInstances.GetInstances(String
machineName)
at
ReportServicesConfigUI.WMIProvider.RSInstances.GetInstance(String
machineName, String instanceName)
at
ReportServicesConfigUI.Panels.ClusterManagementPanel.ConfigureWebFarm(Object
sender, RSReportServerInfo[] rsInfos)
I have spent hours searching for ideas, but so far no success. I have
also tried the following:
1. Enabling DTC access
2. Ensuring RPC service is running on both web and db servers
3. Installing WMI Windows Installer Provider
4. Granting admin rights on both db and web servers to the account
under which Reporting Services is running
Any help or suggestions would be greatly appreciated. It looks like
this should be a straight-forward task.
Thank you.
View 18 Replies
View Related
Apr 24, 2008
We have a SQL2005 server install running on a Win2003 Server. It has a linked server to iHistorian using the iHOLEDB provider for iHistorian. Randomly and after a few execution to this provider, we start getting errors
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider "IhOLEDB.iHistorian" for linked server "fspheafhs1".I created a data source in VS2005 for BI on the SQL server using the iholedb provider. This was successful. However, all queries or OPENQUERY statements to the linked server fail. This seems to continue until SQL Server is restarted. Does anyone know how to reset a provider in SQL Server or tell if the SQL Server is having trouble with the provider? There are no message in the SQL Error Log. Again the provider continues to work outside of SQL Server, but no longer can be accessed from within SQL Server. Thanks in advance.
View 3 Replies
View Related
Jul 24, 2007
I have installed windows server 2003 on one of our test boxes (prior to live) and found that reporting services is now unavailable.
When I browse to the report server I get
Service Unavailable
The event log reports several times
"A process serving application pool 'reportserver' terminated unexpectedly. The process id was '3500'. The process exit code was '0xffffffff'.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
before the worker process is disabled:
"Application pool 'reportserver' is being automatically disabled due to a series of failures in the process(es) serving that application pool.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp."
Has anyone seen similar behavior?
Stuart
"
View 1 Replies
View Related
Mar 7, 2007
Could anybody help me with the following error
"MSDTC on server 'N2984CABA-D249-43' is unavailable"
I am using Sql 2005 Express Edition
What does this error mean?
What should i do?
View 2 Replies
View Related
Sep 21, 2015
I have an SQL Server 2012 with SSIS installed on Windows Server 2008 R2 Core. I'd like to connect remotley to SSIS but I receive the following error. 'The RPC server is unavailable.'
View 2 Replies
View Related
Apr 10, 2007
hi all,
i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.
i have installed reporting server and database on same machine. i tried using
"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"
but i am not bale to connect i am getting "Service Unavailable" page.
and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.
===================================
Cannot connect to http://localhost/reportserver.The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)
===================================
but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.
do i need to start any services for this...
so anybody knows how to troubleshoot this issue.
Thanks in advance...
View 1 Replies
View Related
