May 24, 2008 at 11:59 am
Hello
I am new to SQL and I was told to install SQL server 2005 in order to start practicing in my home computer. I did that but I am having difficulty setting up and launch it. I am trying to explain how I did I have downloaded and installed the following
.Net Framework 2.0 Serv Pack 1
MS SQL server 2005
MS SQL server Native Client
MS SQL server Setup support
MS SQL server VSS Writer
(as the appear in control pannel add /remove screen)
Also I have downloaded and installed
AdventureWorksDB.msi as a sample database i believe
When I want to launch the program I point to Programs, that dispplays MS SQL Server 2005 which displays Configurations Tools which when pointed displays
1) SQL Server Configuration manager (has the icon with little hammer and folder whatever it is,
2) SQL Server Error and Usage reporting
3) SQL server surface area configuration
None of them is letting me to open a screen to see any tables and write a query.
What am i missing?
thanks
ted
May 24, 2008 at 5:34 pm
Did you install the "entire feature onto the local drive" for the main sql componants?
Also are you saying you can't see "Microsoft SQL Server Management Studio"? which is the application you use to view tables and create querys...
(Sorry if i am asking you to suck eggs just making sure...)
May 27, 2008 at 6:57 am
Open the configuration manager. Click on "SQL Server 2005 Services" on the left side of the screen. You should see a list of services include "SQL Server" or "SQL Server (somenameorother)." Check the "State" to see that it's "Running." If not, start it. If it doesn't start, you'll need to check your events log to see why. If it's not there, you didn't complete the install successfully.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 27, 2008 at 2:01 pm
Sounds like you have installed the database services, but not the client tools.
The Redneck DBA
May 27, 2008 at 2:07 pm
You may have installed the "default" version of SQL Server Express Edition...which doesn't include SQL Server Management Studio (the new combined Ent. Mgr/Query Analyzer).
You probably want to grab the SQL Express with Advanced Services install, which will give you access to the Management studio.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply