Refer to KB953748 or SQL server books

 

hello

I have a 2 nodes SQL cluster

I need to add another node

and I got an error

http://support.microsoft.com/kb/953748

I installed the third node with the validation cluster (I unchecked some options) to pass the validation cluster option.

Now I can install the SQL in the third node in all instances

Regards

Santos

Read More >>

The operation failed because either the specified cluster node is not the owner of the group or the node is not possible owner of the group

Hi

If you have this error:

"The operation failed because either the specified cluster node is not the owner of the group or the node is not possible owner of the group..."


You dont have installed the SQL services, Exchange Services and so on in this node.

Maybe you have installed a SQL instance in the first node, but you dont have add the second and thrid ... node again.

Regards
Santos

Read More >>

SQL2008 Cluster error. 'RequireKerberos is 1'

Hi

I am installing a SQL 2008 cluster in a 3 node guest cluster.

I had this error:
'RequireKerberos is 1'

I followed this Q to solve the problem
We need to stream SQL 2008 dVD with SP1
http://support.microsoft.com/kb/955392/en-us

sAntos

Read More >>

SCVMM 08 console error

hi

I try to start the SCVMM but it doesnt work.
I am thinking about something, but SCVMM doesnt give me any id error, or another information.

What happens?

My SQL server was down. The databse was there. SCVMM dont advise me.

I start the SQL server, and the SCVMM rus well.

If my SQL was destroy, you need to do:

http://social.technet.microsoft.com/Forums/en-US/virtualmachinemanager/thread/e3a76bb7-e769-482c-9135-49896d764eb9/
1) Backup the database by going to Administrator Console, Administration Page, on right hand side select "Back up Virtual Machine Manager". This will create a SQL backup (.bak) file on your specified location.
2) Uninstall the server
3) Install the server and now point it to the new SQL server location in the install wizard.
4) This will create new database
5) Run scvmmrecover.exe to recover the data from SQL backup (.bak) file created above into the new database.

or
http://social.technet.microsoft.com/Forums/en-US/virtualmachingmgrsetup/thread/ce96c1d3-2d24-46b8-bbea-5753dbdcf29b/
-Backup the database.-Uninstall SCVMM using the "Retain Data" option-Restore Database to new SQL Install.-Reinstall SCVMM using an Existing Database option.


REgards
sAnTos

Read More >>

Peformance SQL 2008 Cluster and Windows 2008 iSCSI SAN

Hi

I setup a Windows 2008 Cluster with SQL 2008 cluster over Equallogic iSCSI SAN.
I switch the node and I lost a ping.

You can read the cmd box. The yellow line is the ping losted.

Yes, Yes. The SQL instance was 13-14 seconds down.

Yes, Yes . The SQL was just installed, so, I havent any database.

I am going to set up this lab with Hyper-V. That is. SQL in Hyper-V machines to measure the performance as well.

I am going to test this lab with a radio database. Xframe is the piece of software that we use in our radio company . I will test the same.

More information in the next post, or by email ;-)

sAntos

Read More >>

Windows 2008 and SQL 2008 in Cluster.

Hi everyone

This lab runs very well.

But, I would like to share some problems to set up this lab:

a) You need .NET Framework 3.5 SP1. If SQL Wizar doesnt launch the setup, you cand installed from the SQL DVD. DVD:\x64\Redist\DotNetFrameworks\dotNetFx35setup
b) Same for Windows Installer 4.5. DVD:\x64\Redist\Windows Installer\x64\Instmsi45
c) You need install Powershell as well from Features console.
d) I got a IP duplicate error. Teredo Tunneling Pseudo-Interface got the guilty.
Verifying that there are no duplicate IP addresses between any pair of nodes.Found duplicate IP address . . . . .

Links that I followed to solve the problem.
http://sqlblogcasts.com/blogs/justinl/archive/2008/08/20/windows-2008-cluster-validation-failure.aspx
http://www.networkworld.com/community/node/29037
http://thesource.ofallevil.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.clustering&tid=2b62061f-c050-4a82-be30-9677de59a2bc&cat=en_us_947fd056-7098-4a44-a742-6c6224603cb1&lang=en&cr=us&sloc=&p=1




set devmgr_Show_Nonpersistent_Devices=1

devmgmt.msc

ncpa.cpl

I switched off the teredo Tunneling ghosted NIC.
I uninstalled the teredo tunneling ghosted NIC.
Device manager NICs and ncpa console must show the same devices.


d) I got a warning about binding NICs.

NOTE: You need to push Alt+N in English or Alt+A to show the advanced menu.
You need to enter in the advanced features and change the binding order.





After these problems, the installation was right.


PS: The Windows 2008 cluster was with a witness share resource and the sQL saves in a iSCSI Equallogic Dell SAN.
sAnTos

Read More >>

Windows Server 2008 R2 and SQL 2008 Cluster Error

hi

Yes, I am very daring.

I was installing Windows Serve 2008 R2 and SQL Server 2008 in Cluster.

Windows Server 2008 R2 was well.
Cluster W2008 R2, was well.
SQL 2008 Clusterd was bad, very bad.

At the end of the process I got this error:

Require Kerberos to value 1

I didn´t find a solution
I think is for Windows 2008 R2.

The same lab over Windows 2008 runs well, very well.

sAnTos

Read More >>

SQL 2008 Cluster. NET Framework 3.5 error

Hi

I am installing SQL 2008 in Host Clustering and Guest Clustering
See: http://santospardos.blogspot.com/2009/01/hyper-v-performance-cluster-hyper-v_08.html

My first fall when I starting to work:
Error: SQL Server 2008 Setup requires Microsoft .NET Framework 3.5 SP1 to be installed.

If the W2K8 is clean (nothing installed), the SQL wizard runs well.

My server belongs a lab environment. The server has many things installed.
I tried to install NET Framework 3.5 SP1 with the installer downloaded from Microsoft Website.
I have NET framework 3.5 in the server and I have the same error. (see picture

Solution:
I installed everything from the DVD bye my self.
DVD:\x64\redist\DotNetFramework\dotNetFX35Setup
DVD:\x64\redist\Windows Installer\x64\INSTMSI45

Santos

Read More >>