Why sql sERVER products are so frustratingly complicated to install??? (Network Steve Forum)

Why sql sERVER products are so frustratingly complicated to install???

Dear Ms Team,

I found MS SQL Server products are frustrating, complex and difficult while installing.

As per my experience , installing SQL sever need to follow some experts tips.

During installation it will ask for sp1 need to install first, Powershell, >net framework.. blah blah blah......

Why don't u packed the whole compnts in single setup or download automatically thru online.

Except SQLserver 2005 Express edition , none of the other types are easy to install.

Even some people need to format the system to reinstall SQL server.

Currently I am trying to install SQLSever2014 in my Win8.1 32 system, Installation completed successfully but now after clicking SQL Management studio is not working at all.

Error Mess can't find one or more components, Please reinstall.

After trying reinstall doesn't work. Dear Team why this complexity???

SQLEXPR_x86_ENU

SQLEXPR32_x86_ENU.exe

EVEN IF i TRY INSTALLINg SQlserver management Studio 2008R2, It doesn't allow to install stating blah blah again.

Services for SQL server and Browser are running but anable to Open Mgmt studio.

What is the solution

March 28th, 2015 1:21am

Hi,

I would try to help you here. Can you please run discovery report and post output here

Free Windows Admin Tool Kit Click here and download it now

March 28th, 2015 1:29am

Thanks for your response,

while clicking Discovry report, it becam disabled and nothing is showing. It focus on MAP toolit.

some txt file popup as below. As mentioned My system is win8.1 32 bitOS. SQLserver2014,I m tryin.

<html><head><title>Discovery Report for Microsoft SQL Server 2014 Setup</title></head><body><p STYLE="font-family: Verdana, Arial, sans-serif; font-size: 14pt;"><b>
Microsoft SQL Server 2014 Setup Discovery Report
</b></p><table border="1" cellpadding="7" cellspacing="0" STYLE="font-family: Verdana, Arial, sans-serif; font-size: 9pt;"><tr style="background-color:Silver"><th align="center">Product</th><th align="center">Instance</th><th align="center">Instance ID</th><th align="center">Feature</th><th align="center">Language</th><th align="center">Edition</th><th align="center">Version</th><th align="center">Clustered</th><th align="center">Configured</th></tr><tr><td align="center">Microsoft SQL Server 2014</td><td align="center">BJ</td><td align="center">MSSQL12.BJ</td><td align="center">Database Engine Services</td><td align="center">1033</td><td align="center">Express Edition</td><td align="center">12.0.2000.8</td><td align="center">No</td><td align="center">Yes</td></tr><tr style="background-color:LightYellow"><td align="center">Microsoft SQL Server 2014</td><td align="center">BJ</td><td align="center">MSSQL12.BJ</td><td align="center">SQL Server Replication</td><td align="center">1033</td><td align="center">Express Edition</td><td align="center">12.0.2000.8</td><td align="center">No</td><td align="center">Yes</td></tr><tr><td align="center">Microsoft SQL Server 2014</td><td align="center">BJ25</td><td align="center">MSSQL12.BJ2015</td><td align="center">Database Engine Services</td><td align="center">1033</td><td align="center">Express Edition</td><td align="center">12.0.2000.8</td><td align="center">No</td><td align="center">Yes</td></tr><tr style="background-color:LightYellow"><td align="center">Microsoft SQL Server 2014</td><td align="center">BJ25</td><td align="center">MSSQL12.BJ2015</td><td align="center">SQL Server Replication</td><td align="center">1033</td><td align="center">Express Edition</td><td align="center">12.0.2000.8</td><td align="center">No</td><td align="center">Yes</td></tr><tr><td align="center">Microsoft SQL Server 2014</td><td align="center" /><td align="center" /><td align="center">Management Tools - Basic</td><td align="center">1033</td><td align="center" /><td align="center">12.0.2000.8</td><td align="center">No</td><td align="center">Yes</td></tr><tr style="background-color:LightYellow"><td align="center">Microsoft SQL Server 2014</td><td align="center" /><td align="center" /><td align="center">Management Tools - Complete</td><td align="center">1033</td><td align="center" /><td align="center">12.0.2000.8</td><td align="center">No</td><td align="center">Yes</td></tr><tr><td align="center">Microsoft SQL Server 2014</td><td align="center" /><td align="center" /><td align="center">Client Tools Connectivity</td><td align="center">1033</td><td align="center" /><td align="center">12.0.2000.8</td><td align="center">No</td><td align="center">Yes</td></tr><tr style="background-color:LightYellow"><td align="center">Microsoft SQL Server 2014</td><td align="center" /><td align="center" /><td align="center">Client Tools Backwards Compatibility</td><td align="center">1033</td><td align="center" /><td align="center">12.0.2000.8</td><td align="center">No</td><td align="center">Yes</td></tr><tr><td align="center">Microsoft SQL Server 2014</td><td align="center" /><td align="center" /><td align="center">Client Tools SDK</td><td align="center">1033</td><td align="center" /><td align="center">12.0.2000.8</td><td align="center">No</td><td align="center">Yes</td></tr><tr style="background-color:LightYellow"><td align="center">Microsoft SQL Server 2014</td><td align="center" /><td align="center" /><td align="center">LocalDB</td><td align="center">1033</td><td align="center">Express Edition</td><td align="center">12.0.2000.8</td><td align="center">No</td><td align="center">Yes</td></tr><tr><td align="center">Microsoft SQL Server 2012</td><td align="center">SQLEXPRESS</td><td align="center">MSSQL11.SQLEXPRESS</td><td align="center">Database Engine Services</td><td align="center">1033</td><td align="center">Express Edition</td><td align="center">11.0.2100.60</td><td align="center">No</td><td align="center">Yes</td></tr><tr style="background-color:LightYellow"><td align="center">Microsoft SQL Server 2012</td><td align="center">SQLEXPRESS</td><td align="center">MSSQL11.SQLEXPRESS</td><td align="center">SQL Server Replication</td><td align="center">1033</td><td align="center">Express Edition</td><td align="center">11.0.2100.60</td><td align="center">No</td><td align="center">Yes</td></tr><tr><td align="center">Microsoft SQL Server 2012</td><td align="center" /><td align="center" /><td align="center">LocalDB</td><td align="center">1033</td><td align="center">Express Edition</td><td align="center">11.1.3000.0</td><td align="center">No</td><td align="center">Yes</td></tr></table></body></html>

March 28th, 2015 2:31am

This topic is archived. No further replies will be accepted.