Trying to get Classifieds up and running on intranet W2K3 server using real SQL2005 database

Last post 05-15-2008 11:40 AM by BrianRoden. 0 replies.

Sort Posts:

  • Trying to get Classifieds up and running on intranet W2K3 server using real SQL2005 database

    05-15-2008, 11:40 AM
    • Loading...
    • BrianRoden
    • Joined on 11-06-2006, 4:56 PM
    • Posts 7

    We're trying to use the Classified starter kit to provide a buy/sell area for employees, rather than rely on bulletin boards in the break rooms.

    I created a DB on our SQL2005 sever, ran the utility to add the .NET membership tables and SPs, and ran the SQL scripts in the App_Data folder to create the tables and add the categories. I have been able to register and login, and went to try to post an ad. When I click the Finish button to add the ad, I get 

    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Ads_Members". The conflict occurred in database "Classifieds", table "dbo.Members", column 'Id'.
    The statement has been terminated.

     Also, I have tried using the users.aspx file to set myself as an admin user. All the buttons are greyed out. I can highlight my user name, and select the Admin check box, but can't click any of the action buttons like Update Roles, Delete User, etc.

Page 1 of 1 (1 items)
Microsoft Communities
Page view counter