Viewing 15 posts - 1 through 15 (of 149 total)
Do you have a "dummys" version instructions on how you setup the startup procedure?
I've been out of SQL mgmt for a while and getting back into it.
I found this:
June 17, 2022 at 11:43 pm
Thanks, I will give this a try this week.
June 16, 2022 at 8:54 pm
Windows Server Failover Cluster and SQL Failover Cluster Instance.
May 16, 2022 at 11:48 pm
My post already states the....
"Local hosts file has the principle and mirrors IP and NetBIOS name and fqdn.".
March 11, 2015 at 10:45 am
Hmmm...
Will this work????
CREATE TRIGGER [connection_trigger]
ON ALL SERVER WITH EXECUTE AS '...'
FOR LOGON
AS
BEGIN
IF EXISTS = (SELECT ORIGINAL_LOGIN_NAME FROM sys.dm_exec_sessions WHERE database_id = 11 AND ORIGINAL_LOGIN_NAME = 'mydomain\prefix-MV-purpose$')
ROLLBACK;
END;
GO
ENABLE...
March 19, 2014 at 4:36 pm
yup, that was it. Upon creation, <default> meant the account I was logged in as.
Thanks
October 22, 2013 at 12:02 pm
Check to make sure the account that SQL runs as has full NTFS permissions to that folder.
I know you are just putting a "Test" DB in there but the fact...
October 22, 2013 at 11:16 am
PaulB-TheOneAndOnly (10/27/2011)
Weekend pages are part of our job or as one of my bosses used...
October 27, 2011 at 11:46 am
PaulB-TheOneAndOnly (10/27/2011)
This is a large organization, isn't it?
Yes, over 5000 employees and over 50 SQL Servers (not counting the ones I already manage.) and some clusters in an "Undisclosable Government...
October 27, 2011 at 11:35 am
What was the reason for the SQL Server Admin to be locked out? Seems rather counter productive. If you're going to be in charge of all that "Sensitive Data" why...
October 27, 2011 at 11:22 am
OK, figured it out.
Here's the KB: http://support.microsoft.com/kb/2494447
Apparently when you do an inplace upgrade it still references the object "/images/blank.gif ".
After beating this around for a while, a co-worker...
August 26, 2011 at 2:34 pm
SQL is licensed per Physical CPU. How many physical CPU's do you have?
Also, in order to be able to REALLY take advantage of virtualization, you might want to purchase Windows...
August 26, 2011 at 2:22 pm
For what it's worth, here's the reportserver.config security segment...
<Authentication>
<AuthenticationTypes>
<RSWindowsNegotiate/>
<RSWindowsNTLM/>
</AuthenticationTypes>
<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
<EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>
Does the order of these make a difference?
<RSWindowsNegotiate/>
<RSWindowsNTLM/>
Unchecking the IE setting "Enable Integrated Windows......" works but most of the reports we have...
August 24, 2011 at 10:09 am
Viewing 15 posts - 1 through 15 (of 149 total)