Error 2812 : Unable to create new login or resest login password

• neellotus07

  Ten Centuries

  Points: 1245

  More actions

  September 26, 2017 at 12:09 am

  #323750

  Hello Experts,

  I physically moved My M.S. SQL Server 2000 from one location to another location (like Delhi to Chandigarh) and also changed IP. Now my application is working fine in my local or remote network with existing users and their password but i am unable to create new user and resest existing user's password.

  Now i am getting error like "Could find stored procedure 'master.dbo.sp_addlogin'. (Microsoft SQL Server, Error: 2812)" while creating new SQL server authentication based user.

  And getting error "Could find stored procedure 'master.dbo.sp_password'. (Microsoft SQL Server, Error: 2812)" during changing user password.
  Pls help me.. to get resolve this issue.

  Thanx
  neel

• Thom A

  SSC Guru

  Points: 99126

  More actions

  September 26, 2017 at 3:30 am

  #1960912

  I assume you're logged in with an account with sufficient privileges to create and/or change a login?

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk