Sitemap

Amicuk Programming Answers

SQL Cluster - Unable to obtain IP Address from System Center IP Pool

-0001-11-30   Views:7

Advertisement

Hi everyone, we are trying to deploy a SQL cluster into a windows azure pack tenant cloud. Our azure pack environment contains: - 4X Hyper-V server in a failover cluster - 1X SCVMM server - multiple WAP server Steps we have done: -    Windows failove

Hi everyone,
we are trying to deploy a SQL cluster into a windows azure pack tenant cloud.
Our azure pack environment contains:
- 4X Hyper-V server in a failover cluster
- 1X SCVMM server
- multiple WAP server
Steps we have done:
-    Windows failover cluster is installed and configured successfully
-    Quorum disk was configured successfully
-    SQL server 2014 installation (via static IP) is successfully. But routing between the VMs is not possible.
-    SQL server 2014 installation (via DHCP) fails at the end of the installation with following error:
        -> We used DHCP to obtain an IP from the scvmm IP pool.
(01) 2015-04-22 15:29:11 Slp: Running Action: cluster_ip_address_cluster_config_Cpu64
(01) 2015-04-22 15:29:11 Slp: Action Data:
(01) 2015-04-22 15:29:11 Slp:   Feature = SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64
(01) 2015-04-22 15:29:11 Slp:   Scenario = install
(01) 2015-04-22 15:29:11 Slp:   Timing = ConfigNonRC
(01) 2015-04-22 15:29:11 Slp:   ConfigObjectType = Microsoft.SqlServer.Configuration.ClusterConfiguration.ClusterIPAddressPrivateConfigObject
(01) 2015-04-22 15:29:11 Slp:   FeatureName = SQL_Engine_Core_Inst
(01) 2015-04-22 15:29:11 Slp:   FeatureCpuType = Cpu64
(01) 2015-04-22 15:29:11 Slp:   FeaturePackageId = sql_engine_core_inst
(01) 2015-04-22 15:29:11 Slp:   FeatureClusterState = CompleteFailoverCluster
(01) 2015-04-22 15:29:11 Slp: Creating IPv4 address 'SQL IP Address 1 (SQLADFS)'.
(01) 2015-04-22 15:29:11 Slp: Creating cluster resource 'SQL IP Address 1 (SQLADFS)' of type 'IP Address' in group 'SQL Server (ADFS)'
(01) 2015-04-22 15:29:11 Slp: Bringing IP address resource 'Type='IP Address' NetworkName='Cluster Network 1' Group='SQL Server (ADFS)' Resource='SQL IP Address 1 (SQLADFS)'' online
(01) 2015-04-22 15:29:11 Slp: Bringing cluster resource 'SQL IP Address 1 (SQLADFS)' online
(01) 2015-04-22 15:29:12 Slp: Prompting user if they want to retry this action due to the following failure:
(01) 2015-04-22 15:29:12 Slp: ----------------------------------------
(01) 2015-04-22 15:29:12 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
(01) 2015-04-22 15:29:12 Slp: Inner exceptions are being indented
(01) 2015-04-22 15:29:12 Slp:
(01) 2015-04-22 15:29:12 Slp: Exception type: Microsoft.SqlServer.Configuration.Cluster.ResourceOnlineException
(01) 2015-04-22 15:29:12 Slp:     Message:
(01) 2015-04-22 15:29:12 Slp:         The cluster resource 'SQL IP Address 1 (SQLADFS)' could not be brought online.  Error: There was a failure to call cluster code from a provider. Exception message: Generic failure
. Status code: 5023. Description: The group or resource is not in the correct state to perform the requested operation.
(01) 2015-04-22 15:29:12 Slp:         .
(01) 2015-04-22 15:29:12 Slp:     HResult : 0x86d8003a
(01) 2015-04-22 15:29:12 Slp:         FacilityCode : 1752 (6d8)
(01) 2015-04-22 15:29:12 Slp:         ErrorCode : 58 (003a)
(01) 2015-04-22 15:29:12 Slp:     Data:
(01) 2015-04-22 15:29:12 Slp:       resourceName = SQL IP Address 1 (SQLADFS)
(01) 2015-04-22 15:29:12 Slp:       errorMessage = There was a failure to call cluster code from a provider. Exception message: Generic failure . Status code: 5023. Description: The group or resource is not in the correct state
to perform the requested operation.
(01) 2015-04-22 15:29:12 Slp:       WatsonData = Mi[email protected]58
(01) 2015-04-22 15:29:12 Slp:       DisableRetry = true
(01) 2015-04-22 15:29:12 Slp:     Inner exception type: Microsoft.SqlServer.Configuration.Cluster.ClusterProviderDetailedException
(01) 2015-04-22 15:29:12 Slp:         Message:
(01) 2015-04-22 15:29:12 Slp:                 There was a failure to call cluster code from a provider. Exception message: Generic failure . Status code: 5023. Description: The
group or resource is not in the correct state to perform the requested operation.
(01) 2015-04-22 15:29:12 Slp:                 .
(01) 2015-04-22 15:29:12 Slp:         HResult : 0x86d70002
(01) 2015-04-22 15:29:12 Slp:                 FacilityCode : 1751 (6d7)
(01) 2015-04-22 15:29:12 Slp:                 ErrorCode : 2 (0002)
(01) 2015-04-22 15:29:12 Slp:         Data:
(01) 2015-04-22 15:29:12 Slp:           ExceptionMessage = Generic failure
(01) 2015-04-22 15:29:12 Slp:           StatusCode = 5023
(01) 2015-04-22 15:29:12 Slp:           Description = The group or resource is not in the correct state to perform the requested operation.
(01) 2015-04-22 15:29:12 Slp:           WatsonData = Microsoft.S[email protected]2
(01) 2015-04-22 15:29:12 Slp:         Stack:
(01) 2015-04-22 15:29:12 Slp:                 at Microsoft.SqlServer.Configuration.Cluster.WmiClusterResource.Online(Int32 timeout)
(01) 2015-04-22 15:29:12 Slp:                 at Microsoft.SqlServer.Configuration.Cluster.ClusterResource.Online(Int32 timeout)
(01) 2015-04-22 15:29:12 Slp:         Inner exception type: System.Management.ManagementException
(01) 2015-04-22 15:29:12 Slp:             Message:
(01) 2015-04-22 15:29:12 Slp:                         Generic failure
(01) 2015-04-22 15:29:12 Slp:             HResult : 0x80131501
(01) 2015-04-22 15:29:12 Slp:             Data:
(01) 2015-04-22 15:29:12 Slp:               WmiErrorCode = Failed
(01) 2015-04-22 15:29:12 Slp:               WatsonData = [email protected]
(01) 2015-04-22 15:29:12 Slp:               Description = The group or resource is not in the correct state to perform the requested operation.
(01) 2015-04-22 15:29:12 Slp:               ErrorType = 1
(01) 2015-04-22 15:29:12 Slp:               Operation = ExecMethod
(01) 2015-04-22 15:29:12 Slp:               ParameterInfo = MSCluster_Resource.Name="SQL IP Address 1 (SQLADFS)"
(01) 2015-04-22 15:29:12 Slp:               ProviderName = WinMgmt
(01) 2015-04-22 15:29:12 Slp:               StatusCode = 5023
(01) 2015-04-22 15:29:12 Slp:             Stack:
(01) 2015-04-22 15:29:12 Slp:                         at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
(01) 2015-04-22 15:29:12 Slp:                         at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject
inParameters, InvokeMethodOptions options)
(01) 2015-04-22 15:29:12 Slp:                         at Microsoft.SqlServer.Configuration.WMIInterop.Resource.BringOnline(UInt32 TimeOut)
(01) 2015-04-22 15:29:12 Slp:                         at Microsoft.SqlServer.Configuration.Cluster.WmiClusterResource.Online(Int32 timeout)
(01) 2015-04-22 15:29:12 Slp: ----------------------------------------
We have tried to reinstall the servers multiple times, without result.
Can anyone assist us in this case?
Thanks
Kind Regards
Julian

