cancel
Showing results for 
Search instead for 
Did you mean: 

Installation of Dialog Instance (DI) - Error during installation...

joo_migueldimas
Active Participant
0 Kudos

Hello gurus,

System: SAP ECC 6.0 SR3 (ABAP+JAVA) -- Central Instance (CI)

Database: MS SQL Server 2008

Operation System: Windows Server 2003 X64

I´m trying to install a Dialog Instance (DI) but during the SAPInst I´m faccing with an error!

First at all I made some things/requirements in this new server like:

- Install J2SDK;

- Set Swap space (20 Gb);

- Install SQL Server 2008 x64.

So, after that, I run SAPInst with the following option: "SAP ERP 6.0 Support Release 3 --> Software Life-Cycle Options --> Application Server --> MS SQL Server --> Dialog Instance"

The error is on the screen "MS SQL Server --> Database Connection Information" when I put in field "Database Instance" the value (in my case I write PTREPRDPRD which are the hostname of CI server and the sap instance PRD), after I typing the button "Next" it shown a message error which say:

"Cannot connect to PTREPRDPRD Error(s) returned: SQL Server does not exist or access denied. SOLUTION: Check that you specified the correct name for the database server, that the server is running and you are authorized to log on to it."

Can you help me how to resolve this problem!??

Kind regards,

Joao Dimas - Portugal

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

Yes.. correct. That was the pre-req though. I thought you had already done that.

Anyways, glad that it is workng for you.

Regards

Javed

Former Member
0 Kudos

Have you installed the MS-SQL client on the application server? If yes, can you connect to database through client?

Regards,

Javed

joo_migueldimas
Active Participant
0 Kudos

Hello Javed Sapstar,

I just passed this point on sapinst (for DI installation). What I did was create the same user adm of CI server). Both servers (CI + DB server and the DI server) are not registered in Domain, both servers are only registered as Local machines, thus, they must have a username and password same in both!!

Thank you for your help!

Best regards,

João Dimas - Portugal

Former Member
0 Kudos

Hi

We are doing dialoug instance below i mentioned the error

Cannot connect to ERPSOLMAN Error(s) returned: [SQL Server]Login failed for user ''. The user is not associated with a trusted SQL Server connection. SOLUTION: Check that you specified the correct name for the database server, that the server is running and you are authorized to log on to it.Kindly any solutions

Former Member
0 Kudos

Please post lines corresponding to the error (last 40-50 lines) from sapinst_dev.log for help in analysis.

Cheers!!

Javed

joo_migueldimas
Active Participant
0 Kudos

Hello Javed,

Here you have it, sapinst_dev log:

TRACE      2010-07-26 13:21:49.582 [iaxxgenimp.cpp:360]
           CGuiEngineImp::showDialogCalledByJs() 
<dialog sid="diMssLoginWINOnly">
<title>MS SQL Server &gt; Database Connection Information</title>
<field enabled="true" highlight="false" sid="iHost">
 <caption>Database Instance</caption>
 <helpitem id="Databases.MS SQL Server.DatabaseInstance"/>
 <value type="string">PTRESAPPRD</value>
</field>
<dialog/>

TRACE      2010-07-26 13:21:49.582 [iaxxgenimp.cpp:1255]
           CGuiEngineImp::acceptAnswerForBlockingRequest 
Waiting for an answer from GUI

TRACE      2010-07-26 13:21:57.379 [iaxxdlghnd.cpp:96]
           CDialogHandler::doHandleDoc() 
CDialogHandler: ACTION_NEXT requested

TRACE      2010-07-26 13:21:57.379 [iaxxcdialogdoc.cpp:212]
           CDialogDocument::submit() 
<dialog sid="diMssLoginWINOnly">
<field enabled="true" highlight="false" sid="iHost">
 <caption>Database Instance</caption>
 <helpitem id="Databases.MS SQL Server.DatabaseInstance"/>
 <value type="string">PTRESAPPRD\PRD</value>
</field>
<dialog/>

TRACE      2010-07-26 13:21:57.395 
  Call block:MssLoginInfo_ind_ind_ind_ind
    function:MssLoginInfo_ind_ind_ind_ind_DialogPhase_dAskForConnectionValidator_default
is validator: true

TRACE      2010-07-26 13:21:57.395 
t_MssLogin.remove(WHERE Key='std')

TRACE      2010-07-26 13:21:57.395 
t_MssLogin.insertRow({
  Key:std
  Host:PTRESAPPRD\PRD
  LoginType:WIN
}), inserting

