Viewing 15 posts - 1,996 through 2,010 (of 9,244 total)
Joy Smith San (6/24/2015)
setspn -S MSSQLSvc/[sqlinstance] [domain]\[svcaccount]
I was running exactly the same command. Then it gave the message "Updated SPN...." but still logging this error in errorlog and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2015 at 7:15 am
Arthur.Bojilov 1605 (6/24/2015)
I hope you can help with the installation of SQL Server 2008R2 on Server 2012.
Here is my setup.
I am migrating a SQL 2008R2 two node physical cluster...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2015 at 7:11 am
nzone7x (6/24/2015)
Our environment has 4 nodes clustered, I do not know what you call the topology.
the technology is known as Failover Clustering
nzone7x (6/24/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2015 at 7:08 am
Joy Smith San (6/24/2015)
I installed two node sql server cluster annd during installation I configured for both IPV4 and IPV6.
I can see the below messages logged in sql server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2015 at 7:02 am
which versions of sql server are you moving between?
This is my script I use but wont work from sql2008 -> sql 2012 as the encryptor changed
SET NOCOUNT ON
SET CONCAT_NULL_YIELDS_NULL OFF
DECLARE...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2015 at 5:59 am
Joy Smith San (6/25/2015)
Able to access SQL Server cluster with "virtual IP,1433" from a remote application server.
But it fails with the error "Server does not exist" when tried with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2015 at 5:52 am
alex_fajardo2002 (6/23/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 24, 2015 at 9:39 am
Joy Smith San (6/20/2015)
Joie Andrew (6/19/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 6:00 am
hari.devadas 4119 (6/18/2015)
Perry,We evicted Node 02 from the SQL 2008 Clusterand now on course for testing the P2V on Node 01 now.
Why on earth have you done that at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 5:58 am
where is the storage presented from?
have you checked the LUNs are properly exposed to both ESX hosts
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 5:48 am
charipg (6/17/2015)
restore is failing with below error.Msg 60004, Level 16, State 1, Line 0
Error starting process 'C:\Program Files\Quest Software\LiteSpeed\SQL Server\engine\SqlLiteSpeed.exe', Error: 0x3
not getting any idea.any suggestion pls.
Run a repair...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 5:45 am
dan-404057 (6/22/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 5:39 am
alex.sqldba (6/22/2015)
Read Only Routing URLS are configured as follows:Ireland\Primary tcp://Ireland.dom.local:49891ALL
Ireland\Secondary tcp://Ireland.dom.local:49841ALL
This is only a small part of the config required, please supply the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 5:09 am
there are cluster updates between 2012 and 2012 R2, if it's a cluster then definitely 2012 R2
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 5:04 am
either use failover cluster manager or the following PowerShell command
Get-ClusterResource | ?{$_.resourcetype -EQ "IP Address"} | ft OwnerNode,State,Name,OwnerGroup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 5:03 am
Viewing 15 posts - 1,996 through 2,010 (of 9,244 total)