SQL server setup on a server 1

[Wolfen12]

Hi

Please please help me please.Totally new to SQL server.
We want to start using SQL server.We have SQL server 2005 Developers edition

What I want to do:

Install on a central server the SQL Main server and then create the database.

Then on each developer's pc an Instance of that SQL main server, so that they can add tables and do whatever on that main server.

The questions in the wizard and online documentation is so difficult to understand.Cam anyone please assist me step by step

 

[AlexCuse]

You will want to install the server components on your server. This is the ONLY place that you should have an instance of SQL server (if I am reading your question right).

Then, you will want to install the client components (Management Studio, BIDS) on each developer's PC, and set up access for them (I would use windows authentication) so they can connect.

The wizard should walk you through this pretty simply (but you will need to set up permissions on your own).

Here's an overview of user permissions that you might find helpful.

Hope this helps,

Alex

[small]----signature below----[/small]
With all due respect, Don Bot, I don't think we should rely on an accident happening. Let's kill him ourselves.

Ignorance of certain subjects is a great part of wisdom

 

[Wolfen12]

Hi Alex, thanks for you reply, I now understand the princepal, but please dont hate me for being so stupid

I dont find the wizard so simple, for instance it doesnt ask you directly like: Do you want to Install server components or client components?, it just has 2 options:

1.Server components, tools, Books Online, and samples
2.Run the SQL Native Client Installation Wizard

So now for the server I did option 1 and they asked all these weird questions, so I just ticked everything,so now it is installed, but what now:

Where do I go creating my main(Host)SQL Database?

I really do appreciate your post,

 

[Wolfen12]

I did so, thanks Mike

 

[AlexCuse]

You did so what? I am confused?

You will need to use the client tools to create your database (AFAIK).

I believe that you would take the first option, then check ONLY the workstation components, books online, development tools (not server components) to install the client tools only (if you checked everything when you installed on the server, the client tools should be available there).

In T-SQL to create a database it is just CREATE DATABASE dbName

(I imagine you will need to create tables and what-not as well though ;-) )

Depending on your level of comfort with T-SQL, you might want to do this through the SSMS GUI. As you get more comfortable though, I would recommend writing the table creation scripts yourself though.

Hope this helps,

Alex

[small]----signature below----[/small]
With all due respect, Don Bot, I don't think we should rely on an accident happening. Let's kill him ourselves.

Ignorance of certain subjects is a great part of wisdom