12-15-2005 07:39 AM - edited 03-18-2019 05:24 PM
When I ran the failover config on the primary server, it completed successfully, when I ran it on the secondary server, I got the error message at the end of the SQL replication:
Error [0x80044833] : [Microsoft][ODBC SQL Server Driver][SQL Server]Could not connect to server 'USMDLSTAGEUM1' because 'distributor_admin' is not defined as a remote login at the server.
I re-ran the primary failover configuration again and it then also got the same error which made me think perhaps this was permissions related (as customer has a very complex/tight GPO). I have verified local permissions for the unity install accounts (all of them) but cant get past this.
Does anyone know how to resolve this? Thanks.
12-15-2005 10:31 AM
CSCea45624 FCW fails to configure SQL replication
Release-note
Symptom: SQL replication fails to be configured during Failover Configuration.
The following error occurs:
Configure Cisco Unity Failover Wizard - [0x80044833]
[Microsoft][ODBC SQL Server Driver][Sql Server]Could not connect to server
"
at the server.
Condition: The root of this problem was found in the SQL configuration.
At some point in the server's lifetime, the server name was changed. As a
result, SQL Server was using the old machine name rather than the updated
machine name.
Workaround: This problem can be resolved by following these steps in SQL Query
Analyzer. These steps will change the SQL Server name to match the machine
name. It relies on the user correctly entering the machine name for
name>:
1) Get old server name by running SELECT @@SERVERNAME
2) EXEC sp_dropserver '
3) EXEC sp_addserver '
4) Stop and start MSSQLSERVER service. NOTE: You must also stop Unity.
5) Verify new server name with SELECT @@SERVERNAME
12-19-2005 11:17 AM
This is exactly what my problem is..thanks very much.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide