Viewing 15 posts - 16 through 30 (of 71 total)
If you actually did change the authentication mode to mixed mode, entered a new password for sa and then restarted SQL Server, this has to work.
So something must have gone...
December 11, 2013 at 7:24 am
right.
Filtering Auditing was added in SQL 2012.
December 3, 2013 at 1:50 pm
Are aou rally talkin about DTS?
For SSIS that user needs to be in a certain (ssis-)role, to be allowed to store packages in msdb.
No special risk there afaik
November 8, 2013 at 6:08 am
In the title of this thread it also says "system databases".
This does in fact work a little different and not all by simply "MOVE FILE".
November 5, 2013 at 7:10 am
dp75 (10/22/2013)
He requires to only view the server properties, and database properties of all databases on the server.
The real problem are the database properties.
If you are refering to the properties...
October 22, 2013 at 11:32 am
shafibinyunus (8/28/2013)
NO SQL 2014 CTP CAN ONLY BE INSTALLED ON X64 BIT..
right
32 bit is dead
but: I happily noticed this topic to be the only one under "Administration - SQL Server...
October 22, 2013 at 6:14 am
Allow me to ask: what is this doing in SQL Server 2014 Administration?
October 22, 2013 at 6:11 am
hanrahan_tim (10/12/2013)
Andreas.Wolter (10/10/2013)
hanrahan_tim (10/9/2013)
Hello,...
Using Windows Groups instead of individual Logins is indeed a recommended practice
Authenticated Users would work, if you really want ALL AD Users being able to Access SQL...
October 12, 2013 at 8:53 pm
schleep (10/11/2013)
I'm wondering if it is possible to map multiple Windows groups logins to a single database user (which is in fact a group)?
Scenario:
DomainA\Agents
DomainB\Agents
each have logins. I would like...
October 12, 2013 at 9:59 am
hanrahan_tim (10/9/2013)
...
My thought is to use an AD account like "authenticated users" and use this for logins so all company users get a login. I would then use specific AD...
October 10, 2013 at 9:52 am
You should still be able to DENY CONNECT to that Group...
October 7, 2013 at 1:40 pm
Great Insights, Paul.
- See you at your PreCon at PASS Summit
😉
September 30, 2013 at 12:14 pm
Hmm. I like the idea of the audit feature, would this be the "C2 audit tracing?" If so, there was a note from a previous DBA that they...
September 27, 2013 at 11:56 am
jasona.work (9/26/2013)
Is there a way to determine, when an account attempts to open a DB and fails, which DB it was trying to open?Possibly via a server-side trace?
...
If you are...
September 26, 2013 at 4:23 pm
Viewing 15 posts - 16 through 30 (of 71 total)