UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Brand New to MS SQL - Where do I start?    
 
   
CyberCow
post Jul 2 2007, 10:52 AM
Post#1


UdderAccess Admin + UA Ruler
Posts: 19,555
Joined: 27-April 02
From: Upper MI


OK, it turns out that I have been appointed the guy who is going to install, run, administer, deploy and know SQL here at work. Where do I begin. (It's been a long time since I started from scratch with anything.)
He got a brand new server just for SQL Server 2005 Standard, an HP ML150G3 with 2G RAM.
I just got "SQL Server 2005 for Dummies", but even it seems a bit daunting. A basic explicative approach might seem a good place to start.
Any other books, tips, pointers, etc will be appreciated.
Go to the top of the page
 
niesz
post Jul 2 2007, 11:08 AM
Post#2


Utter A-fishin'-ado
Posts: 17,958
Joined: 1-August 05
From: Cincinnati, Ohio, USA . . . ><((((°>


Are you looking for references or just a generalized, "What's the difference" approach?
Go to the top of the page
 
CyberCow
post Jul 2 2007, 11:22 AM
Post#3


UdderAccess Admin + UA Ruler
Posts: 19,555
Joined: 27-April 02
From: Upper MI


Walt, thanks. I'm looking for both actually. I know diving in is a good thing, but I also understand the install for SQL 2005 relies on some "pre-knowledge" for proper setup from the get go.
want to first make sure that it is installed properly. What do I need to know to ensure a properly directed initialization of SQL Server?
Go to the top of the page
 
LPurvis
post Jul 2 2007, 11:24 AM
Post#4


UtterAccess Editor
Posts: 16,085
Joined: 27-June 06
From: England (North East / South Yorks)


I started having another look at reworking that FAQ again a little while ago.
(Among other things inevitably).
I'm not writing anything else right now - so can look to get back to it.
hough not sure if it wouldn't be just way below what Mark needs as even a light intro.
There are indeed good comparison pages out there as you say Walter - that might be worthwhile.
Go to the top of the page
 
niesz
post Jul 2 2007, 11:27 AM
Post#5


Utter A-fishin'-ado
Posts: 17,958
Joined: 1-August 05
From: Cincinnati, Ohio, USA . . . ><((((°>


I recently thought of that myself, Leigh. But I think Mark is after simply installation basics ... and not yet ready for "how to interact with Access".
Go to the top of the page
 
niesz
post Jul 2 2007, 11:29 AM
Post#6


Utter A-fishin'-ado
Posts: 17,958
Joined: 1-August 05
From: Cincinnati, Ohio, USA . . . ><((((°>


Mark, I'm sure you already been down the Google road, but just in case you haven't...

http://msdn2.microsoft.com/en-us/library/ms143516.aspx

http://www.sqlservercentral.com/columnists...lserver2005.asp

The reason I point you to the web is because I've never installed 2005 before. Just 2000. And I didn't want to miss something important.

Ocan give you the 5-minute tour as far as the differences with Access, though.
Go to the top of the page
 
CyberCow
post Jul 2 2007, 11:40 AM
Post#7


UdderAccess Admin + UA Ruler
Posts: 19,555
Joined: 27-April 02
From: Upper MI


Leigh, right now, nothing is below my level regarding SQL Server sad.gif
And thanks again Walter, I'll be doing some good reading this evening . . . (good links!)
Go to the top of the page
 
niesz
post Jul 2 2007, 11:41 AM
Post#8


Utter A-fishin'-ado
Posts: 17,958
Joined: 1-August 05
From: Cincinnati, Ohio, USA . . . ><((((°>


Good places to start:
http://sqlserver2000.databases.aspfaq.com/...sql-server.html
http://www.utteraccess.com/forums/showflat...1350523&Zp=
http://www.utteraccess.com/forums/showflat...1329474&Zp=
http://www.utteraccess.com/forums/showflat...1314575&Zp=
Go to the top of the page
 
CyberCow
post Jul 2 2007, 12:57 PM
Post#9


UdderAccess Admin + UA Ruler
Posts: 19,555
Joined: 27-April 02
From: Upper MI


OK, I just did an install but I cannot find the "Management Studio" referred to by the SQL 2005 for Dummies book.

It's not in "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE" as stated in the MS TechNet Document 174173.

What is "Management Studio" and how do I install that?
Go to the top of the page
 
germargo
post Jul 2 2007, 08:29 PM
Post#10


UtterAccess VIP
Posts: 4,959
Joined: 22-May 02
From: SouthEast MI, USA


...Do not forget to install
SQL Server 2005 Service Pack 2
and
SQL Server 2005 Books Online (May 2007)
Edited by: germargo on Mon Jul 2 21:32:51 EDT 2007.
Go to the top of the page
 
CyberCow
post Jul 2 2007, 08:54 PM
Post#11


UdderAccess Admin + UA Ruler
Posts: 19,555
Joined: 27-April 02
From: Upper MI


OK, uninstalled it, purged the install directories and re-installed. All is better now. Now I need to install SP2 (Thanks Gary!)
Go to the top of the page
 
Maxer
post Jul 5 2007, 11:19 AM
Post#12


Utter Access VIP
Posts: 2,434
Joined: 14-March 06



Did you find management studio?
found that when I installed it I had to just go into the SQL CD and run the tools.msi package by itself on my workstation to get the darn thing to install properly.
Also you have to expand out the install options trees to individually check the tools in some cases (I just did the INSTALL EVERYTHING) option and disabled services I didn't want with the surface area tool.
HAs for books I liked Microsoft SQL Server 2005 Administrator's Companion by Microsoft, Edward Whalen, Marcilina Garcia, and others.
A bit thick, but it was nice to just jump to the area that was troubling me.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    11th December 2017 - 05:45 PM