Hello!
I'm trying to configure our system to seperate our SQLServer from our AppServer. I'm attempting to modify the mfgsys.pf and DSN to point Progress to a seperate physical database server.
Does anyone have an example mfgsys.pf entry they could share?
Here is what I'm attempting to change from:
-db EpicorTrain904 -dt MSS -ld mfgsys -Dsrv PRGRS_CONNECT,DSN=Epicor904TXN_ISOLATION,1,PRGRS_NATIVE_LOCKWAIT,30000,PRGRS_NOWAIT_OVERRIDE,1
TO: (per Epicor)
-db EpicorTrain904 -dt MSS -ld mfgsys -Dsrv PRGRS_CONNECT,DSN=EpicorTrain904;server=EpicorDevSQL;UID={WindowsLogin};PWD={WindowsPW},TXN_ISOLATION,1,PRGRS_NATIVE_LOCKWAIT,30000,PRGRS_NOWAIT_OVERRIDE,1
The Windows Login having permissions on the SQLServer. Of course, changing the DSN on the AppServer.
My Admin tools can connect, but not the Admin Console or the smart client.
Any help would be greatly appreciated!
Bob
I'm trying to configure our system to seperate our SQLServer from our AppServer. I'm attempting to modify the mfgsys.pf and DSN to point Progress to a seperate physical database server.
Does anyone have an example mfgsys.pf entry they could share?
Here is what I'm attempting to change from:
-db EpicorTrain904 -dt MSS -ld mfgsys -Dsrv PRGRS_CONNECT,DSN=Epicor904TXN_ISOLATION,1,PRGRS_NATIVE_LOCKWAIT,30000,PRGRS_NOWAIT_OVERRIDE,1
TO: (per Epicor)
-db EpicorTrain904 -dt MSS -ld mfgsys -Dsrv PRGRS_CONNECT,DSN=EpicorTrain904;server=EpicorDevSQL;UID={WindowsLogin};PWD={WindowsPW},TXN_ISOLATION,1,PRGRS_NATIVE_LOCKWAIT,30000,PRGRS_NOWAIT_OVERRIDE,1
The Windows Login having permissions on the SQLServer. Of course, changing the DSN on the AppServer.
My Admin tools can connect, but not the Admin Console or the smart client.
Any help would be greatly appreciated!
Bob