Solved

SQL Server Installation

Posted on 2011-02-21
10
915 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
  • 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

809 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