TRACE      2010-07-26 13:21:57.395 
MSSTRC: odbc driver is installed.

TRACE      2010-07-26 13:21:57.395 
t_MssMessages.remove(WHERE 1=1)

TRACE      2010-07-26 13:22:13.426 
Cannot connect to PTRESAPPRD\PRD
SQL Server does not exist or access denied.

TRACE      2010-07-26 13:22:13.457 [iaxxgenimp.cpp:752]
            CGuiEngineImp::showMessageBox 

<html> <head> </head> <body> Cannot connect to PTRESAPPRD\PRD<br>Error(s) returned:<br>SQL Server does not exist or access denied.

<br>SOLUTION: Check that you specified the correct name for the database server, that the server is running and you are authorized to log on to it. </body></html>

TRACE      2010-07-26 13:22:13.457 [iaxxgenimp.cpp:1255]
           CGuiEngineImp::acceptAnswerForBlockingRequest 
Waiting for an answer from GUI

TRACE      2010-07-26 13:22:22.973 [iaxxdlghnd.cpp:204]
           CDialogHandler::doHandleDoc() 
CDialogHandler: ACTION_ERROR received

TRACE      2010-07-26 13:22:22.973 [iaxxgenimp.cpp:1255]
           CGuiEngineImp::acceptAnswerForBlockingRequest 
Waiting for an answer from GUI

TRACE      2010-07-26 13:22:42.410 [iaxxdlghnd.cpp:82]
           CDialogHandler::doHandleDoc() 
CDialogHandler: ACTION_PREV requested

TRACE      2010-07-26 13:22:42.410 [iaxxgenimp.cpp:368]
           CGuiEngineImp::showDialogCalledByJs() 
<dialog sid="diMssLoginWINOnly">
<dialog/>

TRACE      2010-07-26 13:22:42.442 
The step dAskForConnection with key |NW_DI|ind|ind|ind|ind|0|0|NW_GetSidFromProfiles|ind|ind|ind|ind|1|0|NW_getDBInfo|ind|ind|ind|ind|4|0|NW_MSS_DBINFO|ind|ind|ind|ind|3|0|MssLoginInfo|ind|ind|ind|ind|0|0 has been executed successfully.

WARNING    2010-07-26 13:22:13.426 
           lib=iamodmssql module=CIaNtMssDmo
Cannot connect to the database server. Errors returned: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
 Call your SAP Support.

INFO       2010-07-26 13:22:42.489 [sixxcstepexecute.cpp:781]
Execute step dCheckGivenServer of component |NW_DI|ind|ind|ind|ind|0|0|NW_GetSidFromProfiles|ind|ind|ind|ind|1|0|NW_getDBInfo|ind|ind|ind|ind|4|0|NW_MSS_DBINFO|ind|ind|ind|ind|3|0|MssLoginInfo|ind|ind|ind|ind|0|0

former_member227283
Active Contributor
0 Kudos

Hi,

Can you confirm CI and DI is on same IP range ??

Thanks

Anil

joo_migueldimas
Active Participant
0 Kudos

Hello Anil Bhandary,

Yeah they are!

The CI server is 172.31.20.18 and DI server is 172.31.20.19... as you can see both are on same IP range!!

Kind regards,

João Dimas - Portugal

Former Member
0 Kudos

Please check the network connection of your DB server from the application server. Whether you are able to ping the server or not.

Make the entry of the IP address and hostname in the host file of the window in which you are facing the error. In host file put Ip address then your fully qualified host name of the DB server and then hostname without domain name.

Please let us know if this resolves the issue or not.

Reagrds,

Elnino

JPReyes
Active Contributor
0 Kudos

Check that the name and IP are populated on the hosts file. If the instalation cant resolve the host name of your CI is not going to work

Regards

Juan

joo_migueldimas
Active Participant
0 Kudos

Hello Juan Reyes,

I install only the SNAC software on the future instance dialog instance (DI) server!

I put an entry of the IP address and hostname (of the CI server) in the host file of the windows in which I am facing the error (DI server). In host file I put the IP address then hostname of the DB server which is the same server of where is installed SAP System (Central Instance).

When I ping both servers in each server, everything is OK!

Note: These two servers (CI/DB Server and the DI) are not registered in domain, both servers are only registered as Local machines!

Any other tips?

Kind regard,

Joao Dimas - Portugal