How to connect to a SQL Server database from local pc?

Question

I am a Crystal Reports developer and I have always been working with Oracle database and this is my first time with SQL Server.

This is what I have been desperately searching for.

From my local PC, I want to connect to a SQL Server database which is on a database server.

I am aware that I need a 'SQL Server Native Client'. And I am also aware that I need to use 'sql server management studio' so that I can view the tables and writes queries instead of using a tool like TOAD.

My questions are:

1. Can I use 'Microsoft SQL Server Management Studio Express' from my local PC to connect to a SQL Server 2005 Database in a database server?

2. If I install 'Microsoft SQL Server Management Studio Express' do I still need to install a 'SQL Server Native Client'?

Thanks, rivi

Answer 1

1. Can I use 'Microsoft SQL Server Management Studio Express' from my local PC to connect to a SQL SERVER 2005 Database in a database server?

Yes.

If I install 'Microsoft SQL Server Management Studio Express' do I still need to install a 'SQL Server Native Client'?

If you want to connect to the database from your application you will need it installed. It should be installed as part of the SSMS install.