Forum Discussion
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 ...
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?
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" />