Installing SQL Server 2012 on Server 2012 R2 core

I have setup a VM with Server 2012 R2 core (no GUI).  I have underlined R2 because everything online seems to have been made with R1.

I want to setup SQL server 2012 with SP1.

I need a working tutorial to set this up.  I have spent all day looking at online resources for this and all have failed with one error or another.  Even the steps in YouTube videos don't work.  So far I have tried using the parameters with setup.exe to specify the features and such.  Also even tried with a configuration file.  I have run into various errors such as the config file being ignored, the password specified for the services and /sapwd not meeting the SQLSecureString policy whatever that is.  I can't find any info on it.

Basically, nothing is working to get this setup.  One way or another, the online tutorials have been inaccurate.

For now, SharePoint 2013 will be the only instance.  I just need to use the bare minimum features set for this which I assume is SQLEngine.

Some links I have tried:
https://www.youtube.com/watch?v=Tytfq6WXvas
http://mssqltrek.com/2011/08/23/installing-sql-server-from-command-linecmd/
http://www.maxtblog.com/2012/07/installing-sql-server-2012-on-server-core-2012/
LVL 17
bigeven2002Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Deepak ChauhanSQL Server DBACommented:
Check this link for SQL installation on server Core.

Please install .Net framework 3.5 if not installed or enable the internet access before starting setup. SQL server will try to download and install it if not already install.

https://technet.microsoft.com/en-us/library/hh231669(v=sql.110).aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ktaczalaCommented:
Switch to the GUI version, install your SQL then switch back to core.

See Link on how to switch between the Two:
http://blogs.technet.com/b/puneetvig/archive/2012/10/16/switch-between-full-and-core-in-windows-server-2012-using-powershell-3-0.aspx
0
bigeven2002Author Commented:
OK I got it installed.  But I cannot get SQL Management studio to connect to it remotely.  If I turn off the firewall then it works.  I must be missing some ports to get this working.  Below are the ports I opened, what am I missing?

TITLE: Connect to Server
------------------------------
Cannot connect to TCN-SQL.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

Open in new window


netsh advfirewall firewall add rule name=SQLPortMAIN dir=in protocol=tcp action=allow localport=1433 remoteip=localsubnet profile=DOMAIN
netsh advfirewall firewall add rule name=SQLPortAS1 dir=in protocol=tcp action=allow localport=2383 remoteip=localsubnet profile=DOMAIN
netsh advfirewall firewall add rule name=SQLPortSSB dir=in protocol=udp action=allow localport=1434 remoteip=localsubnet profile=DOMAIN
netsh advfirewall firewall add rule name=SQLPortHTTP dir=in protocol=tcp action=allow localport=80 remoteip=localsubnet profile=DOMAIN
netsh advfirewall firewall add rule name=SQLPortHTTPS dir=in protocol=tcp action=allow localport=443 remoteip=localsubnet profile=DOMAIN
netsh advfirewall firewall add rule name=SQLPortTSQL dir=in protocol=tcp action=allow localport=135 remoteip=localsubnet profile=DOMAIN
netsh advfirewall firewall add rule name=SQLPortAS2 dir=in protocol=tcp action=allow localport=2382 remoteip=localsubnet profile=DOMAIN
netsh advfirewall firewall add rule name=SQLPortMIR dir=in protocol=tcp action=allow localport=7022 remoteip=localsubnet profile=DOMAIN

Open in new window

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Deepak ChauhanSQL Server DBACommented:
All ports seems  good. Did you try after restart.
0
Deepak ChauhanSQL Server DBACommented:
And you can check the port on which sql server is listning on. First disable the firewall and connect sql server remotely then check sql server error log to find the correct port no. If it is configured on Dynamic port you can add sqlserv.exe in firewall exception.
0
bigeven2002Author Commented:
Thanks.  Yes I did restart after ports setup.  Stupid question, where is sqlserv.exe?  Hard to find on server core.  It is 64-bit install.
0
bigeven2002Author Commented:
Actually nevermind.  I was able to remote computer management into the SQL network configuration and set a static port of 1433 for the TCP/IP connection.  Thanks!
0
bigeven2002Author Commented:
Thanks again for the help.  
@ktaczala, I was able to install without switching to GUI.  I guess I just needed some sleep on getting the command line parameters correct.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.