Dienstag, 1. Mai 2012 21:49
OK, I know during installation two accounts were created with a password I supplied and at least one of these can be used to access the SQL server using SQL Server Management Studio. But just for now let's assume I don't have that password and will never be able to get it.
I try to access it with my domain admin account (windows authentication), both my own and THE domain administrator, and I get "Login failed for user 'domain\username'. (Microsoft SQL Server, Error: 18456)"
But using a 3rd party backup software (SQLBackupAndFTP), and the same windows authentication, I have no problem connecting to the SQL server and accessing the database. At least enough to do backups and recoveries.
Mittwoch, 2. Mai 2012 17:43Moderator
SQL 2008 enforces rights so domain admins just cant walk into database servers
You need to stop the DPM and follow
the above procedure , sql in single user mode allows you to logon with a local administrator member and then you can set permissions.
SQL 2008 R2 is free for use with DPM after the new license changes so i would use that over a express instance
Freitag, 4. Mai 2012 14:12
Tried it with both the -m and -f options, still can't get in. The user is a member of the local admin group. Getting the following in the eventlog;
Log Name: Application
Date: 5/4/2012 10:05:28 AM
Event ID: 18456
Task Category: Logon
Keywords: Classic,Audit Failure
Login failed for user 'OURDOMAIN\usernam'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]
<Provider Name="MSSQL$MSDPM2010" />
<TimeCreated SystemTime="2012-05-04T14:05:28.000000000Z" />
<Security UserID="S-1-5-21-523244613-396842660-5522801-17651" />
<Data> Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors.</Data>
<Data> [CLIENT: <local machine>]</Data>
Dienstag, 22. Mai 2012 14:08Is someone going to reply to this?