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 4
MSDTC on server 'MyComputer' is unavailable.
Why?
Thanks,
Tony Perovic
Compumation, Inc.
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
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.
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?
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!!
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
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
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
------------------------------
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 Relatedhelp.... 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;
Hi!
Do you now if it is possible to make database unavailable for users after business hours and how.
Thank you in advance,
Elena.
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
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 RelatedI 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 RelatedHi 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
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] ....
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 RelatedWindows 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!
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?
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
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?
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.
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.
Is it true that you only have one instance of MSDTC on an active/active Cluster SQL configuration?
All the installations I have seen so far will only allow the MSDTC resource to be under on resource group (usually one of the SQL groups...
Can you all that have worked with cluster respond.
Trying to locate information on MSDTC. Is this "needed" to run SQL Server? That is, if this part of the installation is deleted, will SQL Server still function? Also, does anyone know if this is a crucial tool needed by Veritas Volume Manager or Windows Disk Manager?
If anyone knows of a link to this information, I'd appreciate it. My searches come up with lots on information on MSDTC, but nothing that answers my specific questions.
Thanks for your time.
When i do a BEGIN TRAN to a SQL server sitting on Windows 2003 Server from a SQL Server Sitting on Windows 2000 Server,
the Transaction hangs and if I try o kill it the Transaction is in ROLLBACK State.
I tried setting the Properties for the MSDTC and restarted the Windows 2003 Server but in vain
It still hangs
Did any one come across this problem?
Thx
I keep getting this error on my application server...what does it mean?The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found.The local computer may not have the necessary registry information ormessage DLL files to display messages from a remote computer. Thefollowing information is part of the event: Failed to enlist in DTC:SQL state 37000, native error 8501, error message [Microsoft][ODBC SQLServer Driver][SQL Server]MSDTC on server 'PROSQL' is unavailable..any help would be appreciated...thanks-Jim
View 1 Replies View RelatedI'm using msde. On the little icon in task tray, you have under currentservice, a choice of mssqlserver, and another choice is msdtc. What ismsdtc? And what is sqlserver agent?
View 1 Replies View RelatedThe resource msdtc is down. Every time, it works pretty well , after we restart the servers(node1 and node2). But, about half a hour later, the problem is there. We reintalled msdtc. It didn't work out too. msdtc and sql server is on a cluster. Can anyone help me out?
View 1 Replies View RelatedHi,
I am running SQl 7.0 (SP4) on Windows XP Professional (SP2). Whenever I try an insert/update type of activity, the System returns the following message :
Server: Msg 8501, Level 16, State 3, Line 2
MSDTC on server 'SERVER' is unavailable.
However, all the required services including MSDTC are running on the System.
Please help ASAP.
Thanks & Regards - Rajesh Pathak
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
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 ?
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