SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Other SQL Server 2012 Topics
 Azure and Stored Procedures
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cjsantora
Starting Member

USA
2 Posts

Posted - 07/03/2014 :  16:17:09  Show Profile  Reply with Quote
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

USA
37157 Posts

Posted - 07/03/2014 :  16:37:05  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
2 Posts

Posted - 07/04/2014 :  07:24:12  Show Profile  Reply with Quote
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

USA
37157 Posts

Posted - 07/05/2014 :  16:51:59  Show Profile  Visit tkizer's Homepage  Reply with Quote


Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000