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 RepliesOn the machine on which I want to put my database, there is already a Registered server called berlinsophos - berlin is the name of the machine and sophos relates to the anti-virus system that has been installed on this computer. I added my database to this server - but on reflection have thought that this might not be best practice since the Sophos so closely tied with computer security. Or perhaps, it was just a name that the person setting up the server gave the name to the first registered SQL Server on the machine.
Any suggestions would be greatly appreciated.
Roger
Just got a new workstation and installed Enterprise Manager. Is there an easy way to migrate the registered servers from the old workstation to the new one.
I have about 30 servers defined under 6 groups. It would certainly be a lot easier if there was a file I could drag from one workstation to another.
Sidney Ives
Database Administrator
Sentara Healthcare
I have 100+ SQL servers registered in SQL EM. Is there a way to migrate these servers to a new PC (registry keys?) or do I have to individually register each one in the new PC? Thanks in advance for any response.
View 3 Replies View RelatedI have SQL Server 2000 installed on one hard drive. I just installed SQL Server 2000 to another hard drive. I'd like to be able to transfer all the registered servers (including the group they belonged to) to the new SQL Server. Is there an easy way to do this? Otherwise, it seems that I have to go to "Client Network Utility" and register each server again, which are a lot of servers.
View 2 Replies View RelatedIs it possible to use registered servers feature in clustered environment and with different versions of Sql server like 2012 & 2014.
View 0 Replies View RelatedI 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
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
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 RelatedWhat 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
------------------------------
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;
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
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.
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.
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
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?
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.
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.