restore NT\Ntework Service

• Hadrian

  Hall of Fame

  Points: 3742

  More actions

  March 30, 2006 at 5:36 am

  #103134

  Hi,

  I restored a SQL server 2000 database on other server MSSQL 2000(test $ prod),but I noticed severe problems with account NT Authority\Network Service,applications which use this account don't success to log into MSSQl.(CRM Windows app)

  I had only Windows auth,and the only orpahn users is dbo.Please help me.

   

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738589

  More actions

  April 3, 2006 at 9:03 am

  #630438

  There might be orphaned users with the restore. sp_change_users_login will fix that.

  Check and see if any of your users in the db are not mapped to logins and then use the above procedure to remap them.