RE: Advice on Create a SQL Server

Tech-Archive recommends: Fix windows errors by optimizing your registry



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: Advice on Create a SQL Server
    ... I read about collation, but I didn't quite understand what collation is. ... and the IT will create a new instance for my databases. ... created a SQL Server before, and I don't know what to look for. ... basic setups and basic securities. ...
    (microsoft.public.sqlserver.setup)
  • Advice on Create a SQL Server
    ... After lunch today, I will meet with our IT department to have a discussion ... and the IT will create a new instance for my databases. ... created a SQL Server before, and I don't know what to look for. ... basic setups and basic securities. ...
    (microsoft.public.sqlserver.setup)
  • RE: Advice on Create a SQL Server
    ... If this is a vendor app, you can ask the vendor what collation should ... and the IT will create a new instance for my databases. ... created a SQL Server before, and I don't know what to look for. ... basic setups and basic securities. ...
    (microsoft.public.sqlserver.setup)
  • RE: Advice on Create a SQL Server
    ... Based on what you are saying and based on what I have read, wrong collation ... and the IT will create a new instance for my databases. ... created a SQL Server before, and I don't know what to look for. ... basic setups and basic securities. ...
    (microsoft.public.sqlserver.setup)
  • Re: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)