?
Solved

MSSQL 2008r2 Express auto install

Posted on 2011-02-28
10
Medium Priority
?
887 Views
Last Modified: 2012-05-11
Hello.

I'm trying to install MSSQL 2008r2 from a command line (auto install/silient install)

I'm able to get the install to work but it doesn't complete the TCPIP install even though in the command line parameters I tell it to use TCPIP.  TCPIP is turned on but port 1433 is not defined for connections.

My parameters are:
setup.exe /Action=Install /Q /IACCEPTSQLSERVERLICENSETERMS /TCPENABLED=1 /SECURITYMODE=SQL /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM"/FEATURES=SQLEngine,Tools /instancename=SQLSERVER /SAPWD=mypass

Anyone know what is wrong?

 Thanks
   sj
0
Comment
Question by:sej69
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 20

Expert Comment

by:Marten Rune
ID: 35005538
It's because it is default in SQL express.

You need to enable tcpip and remote connections.
http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/

//Marten
0
 
LVL 20

Expert Comment

by:Marten Rune
ID: 35005542
Have you tried just starting SQL Browser to?

//Marten
0
 

Author Comment

by:sej69
ID: 35006858
I'd like to do this automatically during the install; its going to be hard to explain to people that this is something they need to do.  Do you know of anyway to do this automatically?

What is the SQL browser service btw?
0
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

 
LVL 20

Expert Comment

by:Marten Rune
ID: 35006922
Look under services. SQL Browser allows network connections to Browse (not really, but sometihng in this direction) sql installations. Basically it answers with correct port numbers for instances other than default. But it may have impact in your case.

You'll find it under services, start it and try again. If it works than maybe some parameter for strarting sql browser and setting it to automatically would do the trick.

You dont package programs yourself do you?

//Marten
0
 

Author Comment

by:sej69
ID: 35012084
Yes, I'm including MSSQL Express 2008r2 with the deployment of this application.  My goal is to have a single click to install the whole program.  I've installed other company's programs like this as well (they package MSSQL with their programs).  The people running my new app probably don't know MSSQL at all and I don't want to waste my time trying to explain to them how it works; they don't need to know.

On the automated install for MSSQLr2, I did see the browser service got turned on then shut it off manually.  I shrugged at it when I saw it as my dev environment doesn't have it running.
0
 
LVL 20

Expert Comment

by:Marten Rune
ID: 35016081
Check out what registry values is changed when turning on tcp/ip. Then make a custom action, running these reg values and stopping/starting the sql server service again. Should do the trick.

//Marten
0
 

Author Comment

by:sej69
ID: 35176132
Still working on this....
0
 
LVL 20

Expert Comment

by:Marten Rune
ID: 35295936
0
 

Accepted Solution

by:
sej69 earned 0 total points
ID: 35405021
still working on this....
0
 

Author Closing Comment

by:sej69
ID: 35997879
decided not to do an auto install on MSSQL 2008, too many issues to worry about.
0

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

770 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