I defeated my microsoft today

1. I have  both ASP.NET 1.1 and 2.0/Visual Studio 2003 and 2005 on my machine so I got

"Failed to access IIS...

And Gift is your first name?

Yet have to fight another battle now. "Failed to access IIS metabase"

Back to my microsoft

Hi Gift Peddie

Thanks you so much for the info.What does Peddie mean?

It was funny with that database yesterday. I created a new database, login/user/permissions, application can see it but it's...

OK, I am too stupid to understand it

"create the permissions for Asp.net account you created".  - what does it mean, create server login?

It's...

Hi Gift Peddie,

I didn't solve it, I made it worse. So I didn'' sleep last weekend because I worried so much about it. I am not a dba, I am...

I did it, I did it!

Exec sp_detach_db @dbname='new_db'

EXEC sp_attach_single_file_db @dbname = 'new_db',

@physname = 'c:\data\old.mdf'

"Backup and Restore the old database SQL Server will recreate everything and you can change the name as needed during the restore,

one more thing there is no mdb...

you are right mdf, idf. I back up database and log twice a day automatically though this db is empty. I will try to restore it from the old files. Hopefully I will not screw...