locked
Could not obtain information about Windows NT group/user 'WIN-0Q2LIEAPT5E\Administrator', RRS feed

  • Question

  • 
    
    
    
    

    I don't want to start over. I spent hours recreating jobs and subscriptions and user accounts.  We had an old Win server 2008 system running sql server 2008r2. We wanted to replace with something newer so we set up a Win server 2012 an installed sql server 2014 on it. We had lots of issues with the old system so I backed up the data bases and restored them on the new one. After I did this I turned off the old system and renamed the new one to the old ones name and changed the ip to the old ones ip.

     Now all the user accounts say the original servers name in the securables "WIN-0Q2LIEAPT5E" and when I try to run ssis packages I get this error. "error code 0x534. [SQLSTATE 42000] 9Error 1504))" . when I try to add the renamed server to the securables I get the error above. Please help save me hours of work.

    

    Jeff Grammer

    Friday, December 30, 2016 11:24 PM

Answers

All replies