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-c...
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 adminis...
Read more

Configuring Cisco CME Voice Gateway (VG) for incoming and outgoing calls using Sipgate trunk

-
Image
Hi All For my reference and your's, here is a working sample configuration for configuring sipgate (sipgate.co.uk) for incoming and external VOIP calls on a 2800 series Cisco router. Using GNS3; My wireless adapter has internet connection sharing enabled, and I have created a loopback adapter which is the 'internet' adapter as you can see below. I have tested making calls using Cisco's CIPC version 8 and receiving calls. This doesn't have to be done in GNS3, just pick up yourself a real voice gateway. version 12.4 service timestamps debug datetime msec service timestamps log datetime msec no service password-encryption ! hostname VG-EP ! boot-start-marker boot-end-marker ! ! aaa new-model ! ! aaa authentication login http local aaa authentication login ssh local aaa authorization exec http local ! aaa session-id common ! resource policy ! memo...
Read more