Viewing 15 posts - 5,881 through 5,895 (of 9,253 total)
sqldba.today (3/9/2012)
March 9, 2012 at 8:55 am
Because attaching\restoring the reporting databases to the 2008 R2 instance will upgrade the database structure but the internal SSRS structures will not. It is a known issue with SSRS upgrades,...
March 9, 2012 at 12:33 am
Baabhu is probably going along the right path here. Do you have a maintenance plan on place on this server that rebuilds indexes and maybe shrinks files too?
March 9, 2012 at 12:25 am
Which hypervisor are you using?
March 9, 2012 at 12:19 am
What account are the services for each insurance running under?
Have you checked the SPNs for each instance?
March 9, 2012 at 12:14 am
ok start by trimming the backup history but dont use getdate(0 -30 cos that will try and delete all history and possibly consume the server. Purge the history in stages...
March 8, 2012 at 2:20 pm
check your SPNs and enable delegation on the computer account
March 8, 2012 at 1:54 pm
whats the date of the oldest history in the msdb?
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...
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...
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...
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...
March 8, 2012 at 1:03 pm
sqlfriends (3/8/2012)
Although I did a lot of research and...
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)
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...
March 7, 2012 at 3:01 pm
Viewing 15 posts - 5,881 through 5,895 (of 9,253 total)