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
Hello, Is there any other place on the Internet to ask questions on SAP? Particularly on: SAP Security, ABAP and XI. Thanks, Charles.Other good Forum. http://www.sapfans.com/forums/index.php ARead other 4 answers [More]
I open Firefox and the open window is blank (as it should be, because I have set my Preferences to open firefox with a blank window. Then I select a Bookmarked website from my Bookmarks Toolbar, which opens then opens that website in the window fine. [More]
Has anyone else had this error?Hi aceofleon2, Please refer to the help document below to fix this error: A12E1 error installing Creative Cloud products | CC Regards, SheenaRead other 2 answers [More]
I have been modifying some 3D carousel code that I found in hopes that I can get it such that when image "resolv2.jpg" (or any of my other images) is clicked on at the front of my carousel, it goes to a specific webpage. By just replacing " [More]
Hello Friends.. Logitech MK520 is compatible in my new mac mini ? OR How many wireless combo keyboard & mouse compatible in new Mac Mini ?Logitech MK520 uses Unifying tech, and it needs a special software. You can use it if you have configured your M [More]
Every morning after my mac wakes up, it doesn't automatically reconnect to my wireless network, even though it should be. Anywho, when I click on the airport status indicator up top to manually reconnect, I get the spinning beachball or death, which [More]
The system has three ethernet interfaces (Broadcom 5703, using bge driver). I added a line to ipf.conf to block an ip address and restarted ipfilter. 5-10 minutes later system rebooted and then freezed. I had to power down the system manually and the [More]
Hi, I am working on forms, what is the standard print program for purchase order. Already i have gone to nace and found that the program assigned to the customized print prg, so i am not able to find out the print program, so can u tell me how to sol [More]
so i have my website but am unhappy with the fricken slideshows of Apple, and the so long list of photos, so i wonder if i just can have a list of small boxes with the picture in it and when i click on it, it pops, or even better fades into a certain [More]
Hi There. Please help. I created a form with some required field. when required field is not completed anywhere in form, how do make the mouse pointer to jump to that empty field automatically? Thanks guys. Louk63You want to use http://url.com/Lists/ [More]