Different server for Database and Application

[Former Member]

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

[Former Member · Accepted solution]

Hi Wai Leng,

You can try to install the SQL Native Client 2008.

[Former Member · Accepted solution]

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

Thank you.

[former_member186095 · Accepted solution]

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 :   Jimmy Michael    Apr 9, 2012 2:56 PM   (in response to Wai Leng Tan)   

but I forgot to tell that you need to install  the sql native client 2008 in server2 before installing the SBO application.

Rather than using server to install SBO application, the SBO users worldwide can install the SBO application i.e server component and client component after installing SQL native client 2008.

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,

[Former Member]

Hi,

Try to install the Microsoft SQL Server 2008 Native Client  so that it will recognize.

On the Database Server Logon put the Server1 not the \\Server1.

Thanks.

Clint

[Former Member]

Hi Wai,

We have done this many times, so it is possible. Have you checked the SQL logs to see what errors are recording? What user is running the SQL Services? Does the user you are trying to log into SQL with have the appropriate access on the SQL Server?

Have you created a SQL Instance, which will need to be added infront of server name e.g. server01\instance1

[Former Member]

Actually, the server tool is integrated part of the database. B1 is a fat client. All business logic will be only in client and few store procedure in database.

You can explain to IT that this will not be against the policy. There is no such thing as real Application Server for B1.

[Former Member]

Hi Wai Leng,

Please explain why you need to install the MSSQL and SAP Business One Application into different server.

There may not have any benefits by this method especially for new B1 version.

Thanks,

Gordon

[Former Member]

Hey Gordon,

Of cause due to the IT policy so we need to install into different server.

I know there have not any benefit but we have to follow our IT policy.

Cheers,

Wai Leng

[former_member186095]

Hi,

based on your last reply, I suggest you to install SBO application server i.e. SBO-Common db in server1 where there is installed ms. sql server there. You have to do that prior to install SBO application in server2.

You just run the setup.exe from this folder:

...\Installer\B1881\51040680\51040680\Packages\Server\setup.exe

After finishing install the SBO application server in server1, you can now install SBO application in server2. Do not forget to install server tools prior to install SBO application server in server1 too.

if you install SBO application server in server2, you will not success because there is no ms. sql server in server2.

If you want to install SBO application server in server1 but from server2, I am afraid that it will be difficult because the installer only search the sql server in the server2

Rgds,

JimM

[Former Member]

Hey Jimmy,

I am installing 8.82 PL4. Yes I've install the MSSQL in Server1 successfully.

But when go to SAP Business One Server installation, I am unable to choose the Server type. Suppose we can choose the server type from a drop down list.

Cheers,

Wai Leng

[former_member186095]

I am afraid the SBO installation is not such the way you do.

I mean the SBO installation wizard will detect the database platform that installed in the server in which the SBO server application will be installed. In your scenario, it is the server2. So, the server2 must have SQL server management studio application.

I said so because the SBO server application setup will install SBO-Common database. SBO-Common database requires SQL server management studio as the supported database platform. if you want to install SBO application like client application and server tools, you can do that in the server2 but when come to install SBO server application, you need sql server management studio in the server2, except the sbo server application is installed in the server1 and the sbo application such as server tools and client application installed in server2.

Without sql server mgnt studio in server2, the server2 will be acting as PC client or SBO end user.

Rgds,

JimM

[former_member186095]

Hi Wai,

What version of SAP B1 are you using ?

You can install the SAP B1 application, i.e. SAP B1 client application, SAP B1 server tools and SAP application server (or SBO-Common db) , into server2 and install MS SQL server into server1.

The server1 can be used as company database server and server2 can be used as SBO server.

if you use SAP B1 8.8x, you can use SAP b1 service manager --> license manager --> configure security --> put MSSQL2008 in the DB Type instead of server name like \\server1.

Rgds,