Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
MicrosoftArticlesForumsFAQs
C# .NET
VB.NET
Visual Studio .NET
ADO.NET
Xml / Xslt
VB 6.0
.NET CF
GDI+
LINQ
Deployment
Security
FoxPro
Silverlight / WPF
Entity Framework
RIA Services

WebArticlesForumsFAQs
JavaScript
ASP
ASP.NET
WCF

DatabasesArticlesForumsFAQs
SQL Server
Access
Oracle
MySQL
Other Databases

OfficeArticlesForumsFAQs
Excel
Word
Powerpoint
Outlook
Publisher
Money

Non-MicrosoftArticlesForumsFAQs
NHibernate
Perl
PHP
Ruby
Java
Linux / Unix
Apple
Open Source

Operating SysArticlesForumsFAQs
Windows 7
Windows Server
Windows Vista
Windows XP
Windows Update
MAC
Linux / UNIX

Server PlatformsArticlesForumsFAQs
BizTalk
Site Server
Exhange Server
IIS

Graphic DesignArticlesForumsFAQs
Macromedia Flash
Adobe PhotoShop
Expression Blend
Expression Design
Expression Web

OtherArticlesForumsFAQs
Lounge
Subversion / CVS
Ask Dr. Dotnetsky
Active Directory
Networking
Uninstall Virus
Job Openings
Product Reviews
Search Engines
Resumes

 

  View Other C# .NET Posts   Ask New Question  Ask New Question With Power Editor

Invalid object name 'dbo.aspnet_SchemaVersions'.
Tamer Hatoum posted at Saturday, November 07, 2009 4:01 AM

hello :

I am building a new application, I have created the database and created the web.config file , but I am getting this error so I tried to create that 'dbo.aspnet_SchemaVersions' manually but it still the same error. here is my web.config code:

<?xml version="1.0"?>

<configuration>

<appSettings>

<add key="ConnectionString" value="server=myserver;User ID=******;Initial Catalog=****;Password=****;"/>

<add key="OnlineTimeout" value="300"/>

</appSettings>

<system.web>

<compilation debug="true"/>

<roleManager enabled="true" ></roleManager>

<customErrors mode="Off"/>

<authentication mode="Forms">

<forms name=".UserManagementASPXAUTH" loginUrl="~/Login.aspx"/>

</authentication>

<authorization>

<allow users="*"/>

</authorization>

<trace enabled="true"></trace>

<sessionState mode="InProc" timeout="20"/>

<globalization requestEncoding="utf-8" responseEncoding="utf-8"/>

</system.web>

<connectionStrings>

<remove name="LocalSqlServer" />

<add name="LocalSqlServer" connectionString="data source=myserver;Initial Catalog=abiayub_School;User ID=*******;Password=*******;" providerName="System.Data.SqlClient"/>

</connectionStrings>

</configuration>

but I am getting that error

Invalid object name 'dbo.aspnet_SchemaVersions'.

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: Invalid object name 'dbo.aspnet_SchemaVersions'.

Source Error:

Line 5:  
Line 6:  	void Application_Start(object sender, EventArgs e) {
Line 7:  		if (!Roles.RoleExists("Administrators")) Roles.CreateRole("Administrators");
Line 8:  
Line 9:          ChatProvider.Instance = new AspNetChatProvider();


Source File: c:\inetpub\vhosts\abiayubmodel.com\httpdocs\Global.asax    Line: 7

Can anybody help me to get out from that?

Regards..

Reply    Reply Using Power Editor
  Rank Winnings Points
November 0 $0.00 0
October 0 $0.00 0
aspnet_regsql.exe
F Cali provided a rated reply to Tamer Hatoum on Saturday, November 07, 2009 10:11 AM

Refer to step #3 on the following link:

http://msdn.microsoft.com/en-us/library/ms998317.aspx

Create a User Store Database

The SQL Server membership provider stores user information in a SQL Server database. You can create your SQL Server user store manually by using Aspnet_regsql.exe from the command line. Alternatively, you can run Aspnet_regsql.exe in Wizard mode or use the ASP.NET Web Site Configuration tool available on the Website menu in Visual Studio .NET 2005.

To create the user store database

Use Aspnet_regsql.exe to create the membership database. From a Visual Studio 2005 command prompt, run the following command.

aspnet_regsql -S (local) -E -A m

Regards,
SQL Server Helper

Reply    Reply Using Power Editor
How well do you know SQL? Find out with the free test assessment from SQL Server Helper:
http://www.sql-server-helper.com/free-test/default.aspx
  Rank Winnings Points
November 3 $68.00 166
October 0 $0.00 0

re
Web star provided a rated reply to Tamer Hatoum on Saturday, November 07, 2009 11:00 AM

this article describe details about this problem

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

Reply    Reply Using Power Editor
  Rank Winnings Points
November 5 $55.00 134
October 10 $28.00 94

nice
Tamer Hatoum replied to Web star on Sunday, November 08, 2009 3:26 AM

Thank you guys for the links , but my problem is that I am dealing with an hosting company and I dnt have a remote access for the server they have already created   the database.

I thought that there is any configuration I have to make n my web.config.

So I have to contact them . or is there any other way ?

Regards..

Reply    Reply Using Power Editor
  Rank Winnings Points
November 0 $0.00 0
October 0 $0.00 0