SQL 2005

Does anyone have any good instructions on how to install step by step Microsoft SQL 2005 on Windows 2003? Because i will install Sharepoint after
shorisAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David ToddSenior DBACommented:
Hi,

Have you installed SQL 2005 at all on a test system?

I've found it reasonably straight forward.

Simple steps
1. Maybe reboot server first
2. Put in CD/DVD and run setup and follow prompts
3. Maybe reboot server after

SQL installs - definitely SQL 2000 installs - want a reboot after, and will not run a subsequent setup without that reboot. I can't recall if SQL 2005 is that fussy.

Would suggest that if unfamilar with the setup, you run it on a test machine - workstation/test server just for the familarisation.

HTH
  David
0
shorisAuthor Commented:
Well i did install it on a test server.. But how do i add a new database.. Its so different from the SQL 2000.. I saw my Start - program SQL 2000 but how do i add a new database.. etc..
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

shorisAuthor Commented:
Tab8.. is that the same for SQL standard edition?
0
shorisAuthor Commented:
there is a second cd for that is just for tools.. I just didn't know where i can change passwords.. add users.. weird.. sorry.. so new to SQL 2005.. shouldn't be difficult.. but i didn't see where i can view the databases?
0
TAB8Commented:
You need to install the management tools ... Its all done though a tool called SQL Management Studio .. when you install that It will start look a bit more like em in 2000
0
David ToddSenior DBACommented:
Hi,

I do agree that its quite different - SQL Server Management Studio (SSMS) does take a little getting used to, at least a week iirc.

As TABB has indicated, its a mix of Enterprise Manager, Query Analyser, and bits of Visual Studio.

Regards
  David
0
shorisAuthor Commented:
Ok.. but where do i find the databases, where i can create a database and modify user accounts in SQL 2005?
0
David ToddSenior DBACommented:
Hi,

First register a server, then from the registered servers, right click, and select the connect with explorer.

Then you should see a database explorer window, and can navigate much like Enterprise Manager.

HTH
  David
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shorisAuthor Commented:
Ok.. Again.. I am sorry for the dumb question.. I have the SQL Tools - SQL Configuration Tools installed.. and that's all i see in Start- Programs - So please can you help me navigate how to register a server - Where is the registered Servers?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.