Viewing 15 posts - 181 through 195 (of 6,105 total)
Don't do this!
It worked because by default Domain Admin members are members of the local Administrators group. The local Administrators group I believe has logon as service rights. The easiest...
June 15, 2011 at 1:20 pm
SQL Server doesn't support the User Principal Name format (user@domain) only the down-level domain format (domain\user) internally. When you use Configuration Manager I believe it tries to verify the Windows...
June 15, 2011 at 1:14 pm
GilaMonster (6/13/2011)
NT AUTHORITY\SYSTEM represents the system of the host machine and is the one that typically has sysadmin rights...
June 13, 2011 at 7:54 am
GilaMonster (6/13/2011)
Services (like IIS) shouldn't use NT AUTHORITY\SYSTEM (localsystem) as that means they only have permission locally. It's probably a default installation setting, but it's a bad one....
June 13, 2011 at 7:52 am
I don't believe we've had that issue. However, we're typically connecting from remote. Do you mean when you're on the server and try to start up SSMS or do you...
May 31, 2011 at 12:53 pm
SELECT INTO creates a table. The groups don't have the permission to create a table, is my guess. But that's not something you usually give out. Does using the temporary...
May 31, 2011 at 8:57 am
You should be able to drop the registry monitoring because the error being returned is it can't write to the log file. You should be able to filter further so...
May 31, 2011 at 8:55 am
Are you using double quotes for your quoted identifiers? With default settings for connections, this should work just fine (as others have used it).
May 27, 2011 at 6:54 am
Linq is created by developers for developers. Don't expect DBA level thinking in it. This isn't unusual. As a DBA I just recently took the SharePoint 2010 Installation and Configuration...
May 26, 2011 at 12:15 pm
Yes, I wrote an article on this:
Retrieving SQL Server Fixed Server Roles for Disaster Recovery
May 26, 2011 at 12:11 pm
Don't go the SID route, because they're right. You can, however, create username/passwords on the web server and the SQL Server that are identical. These would be local, not domain...
May 26, 2011 at 12:09 pm
Tara-1044200 (5/24/2011)
After creating the trigger as you gave, i coulnd not connect to the instance, the trigger is kicking out any login to access the server.
Log on to the server...
May 24, 2011 at 7:23 pm
Did you leave ROLLBACK in? If so, this kills the connection and would explain why the login fails.
May 24, 2011 at 11:00 am
MHilsher (5/24/2011)
Thanks for asking. To Clarify the Event Id(s) given above where from the OS Security log. The Error Message numbers that we get in the SQL log...
May 24, 2011 at 10:58 am
Michael Valentine Jones (5/24/2011)
If you are getting "SSPI handshake failed" errors, have you created SPNs for the database server?
SPNs aren't the issue here. Because there are not in the same...
May 24, 2011 at 10:50 am
Viewing 15 posts - 181 through 195 (of 6,105 total)