Installation issues - Connection to the specified server has failed

[Former Member]

Hi

i am trying to install sap server on windows 2008.my SQL server is on another box with windows 2003 and SQL 2008

select server type drop down is blank and after entering SQL server name/user/password i am agettig this error

"Connection to the specified server has failed"

to make sure i have access to sql server ,i hav installed SQL 2008 native client and created one test odbc DSN to test that my serevr is talking to database server

databse and both 2003 and 2008 machines are 64 bit

Please help

[former_member206488 · Accepted solution]

You need to install SAP server on same machine on which you installed sql server.

it is not possible to install sap server on the machine having sql client.

hope this will help you.

thanks,

neetu

[Former Member · Accepted solution]

Hi

now i am trying to install SAP server on same machine as SQL server but the dop down "select server type drop down is blank " is still blank

and i am getting same error

thanks

[former_member206488 · Accepted solution]

Dear,

enter the same of server or IP address manually if it is not showing in dropdown

[Former Member · Accepted solution]

i tried no luck

[Former Member · Accepted solution]

Have you restarted your server after install?

Thanks,

Gordon

[Former Member · Accepted solution]

yes

i have restarted server

[Former Member · Accepted solution]

Have you started Service Manager for B1?

[Former Member · Accepted solution]

yes

one thing i am noticing when i run install is i am getting this message on first screen

so is the setup i ma running really compatible with SQL 2008?

i am runing the setup from Patch0 because other patch downlads do not have ther server setup

The installer detected an outdated version of MSSQL installed on this machine.

If you are using another type of database to run SAP Business One, such as DB2 or MaxDB, press Skip.

To upgrade your MSSQL version exit this installation. Only an experienced system administrator or DBA should upgrade the database.

[Former Member · Accepted solution]

Patch 0 is not compatible with 2008. That is where the problem starts.

[Former Member]

You can try installing SQL Native Client - it's a free download from Microsoft. After installing this you should see more options in the SAP Login Database pulldown