Error number 2812 Store procedure not found

%3CLINGO-SUB%20id%3D%22lingo-sub-2134724%22%20slang%3D%22en-US%22%3EError%20number%202812%20Store%20procedure%20not%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2134724%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Expert%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20migrated%20database%20'northwind'%20from%20Server%20A%20to%20Server%20B%3C%2FP%3E%3CP%3EServer%20A%20Configuratioun-%20ms%20sql%20server%202012%20developer%20edition%26nbsp%3B%2064%20bit%26nbsp%3B%20windows%20nt%206.1%26nbsp%3B%20build%209200%3C%2FP%3E%3CP%3EServer%20b%20configuration%20-ms%20sql%20server%202012%20standard%20edition%26nbsp%3B%2064%20bit%26nbsp%3B%20windownt%206.2%26nbsp%3B%20service%20pack%201%20hypervisor%3C%2FP%3E%3CP%3EI%20am%20able%20to%20run%20the%20store%20procedure%20on%20server%20B%26nbsp%3B%20exec%20sp_northwind_test%20but%20unable%20to%20pull%20into%20application%20getting%20error%3C%2FP%3E%3CP%3EError%20number%202812%20Store%20procedure%20sp_northwind_test%20not%20found%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EShree%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2134739%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20number%202812%20Store%20procedure%20not%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2134739%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F665447%22%20target%3D%22_blank%22%3E%40Shree2280%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eboth%20collation%20is%20same%26nbsp%3B%20latin1_general_ci_as%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

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

 

5 Replies

@Shree2280 

 

both collation is same  latin1_general_ci_as

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

 

@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

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?

@olafhelper 

 

yes it is connecting to TABLES but not Store procedures

 

<add name="WebService" connectionString="data source=db01_server ;Password=j^^^^^ ;User ID=sTest_a;initial catalog=WebService;integrated security=False;MultipleActiveResultSets=True;" providerName="SQLNCLI11" />