Solved

MSSQL 2008r2 Express auto install

Posted on 2011-02-28
10
886 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
Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

 
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

690 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