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!
|
|
Cannot cut remote after upgrade to 7.2
Posted: 18 Oct 07 4:01 PM
|
I've got a site we just upgraded to 7.2. Network clients are working fine but we cannot cut a remote. The database server is now SQL 2005 SP1 with backward compatibility installed. I'm trying to cut to a local SQL Express, also with backward compatibility installed.
Error: this shows up after the usual list of tables that will not be included in the remote. There is no error in the event viewer.
Database creationfailed : Access violation at address 008C0E9D in module 'Admin.exe'. Read of address 0000003D
I've tried setting up a SQL Native client connection and using that on the machine I'm cutting the remote on.
Any ideas?
Maria Amodei |
|
|
|
Re: Cannot cut remote after upgrade to 7.2
Posted: 19 Oct 07 7:40 AM
|
Why are you cutting to the local? You can cut on the server just like you always could.
Yep.. IF you are using SQL2005 you MUST install SQL Native on every system that has SalesLogix.. every system. Make sure the Connection manager is using Native as well. I'd also make sure SQLExpress (as supplied by Slx) is in the admin workstation.
I just did an upgrade for a client a few days ago.. 200+ remotes and we moved the main db from 2000 to 2005.. NO problems and thall remotes cut just fine on the server.
Oh yes.. you can also do the same if the main is SQL2000... you can cut on the db server too.
--
rjl |
|
|
|
Re: Cannot cut remote after upgrade to 7.2
Posted: 19 Oct 07 8:01 AM
|
I had tried the server first since I'd been told the SQL 2005 problem with cutting on the server was resolved. Then I tried cutting on a separate machine to rule that out.
Long story short, it was some old entries in resynctabledefs that did not have matching tables in the database. Now you can cut remotes wherever you want.
Maria |
|
|
|
Re: Cannot cut remote after upgrade to 7.2
Posted: 19 Oct 07 9:07 AM
|
I too had similiar problems. I could be wrong, but I think you CANNOT cut the remote DBs on the same machine that has the SQL2005 database as the remotes will be operating on MSDE V8. That's really SQL 2000. We set up another Admin workstation, installed the Native Client (on Server & Workstation - but not Network Clients).
We then had similiar problems. But we found that the default SA password for the remotes was SLXMaster. We had to play around with these password a bit, but we finally got it to generate the desired remote db. The question that still remains is: Can we support both the Slx OLE-DB and Native Client access methods at the same time. I'm trying to determine that by creating two lower level connections on the server.
Good Luck,
Bob |
|
|
|
Re: Cannot cut remote after upgrade to 7.2
Posted: 19 Oct 07 9:32 AM
|
It is working well at the site now, with SQL 2005 on the server. Cut the remotes on the server, then put them on SQL Express on the remote machines. Our problem ended up being unrelated to database version. It was caused by stray records in resynctabledefs with no matching tables.
I do have a site with 7.0 and MSDE on the remotes so we need to cut to a local MSDE instance there, using the SQL native client as the connection to the server when we log into Administrator to cut them. That site has worked fine as far as cutting. I named the connection using native drivers something obvious like "RemoteCut" so that it would not be used otherwise. |
|
|
| |
|