Freedom software in MSSQL

I run Freedom software on my clients machines. When the computer name changes
we have to completely reinstall the Freedon software or it will not connect
to the MSSQL server. Someone told us that there is a command in MSSql that
will allow us to change the computer name of the client Any ideas?
When the computer name of the client changes or the computer name of the
server changes? I ran Freedom software at a client and didn't see an
issue with changing the client names. If the server changes, you need to
change the configuration on the Freedom software. You could also set up a
server alias in the client utility, although I would't recommend that
approach.
"Debbie" <Debbie@.discussions.microsoft.com> wrote in message
news:4C371B83-E233-462D-AE7C-F69C25624C0E@.microsoft.com...
> I run Freedom software on my clients machines. When the computer name
changes
> we have to completely reinstall the Freedon software or it will not
connect
> to the MSSQL server. Someone told us that there is a command in MSSql that
> will allow us to change the computer name of the client Any ideas?

freedom software

I run Freedom software on my clients machines. When the
computer name changes
we have to completely reinstall the Freedon software or it
will not connect
to the MSSQL server. Someone told us that there is a
command in MSSql that
will allow us to change the computer name of the client
Any ideas?
Debbie
When you say client do you mean Client as in Client Machine separate from
the Server Machine or do you mean Client Software?
If you change the name of the Server Machine there is a stored procedure you
can run to notify SQL Server that the hosts name has changed.
see @.@.SERVERNAME
Remarks
SQL Server Setup sets the server name to the computer name during
installation. Change @.@.SERVERNAME by using sp_addserver and then restarting
SQL Server. This method, however, is not usually required.
Rich
"Debbie" wrote:

> I run Freedom software on my clients machines. When the
> computer name changes
> we have to completely reinstall the Freedon software or it
> will not connect
> to the MSSQL server. Someone told us that there is a
> command in MSSql that
> will allow us to change the computer name of the client
> Any ideas?
>