Solved

MSSQL 2008r2 Express auto install

Posted on 2011-02-28
10
884 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

830 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