I have SQL Server 2005 and Vs 2005.I Have done every steps to install TimeTracker to work with its TimeTracker.mdf:1)
In SQL Server 2005 : attach db TimeTracker.mdf.2) In C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ aspnet_regsql.exe,
I click on this to set the DB TimeTrakcer with my SQL server 2005 Windows Authentification3) In Web.config,
here is what I used :<connectionStrings><addname="aspnet_staterKits_TimeTracker"connectionString="Initial
catalog=TimeTracker;server=MyServer;AttachDBFileName=|DataDirectory|TimeTracker.mdf;uid=;pwd=; Trusted_Connection=True"providerName="System.Data.SqlClient"/><removename="LocalSqlServer"/><addname="LocalSqlServer"connectionString="server=MyServer;uid=;pwd=;
Trusted_Connection=True"/></connectionStrings><membership><providers><removename="AspNetSqlMembershipProvider"
/><addname="AspNetSqlMembershipProvider"type="System.Web.Security.SqlMembershipProvider,
System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"connectionStringName="LocalSqlServer"enablePasswordRetrieval="false"enablePasswordReset="false"requiresQuestionAndAnswer="false"applicationName="/"requiresUniqueEmail="false"minRequiredPasswordLength="6"minRequiredNonalphanumericCharacters="0"passwordFormat="Hashed"maxInvalidPasswordAttempts="5"passwordAttemptWindow="10"passwordStrengthRegularExpression=""
/></providers></membership>4) I succeed
to access the first page TimeTracker’s login. But when I tried to create the user and click on the button Create User, I always get this error message:
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:
System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack
trace below.
....Many
posts about this message error Dbo_AspNet_CheckSchemaVersion, but none of them helped to resolve my problem. I don't know what I'm doing wrong.CAN
SOMEONE HELP ME PLEASE??Thanks before hand!Olivier
Thanks for replying to me. I'`m really appreciated.
As I mentionned in the earlier message, I had done every steps. Your suggestion about aspnet_regsql was in the step 2) that I executed and it recognized the TimeTracker DB that's why I can login to the login page. Again, here were my steps :
1) In SQL Server 2005 : attach db TimeTracker.mdf.
2) In C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ aspnet_regsql.exe, I click on this to configure DB TimeTrakcer with my SQL server 2005 Windows Authentification
3) In Web.config, here is what I used :<connectionStrings><add ...
4) I succeed to access the first page TimeTracker’s login.
But when I tried to login as User ("Manager") and password ("1.manager.1.") OR to create the user and click on the button Create User , I always get this error :
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
One thing that I checked in SqlServer 2005 Management Studio, in TimeTracker DB :
select
*
from aspnet_Applications;
select
*
from aspnet_Membership;
select
*
from aspnet_Paths;
select
*
from aspnet_PersonalizationAllUsers;
select
*
from aspnet_PersonalizationPerUser;
select
*
from aspnet_Profile;
Select
*
from aspnet_roles;
Select
*
from aspnet_starterkits_ProjectCategories;
Select
*
from aspnet_starterkits_ProjectMembers;
Select
*
from aspnet_starterkits_Projects;
Select
*
from aspnet_starterkits_TimeEntry;
Select
*
from aspnet_Users;
Select
*
from aspnet_UsersInRoles;
Select *
from aspnet_WebEvent_Events;
All the tables ABOVE have no rows i.e empty, besides the table below has 6 rows affected:
Select
*
from aspnet_SchemaVersions;
Result:
Feature CompatibleSchemaVersion iscurrenVersion
Common 1 1
health monitoring 1 1
etc
.
Do you think that it's because all the tables (besides
SchemaVersions) are empty, even the aspnet_Users is empty???
olivier2008
0 Points
2 Posts
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
Feb 29, 2008 04:12 PM|LINK
Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
Source Error:
Timetracker
chetan.sarod...
All-Star
65749 Points
11148 Posts
Re: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
Mar 03, 2008 02:46 AM|LINK
In Time Tracking System, it uses inbuild Membership classes for user creation, updation etc..
You have to register your DB with ASP.NET Membership classes by executing the command line utility in VS prompt
aspnet_regsql, it will open one window, where you have to configure DB.
Hope it will help you, let me know.
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.
olivier2008
0 Points
2 Posts
Re: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
Mar 03, 2008 06:43 PM|LINK
Hi Chetan,
Thanks for replying to me. I'`m really appreciated.
As I mentionned in the earlier message, I had done every steps. Your suggestion about aspnet_regsql was in the step 2) that I executed and it recognized the TimeTracker DB that's why I can login to the login page. Again, here were my steps :
1) In SQL Server 2005 : attach db TimeTracker.mdf.
2) In C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ aspnet_regsql.exe, I click on this to configure DB TimeTrakcer with my SQL server 2005 Windows Authentification
3) In Web.config, here is what I used : <connectionStrings> <add ...
4) I succeed to access the first page TimeTracker’s login. But when I tried to login as User ("Manager") and password ("1.manager.1.") OR to create the user and click on the button Create User , I always get this error : Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
One thing that I checked in SqlServer 2005 Management Studio, in TimeTracker DB :
select
* from aspnet_Applications;select
* from aspnet_Membership;select
* from aspnet_Paths;select
* from aspnet_PersonalizationAllUsers;select
* from aspnet_PersonalizationPerUser;select
* from aspnet_Profile;Select
* from aspnet_roles;Select
* from aspnet_starterkits_ProjectCategories;Select
* from aspnet_starterkits_ProjectMembers;Select
* from aspnet_starterkits_Projects;Select
* from aspnet_starterkits_TimeEntry;Select
* from aspnet_Users;Select
* from aspnet_UsersInRoles; Select * from aspnet_WebEvent_Events;All the tables ABOVE have no rows i.e empty, besides the table below has 6 rows affected:
Select
* from aspnet_SchemaVersions;Result:
Feature CompatibleSchemaVersion iscurrenVersion
Common 1 1
health monitoring 1 1
etc
.Do you think that it's because all the tables (besides SchemaVersions) are empty, even the aspnet_Users is empty???
What should I do with these empty tables??
Thanks in advance!
Timetracker
chetan.sarod...
All-Star
65749 Points
11148 Posts
Re: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
Apr 03, 2008 03:24 AM|LINK
Refer this
http://forums.asp.net/p/1006383/2027646.aspx
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=435748&SiteID=1
http://forums.asp.net/t/999489.aspx?PageIndex=1
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.