AXForum  
Вернуться   AXForum > Microsoft Dynamics CRM > Dynamics CRM: Blogs
All
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 05.11.2008, 17:34   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
This post is part of "Overview of NAV-specific SQL features for application consultants".


It describes the simplest way to get SQL Server installed in a test environment. It only mentions the changes to the default installation options that you need to make to get SQL Server running for NAV. Needless to say that for installing SQL Server in a live environment, there are further considerations to make like security, performance, etc, which are not described here.



Which edition:

If you have a choice of editions, then for a test system choose Developer Edition unless you have specific reasons to chose something else.



Installation options:

The following options are for installing SQL Server 2008, but the same options exist when installing SQL Server 2005, even though the menus may look slightly different.



The minimum features that you need to install are:
“Database Engine Services”
“Management Tools”
But I would also recommend installing “SQL Server Books Online”:





Another decision you have to make, is which account the SQL Server Services run under. When prompted for this, for a test system, set all SQL Server Services to use the “NT AuthoritySYSTEM” account (just specify the account, and leave password blank). When installing SQL Server 2008 it looks like this – for SQL Server 2005 it looks slightly different:





The final place where you should deviate from the default installation options, is to set Authentication Mode to “Mixed Mode”. As default, SQL Server will only use Windows Authentication. Setting it to “Mixed Mode” also gives you a database login, which can be useful in some cases:






Remember the password you specify here! This password is for the sa account, so you will always be able to log in to SQL Server as System Administrator with user ID "sa" and the password you decide here.


Use default options for the rest of the installation.


Once you have installed SQL Server, then you will find “SQL Server Management Studio” in the start menu, which is where you can do all the admin tasks that you need.








Lars Lohndorf-Larsen


Microsoft Dynamics UK



Microsoft Customer Service and Support (CSS) EMEA


These postings are provided "AS IS" with no warranties and confer no rights. You assume all risk for your use.




Читать дальше
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 23:57.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.