I have successfully gotten the DB on to our SQL 2000 Server and also use Windows Authentication for the Login since this will be going on our Intranet.  My problem is when I try to post an ad I keep getting this error: 

A user instance was requested in the connection string but the server specified does not support this option.
Changed database context to 'master'.
Changed language setting to us_english.

Once again, writing down the problem and walking away from the computer for a little bit helped me fix my own problem.  I had to edit the ASP.NET configuration through IIS Manager to change the db from pointing to the ASPNETDB.MDF to my SQL 2000 Server.  This has fixed the SQL Express error in previous post but has led to new error.  New error is this: 

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: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_Ads_Members'. The conflict occurred in database 'Classifieds', table 'classifieds_Members', column 'Id'.
The statement has been terminated.

Now to fix this one and I should be good to go.  If anyone has any clue as to why this would happen I would like to hear it.  Also FYI, I put the aspnet table into the Classifieds db so I only have to deal with one db vs two...

Thanks

Dean

Hi Dean,

I am trying to use the Classifieds Starter Kit with Sql Server 2005, could you possibly provide me the details how you connected up with SQL 2000.

Thanks,

Martin

Avatar:

Hi Dean,

I am trying to use the Classifieds Starter Kit with Sql Server 2005, could you possibly provide me the details how you connected up with SQL 2000.

Thanks,

Martin

 Martin,

My issues have been numerous since starting to use this product.  But each day a little progress is made.  To get things to work right with SQL 2000, you need to run two of the sql scripts that are in the App_Data directory of your site.  The classifieds-add.sql and the classifieds-categories.sql files need to be run on your SQL server.  After that you need to run the aspnet_regsql.exe that is located in the Windows/Microsoft.NET/Framework/v2.0.50727 directory of your SQL Server (or WINNT) if your are running Windows 2000 or earlier.  When you run the aspnet_regsql file be sure to change the database you are running it against.  I recommend keeping everything in one db for ease of maintenance.  So I ran mine against my Classifieds DB.  After that you just need to change your connection string in the web.config file to point to your SQL 2000 server.  Here is an example of mine:

<connectionStrings>
  <add name="classifiedsConnection" connectionString="Data Source=ServerName;Initial Catalog=DBname;UID=UserID;PWD=Password" providerName="System.Data.SqlClient"/>
 </connectionStrings>

Now this could lead to additional errors if you are trying to run this on an Intranet and using Windows Authentication.  That is where my problem is now.  But hopefully someone will reply to my post from 1 Jun 07 asking for help on that issue.

Hope this helps

Dean