Migration of Progress to SQL for E10

Yahoo Archive
1
I've had great luck to leaving nothing to chance and using SQL Auth so I can control it without depending on other stuff.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Fri, Feb 13, 2015 at 11:57 AM, larry.jedik@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>And what about the Authentication? can the authentication be Windows Authentication ( I know not administrator) but a domain service account I&#39;ve created (EpicorRuntime)Â </p><div><br></div><div>or does the migration need to be an SQL Authentication?</div><div><br></div><div>Larry</div><p></p>

</div><span class="ygrps-yiv-641468036">
 


<div style="color:#fff;min-height:0;"></div>


2

I'm in the process of migrating my 9.05.702a Progress Database to SQL 2014. Here is my scenario...


 I have three servers:

 [Box1] -  is my E9.05 Server with Progress 10.2a on it.(source database)

 [Box 2] - is my SQL 2014 Database server that E 10 will be on (target database)

[Box 3] is my E10 Application Server.


I have installed the Epicor Admin console on Box 1 along with a copy of SQL 2014 Express. (Source Database)


I have created a Domain account named EpicorRuntime and also created an SQL security login with the same EpicorRuntime and given that user Public, bulk admin and dbcreator roles.


Under the User Mapping page, I have given this user public, & db_owner membership ans assigned it to the Master and empty database that was created. Also I have assigned dbo as the default Schema.


When I run the Migration I receive an error  'NT Authority\ANONYMOUS LOGON' 

When I contacted Epicor about this, they sent me a resolution that says that I need to make sure that SQL authentication is enabled in both SQL instances (from BOX 1 & BOX 2) 


My issue here is that when I do the same procedure as above for an SQL login, and then look at the configuration for the Target Database it is automatically set to a Windows Authentication?


Does anyone know how to change this to SQL Authentication? am I missing something?


Larry

3

Just a heads up, SQL Express has either a size limit or record count limit I forget which. We ran into this on our conversion.

I believe we also had this authentication error. In the Epicor configuration the source database tab we used the “sa” account and pwd.

 

Sorry I don’t have more info, our resident expert who ran this process is not in today.

 

Keith Mailloux

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, February 13, 2015 9:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Migration of Progress to SQL for E10

 

 

I'm in the process of migrating my 9.05.702a Progress Database to SQL 2014. Here is my scenario...

 

 I have three servers:

 [Box1] -  is my E9.05 Server with Progress 10.2a on it.(source database)

 [Box 2] - is my SQL 2014 Database server that E 10 will be on (target database)

[Box 3] is my E10 Application Server.

 

I have installed the Epicor Admin console on Box 1 along with a copy of SQL 2014 Express. (Source Database)

 

I have created a Domain account named EpicorRuntime and also created an SQL security login with the same EpicorRuntime and given that user Public, bulk admin and dbcreator roles.

 

Under the User Mapping page, I have given this user public, & db_owner membership ans assigned it to the Master and empty database that was created. Also I have assigned dbo as the default Schema.

 

When I run the Migration I receive an error  'NT Authority\ANONYMOUS LOGON' 

When I contacted Epicor about this, they sent me a resolution that says that I need to make sure that SQL authentication is enabled in both SQL instances (from BOX 1 & BOX 2) 

 

My issue here is that when I do the same procedure as above for an SQL login, and then look at the configuration for the Target Database it is automatically set to a Windows Authentication?

 

Does anyone know how to change this to SQL Authentication? am I missing something?

 

Larry

The information contained in this e-mail message is intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, or is not the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this message in error, please notify Ferguson Perforating immediately by telephone or reply by e-mail and then promptly delete the message. Thank-you.

4
thank you, yes I am aware there is a 10GB limit on SQL express, I do believe we are under this so that shouldn't be the issue.

I don't think it should batter if I used the built in sa account versus my own 'EpicorRuntime' account. 

-Larry
5

When you convert to SQL, your DB grows by 3 or 4 times… You should get off SQL express…Epicor has a version of SQL they sell for a couple hundred dollars.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, February 13, 2015 10:18 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Migration of Progress to SQL for E10

 

 

thank you, yes I am aware there is a 10GB limit on SQL express, I do believe we are under this so that shouldn't be the issue.

 

I don't think it should batter if I used the built in sa account versus my own 'EpicorRuntime' account. 

 

-Larry

6
We have already purchased SQL 2014 from Epicor, and that is loaded on BOX 2 our Database server.

Can my source database be on the same instance as the Target database?

I was under the impression that you needed to use SQL Express as that's what it states on page 42 of the Epicor ERP10 Installation Guide - Migrate Epicor 9.05 progress Openedge to Epicor 10

Larry
7
yes your DB can be on the same instance.. it doesn't care.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Fri, Feb 13, 2015 at 11:00 AM, larry.jedik@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>We have already purchased SQL 2014 from Epicor, and that is loaded on BOX 2 our Database server.</p><div><br></div><div>Can my source database be on the same instance as the Target database?</div><div><br></div><div>I was under the impression that you needed to use SQL Express as that&#39;s what it states on page 42 of the Epicor ERP10 Installation Guide - Migrate Epicor 9.05 progress Openedge to Epicor 10</div><div><br></div><div>Larry</div><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>

8
And what about the Authentication? can the authentication be Windows Authentication ( I know not administrator) but a domain service account I've created (EpicorRuntime) 

or does the migration need to be an SQL Authentication?

Larry
9
Can the authentication be Windows Authentication (not administrator), one I created named EpicorRuntime?

-Larry