cancel
Showing results for 
Search instead for 
Did you mean: 

Different server for Database and Application

Former Member
0 Kudos
1,460

Hey all,

I am trying to install the MSSQL and SAP Business One Application into different server.

I've installed the MSSQL to Server1, then I will install the SAP Business One Application into Server2.

I was failed to configure the "Database Server Logon" in the installation of SAP Business One Server.

In the Server Type, due to no SQL is installed in this machine, so I type in "MSSQL_2008" manually then click next

Then the next page is Database Server Logon, I put \\Server1 in the Server Name field, then followed by my database ID and password.

But I get the following message

The connection to the specified server has failed. Check your password and that the server exists on the network

I've tried to change the server name but still failed. Anyone can guide me on this?

Cheers,

Wai Leng

View Entire Topic
Former Member

Hi Wai Leng,

You can try to install the SQL Native Client 2008.

Former Member
0 Kudos

Yes, after I installed the Native Client, I can continue the setup.

Thank you.

former_member186095
Active Contributor
0 Kudos

Hi,

Nice to hear the problem solved.

If you used sql native client 2008 in the server 2, it is correctthat the server 2 will be as same as PC client when install SAP B1 application client at first time. That's what I have said in my previous reply :

Anyway, although the problem solved by installing native client, I see that the way of installation is actually incorrect ,it need many efforts or works to do to finish the installation and risky.

if suddenly the connection is stop, the sbo server component installation will be stop and rolling back. The user must install it again.

Rgds,