Connecting to SQL Server DB 1

[btween]

I ususally use a Microsoft access Database for my projects but I am required to usea a sql server 2000 db for this project. I have installed SQL server client on my pc and the database is hosted on a server. What I want to do is open it up locally so I can create all the fields and relationships, but I have no Idea where to begin.

The host provided me with the following info:

Database ID: xxxx
Database Name: xxxx
User Name: xxxx
Password: xxxx
RDBMS Type...........: SQL Server 2000
ODBC DSN.............: SQS1958 (on web server)
Server Name..........: xxxx

On my machine under Microsoft SQL server, I have Client network Utility, Enterpries Manager, Query Analyzer.

I don't know where to begin.

How can I open this database remotely and how can I get a view of it similar to access?

Any help would be greatly appreciated.

thx

 

[SonOfEmidec1100]

To start you need to register the remote server. Use EM goto tools/wizards select Register Server wizard.

Once succesfull you will be able to select databases/tables to view or change the schema and data. Open the database select tables, right click and select what you want to.


Very brief but I hope it gets you started.

 

[btween]

Thanks,

that was easy enough

 

[btween]

I was able to connect to the server but the database folder is empty. I know that the database is there because I accessed it with a remote administering tool. Do you have any suggestions as to why I can't see the tables?

thanks for your help