Hi Everyone,

I am having a really BIG problem over here…

My web site, which is heavily borrowed from, Damon Armstrong, is working great! However, I need to modify it just a little bit.

The site is in C#, (http://stage.rivier.edu), and it is a Web Parts portal, if-you-will. And I want to authenticate against Active Directory, as well as insert the users into the database, so it will remember user’s settings. Right now, I am using the ASPNET.MDF database through VS 2005. Ideally though, I would like to use SQL Server. But, I cannot attach to the database through SQL Server; I get errors.

Anyway, this is KILLING me!!!

I am fairly new to all of this and I need to have this done for, “testing” by April 2nd. I really need some help. I know I sound desperate… But that’s because I am.

Thank you all for any help you can give me. It is GREATLY appreciated, and I only hope I can lend a helping hand in the future.

Cheers,

Dan

Hi

If you couldn't attach the dayabase try to attach it using the following query, it is good to use especially if you don't have the .LDF file
any how open the query analyzer if it is SQL 2000 or the management tool if it is SQL2005 and write the following query replacing the database name with yours and the data base place with your databse path

  exec sp_attach_db @dbname=N'CLASSIFIEDSDB',
     @filename1=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CLASSIFIEDSDB.mdf'

Before executing the query remember to choose the Master Database in the Avalaible Databases DropDownList

This is working

If not state the raised errors

Good luck

Hi Nesrine,

Thank you for the suggestion, but this is the error I received:

Server: Msg 602, Level 21, State 50, Line 1
Could not find row in sysindexes for database ID 13, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

Connection Broken