Sitemap

Amicuk Programming Answers

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

-0001-11-30   Views:3

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
hi everyone...... i'm relatively new to EP.... and my requirement is..... i've created a URL iView and when i logon to the portal.....i need my <b>yahoo or gmail inbox</b> to appear in this URL iView..... i read frm a thread that i need to con [More]
Hello, I am a newbie to RoboHelp 8 and am trying out the Adobe Technical Communication Suite 2.5, and have a Windows 7 (64 Bit) OS. At the moment, I have a single 40 page word document (MS Word 2010) that I would like to bring into RoboHelp 8. With t [More]
          Hello All,           I am trying to hook up 2 Queues as source and target destinations for the WLS8.1           Messaging Bridge[MB] functionality.           So when I send a message to Q1[source destination], the MB forwards the message    [More]
WHen we double tap the home button, only about half of the apps appear.  How do we get them all o appear?If an app freezes on you - you can try force quitting the app. Force quit the app by holding down on the sleep button until the red slider appear [More]
Could I do monthy payments on a 13inch MacBook air? And if so how much would it cost per month?Apple offers the Juniper Visa card through Barclay's Bank. Their interest rates are "fair" but even with excellent credit I was pretty shocked when th [More]
When would i get iphone 5s if i order today and when is 5s available at the storeiPhone 5s is not available yet. Order iPhone 5s beginning September 20. From $199* iPhone - iPhone 5s and iPhone 5c - Apple Store (U.S.)Read other 3 answers [More]
To improve performance we're being "encouraged" to turn off "Automatically write changes". Which means I now have many images scattered throughout the catalog that have metadata changes of some sort on a regular basis. I agree that wit [More]
Receive emails ok but won't open. Ok on iPhone and desk top.  Sometimes I get 'server not responding' message. Safari working fine.  Have turned ipad off and on, and have deleted and re-registered account.  Can anyone help?It's probably on yahoo's en [More]
I am configuring RAC on Oracle Linux,i have configured /etc/hosts on both nodes,when ever i opened network, its displaying error message. system config network error while parsing /etc/hosts wrong ip on line 25 wrong ip on line 26 wrong ip on line 27 [More]
Can you transfer photos and videos from iPhone directly to flash drive?SO you either need a computer or the internet?Read other 4 answers [More]