Avatar of AmmarDJ
AmmarDJ
 asked on

SQL server 2008

Dear all/

I would appreaciate if someone could comprehensively enlighten me on this.
Can anyone answer the following terms in context of installation of SQL 2008 database server.


 What is the recommendation for SQL Compatibility Level requirement (80, 90 or 100)?
 while installation of the database for an application,if the application documentation does not mention it at all.
       

What is recovery model (simple & full). what should be the model if the application does not mention it at all.what is "point in time restore" needs?

What should be the Autogrowth recommendations for db. should the autogrowth turned on or off. if the application does not mention it at all.the application only mentions that you can add filegroups later using application interface when required.


· what should be the sql user for database access.  Application documentation mentions about sa user. what privileges does this user has and is it Ok to use this one.
                   
·
Microsoft SQL Server

Avatar of undefined
Last Comment
EugeneZ

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Member_2_861731

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
plusone3055

What is the recommendation for SQL Compatibility Level requirement (80, 90 or 100)?
 while installation of the database for an application,if the application documentation does not mention it at all.
100 = SQL Server 2008 and SQL Server 2008 R2
       

What is recovery model (simple & full). what should be the model if the application does not mention it at all.what is "point in time restore" needs?
http://msdn.microsoft.com/en-us/library/ms189275.aspx

What should be the Autogrowth recommendations for db. should the autogrowth turned on or off. if the application does not mention it at all.the application only mentions that you can add filegroups later using application interface when required.
http://www.sqlservercentral.com/Forums/Topic697970-146-1.aspx


· what should be the sql user for database access.  Application documentation mentions about sa user. what privileges does this user has and is it Ok to use this one.
Think of SA as (god mode) they have full access to everything in the DB and when configuring connections to other applications its best to use SA account
AmmarDJ

ASKER
As been told the sa account is not a safe user to set so what should be the permissions set on another created user. I need a user which can create the initial application database i.e. admin data
Member_2_861731

What does this "new" user have to do?
The database is only going to have to be created once, if you want you can create it with the SA account (or any other account that can create a database in the server), but use a different account (the new one) as the application user.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
AmmarDJ

ASKER
the "new" user (not the sa user) is mandatory as far as this application is concerned to create the initial database for the application.Please note that this database setup creates the admin schema to run this application.

Before doing this , the database engine has already been installated with an appropriate user,

SInce the DB administrator would never give the sa user to create this initial database for the applicaion (admin schema) how can another user created (which roles) to enable this.

Also I would appreciate if someone could tell me if I shoud use sql server authentical, windows authentication or mixed mode. How to decide between the three when installing and configuring the database server.
Member_2_861731

In order to be able to create databases the user must be a member of the dbcreator server role.

SQL Server Authentication is necessary when you're using a SQL user to connect to the database (as in your case)
Windows Authentication is used when you authenticate in the server with your windows user, used with Active Directory.

Mixed mode allows you to connect to SQL Server using either a windows account or a SQL Server user...

Since you need to authenticate with a SQL Server User, you need to enable Mixed Mode Authentication.
AmmarDJ

ASKER
Thanks guys for your help.

Lastly can you please tell.


What is "built in system account" . This pops up while installing the database engine,

And what is sql collation.

Also can I create an instance for my application with a user with sysadmin role other than the 'sa' user .
If yes ,how?

regardss
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
EugeneZ

--looks like this post should be set as at least 10 questions: please do not add extra questions in the 1 question... open a new one
---
check:
"built in system account":
Built-In Accounts
technet.microsoft.com/en-us/library/cc722455.aspx


Default User Accounts and Groups
http://technet.microsoft.com/en-us/library/bb726980.aspx
---

sql collation:
SQL Server Collation Fundamentals
http://technet.microsoft.com/en-us/library/aa174903(v=SQL.80).aspx