Urgent - Analysis Service Install On An Existing Sql 2005 Cluster - Please Help
Hi,
I am having an existing sql 2005 cluster on an active passive cluster. I need to add analysis service to this as a new component. I am having enough space available in the cluster disks. Following are my queries,
1) do i need a new virtual ip and virtual server name for the analysis services ?
2) do i need a seperate cluster resource group for analysis services with an additional disk added ?
Regards
Nimesh
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Microsoft SQL Server 2005 Service Pack 1 (KB 913090) Cluster Install
I have the initial MSSQL 2005 install on a two-node cluster in place with no production db's moved over, basically prepping it for sp_attach further down the road. I proceeded with applying SP1 on the primary node. I moved the cluster over to the secondary node and checked for any critical windows updates and it reported back that the SQL 2005 SP1 was still required. According to what I have read online the SP1 update on the primary node would have been applied to all nodes. Is this a false report? What harm if any would be if I applied SQL 2005 SP1 again on the secondary node. TIA. Mark
View Replies !
View Related
Can I Install A Enterprise Version Analysis Service On A Standard Version Of SQL 2005 Server?
Hi all, Since some analysis services features are only available in Enterprise version , I have to upgrade my SQL 2005 server from standard edition to enterpise edition. So I uninstall originial standard version of analysis service and install a Enterprise version. However, the analysis service is still a standard version after installation. Is it possible to keep data engine as standard version and install a enterprise version of analysis service? Thank you very much Tony
View Replies !
View Related
How To Install SS2005 On New Nodes In Existing Cluster For Multiple Instances ???
Hi There I have found no real documentation on this, so any links would be greatly appreciated. We have an existing 2 node active active cluster. A default and and named instance SS2005 Enterprise Edition are installed on the cluster. Recently we acquired new hardware, 2 servers, which we added to the cluster so we now have a 4 node cluster. The 2 new nodes have OS etc installed. Now i have installed sql on a new multi node cluster, i have upgraded sql server in an existing cluster BUT i have never installed sql on an existing cluster for new nodes for multiple instances. Now i presume you simply run the install on one of the new nodes, do this for a default instance, selecting both 2 new nodes to installl on. And do this again for the named instance. But in the past I have never been promoted for which nodes to install sql on, it simply does all the nodes BUT i do not want this. And how will the cluster know where the binary files are for each instance on the new nodes? In a nutshell, how do i install sql server 2005 for 2 new nodes in an existing 4 node cluster for multiple instances ? Thanx
View Replies !
View Related
Unable To Install Analysis Services On Sql2005 Active/passive Cluster
Hi i'm trying to install a cluster analysis services on one of the named instance for the SQLServer 2005 running on w2k3 sp2; the rest of the instances have sp2 patches installed except this having no service pack. I keep getting this error when i install the analysis services with or without clustering Thks for any info Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790) Time : Thu Apr 24 11:27:15 2008 SQL02 : To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter. SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt. Time : Thu Apr 24 11:31:40 2008 List of log files: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_SQL02_Core(Patched).log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_SQL02_Datastore.xml C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_SQL02_.NET Framework 2.0.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_SQL02_Core.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_SQL02_.NET Framework 2.0 LangPack.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_SQL02_.NET Framework Upgrade Advisor.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_SQL02_.NET Framework Upgrade Advisor LangPack.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_SQL02_.NET Framework Windows Installer.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_SQL02_.NET Framework Windows Installer LangPack.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_SQL02_Support.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_SQL02_SCC.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_SQL02_WI.log \SQL02C$Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_SQL01_Logs.cab
View Replies !
View Related
Unable To Install Analysis Service SP3
Hi, I was facing problems applying SP3 for Analysis Services so I removed it and then re-installed. I then tried to apply SP3 but I am still getting v8.00.382 for AS (which represents SP1). I have tried a couple of things but it seems that SP3 is just not getting applied (for Analysis Services). Anyone any clues? Thanks.
View Replies !
View Related
Migrating Existing Analysis From 2000 To 2005
Morning am very new to analysis server. I have a 2000 sql server box which has two analysis databases. I am migrating them to 2005 sql server and am using the wizard but am getting an error message on the last part of the migration. "Mining models: Test Miner My OLAP Server;MIS Data Warehouse;Test Miner;Documents;All: The source object is not valid." Any ideas.
View Replies !
View Related
SQL 2005 Standard To Enterprise Edition Upgrade On Existing Three-node Cluster
Current set-up: three node cluster running Windows Server 2003 Enterprise Edition SP2 with two instances of SQL Server 2005 Standard Edition SP2. Virtual node 1: Standard Edition, default instance, Database Engine only Virtual node 2: Standard Edition, named instance, Database Engine, Analysis Services and Integration Services Physical node A: Prefered node for virtual node 1 Physical node B: Failover node for both virtual node 1 and 2 (thus having two installations of Standard Edition) Physical node C: Prefered node for virtual node 2 We started off with this set-up because there was no need for Enterprise features, and SQL 2005 supports failover clustering with two nodes in Standard Edition. Saved a bundle of cash, so everybody's happy. Now we need to run a solution on virtual node 2 that requires Enterprise features in Analysis and Integration Services, so an edition upgrade is required on virtual node 2. I have done some research and found several edition upgrade examples, but none that match the above scenario. We are running production on these machines, so I can't risk experimenting with command line options, I have to be right the first time. Is it possible to mix two editions of SQL Server 2005 in one cluster? Can I upgrade virtual node 2 to Enterprise but leave virtual node 1 at Standard? What procedure do I have to follow to upgrade all three components of virtual node 2 to Enterprise Edition on both physical node B and C? Any ideas will be greatly appreciated.
View Replies !
View Related
Adding 'unaware' SQL Server 2005 Components To Existing Windows 2003 Cluster
This is a fresh install of SQL Server 2005 (64bit) on a Windows 2003 R2 SP2 64bit OS. The Cluster has been built and SQL 2005 has been installed (Database Engine(clustered), Analysis Server(clustered), Notification Server, Integration Server, Reporting Services). SQL 2005 SP2 has been installed. Now, I want to install Notification Server, Integration Server and Reporting Services on the second node for high availability. When I select 'Install New Components' from Add/Remove Programs, the System Configuation Checker tells me theres a version difference and to: To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter. I'm using the same binaries as the original install. Could this be a result of installing SQL 2005 SP2? Can someone help me out with this. I'd prefer using the setup interface instead of a command line script.
View Replies !
View Related
How To Add Reporting Service On An Existing SQL Server 2005 SP2
I am being asked to install Reporting Services on an existing SQL Server 2005 SP2 as well. My question is with regard to the setup. When I go through the setup I choose nothing but Reporting Services, which means everything else has a red X on it. Will setup un-install my existing SQL Server 2005 environment? I need Reporting Services, but I do not want to remove my existing environment. Will this happen? Dave
View Replies !
View Related
How To Add Reporting Service On An Existing SQL Server 2005 SP2
Hi, I have a windows 2003R2 SP2 server with SQL Server 2005 std SP2. I need to add Reporting services & Analysis Services, but i'm not sure of how to proceed. I was thinking about this : "Add or remove programs", select "Change", select "To install a new component, click here", inserting my CD, and select in the setup Reporting Services & Analysis Services. After the install, I think I also need to run again SP2 setup, right ? Thanks for your advices
View Replies !
View Related
SQL 2005 SP1 Install In A/A Cluster
Okay, it's a good thing no one from M$ is in the immediate (physical) vicinity... I'm doing some preliminary testing on SQL 2005 in an Active/Active Cluster. I'm using Windows 2003 Enterprise, on a 2-node cluster using SCSI storage. I installed a default instance and patched it to SP1. Then I installed a second (named) instance and attempted to patch it. That's where the fun began. Read KB 918357 (http://support.microsoft.com/?kbid=918357). Buried in the log files (good luck finding them) on the passive node was the error message "Unable to install Windows Installer MSP file". You have to apply the instructions outlined in the previous KB to BOTH nodes in order to get SP1 to install. Alternatively, I suppose you could install SP1 on both instances at the same time, but if you add another instance into your cluster, you'd better watch out! Also, another gotcha was that I had the default instance turned off during the SP1 installation. I had simply off lined the group (including the disks) instead of offlining the SQL Resource. Buried in the log files on the passive node was an error message indicating that the installer could not find the owner for the S: drive (the data drive for the default instance). Why the installer should CARE who owns the S: drive when it shouldn't be doing anything with it, I don't know. What a total PITA!!!! I am going to go have a beer...or two...or three...... Regards, hmscott BTW, the log files for the SP install are in C:WindowsHotfixSQL9. The log files for the base install are in C:Program FilesMicrosoft SQL Server90Bootstrap
View Replies !
View Related
$#@$#%! SQL 2005 Cluster Install!
I have YET to have a 100% CLEAN install of SQL 2005 in a clustered environment. SQL 2005 Std. was not so bad, I think I finally managed a 99% clean install (no script errors on patches) on the third try. SQL 2005 EE keeps erroring off on 2153 patch install. The error logs are no help at all; they simply stop logging activity at about the point that the error occurs. For a premier product, this installation SUCKS. Whooo. Okay. I feel better. Here's my situation: 4-node Cluster (Windows 2003 Enterprise Edition), SP1 SQL 2005 Enterprise Edition Process: Install OS Patch OS to SP1 Cluster OS on SAN Configure Cluster Groups (DBC01, DBC02, DBC03) with cluster disks Configure MSDTC (network access, configure cluster resources) Start SQL Installation Install RTM Binaries on Node 1 for Default Instance Install Workstation and non-cluster components on remaining nodes Install RTM Binaries on Node 2 for Named Instance Reboot all nodes Install SP1 for all instances from node 1 Install SP1 for all local services/applications for all other nodes While attempting to install the 2153 SQL patch/hotfix, the process will either: Hang while waiting for the first passive node for the default instance; or Crash immediately with no error messages in the logs. This is no nearly detailed enough, I know. I'm missing error messages and more. It's snowing outside and I have to get home. I just think that the installation for this product in a clustered environment is very unstraightforward at best, and at worst is a real liability to an organization since it's practically impossible to get it clean the first time through. Regards, hmscott
View Replies !
View Related
SQL 2005 SP2 Cluster Install
When you try to re-apply SP2 for SQL 2005 on node added to cluster it continously fails? Only way to apply SP2 is to shut down original node(with SP2 allready applied) and then apply SP2 and hotfixes on additional node! I would like to see some reply from SQL support team for this 'issue'. Is this normal? This bring many issues when you have more than one sql on 2 node cluster....etc any explanation is appreciated rgds Sinisa
View Replies !
View Related
2005 Cluster Install Issue
Hello I am having a problem installing the first instance in our two node cluster. We're running 64-bit 2003. I'm trying to install the database engine and client tools only, so of course I get the IIS warning for both nodes. This is expected because I don't want Reporting Services. So the install should still work. However, I'm also getting the ASP.net registration message on only one node. "Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS)." I suspect that I should be getting the error on both nodes because I don't have IIS installed on either node. But again, I only get a warning for one node. This is probably the cause of my failure because it sees the nodes as being out of sync. I'm not sure how to correct this though when it appears that the nodes are exactly the same. Does anybody have any ideas? Thanks in advance! :eek:
View Replies !
View Related
Install SP2 For Sql 2005 In ActivePassive Cluster
Do I have install sp2 on each node in the cluster or do I just need to install it on the active node and reboot? Do I need to pause the active node? I was looking for some documentation for this and didn't mention anything regarding pausing the active node in the cluster in order to apply the sp2 for sql 2005.
View Replies !
View Related
SQL 2005 Cluster, Can Not Install New Database
I am trying to install a new database onto a SQL 2005 cluster with installshield and am getting an error that I can not find any info on. The error is as follows. "Cannot use program file ... for cluster server. Only 4 metafiles on which the cluster resources of the server has a dependency can be used." I will confess to knowing very little about clustering so any help would be greatly appreciated. -John
View Replies !
View Related
Failure To Install SQL 2005 SP2 Standard On Cluster
Hi, While I installed on the active node I got the following error: A recently applied update, KB921896, failed to install After that installation finished , but query the server version I get: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') 9.00.1399.06 RTM Standard Edition On the Visual Studion Manager Help About I get 9.00.3042 Error logs are below. Can you please tell me how can I overcome this? TIA. I paste here the summary and the hotfix logs of the primary node. There is also the Redist9_Hotfix_KB921896_SqlSupport.msi.log but it is too long to paste here. summary.txt: Time: 07/29/2007 02:46:28.253 KB Number: KB921896 Machine: DB1 OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 2 Package Version: 3042 Command-line parameters specified: Cluster Installation: Yes Log Location on Passive Nodes: (DB1) C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix (DB2) C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix ********************************************************************************** Prerequisites Check & Status SQLSupport: Passed ********************************************************************************** Products Detected Language Level Patch Level Platform Edition Setup Support Files ENU 9.1.2047 x86 Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD Integration Services ENU SP1 9.00.2047.00 x86 STANDARD SQL Server Native Client ENU 9.00.2047.00 x86 Client Components ENU SP1 9.1.2047 x86 STANDARD MSXML 6.0 Parser ENU 6.00.3883.8 x86 SQLXML4 ENU 9.00.2047.00 x86 Backward Compatibility ENU 8.05.1704 x86 Microsoft SQL Server VSS Writer ENU 9.00.2047.00 x86 ********************************************************************************** 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): 1399 Product Version (Final) : Status : Failure Log File : Error Number : 11009 Error Description : No passive nodes were successfully patched ---------------------------------------------------------------------------------- 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 : Reboot Required Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlncli.msi.log Error Number : 3010 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): 3883 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 No passive nodes were successfully patched Exit Code Returned: 11009 hotfix log: I paste here only part of the file were I think I see errors (because the post fails on complete logs) 07/29/2007 02:24:37.934 ================================================================================ 07/29/2007 02:24:37.949 Hotfix package launched 07/29/2007 02:24:37.965 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion" 07/29/2007 02:24:37.965 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files 07/29/2007 02:24:37.965 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion" 07/29/2007 02:24:37.965 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files 07/29/2007 02:24:37.980 Local Computer: 07/29/2007 02:24:37.980 Target Details: DB1 07/29/2007 02:24:37.980 commonfilesdir = C:Program FilesCommon Files 07/29/2007 02:24:37.980 lcidsupportdir = f:33a341363e4f5937131539f11033 07/29/2007 02:24:37.980 programfilesdir = C:Program Files 07/29/2007 02:24:37.980 programfilesdir_wow = C:Program Files 07/29/2007 02:24:37.980 supportdir = f:33a341363e4f5937131539f1 07/29/2007 02:24:37.996 supportdirlocal = f:33a341363e4f5937131539f1 07/29/2007 02:24:37.996 windir = C:WINDOWS 07/29/2007 02:24:37.996 winsysdir = C:WINDOWSsystem32 07/29/2007 02:24:37.996 winsysdir_wow = C:WINDOWSSysWOW64 07/29/2007 02:24:37.996 07/29/2007 02:24:38.012 Enumerating applicable products for this patch 07/29/2007 02:24:38.027 Found Redist 2005 product definition 07/29/2007 02:24:38.121 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion" 07/29/2007 02:24:38.121 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files 07/29/2007 02:24:38.121 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion" 07/29/2007 02:24:38.121 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files 07/29/2007 02:24:40.105 Found Redist 2005 product definition 07/29/2007 02:24:40.137 Found Redist 2005 product definition 07/29/2007 02:24:40.152 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion" 07/29/2007 02:24:40.152 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files 07/29/2007 02:24:40.152 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion" 07/29/2007 02:24:40.152 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files 07/29/2007 02:24:56.168 Found SQL 2005 product definition 07/29/2007 02:25:00.293 Enumeration: Determining QFE level for product instance MSSQLSERVER 07/29/2007 02:25:00.309 Enumeration: Associated hotfix build information not found for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLServr.exe 07/29/2007 02:25:00.309 Enumeration: Found following QFE level for product instance MSSQLSERVER: 1399 ... 07/29/2007 02:30:06.090 Locked file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLinnsqlagent90.exe (SQLSERVERAGENT [SQLAGENT90.EXE] - 3284) 07/29/2007 02:30:06.387 Locked file: C:Program Filesmicrosoft sql server90sharedsqlbrowser.exe (SQLBrowser [sqlbrowser.exe] - 1480) 07/29/2007 02:30:58.137 Attempting to pause the 32 bit ngen queue 07/29/2007 02:30:58.902 Installing product: Redist9 07/29/2007 02:30:58.918 Installing instance: Setup Support Files 07/29/2007 02:30:58.934 Installing target: DB1 07/29/2007 02:30:58.934 Installing file: SqlSupport.msi 07/29/2007 02:30:59.027 Copy Engine: Creating MSI install log file at: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log 07/29/2007 02:30:59.027 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller" 07/29/2007 02:30:59.027 Registry: Cannot read registry key value "Debug" 07/29/2007 02:31:29.730 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller" 07/29/2007 02:31:29.746 Registry: Cannot read registry key value "Debug" 07/29/2007 02:31:29.762 Copy Engine: Installed file: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi 07/29/2007 02:31:29.762 Installed target: DB1 07/29/2007 02:31:30.027 Installed instance: Setup Support Files 07/29/2007 02:31:30.043 Installed product: Redist9 07/29/2007 02:31:30.043 Installing product: SQL9 07/29/2007 02:31:30.043 Installing instance: MSSQLSERVER 07/29/2007 02:31:30.059 Enumerating passive cluster nodes 07/29/2007 02:31:30.574 Patching available passive node: DB2 07/29/2007 02:31:30.574 Patching passive node: DB2 07/29/2007 02:31:30.590 Waiting for first completed passive node 07/29/2007 02:31:30.934 Task Scheduler: Created remote folder for product instance target \DB2 07/29/2007 02:31:49.387 Task Scheduler: Transferred payload to remote product instance target \DB2 07/29/2007 02:31:49.402 Task Scheduler: Transferred payload to remote product instance target \DB2 07/29/2007 02:31:49.574 Task Scheduler: Error, cannot create scheduled task for product instance target \DB2 07/29/2007 02:31:50.449 Task Scheduler: Removed remote folder for product instance target \DB2 07/29/2007 02:31:50.449 Error, remote process failed for product instance target 07/29/2007 02:31:50.449 Exit code for passive node: DB2 = 1603 07/29/2007 02:31:50.590 The following exception occurred: No passive nodes were successfully patched Date: 07/29/2007 02:31:50.590 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllinstance.cpp Line: 3422 07/29/2007 02:31:51.449 Watson: Param1 = Unknown 07/29/2007 02:31:51.465 Watson: Param2 = 0x2b01 07/29/2007 02:31:51.465 Watson: Param3 = Unknown 07/29/2007 02:31:51.465 Watson: Param4 = 0x0 07/29/2007 02:31:51.465 Watson: Param5 = instance.cpp@3422 07/29/2007 02:31:51.465 Watson: Param6 = Unknown 07/29/2007 02:31:51.480 Watson: Param7 = SQL9 07/29/2007 02:31:51.480 Watson: Param8 = Hotfix@ 07/29/2007 02:31:51.480 Watson: Param9 = x86 07/29/2007 02:31:51.480 Watson: Param10 = 3042 07/29/2007 02:31:51.480 Installed product: SQL9 07/29/2007 02:31:51.480 Installing product: DTS9 07/29/2007 02:31:51.496 Installing instance: Integration Services 07/29/2007 02:31:51.496 Installing target: DB1 07/29/2007 02:31:51.512 Installing file: sqlrun_dts.msp 07/29/2007 02:31:51.512 Copy Engine: Creating MSP install log file at: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log ...
View Replies !
View Related
SQL Server 2005 SP2 Install Failing On Cluster
I'm attempting to install SP2 on a 2 node cluster and am running into problems when it attempts to authenticate on the passive node. I'm getting a request for remote user authentication asking for ID, password and domain. I enter that information, but get an authentication failed message. Everything appears fine on the active node, the instance is found, the test comes back successful, but when I click next, this dialog pops up. I'm a domain administrator and have tried the domain administrator account and password - no luck. The last few lines of the hot fix log on the primary show this: 01/10/2008 12:34:41.324 Authenticating user using Windows Authentication 01/10/2008 12:34:41.668 Authenticating user using Windows Authentication 01/10/2008 12:34:41.668 Validating database connections using Windows Authentication 01/10/2008 12:34:41.886 Pre-script database connection check was successful - proceeding with script execution 01/10/2008 12:34:42.105 Received sysadmin status for instance: MSSQLSERVER 01/10/2008 12:34:42.105 Validating database connections using Windows Authentication 01/10/2008 12:34:42.324 Pre-script database connection check was successful - proceeding with script execution 01/10/2008 12:34:42.324 User authentication was successful 01/10/2008 12:34:43.277 Authenticating user using Windows Authentication 01/10/2008 12:34:43.511 Authenticating user using Windows Authentication 01/10/2008 12:34:43.511 Validating database connections using Windows Authentication 01/10/2008 12:34:43.730 Pre-script database connection check was successful - proceeding with script execution 01/10/2008 12:34:43.949 Received sysadmin status for instance: MSSQLSERVER 01/10/2008 12:34:43.949 Validating database connections using Windows Authentication 01/10/2008 12:34:44.168 Pre-script database connection check was successful - proceeding with script execution 01/10/2008 12:34:44.168 User authentication was successful 01/10/2008 12:34:47.355 Hotfix package closed And the summary log has this (I end up having to cancel installation since I can't go further): Time: 01/10/2008 12:34:47.042 KB Number: KB921896 Machine: SQL01 OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790) Package Language: 1033 (ENU) Package Platform: x64 Package SP Level: 2 Package Version: 3042 Command-line parameters specified: Cluster Installation: Yes Log Location on Passive Nodes: (SQL01) C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix (SQL02) C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix ********************************************************************************** Prerequisites Check & Status SQLSupport: Passed ********************************************************************************** Products Detected Language Level Patch Level Platform Edition Setup Support Files ENU 9.00.1399.06 x64 Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x64 ENTERPRISE Integration Services ENU RTM 9.00.1399.00 x64 ENTERPRISE SQL Server Native Client ENU 9.00.1399.06 x64 MSXML 6.0 Parser ENU 6.10.1200.0 x64 Backward Compatibility ENU 8.05.1054 x64 Microsoft SQL Server VSS Writer ENU 9.00.1399.06 x64 ********************************************************************************** Products Disqualified & Reason Product Reason ********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID ********************************************************************************** Summary User Cancelled Exit Code Returned: 1602 What services must be running for the install to work? We've turned off a few, but nothing strikes a chord as to a possible problem. Do you have any other ideas as to what might be causing the problem? Thanks
View Replies !
View Related
SQL 2005 Failover Cluster Install Failing.
I am tying to set up an SQL 2005, SP1 failover cluster on a new set of hardware. Everytime I try to run the install, I get this error TITLE: Microsoft SQL Server 2005 Setup ------------------------------ Setup failed to start on the remote machine. Check the Task scheduler event log on the remote machine. I've gone through this doc (http://msdn2.microsoft.com/en-us/library/ms189910.aspx) and checked all of the applicable cautions: I don't have an antivirus package running. All of the SQL setup pre-checks run fine. I have a SQL Group created, with the shared drive as a resource. NBT is disabled on both heartbeat NIC's. NBT is explicitly enabled on both external NIC's. While I do have DDNS running, just to be safe I've pre-created an A record for my SQL VR. Both nodes are registered in DNS and Setup correctly finds the second node. In the Application event log on the second node (the one failing...), I get MSI Installer 'Install Started' successes (and sometimes I even get "Product: Microsoft SQL Server 2005 -- Installation completed successfully.") I am running the install as myself, a Domain Admin and am explicitly added to the Administrators group on both servers. Remote Registry is running. Task Scheduler is running. There is plenty of space everywhere. All of the Admin shares are enabled. The node I am running the install from is the owner of all of the cluster groups and resources: Cluster group MSDTC group SQL group This is all that is in my setup log: Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790) Time : Tue Nov 06 16:45:52 2007 Task did not appear to start on machine: \ERLEW01B: 267013 I'm at a total loss and I'm getting very frustrated... Ed
View Replies !
View Related
SQL 2005 Failover Cluster Install Failure. Please Help!
Hi we have a two node windows 2003 x64 cluster, each running a SQL 2005 instance. I've added a new node to the cluster and am now trying to set up a new instance of SQL 2005 on the new node (node c). During the install i am getting a failure just after the stage where you choose the features to install. I'm selecting SQL database engine with Failover Cluster. When i click next i get a message which states: "The drive specified cannot be used for program location. Program Files must be installed on a valid local disk available on all cluster nodes. The valid values are" I've read a number of articles about possible causes for this and i've checked all the suggested causes but none of these have made a difference. The cluster disk resource is healthy and can be failed between all nodes in the cluster. No errors are generated. I am using an account which has domain admin rights and I can access all admin shares on all nodes. Some of the articles i have referenced are here: http://support.microsoft.com/kb/907261 http://support.microsoft.com/?kbid=913815 http://blogs.technet.com/mbaher/archive/2007/03/23/clustering-sql-2005-and-administrative-shares.aspx I've tried uninstalling all components etc but still i can't get it to work. The next step is rebuilding the server completely so does anyone have any suggestions? Any suggestions would be greatly appreciated. Thanks Chris
View Replies !
View Related
Install SQL 2005 To Cluster That Has SQL 2000 Installed
I have a Cluster environment that has SQL 2000 Enterprise installed. I would like to install SQL 2005 Enterprise as well. What should I watch out for. Do I need to specify a named instance for the 05 install, setup is giving me the option and does see the 2000 instance? Is there a document that walks through this installation? Regards
View Replies !
View Related
SQL 2005 Analysis Service Clustering And Majority Node Set
Hi, I am trying to set up a SQL 2005 analysis server cluster in our two servers, AS02 and AS04. The server cluster is built up on Majority Node Set (MNS). During the installation of the analysis service, I don't see the available cluster groups. In the cluster admin, the cluster is up and running fine. The MNS cluster has no shared disk, and it has two nodes. Any thoughts or suggestions? or is it possible to built the SQL 2005 analysis service cluster with MNS? Thanks.
View Replies !
View Related
Error With Analysis Service 2005: The Query Could Not Be Processed
I have created a cube with Analysis Service 2005. I then publish the pivot table (generated in Microsoft Excel 2003) as a web page. When I view the web page on the domain the LAN everything is working properly. But when the web page I view on Internet I get the error. The query could not be processed: * An error was encounted in the transport layer * The peer prematurely closed the connection. The web page is publish on the Internet Information Server, I changed the security directory of the website, but the error persists. The firewall of the machine is disabled. The port 2382 and 2883 are allowed. The components needed to consult the cube are installed in the machine on which you are viewing the cube. On the Rol of Analysis Service are allowed all users. What other type of restriction may be? Thanks...!!!
View Replies !
View Related
Sql Server 2005 SP2 Unattended Install For Failover Cluster
Hello All, I am trying the following script to upgrade SQL Server 2005 SP1 to SP2. I have an Active Passive cluster configuration. I have default instances of SQL Server. I am using the following script. start /wait c:1sqlserversp2SQLSERVER2005SP2-KB921896-x86-ENU.exe /allinstances /quiet. The sql server install fails to run. When I used the above command with just start /wait c:1sqlserversp2SQLSERVER2005SP2-KB921896-x86-ENU.exe /quiet still the summary.txt file came with authentication success and that is all. I changed the above script and did start /wait c:1sqlserversp2SQLSERVER2005SP2-KB921896-x86-ENU.exe /instancename=instancename of the cluster This worked, however the install patched the passive node (DB engine, all the cluster unaware components) but failed to patch the DB engine on the Active node. I had to run the SQL Server sp2 install manually but still it did not patch the DB engine on the primary node 1. Can someone please help me with this issue as I want the unattended install to work. so it installs both active and passive node. I will post the final output and also the ADS script to do this as a bonus if this works. Here is the summary.txt file. ********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID msftesql Database Services Service 5152 MSSQLSERVER Database Services Service 4412 ResrcMon.exe Database Services Application SHOMSCSService 4688 ********************************************************************************** Product Installation Status Product : Setup Support Files Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Database Services (MSSQLSERVER) Product Version (Previous): 2153 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log Error Number : 29506 Error Description : MSP Error: 29506 SQL Server Setup failed to modify security permissions on file D:Microsoft SQL ServerMSSQL.1MSSQLData for user sqlservice. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that exists on the destination drive. ---------------------------------------------------------------------------------- Product : Integration Services Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : SQL Server Native Client Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Client Components Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : MSXML 6.0 Parser Product Version (Previous): 1129 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : SQLXML4 Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Backward Compatibility Product Version (Previous): 2004 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Microsoft SQL Server VSS Writer Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- ********************************************************************************** Summary One or more products failed to install, see above for details Exit Code Returned: 29506
View Replies !
View Related
Install Muliti Instances On SQL 2005 Cluster With The Same Server Name
I am trying to install multi instances on my server cluster 2003 R2 Sp2. Because of the compatibility issues with my services I need to install both SQL 2000 and 2005. With 2000 I can easily specify the instance and servername. The server name can be the same, but the instance has to be different. Is this true for 2005? I have found so far that for every new instance that you create that you need to have a different virtual server name. How can you utilize the same virtual name and have multi insances servername$instance1 servername$instance2 and so on ThatGuy
View Replies !
View Related
SQL 2005 Cluster (Service Account) Removal.
We have a N+1 SQL 2005 x65 SP2 + 3159 cluster which was running fine until the service account which runs Windows cluster and the SQL services was removed as a login from SQL. This was a new setup so the only SQL accounts are (SA) as SA, Windows Domain GROUP's which one group is configured as SA and the cluster account is added to this group. I cannot start SQL service on the cluster now. I've tried logging into one node as the service account which is member of a AD group which has SA rights to SQL as well as my personal account. If anyone knows a way ot fix this without reinstalling I'd appreciate your help.
View Replies !
View Related
Analysis Service 2005: Microsoft Association Rules Problem
Hi there, i'm new to this forum .. Maybe my way of expression is not very good, but I hope to be understandable. I've a sql server 2005 database with 90 columns and more or less 185 thousands records. I've to run microsoft associations rules on my laptop (sony vaio sz3, core 2 duo, 2gb ram). The problems is that the amount of ram seems not to be enough [it starts to swap when it's reading 240th case) Because of this, i decided to sample my data by extracting 10thousands records randomnly ... it lasts 25minutes (more or less) now, but it's still to much... Does a better way exists? What's the problem: column or row numbers? hope you guys can help me.
View Replies !
View Related
Install SQL Server 2005 Cluster Error - ParseBootstrapOptionsAction Failed
Hi, When I tried to SQL Server 2005 (Standard) to two-node Windows 2003 servers, the Remote Setup task on the 2nd node hang. Here is the SQL Setup log. Please help figure out the cause of the problem. Thanks in advance. Microsoft SQL Server 2005 Setup beginning at Tue Apr 24 16:17:14 2007 Process ID : 2864 \irv144C$SQL2005Std-x64disc1setup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/3/24 16:17:14 Complete: LoadResourcesAction at: 2007/3/24 16:17:14, returned true Running: ParseBootstrapOptionsAction at: 2007/3/24 16:17:14 Loaded DLL:\irv144C$SQL2005Std-x64disc1xmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2007/3/24 16:17:14, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Fri Jul 29 01:13:55 2005 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Fri Jul 29 01:13:55 2005 Function Name: writeEncryptedString Source Line Number: 123 ---------------------------------------------------------- Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: cryptohelpercryptsameusersamemachine.cpp Compiler Timestamp: Mon Jun 13 14:30:00 2005 Function Name: sqls::CryptSameUserSameMachine:rotectData Source Line Number: 50 2 Could not skip Component update due to datastore exception. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "2864"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Running: ValidateWinNTAction at: 2007/3/24 16:17:14 Complete: ValidateWinNTAction at: 2007/3/24 16:17:14, returned true Running: ValidateMinOSAction at: 2007/3/24 16:17:14 Complete: ValidateMinOSAction at: 2007/3/24 16:17:14, returned true Running: PerformSCCAction at: 2007/3/24 16:17:14 Complete: PerformSCCAction at: 2007/3/24 16:17:14, returned true Running: ActivateLoggingAction at: 2007/3/24 16:17:14 Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run: Datastore exception while trying to write logging properties. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupStateScope.primaryLogFiles Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" 0000000000EDAF90Unable to proceed with setup, there was a command line parsing error. : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 Class not registered.
View Replies !
View Related
SQL Server 2005 Cluster Install/adding Node Problem !
Hello, We got an issue when installing a third node in our 2node active/active SQL server 2005 cluster. The installation (interactive) of a additional node in the cluster fails on the database engine whith the error message 'SQL Server Setup has determined that the following account properties are not specified: 'SQLBROWSERACCOUNT'.... The SQL browser Service Account is a domain account and have Local Administrator privileges on all machines. OS: Version 5.2 (Build 3790.srv03_sp2_rtm.070216-1710 : Service Pack 2) SQL: 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 2) Any one have a solution ? Regards Tommy
View Replies !
View Related
Unable To Install SP1 SQL SERVER 2005 On CLUSTER 2 Nodes - KB913090
Hi, I am trying to install SP1 on a cluster with two nodes. I connected directly on the active node with a local administrator user and also with a domain user who have administrator rights. The installation fails to install on mssql e component. The other component is OK. In the log, the message is: 03/09/2007 18:05:26.239 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller 03/09/2007 18:05:26.239 Failed to read registry key: Debug 03/09/2007 18:05:27.019 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller 03/09/2007 18:05:27.019 Failed to read registry key: Debug 03/09/2007 18:03:47.532 ================================================================================ 03/09/2007 18:03:47.532 Hotfix package launched 03/09/2007 18:05:26.223 Attempting to install instance: SQL Server Native Client 03/09/2007 18:05:26.223 Attempting to install target: SQLE1 03/09/2007 18:05:26.223 Attempting to install file: sqlncli.msi 03/09/2007 18:05:26.239 Attempting to install file: \SQLE1u$d75e90bf750dc63a6ae09f16abf9ce95HotFixSqlncliFilessqlncli.msi 03/09/2007 18:05:26.239 Creating MSI install log file at: C:WINDOWSHotfixRedist9LogsRedist9_Hotfix_KB913090_sqlncli.msi.log 03/09/2007 18:05:26.239 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller 03/09/2007 18:05:26.239 Failed to read registry key: Debug 03/09/2007 18:05:27.004 MSP returned 0: Action réussie. 03/09/2007 18:05:27.019 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller 03/09/2007 18:05:27.019 Failed to read registry key: Debug 03/09/2007 18:05:27.019 Successfully installed file: \SQLE1u$d75e90bf750dc63a6ae09f16abf9ce95HotFixSqlncliFilessqlncli.msi 03/09/2007 18:05:27.019 Successfully installed target: SQLE1 03/09/2007 18:05:27.019 Successfully installed instance: SQL Server Native Client 03/09/2007 18:05:27.019 03/09/2007 18:05:27.019 Product Status Summary: 03/09/2007 18:05:27.019 Product: SQL Server Native Client 03/09/2007 18:05:27.019 SQL Server Native Client (RTM ) - Succès 03/09/2007 18:05:27.035 03/09/2007 18:05:27.035 Product: Fichiers de prise en charge installation 03/09/2007 18:05:27.035 Fichiers de prise en charge installation (RTM ) - Non appliqué 03/09/2007 18:05:27.035 03/09/2007 18:05:27.035 Product: Services de base de données 03/09/2007 18:05:27.035 Services de base de données (RTM 1399 FRA CLU-SQLEXTERNE) - Non appliqué 03/09/2007 18:05:27.035 03/09/2007 18:05:27.035 Product: Notification Services 03/09/2007 18:05:27.035 Notification Services (SP1 2047 FRA) - Non sélectionné 03/09/2007 18:05:27.035 03/09/2007 18:05:27.035 Product: Integration Services 03/09/2007 18:05:27.035 Integration Services (SP1 2047 FRA) - Non sélectionné 03/09/2007 18:05:27.035 03/09/2007 18:05:27.035 Product: Composants clients 03/09/2007 18:05:27.035 Composants clients (SP1 2047 FRA) - Non sélectionné 03/09/2007 18:05:27.035 03/09/2007 18:05:27.035 Product: Analyseur MSXML 6.0 03/09/2007 18:05:27.035 Analyseur MSXML 6.0 (RTM ) - Non sélectionné 03/09/2007 18:05:27.035 03/09/2007 18:05:27.035 Product: SQLXML4 03/09/2007 18:05:27.035 SQLXML4 (RTM ) - Non sélectionné 03/09/2007 18:05:27.035 03/09/2007 18:05:27.035 Product: Compatibilité descendante 03/09/2007 18:05:27.035 Compatibilité descendante (RTM ) - Non sélectionné 03/09/2007 18:05:27.035 03/09/2007 18:05:27.035 Product: Microsoft SQL Server VSS Writer 03/09/2007 18:05:27.035 Microsoft SQL Server VSS Writer (RTM ) - Non sélectionné 03/09/2007 18:05:27.035 Here is the entire log file: Thanks very much for your help med
View Replies !
View Related
Unable To Start SqlServerAgent Service In A Sql 2005 Cluster
hi all i'm using a domain accout to setup a sql 2005 cluster in a win2003 cluster.when the installation ended,the SqlServerAgent service can't be started.the event in event viewer is "SQLServerAgent could not be started (reason: Unable to connect to server "(local)"; LServerAgent cannot start). " (event id 103 ,source sqlserveragent).I try to use local system and network service account to start it,but it's all the same. And i found i can connect to the sql cluster vitrual ip 10.73.2.224,but can't connect to the node A.So i enable all the network protocols for the instance MSSQLSERVER,and also enable every ip in the TCP/IP protocol,then restart the sqlserver service,but it still doesn't work. Any advise?Thanks a lot.
View Replies !
View Related
Connecting From Reporting Services 2005 To Analysis Service 200 Data Cubes
I am having a hard time connecting from Reporting Services 2005 to Analysis Service 200 data cubes. To complicate matters the Analysis Services 2000 machines only allows connections to be made over http i.e. http://199.xxx.xxx.xxx/msolap;prompt=1 When I try to setup the connection with RS 2005, I use a data source of type 'MS Sql Server Analysis Services' and then provide the above url with credentials. I get the following error message : integrated security 'sspi' is not supported for http or https connections Has anyone run into the same scenario and had success connecting to data cubes on Analysis Services 2000? Thanks ~Rohit
View Replies !
View Related
SQL 2005 Failover Cluster Installs But Sql Server Service Will Not Start
Hello all, I am intsalling SQL 2005 in an activepassive cluster. The OS is Windows 2003 with SP1. Everything installs OK but the sql server service cannot start afterwards. There are many access errors in the Security Event log - see example below - and numerous "SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. " errors in both the SQL and Application event logs. I have tried installing SQL in both mixed mode and under Windows Authentication and get the same errors. I can install SQL 2005 outside of the cluster on both nodes. Other items of note: This was a SQL 2000 cluster. I uninstalled SQL 2K, the virtual name was changed (IP remained the same) and the DNS entry was updated to reflect the new name. Early in the installation process - 3 or 4 days ago - I got a few errors about the Server Principal Name had to be updated but when I do a setspn -l the both nodes are listed and the entries look fine, though there are no entries for the sql service (MSSQLSvc). Not sure if there should be entries for the virtual name, but there aren't any for either the old or new name. Does the new virtual name need to be added to AD? Here is the security error - Event ID is 560 and it looks like there's a problem with Remote Access and is generated when trying to access either node: Category: Object Access Type: Failure Audit Event_ID: 560 User: NT AuthorityNetwork Service Object Open: Object Server: SC Manager Object Type: SERVICE OBJECT Object Name: RemoteAccess Handle ID: - Operation ID: {0,134558507} Process ID: 1516 Image File Name: C:WINDOWSsystem32services.exe Primary User Name: CM-OHCO-DS006B$ Primary Domain: SWNA Primary Logon ID: (0x0,0x3E7) Client User Name: NETWORK SERVICE Client Domain: NT AUTHORITY Client Logon ID: (0x0,0x3E4) Accesses: Query status of service Privileges: - Restricted Sid Count: 0 Access Mask: 0x4 One other informational message that may be of use - looks like there's a problem with dll's for remote access, though this isn't pertaining to SQL: The description for Event ID ( 0 ) in Source ( srmservice ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: srmservice error: 0, Started the agent (srmagent.exe)..
View Replies !
View Related
SQL Server,SQL Server Agent,SQL Analysis Resources Failing In SQL 2005 Cluster
Hi. I have installed an SQL 2005 Failover Cluster on a Two Node Active Passive Windows 2003 Cluster.If i am trying to failover from the Active node to the passive Node,The Sql Server,Sql Server Agent and SQL Analysis resources fail,However if i reset the passowrd in the services tab of the above three services on the pasive node,the resources come online. Below is the brief of my setup 1.I have two Active directory domain controllers running Windows 2003 R2 Standard edition with SP2. 2.i have installed a Windows 2003 Two Node Active Passive Cluster as NODE1 and NODE2. 3.The Domain account used to install WIndows 2003 A/P Cluster is Clusteradmin.This account is the member of Administartors on the Domain as well as the Local Admin on NODE1 and NODE2. 4.SQL 2005 with SP2 is installed on both the Nodes as SQL 2005 Failover Cluster.The account used to install SQL 2005 is sqadmin.This account is the member of Administartors on the domain and the member of Local Admins on NODE1 and NODE2. 5.SLQ 2005 has four domain groups for 4 SQL Services.The Services are SQL Server,SQL Server Agent,SLQ Anaylisis Server and Full text Search. 6.Each of these servcie has a seperate service account created for them.All these service accounts areb the members of domain admin and the member of Local Admin on NODE1 and NODE2. 7.Each of these servcies is running under these servcie accounts in the Servcies tab in NODE1 and NODE2. 8.If i fail the resources from NODE1 to NODE2 ,The SQL Server,SQL Server Agent and SQL Anaylisis resources are failing.on going to the service tab of NODE 2 I reset the password for these services,the services come online. 10.The Cluster resources and MSDTC Resources are Failing over successfully.They are coming online successfully. 11,I have a problem with the SQL Server Resources,even if i failback to NODE1 from NODE2,the same resources are failing again. Plz Advice. Regards Khalid
View Replies !
View Related
Cannot Install SQL Srv 2005 Service Pack 2 (KB 921896) / Uninstall SQL Srv 2005
I tried to uninstall SQL Server 2005 and it was failed. I tried to install SP2 for SQL Server 2005, and it was failed too! Here are the log file SUMMARY.TXT (is it enough?). Can anyone tell me what the problem is? Time: 05/17/2007 16:51:41.483 KB Number: KB921896 Machine: XXXXXX OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 2 Package Version: 3042 Command-line parameters specified: /quiet /allinstances Cluster Installation: No ********************************************************************************** Prerequisites Check & Status SQLSupport: Passed ********************************************************************************** Products Detected Language Level Patch Level Platform Edition Express Database Services (SQLEXPRESS) ENU RTM 2005.090.1399.00 x86 EXPRESS ********************************************************************************** Products Disqualified & Reason Product Reason ********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID ********************************************************************************** Product Installation Status Product : Express Database Services (SQLEXPRESS) Product Version (Previous): 1399 Product Version (Final) : Status : Failure Log File : D:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9Express_Hotfix_KB921896_SQLEXPR.EXE SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools Error Number : 1332 Error Description : *** Shared String ID 1332 Not Found *** ---------------------------------------------------------------------------------- ********************************************************************************** Summary One or more products failed to install, see above for details Exit Code Returned: 1332
View Replies !
View Related
Cannot Install SQL Server 2005 On A Windows 2003 Cluster In Virtual Server 2005
I am trying to install SQL 2005 in a 2-node virtual Windows 2003 cluster. I set the cluster up through Virtual Server 2005 with 2 virtual nodes and one virtual domain. The nodes can connect to each other as well as the physical machine. When I try to install a fresh copy of SQL 2005 on my cluster, I get an error every time. The error stops the installation while checking system configuration after installing prerequisites. The log file entry is as follows: ******************************************* Setup Consistency Check Report for Machine: --SERVERNAME-- ******************************************* Article: WMI Service Requirement, Result: CheckPassed Article: MSXML Requirement, Result: CheckPassed Article: Operating System Minimum Level Requirement, Result: CheckPassed Article: Operating System Service Pack Level Requirement, Result: CheckPassed Article: SQL Compatibility With Operating System, Result: CheckPassed Article: Minimum Hardware Requirement, Result: CheckPassed Article: IIS Feature Requirement, Result: Warning Description: IIS is not installed, therefore Report Server feature will be disabled Action: Install IIS in order for Report Server feature to be enabled Article: Pending Reboot Requirement, Result: CheckPassed Article: Performance Monitor Counter Requirement, Result: CheckPassed Article: Default Installation Path Permission Requirement, Result: CheckPassed Article: Internet Explorer Requirement, Result: CheckPassed Article: Check COM+ Catalogue, Result: CheckPassed Article: ASP.Net Registration Requirement, Result: CheckPassed Article: Minimum MDAC Version Requirement, Result: CheckPassed <Func Name='PerformDetections'> 1 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0 Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run: Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache Source File Name: datastoreclusterinfocollector.cpp Compiler Timestamp: Fri Sep 16 13:20:12 2005 Function Name: ClusterInfoCollector::collectClusterVSInfo Source Line Number: 883 ---------------------------------------------------------- Failed to detect VS info due to datastore exception. Source File Name: datastoreclustergroupsproperties.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: ClusterGroupScope.SharedDisks Source Line Number: 56 ---------------------------------------------------------- Failed to find a cluster group that owned shared disk: J: WinException : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: datastoreclustergroupsproperties.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: ClusterGroupScope.SharedDisks Source Line Number: 56
View Replies !
View Related
SQL Server 2005 Service Pack 2 - Install
Hi dear Devs! I have a problem and now I am not sure, what I should do. "Microsoft Update" Service warned me, that a new critical update is ready for download. It was the update "SQL Server 2005 Express Edition Service Pack 2", I did that. Untill here no problem. The update "SQL Server 2005 Service Pack 2" was ready for download too. I have both versions on my computer "SQL Server 2005 Express Edition" and "SQL Server 2005 Developer Edition". The Express Edition came together with the install of "Visual Studio 2005 Team Suite", two days later I have installed the "SQL Server 2005 Developer Edition". Now to my problem, the "SQL Server 2005 Service Pack 2" installation failed in one point, the name of it is "Microsoft SQL Server Native Client". The whole installation was not interrupted, it told me only at end of this updating that this point wasn't successful - I saw it in the "Summary.txt". While the install I saw that this "Microsoft SQL Server Native Client" was twice in the list of the Service Pack 2 Update. Both of these points had the identical name. In short words, I saw that the SP2 wanted made an update at "Microsoft SQL Server Native Client" twice. I thought, it is because these two editions of "SQL Server 2005" on my computer. But the result is, that the SP2 couldn't update the second 'Native Client'. I checked it in the 'Software' section in 'Control Panel' and I have really two installations of this "Microsoft SQL Server Native Client". My question is, is that normal, is that because I have two "SQL Server 2005" Editions on my computer? And what can I do with this failed part of the SP2. Can someone help me with this failed 'Native Client' SP2 update? I were really happy, if someone could give me the best solution to fix this problem. Thank you very much for your help and answers Arzu Bazman · «US DEV United Systems»
View Replies !
View Related
|
TRACKER
