Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Other SQL Server 2012 Topics
 Azure and Stored Procedures

Author  Topic 

cjsantora
Starting Member

2 Posts

Posted - 2014-07-03 : 16:17:09
We are currently trying to deploy an application to the Azure Cloud Service. Once the database was copied over I tried to run the application and it continues to fail with the message "Cannot find stored procedure XXX". The stored Procedure is there, I even removed and recreated it to avoid some type of permission errors.

If anyone else has run into this and has some advice I would appreciate the pointer.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-07-03 : 16:37:05
Could it be a case sensitivity issue? Or owned by the wrong schema?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

cjsantora
Starting Member

2 Posts

Posted - 2014-07-04 : 07:24:12
Thanks for the quick reply and although I am far from a newbie, I made a newbie mistake. I neglected to enter the database name in the connections string and I believe he application was trying to talk to Master.

It has been resolved with some humility.

Thanks
Carmen
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-07-05 : 16:51:59


Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -