Viewing 15 posts - 376 through 390 (of 972 total)
Those are system generated when SQL Server is installed. I would not change the password to those accounts. I cannot get to my instance of SQL 2008 at the moment...
April 11, 2011 at 8:02 am
I do have one question for you....do you know what URL you are at?
Asking for dumps for a certification test...not a good way to start off on this forum.
If you...
April 7, 2011 at 11:21 pm
Your DECLARE statement for @schema is mis-spelled...so it does not recognize the other lines of code that reference @schema.
April 7, 2011 at 9:25 pm
First: I would take your email address out of the post. If you need someone to email you they can do so through SSC forum tools, it will send it...
April 7, 2011 at 9:14 pm
Well it will try to write to each file equally but if it turns out that somehow File1 gets to say 50% free space on it and File2 and File3...
April 7, 2011 at 8:18 am
If it is within one filegroup then the SQL Server will stripe data across those files proportionally. Meaning based on the free space left in each file it will write...
April 7, 2011 at 7:49 am
If you your primary servers goes down and you restore the recent backup to the secondary, how does the application know to switch over to the secondary database server?
April 6, 2011 at 10:03 am
Security in a database is usually handled by creating Windows groups and then add those to database roles in SQL Server that control what access/permissions are allowed in the database.
The...
April 6, 2011 at 9:59 am
What security are you referring to? The application accounts that SharePoint 2007 requires or user accounts?
April 6, 2011 at 8:26 am
Do you know all the paths to all the folders the old account has access to?
I use PowerShell to verify permissions on a server for both troubleshooting and security checks:
$a...
April 5, 2011 at 9:50 am
AVB (4/4/2011)Is there any way to allow a user to reset a password without "Control Server/Sysadmin" Permissions?
Well I did not catch this but if you try the command without the...
April 4, 2011 at 8:05 am
I would worry about number 2 before I address number 1. The SQL Server error logs and Windows Application Event Logs should give you some information on what or why...
April 4, 2011 at 7:54 am
To give fair warning on what permission you just gave to that login, CONTROL SERVER is the equivalent of having sysadmin role.
Brian Kelly wrote up a good article on SSC...
April 1, 2011 at 3:13 pm
You would need to execute this command for the login that needs the permission, which I take it would be User2:
GRANT CONTROL SERVER TO [User2]
April 1, 2011 at 2:35 pm
Well to do as your command is showing "CHECK_POLICY=OFF", you will need to also grant the login CONTROL SERVER permissions. This should allow the login to set MUST_CHANGE, CHECK_POLICY, or...
April 1, 2011 at 2:13 pm
Viewing 15 posts - 376 through 390 (of 972 total)