Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL Server 2014 Developer Installation

Posted on 2014-08-28
9
Medium Priority
?
815 Views
Last Modified: 2016-02-11
I recently installed SQL Server 2014 Developer over an existing installation of SQL Server Express 2014 Advanced Services. During the installation of SQL Server 2014 Developer, I installed a new SQL Server database and all of the features of SSIS and SSRS.

Questions:
(1) Why doesn’t Management studio show the new SQL Server database?
(2) Why was Server SQL Server Data Tools not installed?
0
Comment
Question by:Mark01
  • 5
  • 4
9 Comments
 
LVL 4

Expert Comment

by:Randy Knight, MCM
ID: 40291064
Is this a 2nd instance?  What do you mean by over an existing installation?

On your questions:

1.  There is no mention of a new database in your question.  Do you mean the new instance?
2. Did you choose them when you did the install?
0
 

Author Comment

by:Mark01
ID: 40291180
Yes. It is a second instance. When I installed SQL Server Express 2014 Advanced Services, the first instance was installed. A second instance was installed when I installed SQL Server 2014 Developer.

Why doesn’t Management studio show the second instance?

Your question: Did you choose them when you did the install?
Answer: Yes. I selected all features (database, SSIS and SSRS) when I installed SQL Server 2014 Developer.
0
 
LVL 4

Accepted Solution

by:
Randy Knight, MCM earned 2000 total points
ID: 40291219
You'll need to register the 2nd instance on SSMS.

On the SSDT, I was asking if you choose to install the SSDT during installation.
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 

Author Comment

by:Mark01
ID: 40291273
I don't remember if I choose to install the SSDT during installation.
0
 

Author Comment

by:Mark01
ID: 40291297
I did select the installation of Data Tools (assume you call them SSDT?) during installation.
0
 
LVL 4

Expert Comment

by:Randy Knight, MCM
ID: 40291305
SSDT = SQL Server Data Tools.  If you chose them and didn't get any errors, then I don't know why you wouldn't have them.
0
 

Author Comment

by:Mark01
ID: 40293633
I was able to register the the second instance on SSMS.  Regarding SSDT, I have Visual Studio Express 2013 for Windows Desktop installed. Perhaps SSDT is not compatible with Express.
0
 
LVL 4

Assisted Solution

by:Randy Knight, MCM
Randy Knight, MCM earned 2000 total points
ID: 40293966
Apparently my reading comprehension is not what it should be.  I was thinking of SQL Server 2012. For SQL 2014, SSDT is a separate download.  No idea why they did it that way.

http://msdn.microsoft.com/en-us/hh297027.aspx
0
 

Author Closing Comment

by:Mark01
ID: 40295000
Thank you, Randy.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

578 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