Viewing 15 posts - 6,346 through 6,360 (of 9,244 total)
winston Smith (10/22/2011)
Apologies for the relative open-endedness of the question, but im in a bit of a jam. Ive been put on an assignment for a client where i potentially...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 10:31 am
remove the BuiltIn admins group or remove its membership from the Sysadmin role in each sql server instance to impede Windows administrators
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 10:23 am
ananda.murugesan (10/22/2011)
Hi,Database user to become Orphaned User by automatically, whenever mirror database to change the Principal database.
Please suggestion me, how to resolve this issues?
Thanks
ananda
you can either script the logins...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 8:12 am
the setup process has changed totally
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2011 at 4:43 am
kapfundestanley (10/20/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2011 at 4:15 am
philip.nash (10/21/2011)
I'm receiving the following error when trying to set up mirroring on a database.
Database Mirroring login attempt by user 'domain\user.' failed with error: 'Connection handshake failed. The login...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2011 at 4:13 am
instead of stopping services test by interrupting the networking on the principal. You could do this by disabling the network card
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2011 at 4:01 am
there should also be a .log file too with the same name, whats in there?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2011 at 3:53 am
itsamarnath (10/21/2011)
Thanks. Isn't there a need to run setup on node C also and do the manage virtual cluster procedure there?Coz, Our Inst1 is currently not recognized on Node C?
no,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2011 at 3:52 am
itsamarnath (10/21/2011)
Perry Whittle (10/21/2011)
itsamarnath (10/21/2011)
We have 2 instances running Inst1 and Inst2 on these nodes..Both...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2011 at 3:43 am
DMarvez (10/19/2011)
I've read the post on the BuiltIn\Administrator account but can't...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2011 at 3:40 am
be aware that preferred owner is set at the group level, possible owner is set at each resource level
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2011 at 3:32 am
itsamarnath (10/21/2011)
We have 2 instances running Inst1 and Inst2 on these nodes..Both are SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2011 at 3:29 am
high availability is the only mode that can use FailOverPartner as the other modes are manually failed over, with the witness it's automatic and so requires the connection string option...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2011 at 4:21 am
ananda.murugesan (10/20/2011)
please suggestion me, What changes required in ASP web application for database connectivity? whenever modify ALTER DATABASE MyDB SET PARTNER FAILOVER.Thanks
ananda
The instance name in the connection string would obviously...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2011 at 4:09 am
Viewing 15 posts - 6,346 through 6,360 (of 9,244 total)