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.
| Author |
Topic |
|
lakhva
Starting Member
22 Posts |
 Posted - 2005-03-31 : 03:12:40
|
| Hi,I did successful restore of database on my development server from the back up of production database.NOw none of the ASP pages are working. Whereever there is a call to the database by a stored procedure i'm getting the follwing error message.Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'storedproceure_name'. I did this restore with my user name and password. I thought it might be related to permission issue so I also changed database owner to "SA" but still no change. I"m still getting the same error message. Any suggestios? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-03-31 : 03:54:27
|
| Really basic question...can you see the SP's in the restored database using EM?Really basic question...are you hitting the right database? |
 |
|
|
lakhva
Starting Member
22 Posts |
Posted - 2005-03-31 : 11:10:51
|
| Yes I can see all SP using EM. Before the restore I was hitting the same database and i've not changed any DSN or data connection code. All i did was to restore the database with the current data from production. |
|
|
|
lakhva
Starting Member
22 Posts |
Posted - 2005-04-01 : 00:18:43
|
| Hi,Default database of the ASP account was master and that was the problem. I changed the default database and Its working perfectly now.Thanks for helping me out. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-04-01 : 04:40:58
|
| yea.....userid issues are one of the post-restore tasks that need to be ticked off! |
|
|
|
|
|
|
stored procedure not found after restore