?
Solved

SQL Server Installation

Posted on 2011-02-21
10
Medium Priority
?
929 Views
Last Modified: 2012-05-11
I am trying to embed sql server 2008 r2 express with advanced services along with my application.
http://msdn.microsoft.com/en-us/library/dd239405.aspx

Only my application, installed on the same machine as sql server, will be accessing the database. Client computers will be able to generate reports through reporting services.

My client/s who will be installing the application might have no knowledge about SQL Server so the installer or my application should be able to configure everything to make it work properly.

What is the best configuration for this setup?
0
Comment
Question by:Thomasian
[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 57

Expert Comment

by:Raja Jegan R
ID: 34948766
For your scenario, its recommended to perform silent installation of SQL Server 2008 R2 express using configuration files..
More info about Silent Installation here:

http://msdn.microsoft.com/en-us/library/ms144259.aspx

Sample installation setups here:
http://digitalformula.net/articles/how-to-perform-an-unattended-installation-of-sql-server-2008-express
http://mycodelog.com/2010/09/28/sqlsilent/
0
 
LVL 22

Author Comment

by:Thomasian
ID: 34948800
Thanks rrjegan

In your links, the article in digitalformula.net  mentioned about an attached configration file which I can't find. While for the other article, it mentioned that it will not work for the express edition.

I would actually need some advice on the configuration for the installation.
e.g.
What is the recommended account name to run sql server database engine and reporting services?
0
 
LVL 22

Author Comment

by:Thomasian
ID: 34948812
>>Added a parameter called SAPWD and set it to the strong 'sa' password.
Also, in the article it mentioned that the sa password is stored in the configuration file. That file wouldn't be encrypted, would it?
0
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 2000 total points
ID: 34948821
>> In your links, the article in digitalformula.net  mentioned about an attached configration file which I can't find

Ok, missed mentioning it in my earlier comment.
In order to obtain the Configruation file, just perform the following steps:

1. Do SQL Server 2008 R2 Express with Advanced Services installation in a test machine.
2. Choose all the required values and proceed with installation.
3. In Ready to Install page, you would be able to find the location where Configuration file will be available.

You can have that configuration file as base and perform silent installation on all required machines..

>> What is the recommended account name to run sql server database engine and reporting services?

If you require Network access for SQL Server database engine, then its recommended to have it run using a domain account which has privileges for those network shares along with admin rights on SQL Server machine or else you can make it to run using Local System or local account.
For Reporting Services, its recommended to have a domain account.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 34948824
>> Also, in the article it mentioned that the sa password is stored in the configuration file. That file wouldn't be encrypted, would it?

Yes, it wouldn't be encrypted..
But once you package it along with your application, your sa password would be safer..
0
 
LVL 22

Author Comment

by:Thomasian
ID: 34948868
How can I silently install the application and use a domain account?

Another question, in one of the link it has  "Set the SQLSYSADMINACCOUNTS value to "MYPC\Administrator""
So that will mean I will have to know the machine name since it was hard-coded.

In the other article it has "SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS""
But I can't seem to make it work in the installation. When I enter BUILTIN\ADMINISTRATORS when adding administrator using the standard installation, it kept asking for a network password for builtin.
0
 
LVL 22

Author Comment

by:Thomasian
ID: 34948879
I got the BUILTIN\Administrators question. Just "Administrators" works fine.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 34948889
>> SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS"

This would suffice..

>> When I enter BUILTIN\ADMINISTRATORS when adding administrator using the standard installation, it kept asking for a network password for builtin.

Check whether you haven't provided credentials for some other service like SQL Agent or Reporting Services..
0
 
LVL 22

Author Closing Comment

by:Thomasian
ID: 34948917
Thanks for you help.

I will be posting related questions when I have more questions
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 34948956
Sure, welcome..
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

777 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