SQL Server 2005 DB errors out as "Could not find stored procedure

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.

Dejan Sarka  wrote:
> Shar,
>
> My first thought is - do you have the Initial Catalog (or Database) elemen
t
> 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

Dejan Sarka  wrote:
> Shar,
>
> My first thought is - do you have the Initial Catalog (or Database) elemen
t
> 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

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.