Solved

SQL Server Installation

Posted on 2011-02-21
10
916 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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 I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

789 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