Solved

MSSQL 2008r2 Express auto install

Posted on 2011-02-28
10
885 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

734 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