on 11-04-2013 1:06 PM
Looks like a few of you have found a work-around. I'm still trying to fix my SQL Server 2008 installation. I suspect everyone had the same errors in the SQL4SAP log (see below).
Does anyone know what those commands are trying to do?
From the previous discussions, it would seem that the problem is connectivity related (perhaps DNS, or similar). Anyone have any ideas? I must have tried the install 10 times already with the same result.
11/11/2013 3:09:36 PM
----------------------------------------
CreateObject("ADODB.Connection")
Open(Provider=SQLOLEDB;Integrated Security='SSPI';Initial Catalog=master;Data Source='.')
=> ERROR
Execute(exec sp_configure 'show advanced options', 1 reconfigure with override )
=>
Close
=> ERROR
11/11/2013 3:09:58 PM
----------------------------------------
CreateObject("ADODB.Connection")
Open(Provider=SQLOLEDB;Integrated Security='SSPI';Initial Catalog=master;Data Source='.')
=> ERROR
Execute(exec sp_configure 'max degree of parallelism', 1 exec sp_configure 'xp_cmdshell', 1 exec sp_configure 'SMO and DMO XPs', 1 reconfigure with override ALTER LOGIN [sa] DISABLE )
=>
Close
=> ERROR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Ron,
Those commands are trying to create the connection to SQL Server.
Can you ping to your server name (from the server itself)? (sorry but I have to ask).
By the way, are you using virtual host names or clustering?
Please check DNS/hosts, UAC, path to installation media and windows firewall.
And take a look on SAP notes:
1282975 - Use of virtual TCP/IP host names in Windows
1144459 - SAP Installation Media and SQL4SAP for SQL Server 2008 (R2)
Best regards.
M. Massoud
Thanks for your reply. I thought so.
I read some previous notes regarding people that re-installing the OS and then got MS SQL to successfully install. I chose to update the OS. (There were a number of Microsoft OS patches outstanding.)
Once complete, I removed the partial MS SQL Server install, and then re-tried.
This time it worked. It would appear this error has something to do with the OS patch level.
I could not find any OS patch level details in the PAM. Does SAP list the OS patch level for each product? All I've seen is the main release version (i.e. MS Windows 2008). Nothing on the patch level.
Hi Guys,
Thanks for the replies, but all relevant note inspections was done, CUA and firewall was disabled, I tried to unistall and reinstall the MSSQL 2008 and MSSQL 2008R2, but both of MSSQL version installation said same warning with the version number at end of the installation.
When I tried to run the SAP install (SWPM 7.0x SP4) it can looked up the SQL server, but cannot connect in to the server.
Some other MSSQL server was installed on this Windows 2008, and I think it was the problem.
We reinstall the OS and then the MSSQL 2008R2 install was successfully.
This is just a workaround, not the solution, but works...
Regards
Janos
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Janos,
I'm glad you (and also Bhaskar) could solve it but, as you said, that was a workaround. We had exactly the same problem as you did:
...CUA and firewall was disabled, I tried to unistall and reinstall the MSSQL 2008 and MSSQL 2008R2, but both of MSSQL version installation said same warning with the version number at end of the installation.
When I tried to run the SAP install (SWPM 7.0x SP4) it can looked up the SQL server, but cannot connect in to the server.
There was a wrong entry in HOSTS file causing sql4sap and sapinst could not connect to SQL Server. I don't know if that was your case but I hope next time you don't need to reinstall the OS!
Best regards.
M. Massoud
Hi All,
Finally completed the SQL installation, i have followed the below steps.
1. Format the OS
2. Disable the CUA in Control panel
3. Copy the media in separate folder.
4. Start the SQL installation and Successfully completed
Thanks all for your support.
Best Regards,
Bhaskar N
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please let me know if you find a solution to your problem. I have just started a NW731 install with SQL Server 2008 R2 and have run into the exact problem. Turning off UAC did not change anything.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
I just faced the same issue. In my case, there was a problem with name resolution. I followed these steps:
- Fix DNS
- Completely uninstall SQL Server
- Turn off UAC
- Copy the installation media to a new directory (path without spaces)
- Reboot the system
- Install SQL Server again (successfully)
Best regards.
Hi There,
I have same issue and C:\windows\sql4sap.log shows the following error at the ending:
2013.11.06. 12:39:33
----------------------------------------
CreateObject("ADODB.Connection")
Open(Provider=SQLOLEDB;Integrated Security='SSPI';Initial Catalog=master;Data Source='.')
=> ERROR
Execute(exec sp_configure 'show advanced options', 1 reconfigure with override )
=>
Close
=> ERROR
2013.11.06. 12:39:54
----------------------------------------
CreateObject("ADODB.Connection")
Open(Provider=SQLOLEDB;Integrated Security='SSPI';Initial Catalog=master;Data Source='.')
=> ERROR
Execute(exec sp_configure 'max degree of parallelism', 1 exec sp_configure 'xp_cmdshell', 1 exec sp_configure 'SMO and DMO XPs', 1 reconfigure with override ALTER LOGIN [sa] DISABLE )
=>
Close
=> ERROR
2013.11.06. 12:40:16
----------------------------------------
CreateObject("ADODB.Connection")
Open(Provider=SQLOLEDB;Integrated Security='SSPI';Initial Catalog=master;Data Source='.')
=> ERROR
Execute(select serverproperty('ProductVersion'))
=>
Close
=> ERROR
2013.11.06. 12:40:37
----------------------------------------
Message Box "Wrong SQL Server version"
Installation finished successfully...
but verification showed unexpected version:
SQL Instance: (default)
SQL Version:
The SAPInstall said:
TRACE 2013-11-06 13:57:27.456
MSSTRC: odbc driver is installed.
TRACE 2013-11-06 13:57:27.468 [iaxxclib.cpp:161]
CLib::load()
Opened C:\Users\HOSTLO~1\AppData\Local\Temp\2\sapinst_exe.5568.1383742388/iamodmssql.dll
WARNING 2013-11-06 13:57:48.658 [iaxmcsql.cpp:113]
iastring CIaMssSqlConnect::executeSQL(args_t const& _args)
Cannot connect to the database server. Errors returned: [Microsoft][ODBC SQL Server Driver]A várakozási idő lejárt.
Call your SAP Support.
TRACE 2013-11-06 13:57:48.666
Cannot connect to ORION
A várakozási idő lejárt.
ORION is the MSSQLSERVER (default), and "A várakozási idő lejárt." means the time is out...
Any idea?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I thing you may require to check the MS Sql server installation media and OS support Kindly refer the Installation guide http://service.sap.com/instguides -> Database Upgrades -> MS SQL Server. For practical reasons, we call this guide "Upgrade and Installation Guide"
and SAP Note 1144459 - SAP Installation Media and SQL4SAP for SQL Server 2008 (R2)
1152240 - Setting Up Microsoft SQL Server 2008 (R2)
Regards
Sriram
Hi,
First of all i would suggest you to check PAM for your release and the database that is avalible for your OS and the sap product you are going for.
Thanks
Rishi Abrol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rao
Kindly refer the link
http://scn.sap.com/thread/3444627
and also check the log in C:\windows\sql4sap.log
Regards
Sriram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm having the same error. Here's the section of the log that is creating the error.
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20131108_201729\SystemConfigurationCheck_Report.htm
11/8/2013 8:34:08 PM
----------------------------------------
CreateObject("ADODB.Connection")
Open(Provider=SQLOLEDB;Integrated Security='SSPI';Initial Catalog=master;Data Source='.')
=> ERROR
Execute(exec sp_configure 'show advanced options', 1 reconfigure with override )
=>
Close
=> ERROR
11/8/2013 8:34:30 PM
----------------------------------------
CreateObject("ADODB.Connection")
Open(Provider=SQLOLEDB;Integrated Security='SSPI';Initial Catalog=master;Data Source='.')
=> ERROR
Execute(exec sp_configure 'max degree of parallelism', 1 exec sp_configure 'xp_cmdshell', 1 exec sp_configure 'SMO and DMO XPs', 1 reconfigure with override ALTER LOGIN [sa] DISABLE )
=>
Close
=> ERROR
11/8/2013 8:34:51 PM
----------------------------------------
CreateObject("ADODB.Connection")
Open(Provider=SQLOLEDB;Integrated Security='SSPI';Initial Catalog=master;Data Source='.')
=> ERROR
Execute(select serverproperty('ProductVersion'))
=>
Close
=> ERROR
11/8/2013 8:35:12 PM
----------------------------------------
Message Box "Wrong SQL Server version"
Installation finished successfully...
but verification showed unexpected version:
SQL Instance: (default)
SQL Version:
Result: vbOK
----------------------------------------
Registry settings (2/2):
----------------------------------------
HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\{3d06c673-5e8a-41c0-b47f-3c3ca0a22e67}
WRITE(REG_DWORD): 4
HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\{2b9034f3-b661-4d36-a5ef-60ab5a711ace}
WRITE(REG_DWORD): 4
----------------------------------------
11/8/2013 8:35:21 PM
Quit script with return code 0
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.