January 6, 2014 at 11:39 am
Hi all
I have recently installed SQL Server 2012 (from a download from the SQL Server pages)
After a lot of practising with queries I would like to start with the more advanced posibilities: SSIS, SSAS and SSRS.
SSDT is one of the installed components (or so I thought, see the example in attachted jpeg: Installed Products)
When I try to make a new project I get the message from ErrorMessage.jpeg
Trying to find out what version I have, I have checked the about info, found in mgtStudio.jpeg
Is there a way to install or activate SSDT?
If I run the installation again (without removing the current 1) will that leave my Linked Server to another database intact? I would hate to do that excercise again. That was a difficult excercise.
Hope somebody knows what to do to activate SSDT
Thanks in advance
Hein
January 6, 2014 at 1:17 pm
hjvegt1960 (1/6/2014)
Hi allI have recently installed SQL Server 2012 (from a download from the SQL Server pages)
After a lot of practising with queries I would like to start with the more advanced posibilities: SSIS, SSAS and SSRS.
SSDT is one of the installed components (or so I thought, see the example in attachted jpeg: Installed Products)
When I try to make a new project I get the message from ErrorMessage.jpeg
Trying to find out what version I have, I have checked the about info, found in mgtStudio.jpeg
Is there a way to install or activate SSDT?
If I run the installation again (without removing the current 1) will that leave my Linked Server to another database intact? I would hate to do that excercise again. That was a difficult excercise.
Hope somebody knows what to do to activate SSDT
Thanks in advance
Hein
What edition of SQL Server did you install?
January 6, 2014 at 1:22 pm
Hi Lynn
Thanks for your reply
I have installed the file: SQLEXPRADV_x64_ENU as found on the SQL Server site
So I guess that is the Express version?
Hein
January 6, 2014 at 1:44 pm
That version does not include SSIS or SSAS. If you want to learn these areas I would recommend purchasing the Developer Edition of SQL Server 2012. This will give you all the features of SQL Server 2012 Enterprise Edition, you just can't (shouldn't) use it in a Production Environment. At $75 or less it is well worth the cost.
January 6, 2014 at 1:48 pm
OK, sounds do-able
I will purchase this edition
Maybe an additional question: like I mentioned in my 1st thread: I have created a linked server to another database (mySQL)
If I install the developer edition: do I have to create this linked server again, or does it stay intact?
Anyway: thanks for your help!
Hein
January 6, 2014 at 2:42 pm
hjvegt1960 (1/6/2014)
OK, sounds do-ableI will purchase this edition
Maybe an additional question: like I mentioned in my 1st thread: I have created a linked server to another database (mySQL)
If I install the developer edition: do I have to create this linked server again, or does it stay intact?
Anyway: thanks for your help!
Hein
You'll have to create it again, as the linked server exists in that server instance only.
You can script it out though, saves you the pain of typing all the information again.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 6, 2014 at 3:21 pm
Thamks Koen
I will try your solution
Hein
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply