Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to change AspNetSQLProvider from SQLExpress to SQL2K.  And why do I get this error?

Posted on 2007-03-19
5
Medium Priority
?
1,006 Views
Last Modified: 2013-12-17
I keep ketting this error when I try to implement the AspNetSQLProvider in the ASP.NET 2.0 Config tab of IIS.

I created an AJAX-exnable web solution (not a web application).  I first created a website (192.168.0.154), and pointed it to the folder that the above soltion was later placed in.

I then went into the ASP.NET 2.0 Tab in IIS, clicked on Global, and entered a connection name and string for LocalSQLServer.  I changed the login management to Forms, pointing to login.aspx page.

In VS2005, I clicked on the ASP.NET Web Application Configuration web page button, and selected the Provider Management link.  I click on the 'single provider' link, and click on test.  I get the following response:

Provider Management  
Successfully established a connection to the database.  

So, I KNOW I have a successful connection for the LocalSQLServer (I DO NOT WANT TO USE SQLEXPRESS.  I am using SQL2K, which is why I changed it).

When I go to click on the 'Security' tab in the ASP.NET Application Provider Configuration web page, I get the following error:

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.


Now, it's obvious that somewhere, this stupid VS2K5 or IIS or something was supposed to populate the database I pointed to with a bunch of asp_membership tables and stored procs--which if obviously DID NOT DO.

So, after searching for about an hour on the web, finding zero answers of anyone that knows how to deal with or fix this problem, I am here to offer an expert 500 big ones to help solve this problem for me.

Thanks in advance for your help.  I wish I had become a plumber instead of a programmer.
0
Comment
Question by:louisiana_blues
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 22

Accepted Solution

by:
DarkoLord earned 2000 total points
ID: 18753350
The database does not get populated automatically. Run the aspnet_regsql.exe from the Visual Studio 2005 Command Prompt and follow the wizard
0
 

Author Comment

by:louisiana_blues
ID: 18753432
Hi DarkoLord. Thanks for responding...

How do I find this 'aspnet_regsql.exe from the Vistual Studio 2005'?  I don't see it anywhere in any menu....could you be more specific?  Thanks...
0
 

Author Comment

by:louisiana_blues
ID: 18753441
Oh. Sorry, I didn't see the 'command prompt'.  But I also don't know how to get a 'visual studio 2005 command prompt' either.  Is that just Start->Run->'cmd'?  I tried that and it said, no program exists...
0
 

Author Comment

by:louisiana_blues
ID: 18753478
Hey darko...

Thanks.  That did the trick!  I had to navigate to the windows\Micorosoft.NET\2.0..... folder

Is there an actual VIsutal Studio Command Prompt?  I've seen it once in my 'recent programs' on my start menu, but it's gone, and I never figured out how it got there in the first place.

I'd truly appreciate it if you could let me know how to go directly to a VS2K5 Command Prompt.  I've already awarded you the points, so you don't have to, but....it's be nice! :)

Thanks again.  An A.
0
 
LVL 22

Expert Comment

by:DarkoLord
ID: 18754733
Hi,

VS 2k5 Command Prompt is usually located in Start -> Programs -> Microsoft Visual Studio 2005 -> Visual Studio Tools -> Visual Studio 2005 Command Prompt

In usage, it's not really different than normal Command Prompt, however it gets open with all necessary environment variables, so you don't have to navigate to those Windows\Microsoft.NET\.... folders manuallly but you can just run the commands directly...
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question