Sql 2008 Cluster - Add Node Error

-

During the end of the installation for configuring a new cluster with the SQL 2008 Enterprise installation,  the following error was shown;









The following error has occurred;
There was an error setting private property 'RequireKerberos' to value 1 for resource 'SQL Network Name () Error: Value does not fall within the expected range.
The solution to is to register the SPN of the user account you created to run the services.
Open up the Command Prompt and type the following;
setspn -L mynet\sqlservice
setspn -s MSOLAPSvc.3/sqlcluster:cluster1 mynet\sqlservice
setspn -s MSOLAPSvc.3/sqlcluster.mynet.local:cluster1 mynet\sqlservice
setspn -s MSSQLSvc/sqlcluster:cluster1
setspn -s MSSQLSvc/sqlcluster.mynet.local:cluster1
sqlcluster is the name of my SQL cluster set during the SQL installation and cluster1 is the name of my instance.

Once you have done this, make sure all computer accounts used in Cluster are enabled for Kerberos Delegation and that the user service account is allowed to Delegate Kerberos as well (Trust this user for delegation for any service).

This was all done in a lab and I take no responsibility if you try this in a real environment.



Have fun.


Ps. I used StarWind iSCSI to create my Cluster.






Comments

Post a Comment

Popular posts from this blog

Create bootable CUC CUCM CUP Image / ISO

-
The following script allows you to automatically create a bootable CUCM/CUC/CUP image without the need for any paid for software when you only have access to the update outside of put or the datastore for the new server. I have spent several hours on this, but I just wanted to make it simple. Only really for lab purposes, the checksum will fail due to the ISO being manipulated but essentially once you fill in the variables, you will just be left with a single ISO file in the staging directory. To use; 1. Download the mkisofs.exe file as described in the script 2. Paste script below into Powershell ISE Script Editer 3. Modify the variables 4. Execute the script. Simple. Tested creating an ISO on a Windows 10 machine and running the ISO on a ESXI server. Thanks for this guy Aaron Harrison as per the URL, was helpful in the finding out the mkisofs.exe command syntax. http://www.ipcommute.co.uk/technical-articles/17--creating-isolinux-boot-dvds-with-free-software-cucm-uccx-cups.
Read more

Configuring Oracle 12c backups on Veritas Backup Exec 16.

-
Image
This is a short guide to configuring backups of Oracle 12c using Veritas Backup Exec 16. 1.        Establish trust with Oracle Database server within Backup Exec console and ensure agent is installed. 2.         Create a login to the database for backup purposes in Oracl e; Open up a command prompt and run the following command – Sqlplus / nolog Log in with your database admin account as sysdba Connect myusername / mypassword@databasename as sysdba CREATE USER BACKUP IDENTIFIED BY MYPASSWORD; GRANT UNLIMITED TABLESPACE TO BACKUP; GRANT AQ_ADMINISTRATOR_ROLE TO BACKUP; GRANT DBA TO BACKUP; GRANT CONNECT TO BACKUP; ALTER USER BACKUP DEFAULT ROLE ALL; ALTER USER BACKUP DEFAULT TABLESPACE SYSTEM; 3.        Within the Local Users and Groups section of Computer Management on the Oracle database server, add the backup servers windows domain administrator account to the following groups – a.        ORA_OraDB12Home1_SYSBACKUP b.    
Read more

CUCM 11.5 - Esxi 6.5 - unable to create VM

-
Image
Hi Guys Had an issue where I was unable to deploy a Cisco Unified Call Manager 11.5 OVA to the VMWare Esxi 6.5 standalone server. The following error would appear during the provision of the VM - "At least one extra disk image was provided that will be ignored". The solution to import the Cisco OVA into VMware is to use VMware's OVFTool. The commands I used worked for also UCCX and Cisco Unity Connect - CUCM Deployment for 2500 Users --------------------------------- ovftool --acceptAllEulas --datastore="datastore1" -dm="thick" --name="CUCM01-PUB" --net:"eth0"="Voice" --deploymentOption="CUCM_2500" "c:\temp\cucm_11.5_vmv8_v1.1.ova" vi://UserName:Password@IPAddress UCCX ---- ovftool --acceptAllEulas --datastore="datastore1" -dm="thick" --name="UCCX1" --net:"eth0"="Voice" --deploymentOption="UCCX_400_Agent" "C:\temp\UCCX_11.
Read more