Autodesk 46304-050008-1600A Implementation Guide - Page 36

Set Up Remote SQL, Con Microsoft SQL Server for Remote Access

Page 36 highlights

In the Service Account dialog box, specify the Local System account. Or, if you plan to perform backups and restores to remote locations, specify a Domain User account for the SQL Server. 6 In the Authentication Mode dialog box, select Mixed Mode authentication and set the SA password. The default password used in during a default installation is "AutodeskVault@26200". Set Up Remote SQL Vault Collaboraition or Professional allow the Vault environment to be configured to use a remote SQL database. This database resides on a dedicated server which a single site can use to increase performance. Alternatively, it can be used for a multi-site replicated Vault environment. Configure Microsoft SQL Server for Remote Access NOTE The following steps are detailed steps for setting up remote access on SQL 2005. Some steps may vary for SQL 2008. 1 On the computer on which SQL is installed, click Start ➤ Programs ➤ Microsoft® SQL Server 2005 ➤ Configuration Tools ➤ SQL Server Configuration Manager. 2 In the SQL Server Configuration Manager dialog box, expand SQL Server 2005 Network Configuration and then select Protocols for AUTODESKVAULT. 3 Right-click TCP/IP in the protocols list and then select Enable. 30 | Chapter 4 Build the Vault Environment

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140

In the Service Account dialog box, specify the Local System account. Or,
if you plan to perform backups and restores to remote locations, specify
a Domain User account for the SQL Server.
6
In the Authentication Mode dialog box, select Mixed Mode authentication
and set the SA password. The default password used in during a default
installation is
AutodeskVault@26200
.
Set Up Remote SQL
Vault Collaboraition or Professional allow the Vault environment to be
configured to use a remote SQL database. This database resides on a dedicated
server which a single site can use to increase performance. Alternatively, it
can be used for a multi-site replicated Vault environment.
Configure Microsoft SQL Server for Remote Access
NOTE
The following steps are detailed steps for setting up remote access on SQL
2005. Some steps may vary for SQL 2008.
1
On the computer on which SQL is installed, click
Start
Programs
Microsoft
®
SQL Server 2005
Configuration
Tools
SQL Server Configuration Manager.
2
In the SQL Server Configuration Manager dialog box, expand SQL Server
2005 Network Configuration and then select Protocols for
AUTODESKVAULT.
3
Right-click TCP/IP in the protocols list and then select Enable.
30
| Chapter 4
Build the Vault Environment