The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Changing a computer's name breaks remote
Posted: 03 Dec 08 2:49 PM
|
A customer's IT department occasionally changes a computer name on a machine running SLX 7.0 remote, which breaks access to the remote database. Connection manager is no longer able to connect. I have not found a solution other than cuttting a new remote. Does anyone have a better solution?
|
|
|
|
Re: Changing a computer's name breaks remote
Posted: 04 Dec 08 7:26 AM
|
This is a Microsoft problem.. not SalesLogix.
IF you change the name of a system that is running ANY SQL Server engine (MSDE/Pers SQL Server/Main SQL Server/SQLExpress..) you break things.
Usually you can fix this by deleting the Connection at the Connection Manager level (SalesLogix Server) and re-creating it manually. You will also want to delete and re-create the "client" datalink connection after doing it as well.
NOTE: Make sure you re-create them exactly as they originally were setup or you may have problems later on w/db replacements and/or upgrades.
The reason the re-cut works is because the AttachRemote process is destroying and re-creating the above connections 
--
RJLedger - www.SLxWizard.com
rjlSystems |
|
|
|
Re: Changing a computer's name breaks remote
Posted: 04 Dec 08 11:10 AM
|
In this case I wasn't able to do anything in connection manager without it crashing.
I suspected that a re-attaching the remote might do the trick. Next time I'll try this:
Shut off MSSQL service.
Copy the remote mdf to the desktop.
Run attach remote (You'll need the copy of the mdf because Attach Remote has to copy the file and it won't copy to itself).
|
|
|
|
Re: Changing a computer's name breaks remote
Posted: 04 Dec 08 12:37 PM
|
Dan
I've had this happen to me a number of times as well. When the computer name changes, the SQL system name changes, so what was once PC1\SALESLOGIX becomes COMPUTER1\SALESLOGIX. The Connection Manager will lockup or take a long time if you try to edit the existing connection because it'll try to talk to connect first. Just delete the old connection and create a new one. As RJ mentioned, you'll have to delete the Data Link and create a new one (the connection name when you sign into one of the clients).
It's pretty painless really. There is no reason you should have to detach and reattach the entire database, though it certainly works.
Marc |
|
|
|
Re: Changing a computer's name breaks remote
Posted: 05 Dec 08 2:25 AM
|
Note: when using SpeedSearch change the line Server=PC1 in the file SlxSearchService.ini
in the directory "C:\Program Files\SalesLogix\SpeedSearch\Bin"
Andre |
|
|
|