Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
 Posted - 2005-03-28 : 13:45:21
|
| I am working on a development for contact management for our sales agents out on the road. They will be disconnected from the network for extended periods without internet access yet still need to be able to access a central Database for entering and retrieving data via a laptop.After a lot of reading and messing around I feel the best method would be to use MSDE on the laptops and run merge replication to a main SQL 2000 Server Database though the main network or VPN. I believe I have the solution to the conflict issue of merge because my front end will control the update capability or “ownership” of a given entry to the creator of said entry unless it has been given to another and as this is incorporated into the Key field no conflicts. My problem is that I cannot get the main SQL server to connect to the MSDE on the remote computer so that I can run the merge. I created the MSDE using.C:\msde\Setup DIABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL SAPWD="MYTSQL" DATADIR="c:\SQLDB\"I have tried different combinations of Access rights and SQL and Windows authentification with no luck. KB says it should work but I must be missing something. The EM error is. SQL Server registration failed because of the connection failure displayed below. Do you wish to Register anyway?SQL Server does not exist or access denied.ConnectionOpen (Connect()) The MSDE is in the dropdown list but I cannot connect.JimUsers <> Logic |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-03-29 : 08:35:39
|
| Found it the "DIABLENETWORKPROTOCOLS=0" did not take I had to configure it through EM.This does cause a problem when I want to create a instalation package.JimUsers <> Logic |
 |
|
|
|
|
|
MSDE and SQL 2000 Server