how to setup SQL instance

Question

how to setup SQL instance

tlou.mone

SSC Enthusiast

Points: 126
More actions
April 26, 2014 at 11:16 pm

#307084

hello everyone
can you please help.I have downloaded SQL Server 2008(im a novice). i wnt to use management studio but cannot connect to an instance.Question: Can u connect to an instance on a machine without server installed?.m using windows XP SP3

Viewing 7 posts - 1 through 6 (of 6 total)

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

LutzM SSC Guru Points: 107049 More actions · Answer 1

If you have SSMS (SQL Server Management Studio) installed, you can connect to a SQL Server instance on another machine if the machine allows access (SQL port open, usually port 1433, to check the port see this link) and you have permission to connect to the SQL Server instance (either by Windows authentication or SQL Server authentication).

Can you connect to the SQL Server instance when logged on to the machine where the instance is installed? If yes, how do you connect (Windows or SQL login)?

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 2

tlou.mone (4/26/2014)
hello everyone
can you please help.I have downloaded SQL Server 2008(im a novice). i wnt to use management studio but cannot connect to an instance.Question: Can u connect to an instance on a machine without server installed?.m using windows XP SP3

Did you only install the ssms on your local PC and want to connect to an instance on another machine?

Yes you can connect, without installing a server on your PC.

Regards,

Igor

Igor Micev,My blog: www.igormicev.com

tlou.mone SSC Enthusiast Points: 126 More actions · Answer 3

@LutzM and Igor

I have ssms installed on my PC but cannot connect at all.perhaps if you give me step-step instructions how to connect.M Using a training kit in preparation for 70-432 exam.I have downloaded evrythn adventureworks etc.thank you!

LutzM SSC Guru Points: 107049 More actions · Answer 4

On what SQL Server instance did you install the Adventure Works database?

How can we provide a step by step solution if you don't provide us any information except "I cannot connect"? And if we have no point to start from?

E.g. where is the SQL engine located that you used to attach the AdventureWorks database to?

What do you mean by "downloaded everything"?

Are you aware that you need a running SQL Server engine installed "somewhere" in order to attach any database to it and/or connect to it using SSMS? SSMS itself is not the SQL Server database, it's a GUI. You can use a SQL Server instance without SSMS installed but you can't use SSMS without any database you can connect to.

Please remember: we don't see what you see since we cannot look over your shoulder. All we have is what you're telling us. And that isn't that much at the moment.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 5

Eirikur Eiriksson

SSC Guru

Points: 182912

April 27, 2014 at 12:38 pm

#1709043

Check out this post

😎

tlou.mone SSC Enthusiast Points: 126 More actions · Answer 6

@LutzM

I have only downloaded adventureworks to my machine, apparently 2 install it needs filestream and full text search enabled of which I dnt knw hw.

Secondly when I try to connect my ssms it give error " network or pipes not provided and instance name not provided m sure you once came across that error.

Adventureworks database do I install or attach?

Which location do I attach?

I have only ssms installed on my machine.like i said m a Novice