I have tried creating the ASPNETDB using the admin tool but when i click the 'Security' tab i get the error:

 Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'

I have also tried running 'ASPNET_REGSQL.exe but it cannot find any database on my server!

How do I assign a database to SQLEXPRESS 2005? When I use the configuration tool I cant see ASPNETDB or CLASSIFIEDSDB.

 PLEASE HELP ME !!

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

check that.

thanks for the link but Ive checked this link already and it didnt work for me.

I can get the GUI up when I run the aspnet_regsql command but it cant find any databases in the drop down box, and doesnt seem to recognise my sqlexpress server ( mycomputername\SQLEXPRESS )

Any ideas how to get the databases to show in the dropdown?

I've been reading up and I think the reason regsql.exe is not working is because I created the classifieds site in Visual Studio 2005 but Im using SQLEXPRESS. I think I should be using Visual Web Developer ? or use SQL 2000 with Visual Studio? thoughts?

I Hhave removed SQLEXPRESS and installed SQL Server 2000. Can I use SQL 2000? If so, what adjustments do I need to make to the app? webconfig?

KevinMaguire:

I Hhave removed SQLEXPRESS and installed SQL Server 2000. Can I use SQL 2000? If so, what adjustments do I need to make to the app? webconfig?

My suggestion to you is.

1. Go to your Visual Studio or Visual Web Developer Installer.
2. Run it.
3. Select Repair Installation.
4. Once completed Restart your System.
5. Try running your application again.

Hope that helps you out.

 yes actually i was going to suggest repairing as well. I do not think it would matter if you used either VS or Visual web developer.

Thanks guys for the replys.. I thought id try anything at this stage so I slapped the SQL 2000 back on to give it a go! At my witts end! I could not for the life of me get SQLEXPRESS to show CLASSIFIEDSDB nor could I get ASPNETDB created... As far as I know these have to show as a database on the server, yes?

Ill try the repair option,,, Ill reinstall SQLEXPRESS first though... if you have any suggestions on how to get SQLEXPRESS to show my databases please let me know. Do I have to create a blank database with the name 'CLASSIFIEDSDB' and run the SQL scripts in APP_DATA? I wouldnt have thought so though as its been created already.

I also followed the link to that other guys page showing how to run and use the ASPNET_REGSQL.exe but still no luck - My SQLSERVER wont connect and no databases show up.

 Feel free to reply !!!! :)

thanks again

Kevin

Hello again lol

First off it is hard to get ya head around all the features of VWD and VS but it is important that you know that once installed everything is there to get started.

• You install VS or VWD
• You install the starter kit
• You then press F5 or Debug from the main menu
• VWD and VS both automaticlly look for your database.mdf file in your App_Data folder (does not happen on production servers)
• VWD and VS will automatically conect these .mdf's to SQL on App_Start

That is it. If you are having problems you may have the BETA version of the starter kit witch has been proven a DUD full of bugs.

Let me know how you get on. I may have to send you the last release of the kit becuase it would seem the faulty version is still avaliable for download and no way to get the previous release's..

hi, he he.. thanks for the prompt reply..

Not sure how to check if I have the BETA version, but ill try and check this out.. if you know a way I would appreciate it :)

If you do want to forward me the last release you can send to MY EMAIL ( which i sent you ) or you can put the link in here....

thanks!

I must appoligise I cant find WinZip installed any where on vista so i could not compress the file. I hope you have fast internet haha.

Um before you put the file on your computer I suggest doing your best to issolate or remove the version you have from your system to prevent any mix ups.

Let me know how it goes for you.

Oh and a wee note, If you dont want spam filling your email inbox I would suggest removing your address from the forum as asp.net is searched by allot of email seeking robots/indexer's. You can allways send prrivate messages from the wee panel on the left

thanks.... :) will let u know how it goes!

Thanks SpiderMaster, that worked a treat.

The version I got off the ASP.net website though was just over a mb. Did they not update this then ? The version on the website must be dodgy?

 thanks