cancel
Showing results for 
Search instead for 
Did you mean: 

Side by side installs of SQL 2008 and SQL 2008R2 How to access db on R2

Former Member
0 Kudos

Problem:  2 versions of SQL 2008 installed on same server.  Unable to login to SBO database located on SQL 2008 R2 .  Can login to dbs located on SQL 2008 standard without issue.

I have SQL2008 Standard SAP Business One installed and working.   Recently installed SQL2008 R2 on same server as side by side install in order to restore db backups from SQL2008R2 environment.  Restored a db backup to SQL 2008 R2.   Can login to SBO but only databases on SQL2008 are available.

SQL R2 installed without issue.  I can access it and still can access original SQL 2008.

I've tried changing the license server settings in Configure Security and  receive message:  Cannot save credentials.  The database SBO-Common has not been found in selected database server LENOVO\SQLR2   Would appreciate any help. 

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

Please restore you backup from different computer then restore it to your live server so that the existing SQL server will not be touched. Only 1 SQL server will access the SBO-Common.

THanks.

Clint

former_member186095
Active Contributor
0 Kudos

Hi,

You can have Sql server 2008 std and 2008 R2 std in one server but if the SBO-COmmon is only available in one of them and  SBO database is available in the 2008 R2, the SBO company database will not available to access.

Rgds,

JiMm

Former Member
0 Kudos

HI

It seems that SBO-Common database is not located in one server.

You finalise the server which you are going to use and then restore SBO-Common to that server and work b1 with that.