Solved

SQL 2005

Posted on 2007-04-04
10
162 Views
Last Modified: 2012-05-05
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
0
Comment
Question by:shoris
  • 5
  • 3
  • 2
10 Comments
 
LVL 35

Expert Comment

by:David Todd
ID: 18854449
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
 
LVL 10

Expert Comment

by:TAB8
ID: 18854542
0
 

Author Comment

by:shoris
ID: 18854543
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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 

Author Comment

by:shoris
ID: 18854548
Tab8.. is that the same for SQL standard edition?
0
 

Author Comment

by:shoris
ID: 18854556
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
 
LVL 10

Expert Comment

by:TAB8
ID: 18854588
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
 
LVL 35

Expert Comment

by:David Todd
ID: 18854741
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
 

Author Comment

by:shoris
ID: 18855160
Ok.. but where do i find the databases, where i can create a database and modify user accounts in SQL 2005?
0
 
LVL 35

Accepted Solution

by:
David Todd earned 500 total points
ID: 18855241
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
 

Author Comment

by:shoris
ID: 18856859
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

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sqlquerystress - To test db performance 8 39
script to send html report 3 30
SQL LINE CONTINUATION ISSUE 12 31
SQL - Update field defined as Text 6 15
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now