Windows Server

Stefano Colombo · Guest

Hi ,
I'm trying to install HIS2004 and got the following problem
As SQL server we have a Clustered SQL 2000 server.
When running the HIS2004 configuration Wizard the procedure stops with
the following error
"Windows NT user or group SQLSRV\HIS Administrator not found "
where SQLSRV is the virtual SQL Server Name of the clustered SQL Server
..

On the SQL Server Host the two local groups ( HIS Administrators and
HIS Runtime users ) are created but then the configuration stops with
the error "Windows NT user or group SQLSRV\HIS Administrator not found "

From the same node I'm trying the installation on I opened an MMC
console and connected to the SQLSRV server and opened the Local "HIS
Administrators" group successfully

Thanks
Stefano Colombo

Aaron Grady [MSFT] · Guest

Stefano-

Yes, the config wizard doesn't seem to work well against a clustered SQL
Server because it attempts to use the virtual server name\HIS Administrators
which just doesn't exist... even though the group does exist on the node you
are using.

Here are some steps that I have given to another customer to get this
working:

1. Create the database manually on the clustered SQL.
2. Create HIS Administrators and HIS Runtime Users groups on each of the
nodes in the cluster
3. Create HISAdmin and HISRuntime roles in the newly created database.
4. Add the nodes HIS Administrators and HIS Runtime Users groups as logins
to the newly created database and add them to the HISAdmin or HISRuntime
role (As appropriate)
5. Use the HIPTables.SQL script to create the tables and stored procedures
in the database. You can find this in the HIS\System directory.
6. Run the config wizard on the HIS machine, first pointing it at a local
SQL server instance (or a non-clustered SQL Server instance somewhere). Then
manually change the ConnectionString registry entry under
HKLM\Software\Microsoft\Host Integration Server\HIP to point at the
clustered SQL Server database that you just created.

Can you give that a try and let me know if that works for you? I believe one
of our support engineers may be working on writing this up in a KB article
at the moment.

HTH,
--
Aaron Grady
MCSE + Internet, MCDBA, MCSD
SNA Server/Host Integration Server 2000
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Stefano Colombo" <fakemail@iol.it> wrote in message
news:e2xgdE6AFHA.1400@TK2MSFTNGP11.phx.gbl...

Stefano Colombo · Guest

Hello Aaron ,
thanks for the instructions.
I cannot test your solution in short time because for testing purpose we
have setup the HIS against a non clustered SQL Server.
If test went good we might have to go on production on the clustered
server environment so I'll try your workaround ( or the KB if published )

Thanks
Stefano

"Aaron Grady [MSFT]" <aagrady@online.microsoft.com> ha scritto nel messaggio
news:OekUZU9AFHA.1388@TK2MSFTNGP09.phx.gbl...

	Windows Server Forum Index -> Host Integration Server	All times are GMT
Page 1 of 1