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

[rivi10]

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

 

[gmmastros]

Installing SQL server management studio express will also install the SQL native client. You should be able to download and install just the client tools for SQL server management studio express. This will allow you to connct to a database hosted on another server.

You will, of course, need to know the name of the server and login credentials.


-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[dhulbert]

Rivi.

No need to stop using toad if you don't want to. I've used it in a SQL server environment with no problems.

In fact I think it comes with the SQL server connectivity straight out of the box.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)