RE: Advice on Create a SQL Server

AccessHelp,

Listen to your IT department. They will, for the most part, understand what
to install for SQL Server. Use the default collation. On "Authentication
Mode" - it depends on how you will be connecting to your database. If you
have an application connecting to your database that resides on a windows
domain, and running on a windows domain account, it is better to run under
Windows Authentication mode. However, some applications require a connection
to SQL Server using a username/password. In that case you will need to use
Mixed Mode.

--
Michael Loyd
MCDBA
a0209129



"Linchi Shea" wrote:

The default collation is the one SQL Server setup presents you when you
install SQL Server and choose everything by default. It depends on your
Windows locale, which you can find from Regional Options in Control Panel.
For US English, it's SQL_Latin1_General_CP1_CI_AS.

Look up in the Books Online under "Default Collations in SQL Server Setup"
for teh complete list of the default collations.

Linchi

"Accesshelp" wrote:

Hi Linchi,

Thank you very much for continuing to help. I am not sure what the server
default collation is. I think I know what I should have for collation.
Below is what I come up with:

SQL_Latin1_General_CP1_CI_AS_KI_WI
Dictionary order, case-insensitive

What do you think of it?

In addition, what other things that I need to know? As far as
Authentication Mode, based on what I have read, Windows Authentication is the
best option. Do you agree?

Thanks.

"Linchi Shea" wrote:

No, there is no one-fit-all collation. You have to make a choice. But if you
have no idea and nobody else has any idea when it comes to your database, you
are probably fine with a server default collation -- just a wild guess.

Linchi

"Accesshelp" wrote:

Linchi,

Thanks again for the information.

Is there a "one-fit-all" collation? I am not sure what would be
appropriate. I will be using this instance for the data similar to tax
returns. How should I determine the most appropriate collation for this
instance?

Based on what you are saying and based on what I have read, wrong collation
can create headach.

Thanks.

"Linchi Shea" wrote:

Collations determine the physical storage of character strings and how they
are sorted. Because this is fundamental and any change afterwards can be a
big headache, you want to make sure you use the correct collation before
hand. If this is a vendor app, you can ask the vendor what collation should
be used. If it's an internal app, you can probably just match whatever
collation is used by the QA/Dev server or check with the developer.

Linchi

"Accesshelp" wrote:

Hi Linchi,

Thanks for your input.

I read about collation, but I didn't quite understand what collation is.
Can you tell me what collation is and what I need to have for collation
requirements?

Are there anything else that I need to look for or to communicate with IT?

Thanks.

"Linchi Shea" wrote:

Hopefully, you have communicated your collation requirement to your IT. You
don't want them just to create the instance with whatever assumption they may
have about the default collation if there is a chance that is not what you
want.

Linchi

"Accesshelp" wrote:

Hello all,

After lunch today, I will meet with our IT department to have a discussion
on creating a new SQL Server instance. We already have instances in our
server, and the IT will create a new instance for my databases. I have never
created a SQL Server before, and I don't know what to look for. It will be
SQL Server 2005.

I have read materials from SQL Server 2005 Books Online and from SQL Server
2005 Bible by Paul Nielsen about setting up SQL Server. However, they do not
discuss things that I need to know when I work with IT department.

From my understanding, IT will create an instance (a shell) for me with
basic setups and basic securities. I will then create databases in the
instance.

Can you guys share some items that I need to mention during the meeting in
case IT misses or so that I won't act like I do not know anything?

Thanks.
.

Relevant Pages

  • Re: SQL_Latin1_General_CP1_CS_AS
    ... case-SENSITIVE from the SQL collation. ... Windows collations on the other hand are taken from Windows. ... When you install SQL Server, you will be suggested a default collation ...
    (comp.databases.ms-sqlserver)
  • RE: Advice on Create a SQL Server
    ... Use the default collation. ... Mode" - it depends on how you will be connecting to your database. ... domain, and running on a windows domain account, it is better to run under ... to SQL Server using a username/password. ...
    (microsoft.public.sqlserver.setup)
  • Re: Installing SQL_Latin1_General_CP1_CI_AS collation order??
    ... Tibor Karaszi, SQL Server MVP ... "Ward Horsfall" wrote in message ... >> rebuildm.exe) interfaces and a collation designator, ...
    (microsoft.public.sqlserver.setup)
  • Re: Nearest Common Ancestor Report (XDb1s $1000 Challenge)
    ... but even MORE generic than the XDb1 implementation, ... disadvantage that 'john', 'John' and 'JOHN' are treated as three distinct ... Since this is the default collation, I assume that your database will use ... I have SQL Server on my desktop; ...
    (comp.object)
  • Re: Russian Language support in SQL SERVER
    ... SQL Server supports languages on a couple of levels. ... specifying a collation defines what language rules are used for ... Cyrillic_general Windows collation that supports the Russian language. ...
    (microsoft.public.sqlserver.server)
Loading