Forum Discussion

Shree2280's avatar
Shree2280
Brass Contributor
Feb 15, 2021

Error number 2812 Store procedure not found

Hi Expert,

 

Have migrated database 'northwind' from Server A to Server B

Server A Configuratioun- ms sql server 2012 developer edition  64 bit  windows nt 6.1  build 9200

Server b configuration -ms sql server 2012 standard edition  64 bit  windownt 6.2  service pack 1 hypervisor

I am able to run the store procedure on server B  exec sp_northwind_test but unable to pull into application getting error

Error number 2812 Store procedure sp_northwind_test not found

 

Regards

Shree

 

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Feb 15, 2021

    Shree2280, is this a theoretical question? Your application uses the old "Northwind" database? And the name of the SP ist "test"?

     

    • Shree2280's avatar
      Shree2280
      Brass Contributor
      Feb 15, 2021

      olafhelper 

       

      No facing issues after db migration .Database is just for an example. no issues with db on  new server but when connecting with .net application getting above error  Error number 2812 Store procedure not found

      • olafhelper's avatar
        olafhelper
        Bronze Contributor
        Feb 15, 2021

        Is your application connecting to the right database on the new SQL Server?

        A login can have a default database, where the login connects first to. Better is to address the database to use in connection string with property "Initial Catalog"; is that property set and this to the right database?

Resources