|
Home > Archive > MS SQL Server > December 2005 > SQL Server 2005 DB errors out as "Could not find stored procedure
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server 2005 DB errors out as "Could not find stored procedure
|
|
| Sharath Shetty 2005-12-28, 9:23 am |
| Hello All,
I get the below mentioned error
"Could not find stored procedure 'dbo. aspnet_checkschemave
rsion'."
when I try to access a SQL Server 2005 DB from a .NET application.
Anyone has any idea why this error is thrown..
Thanks in advance...
Shar.
| |
| Sharath Shetty 2005-12-28, 11:23 am |
| Dejan Sarka wrote:
> Shar,
>
> My first thought is - do you have the Initial Catalog (or Database) element
> in the connection string? Maybe you use the default database, probably
> master?
>
Hello Dejan,
Thanks for the quick reply. The connection string is as follows
<add name="LocalSqlServer" connectionString="Data
source=BLRIDCTPR187\
SQLEXPRESS;UID=HgAud
itTester;PWD=app;Ini
tial
Catalog=Mercury"/>
As per the connection string the Initial Catalog is defined. Kindly
let me know if any other details are needed
| |
| Sharath Shetty 2005-12-28, 11:23 am |
| Dejan Sarka wrote:
> Shar,
>
> My first thought is - do you have the Initial Catalog (or Database) element
> in the connection string? Maybe you use the default database, probably
> master?
>
Hello Dejan,
Thanks for the quick reply. The connection string is as follows
<add name="LocalSqlServer" connectionString="Data
source=BLRIDCTPR187\
SQLEXPRESS;UID=HgAud
itTester;PWD=app;Ini
tial
Catalog=Mercury"/>
As per the connection string the Initial Catalog is defined. Kindly
let me know if any other details are needed
| |
| Sharath Shetty 2005-12-29, 7:23 am |
| Dejan Sarka wrote:
>
>
> Next idea: is the db collation case sensitive? Can you check the procedure
> name with Management Studio?
>
Hello Dejan,
The stored procedure itself was missing, our counterparts told us
that the version of the DB was a problem and have sent across a script
file with all the Roles, Schemas, Table and Stored Procedures
Below is a brief description of some of the objects that were created
sys.database_principals -- Roles
aspnet_WebEvent_Full
Access - Schema
aspnet_SchemaVersion
s - Table
aspnet_GetUtcDate - Procedure
But now when we try to login,it gives the following error...
The 'System.Web.Security. SqlMembershipProvide
r' requires a database
schema compatible with schema version '1'. However, the
current database schema is not compatible with this version. You may
need to either install a compatible schema with aspnet_regsql.exe
(available in the framework installation directory), or upgrade the
provider to a newer version.
Can you please let us know what is the version problem and what is the
new error that is occuring..
Thanks in Advance.
|
|
|
|
|