January 11, 2013 at 7:18 am
Excellent!
Thank you!
_____________________________________________________________________
-Jamie Scharbrough
MCTS: SQL 2008R2
January 11, 2013 at 8:10 am
opc.three (1/11/2013)
Jamie Scharbrough (1/11/2013)
Sorry, not downloaded, I used the wrong word.Yeah that's definitely doable (installing it on my workstation). I'm so used to everything being in the same place that I kind of panicked when I realized it wasn't there.
EDIT: Oh good grief. The original installation disks are overseas. And there would be some serious other issues in trying to get them. (The long and the short of it is, our parent company has disassociated from us and legally we are no longer allowed to work with them. It's complicated.)
Is it possible to download the 6 month freebie SSMS that Microsoft offers, or would there be issues in connecting them?
I am not sure if a SQL 2005 Evaluation download is still going to be around, but you can download the 180-day Evaluation copy of SQL 2012 from Microsoft's website and that will get you a copy of SSMS. SSMS 2012 can connect to SQL 2005 instances. You may run into some quirks trying to manage some of the subsytems (e.g. replication) but Microsoft touts that SSMS 2012 can manage SQL 2005 instances. This would only be a stopgap until you got the SQL 2005 media and could install SSMS 2005, or upgraded to SQL 2012 😉
You can download the free SQL Server Express edition and install it on your workstation - the "with Tools" and "with Advanced Services" versions include SSMS, so be sure to get one of those and not the plain vanilla version.
Jason Wolfkill
January 11, 2013 at 8:16 am
It doesn't come with SQL Agent though (I'm pretty sure). I used to use it before I got the evaluation copy.
_____________________________________________________________________
-Jamie Scharbrough
MCTS: SQL 2008R2
January 11, 2013 at 8:20 am
You can purchase SQL Server 2012 Developer Edition on Amazon.com for $43.00. Gives you everything you need for a development/training environment and doesn't cost a whole lot and you don't have to worry about it expiring.
January 11, 2013 at 8:41 am
Man I wish that sucker came with two licenses though; one for work and one for home! 😀
_____________________________________________________________________
-Jamie Scharbrough
MCTS: SQL 2008R2
January 11, 2013 at 8:42 am
JESDBA (1/11/2013)
It doesn't come with SQL Agent though (I'm pretty sure). I used to use it before I got the evaluation copy.
Express will not install a local intances of SQL Agent but you can still access the server's instance of SQL Agent. Express Edition will not include Profiler, which may come in handy down the line. Developer Edition is a good option if the SQL 2005 media is lost, or you want to run SSMS 2012 going forward.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 11, 2013 at 8:45 am
JESDBA (1/11/2013)
It doesn't come with SQL Agent though (I'm pretty sure). I used to use it before I got the evaluation copy.
You're right that the Express edition doesn't include SQL Agent as part of the database installation. SSMS is just client software that will connect to whatever SQL Server instance you point it at (assuming you have proper credentials and permissions). Installing the Express edition on your laptop/desktop installs SSMS there, too. Fire it up and connect to your SQL Server instance on the database server and you're good to go.
SQL Agent runs on the database server. You can manage SQL Agent jobs on the server through SSMS from your laptop/desktop.
Does that make sense, or have I not understood your needs and circumstances properly?
Good luck with your sink-or-swim situation. Continuing the LOTR analogy, I hope you fare better than Isildur at the sinking-or-swimming, and for that matter, better than Boromir fared, too. Fortunately, I don't think the corrupting power of the DBA title is quite as great as that of the One Ring.
Jason Wolfkill
January 11, 2013 at 10:53 am
wolfkillj (1/11/2013)
JESDBA (1/11/2013)
It doesn't come with SQL Agent though (I'm pretty sure). I used to use it before I got the evaluation copy.You're right that the Express edition doesn't include SQL Agent as part of the database installation. SSMS is just client software that will connect to whatever SQL Server instance you point it at (assuming you have proper credentials and permissions). Installing the Express edition on your laptop/desktop installs SSMS there, too. Fire it up and connect to your SQL Server instance on the database server and you're good to go.
SQL Agent runs on the database server. You can manage SQL Agent jobs on the server through SSMS from your laptop/desktop.
Does that make sense, or have I not understood your needs and circumstances properly?
Good luck with your sink-or-swim situation. Continuing the LOTR analogy, I hope you fare better than Isildur at the sinking-or-swimming, and for that matter, better than Boromir fared, too. Fortunately, I don't think the corrupting power of the DBA title is quite as great as that of the One Ring.
Nope that makes perfect sense, and that's what I'll do!
Yeah, I hope I'm better at this than Isildur was too.
_____________________________________________________________________
-Jamie Scharbrough
MCTS: SQL 2008R2
Viewing 8 posts - 16 through 22 (of 22 total)
You must be logged in to reply to this topic. Login to reply