Connect to sql server

Question

Connect to sql server

crunchy_stephen

Old Hand

Points: 368
More actions
October 2, 2009 at 1:03 pm

#98014

hi,
how can i connect to sql server?i have server name which is located in canada with enterprise edition and all licensed.
how can i connect to the sql server? please help me as i am a developer and new to this sql field?
do i have to install sql server native client on my laptop?
Thanks,

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

Are you trying to connect an application you're building, or are you trying to connect Management Studio?

I'd say the best place to start for either one would be to have the IP address of the database, and you'll probably need the port number as well, unless they've left it as the default (some do).

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

crunchy_stephen Old Hand Points: 368 More actions · Answer 2

hi,

thanks for the reply.

I have port number, server adress all the details. the servers are in canada as i said. now i want to connect to the sql server there from my laptop.

am trying to connect to the sql management studio and enterprise manager. my id have right permissions.

how can i, please suggest?

thanks,

GSquared SSC Guru Points: 260824 More actions · Answer 3

When Management Studio asks you which server to connect to, type in the IP address, add the correct credentials, and see if it'll connect.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

crunchy_stephen Old Hand Points: 368 More actions · Answer 4

I dont have any management studio or any sql native client install on my laptop.

please tell the procedure. as im new. i will be thankful if u can tell me step by step...

thanks,

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 5

How to install client tools only (Setup)

http://msdn.microsoft.com/en-us/library/aa197918(SQL.80).aspx

MJ

crunchy_stephen Old Hand Points: 368 More actions · Answer 6

My question is still not answered, can you please help me on this??

I want to access my servers and i have valid id.

What do i download on my laptop?

how i will run query on the a query analyzer?

Do I buy any devloper/express edition?

All my servers there in canada are licensed... please help as im new

thanks,

GSquared SSC Guru Points: 260824 More actions · Answer 7

First, you get a copy of Query Analyzer or SQL Server Management Studio. Either one will work.

Do you have one of those?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

crunchy_stephen Old Hand Points: 368 More actions · Answer 8

No, I dont have none of those you mentioned.

can i connect with native client?

DougGifford SSCommitted Points: 1815 More actions · Answer 9

Maybe the OP needs terminal services to connect and run the applications on the servers?

"When in danger or in doubt. Run in circles, scream and shout!" TANSTAAFL
"Robert A. Heinlein"

GSquared SSC Guru Points: 260824 More actions · Answer 10

Yes, you can connect with native client. The documentation on it is here http://msdn.microsoft.com/en-us/data/aa937733.aspx.

Native client is a means for getting applications to connect to SQL Server. It's not something you can use directly, it's something you use in software that you are building. Is that what you're trying to do? Connect an application to SQL?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

sanketahir1985 SSCarpal Tunnel Points: 4473 More actions · Answer 11

first u will have to install workstation component(SQL 2005) or client component (SQL 2000) which is included in SQL server setup CD.

then only u will be able to connect to the servers.

Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......

suresh.theyyath Old Hand Points: 304 More actions · Answer 12

Dear Friend,

Simply download this stuff and just open sqldbx there you can specify servername as servername,portno. and enter your credentials. you can connect to the server and use like server management studio.

http://www.sqldbx.com/personal_edition.htm

try it out!