Viewing 15 posts - 5,881 through 5,895 (of 9,244 total)
check your SPNs and enable delegation on the computer account
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2012 at 1:54 pm
whats the date of the oldest history in the msdb?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2012 at 1:47 pm
yes there is impersonation so that when the agent service needs to carry out an admin task it can. However, there is no inheritance, logging into SSMS as the service...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2012 at 1:44 pm
sqlfriends (3/8/2012)
No, it is a member of the NT SERVICE\SQLSERVERAGENT virtual account and is granted minimum permissions needed to be that service account. If YOU set up your domain...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2012 at 1:35 pm
sqlfriends (3/8/2012)
Separate, it is not a windows group. It is actually what they call a Virtual Account. As far as I know, you cannot see which domain users are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2012 at 1:06 pm
sqlfriends (3/8/2012)
windows 2008
did you use group based or SID based security?
The agent and sql service accounts are default sysadmins. Using SID based security secures this and stops people from dropping...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2012 at 1:03 pm
sqlfriends (3/8/2012)
Although I did a lot of research and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2012 at 12:58 pm
nvsqlserver (3/6/2012)
3. than i need to add new instance , than i install instance but i have problem with error 0X80071736
can you post a screenshot of the error?
nvsqlserver (3/6/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2012 at 12:48 pm
You only needed to launch the "configure cluster quorum settings" wizard, select node maj and file share option, supply the new server name and share and this will re configure...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 7, 2012 at 3:01 pm
ramu.a (3/7/2012)
if i change another name : it showing invalid DNS or Wins Name...
What name are you supplying?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 7, 2012 at 5:24 am
Perry Whittle (3/7/2012)
What version of SFW with HA (VCS) do you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 7, 2012 at 1:20 am
ramu.a (3/6/2012)
error: the Sql Server Failover cluster network 'name' is not valid.The name must be a valid...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 7, 2012 at 12:29 am
You have just 2 nodes in the cluster is that correct?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 7, 2012 at 12:23 am
So you have a physical cluster that is clustered using VCS and you want to virtualise it, is that correct?
What version of SFW with HA (VCS) do you have installed?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 7, 2012 at 12:14 am
n_navadehgi19 (3/6/2012)
hi friends...why this script dont act in my sql server2008 , dont remove old backups ,plz help me
which script, have you tried mine posted above?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2012 at 4:02 pm
Viewing 15 posts - 5,881 through 5,895 (of 9,244 total)