HP AiO400r HP StorageWorks All-in-One Storage System User Guide (440583-005, F - Page 112

Application software problems, SQL Server errors, ASM alerts

Page 112 highlights

3. Install the current drivers. Application software problems If your application software locks up, perform the following actions: • Check the application log and operating system log for entries indicating why the software failed. • Check for incompatibility with other software on the server. • Check the support web site of the software vendor for known problems. • Review the log files for changes made to the server that may have caused the problem. • Scan the server for viruses with an updated virus scan utility. SQL Server errors Host a SQL Server Database Wizard authentication error Problem: While using the Host a SQL Server Database Wizard, you receive an error message informing you that ASM cannot authenticate with the server that hosts SQL Server. Solution: Each SQL Server license (instance) must have a login for the local user called ASMUser with the server role defined as System Administrators. This login is created during the installation of the ASM agent on the server that hosts SQL Server; however, if another SQL Server license is installed after the ASM agent is installed, this login will not be configured. To fix this problem, you can remove the ASM agent from the server that hosts SQL Server, and then reinstall it following the instructions in the HP StorageWorks All-in-One Storage System quick start instructions (no information will be lost). Or, manually enter the login as follows: 1. Open SQL Server Enterprise Manager. 2. Connect to the server with SQL Server data you want to store on your HP All-in-One Storage System. 3. Select the Security Folder. 4. Select Logins. 5. Select New Login. 6. In the Name field, enter ASMUser. 7. In the Domain field, enter the domain name for the server that hosts SQL Server. 8. Select the Server Roles tab. 9. Select the System Administrators server role and click OK. ASM alerts ASM generates an alert whenever the status of an application area or storage area changes from OK to Warning or Critical. The alerts describe the condition that caused the storage status to change. Alerts are displayed on the General tab of the Properties window. 112 Troubleshooting, servicing, and maintenance

  • 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
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204

3.
Install the current drivers.
Application software problems
If your application software locks up, perform the following actions:
Check the application log and operating system log for entries indicating why the software failed.
Check for incompatibility with other software on the server.
Check the support web site of the software vendor for known problems.
Review the log files for changes made to the server that may have caused the problem.
Scan the server for viruses with an updated virus scan utility.
SQL Server errors
Host a SQL Server Database Wizard authentication error
Problem:
While using the Host a SQL Server Database Wizard, you receive an error message informing
you that ASM cannot authenticate with the server that hosts SQL Server.
Solution:
Each SQL Server license (instance) must have a login for the local user called
ASMUser
with
the server role defined as System Administrators. This login is created during the installation of the
ASM agent on the server that hosts SQL Server; however, if another SQL Server license is installed
after the ASM agent is installed, this login will not be configured.
To fix this problem, you can remove the ASM agent from the server that hosts SQL Server, and then
reinstall it following the instructions in the
HP StorageWorks All-in-One Storage System quick start
instructions
(no information will be lost). Or, manually enter the login as follows:
1.
Open SQL Server Enterprise Manager.
2.
Connect to the server with SQL Server data you want to store on your HP All-in-One Storage
System.
3.
Select the Security Folder.
4.
Select
Logins
.
5.
Select
New Login
.
6.
In the Name field, enter
ASMUser
.
7.
In the Domain field, enter the domain name for the server that hosts SQL Server.
8.
Select the
Server Roles
tab.
9.
Select the
System Administrators
server role and click
OK
.
ASM alerts
ASM generates an alert whenever the status of an application area or storage area changes from
OK to Warning or Critical. The alerts describe the condition that caused the storage status to change.
Alerts are displayed on the General tab of the Properties window.
Troubleshooting, servicing, and maintenance
112