• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 897
  • Last Modified:

MSSQL 2008r2 Express auto install

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
sej69
Asked:
sej69
  • 5
  • 5
1 Solution
 
Marten RuneCommented:
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
 
Marten RuneCommented:
Have you tried just starting SQL Browser to?

//Marten
0
 
sej69Author Commented:
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
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
Marten RuneCommented:
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
 
sej69Author Commented:
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
 
Marten RuneCommented:
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
 
sej69Author Commented:
Still working on this....
0
 
Marten RuneCommented:
0
 
sej69Author Commented:
still working on this....
0
 
sej69Author Commented:
decided not to do an auto install on MSSQL 2008, too many issues to worry about.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now