Sitemap

Amicuk Programming Answers

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

-0001-11-30   Views:6

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
Creative cloud won't load, nor can I shut it down. Every time I click on the icon the drop down is blank. (using a mac)Launch Activity Monitor and "Force Quit" all the process related to Adobe like Creative Cloud, CoreSync, AAMupdater, AAMupdate [More]
Hello, I install oracle 8i on windows XP, then I install Forms 6i successfully, But when I go to install Repors 6i, the installations termenates, Now I dont Know whats the problem, If anyone know something about this problem then please guide me in t [More]
what is the registry key in Adobe Acrobat v9 which turns the dialog off: any form fields that have the same name in the merged documents are now...There is no key because that is an important dialog.  Why would you want it to go away?Read other 2 ans [More]
iphone 3gs shows activation required, hooked up to iTunes and it is not recognized. Did the restore but just gets to the end and gives an error message it could not be restored, an unknown error occurred (-1). Can someone assist me in next steps plea [More]
this page open http://zingcomms.co.uk/three/#videoplay then i cant close it he told me u sholud dowenlowd flash 11Try posting at the Web Development / Standards Evangelism forum at MozillaZine. The helpers over there are more knowledgeable about web [More]
Who can help me!?im having the same problem! it just started 2 days ago and im frustrated! Tech support sez its a FB issue not an apple software issue....i left a message on FB help page, but that will fall on deaf ears. i am bound and determined to [More]
There is a flowery, very colorful background on the heading portion of my browser behind my toolbars ever since I upgraded. It makes the tabs very hard to read and everything else too. How do I get rid of it? I certainly did NOT pick it out or change [More]
Dear guru. Let me know what's may be wrong ? My post is closely related to bad SQL thread. Shortly speaking, I'd like to discuss multiple star problem. So, Oracle Business Intelligence 11.1.1.6.0 I have three fact table A,B,C joined to common link ta [More]
How do I know where all( in which tables) the new records are created when I've updated a field in a Table. I've updated a field it displayed. actually it updated only one row in my original table 1 row effected. 1 row effected 1 row effected. 1 row [More]
hey, first post... i am noting tons of spam where the subject line is one long mess consisting of junk words. There is no custom rule category allowing me to set something similar to: if SubjectLine has word with length >20 Junk It.. Until Apple catc [More]