Solved

SQL Server Installation

Posted on 2011-02-21
10
912 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
Comment Utility
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
Comment Utility
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
Comment Utility
>>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
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
Comment Utility
>> 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
Comment Utility
>> 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
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 
LVL 22

Author Comment

by:Thomasian
Comment Utility
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
Comment Utility
I got the BUILTIN\Administrators question. Just "Administrators" works fine.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
Comment Utility
>> 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
Comment Utility
Thanks for you help.

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

Expert Comment

by:Raja Jegan R
Comment Utility
Sure, welcome..
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
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…
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.

728 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now