The replay answer
Advertisement
Hi Darryl,
thanks for your supply.
We don't have an DHCP in the Cloud. System Center DHCP is used for assigning IP addresses and routing inforamtion to the vms.
This works fine for assigning IP addresses to the vms.
At my current point of understanding network virtualisation with system Center, we do not have an alternative to this way of assigning IP addresses.
Kind Regards
Julian

Go to See the other 3 answers

SQL Cluster - Unable to obtain IP Address from System Center IP Pool

Category:DefaultRelease time:-0001-11-30Views:130

Hi everyone, we are trying to deploy a SQL cluster into a windows azure pack tenant cloud. Our azure pack environment contains: - 4X Hyper-V server in a failover cluster - 1X SCVMM server - multiple WAP server Steps we have done: -    Windows failove[More]

HP LJ8000n unable to obtain IP address

Category:DefaultRelease time:2015-10-11Views:130

We have an old LaserJet 8000n that is unable to obtain an IP address. It has been working for the last 10 or so years. In the last two weeks or so, the printer is unable to get an IP address. I did a cold reset and nothing happens. The printer is set[More]

SCCM 2012 & SQL Cluster

Category:DefaultRelease time:-0001-11-30Views:130

Hello.. My Colleague and I are involved in implementing SCCM 2012 for a client and having a question on what would be the best practice (Microsoft Recommendation) for having DB for SCCM 2012 specifically, please note it is for 2012 and not for 2007.[More]

System center sql 2012 remote or local install

Category:DefaultRelease time:-0001-11-30Views:130

