Anmelden
 
HomeLibraryDownloadsSupportWebcasts & EventsCommunityForenBlogs
Ressourcen für IT-Professionals >
> 
> 
accessing database with SQL Server Management Studio

Frage accessing database with SQL Server Management Studio

  • Dienstag, 1. Mai 2012 21:49
     
     
    Anmelden
    0

    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.

     

Alle Antworten

  • Mittwoch, 2. Mai 2012 17:43
    Moderator
     
     
    Anmelden
    0

    SQL 2008 enforces rights so domain admins just cant walk into database servers

    You need to stop the DPM and follow 

    http://msdn.microsoft.com/en-us/library/dd207004(v=sql.105).aspx

    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
     
     
    Anmelden
    0

    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
    Source:        MSSQL$MSDPM2010
    Date:          5/4/2012 10:05:28 AM
    Event ID:      18456
    Task Category: Logon
    Level:         Information
    Keywords:      Classic,Audit Failure
    User:          OURDOMAIN\username
    Computer:      DPM.domainname.com
    Description:
    Login failed for user 'OURDOMAIN\usernam'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="MSSQL$MSDPM2010" />
        <EventID Qualifiers="49152">18456</EventID>
        <Level>0</Level>
        <Task>4</Task>
        <Keywords>0x90000000000000</Keywords>
        <TimeCreated SystemTime="2012-05-04T14:05:28.000000000Z" />
        <EventRecordID>3383</EventRecordID>
        <Channel>Application</Channel>
        <Computer>DPM.domainname.com</Computer>
        <Security UserID="S-1-5-21-523244613-396842660-5522801-17651" />
      </System>
      <EventData>
        <Data>domainname\username</Data>
        <Data> Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors.</Data>
        <Data> [CLIENT: &lt;local machine&gt;]</Data>
        <Binary>184800000E0000000E000000440050004D005C004D005300440050004D0032003000310030000000070000006D00610073007400650072000000</Binary>
      </EventData>
    </Event>

     
  • Dienstag, 22. Mai 2012 14:08
     
     
    Anmelden
    0
    Is someone going to reply to this?