on 07-24-2010 5:18 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have you installed the MS-SQL client on the application server? If yes, can you connect to database through client?
Regards,
Javed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Please post lines corresponding to the error (last 40-50 lines) from sapinst_dev.log for help in analysis.
Cheers!!
Javed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 > 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
Hi,
Can you confirm CI and DI is on same IP range ??
Thanks
Anil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.