I have some desktop app that is using sql 2000 which works just fine on this PC.
What I am trying to do is basically reverting it to db that has empty tables so that I can start using it from scratch (fill it with different data but still maintain the layout or what-have-you) on another, different PC.
I have found some bak file that says "clean_db" which is loaded just fine. (using the restore function) The thing is, when I open my desktop app (add new user and everything) on this other PC now, it's entirely empty, I only see "File" and nothing else which was not my intention.
Could someone point me to the right direction as to what I am supposed to do ? I am quite new to this and I'd appreciate some assistance.
If you have access to a SQL Server Client - attempt to connect to the SQL Server installed.Do you know the address of the SQL Server instance. I assume you know the address as you restored the database. Once you've connected - doublecheck the connection string of the application to the database server.
Did you unorphan the login and the user (sp_change_users_login)?
There's perhaps default data that still needs to be in the database. We can't help you with that as that requires application knowledge, but you can run a SQL Trace to see what it's doing and compare that with trace data for the database that is working.