Guys I'm testing System Center 2012 R2 right now I plan on installing configuration manager for starters. I would like to ask you guys did you install your sql server instance locally for System Center or do you have a remote SQL server installation[More]

SQL cluster 2008 R2 migration to new Hardware in VM

Category:DefaultRelease time:2015-10-11Views:130

Hi, We have a task to migrate existing Physical SQL Cluster DB to new Hardware but in VM. (cannot argue with the client) hence our plan is to install new Cluster in VM with same Windows and SQL version i.e Win 2K8 R2 ENT w/SP and SQL 2K8 R2 STD w/SP[More]

Sharepoint 2010 farm Sql cluster

Category:DefaultRelease time:-0001-11-30Views:130

hello, i have sharepoint farm with 3 server ( Web front , Sql , search server ) can i make sql cluster to sql with 3 sql server or it be must before begin install sharepoint farm thanks NourYour question isn't very clear but i think i understand. You[More]

Log Viewer: Unable to obtain a valid configuration - BAMRuntimeException

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, We have problems working with the Visual Administrator -> Log Viewer tool. excuting the Visual Administrator -> F:\usr\sap\<SID>\J(XXX)\j2ee\admin>go.bat Login with the user Administrator. Click On: Cluster -> PEP -> Server X[More]

CIFS on OES2SP3 not registering as server on WINS server - Unable to obtain server list from CIFS server.

Category:DefaultRelease time:-0001-11-30Views:130

Running OES2P3 cifs on SLES10SP4. This server is on it's own subnet connected via a router to the other subnets, with the rest of the servers. Name resolution and CIFS file access does work, but browsing does not work. I found that the server registe[More]

Unable to obtain task sequence from SCCM 2007

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have problem to deploy OS to one of my new model laptop due to no NIC driver in boot media CD. When running task sequence wizard, i encounter error " unable to find a valid network adapter driver" and I have google it and get the solution.[More]

Adding SQL Cluster to MARS

Category:DefaultRelease time:-0001-11-30Views:130

What is the best way to add the physical servers and SQL server instances to MARS? As a bit of background we have a SQL cluster with 3 physical servers and each one has an ip address. There are also 3 SQL instances with an associated IP address. Thes[More]

Airespace Wireless Client periodically unable to obtain DHCP

Category:DefaultRelease time:-0001-11-30Views:130

I am experiencing a problem at a couple of customer sites. I have the WLC configured to point to a Microsoft DHCP server. Periodically, all of the clients will be unable to obtain a DHCP address. Currently, the only fix I have been able to come up wi[More]

Hot
Getting a new drive upgrading from my 250 gb western digital. I use it to backup, store, move, archive files. Anyhow, with my new Macbook, I'm considering the omega Mac version ego drive. Since I live and work in s windows world, I'd prefer to have a [More]
I did an update of the Microsoft Framework.net (4), but it did not help.  Cannot reinstall my itunes and this whole thing started when I clicked on my computer to get the latest itunes update when the window came up.Hey Jon Wahl, Thanks for the quest [More]
When trying to navigate around the timeline in a project, I can press the "Right Arrow" key on the keyboard to navigate to the next frame in the timeline from the playhead.  When I try and press the "Left Arrow" key to navigate to the [More]
Hi Experts, I have a requirement to create Additional Payments for two wage types 591 and 691 for a particular Employee subgroup and for three personnel areas whenever a person is hired. I have written the code like this 400           *BEK047.01 RECU [More]
Some strange behaviour in Enter-Query-Mode: Although the help states About Designing Forms for Querying+ +.. To make a "query-only" block, set Query Allowed to Yes and Delete Allowed, Insert Allowed, and Update Allowed to No. ..+ I get FRM-40200 [More]
Post Author: hstevens CA Forum: Formula Given that I've successfully set up a parameter to prompt for a date range, can I now somehow use that in a heading?  Is there someway to extract the dates from that? Or do I have have to set up two parameters [More]
Hi to all, I have this interactive report: select "Work ID", MA01_WORK_GROUP_ID, "Relco", "Data Esecuzione", "Stato" from ( SELECT ma01.ma01_work_id as "Work ID", ma01.ma01_work_type_id, ma01.MA01_WORK_GRO [More]
I am using Batch Loader to load around 100,000 documents per day with per script around 1000 documents. I need to generate a report for the documents mentioned in my script and vs successfully loaded in UCM. Please help me and let me know to generate [More]
Hi, I'm trying to free up space on my phone but have noticed when managing storage the photo library is using 7.5GB, however all photos have been deleted? Any ideas how to delete the photo library? Thanks in advanceTry this Why does my iOS device say [More]
Hi, I have created EXIT but i don't know where to call that exit in the Query to calculate the age in years and please explain me the below line  also and where can i find 0DATE exit. How to Use a formula variable with replacement path filled by exit [More]