Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 934
  • Last Modified:

SQL Server Installation

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
Thomasian
Asked:
Thomasian
  • 5
  • 5
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
ThomasianAuthor Commented:
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
 
ThomasianAuthor Commented:
>>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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> 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
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> 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
 
ThomasianAuthor Commented:
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
 
ThomasianAuthor Commented:
I got the BUILTIN\Administrators question. Just "Administrators" works fine.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> 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
 
ThomasianAuthor Commented:
Thanks for you help.

I will be posting related questions when I have more questions
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Sure, welcome..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now