Databases not show in choose company list

[Former Member]

Hi All,

Can anyone shed some light as to why the companies are not appearing in the Choose Company List?

Site is running SQL 2008, B1 8.8 PL:12. Databases are visible in SQL Studio and I can log on to any one in the DTW. I have tried most of the solutions that I can find on the Forums but none seems to have provided a solution.

Look forward to response.

Best regards

Earl

[karthick_s8]

Hi,

Restart SLD services in Services.EXE

and try to connect SLD in service manager

after that connect SAP B1.It works.!!

[Former Member]

Dear all,

Am also across this issue, but i resolved it,

in my case, i added the SQL Server IP address in to client PC DNS IP Address.

The Data bases are Shown in the List now.

Thanks & Regards

Hemanathan.G

[Former Member]

I'm experiencing the exact same problem on a server that is comparable to Earl's:

Server 2008 Std

SQL Server 2008 R2 Std

SAP B1 8.8 PL20

Earl, when you indicated you removed and re-entered the server name in Service Manager, can you please elaborate? Are you talking about the server name at the top of the Service Manager window? When I try to remove the server name (highlight it, Delete), nothing happens - ie. it's locked in there and cannot be removed/re-added. Did you have a particular service selected in the drop-down list? Did you remove/re-enter from the Settings or Connection button?

[Former Member]

I figured out the problem - I'm an idiot.

I was thinking of the old days when you'd use the client to upgrade the company databases. I forgot to use upgrade.exe to complete the company database upgrade. I'm guessing that in combination with the fact that I hadn't logged on to the company yet (because this is a fresh install) meant that it wasn't displayed in the list.

After upgrading the company db, all is well.

[Former Member]

I have similar problem. I already changed the Server Name under License Manager > Setting from the Server Name to its IP Address but to no avail. The companies are still not appearing. What did I miss? By the way I upgraded from 32-BIt SQL Server 2005 to 64-Bit SQL Server 2008.

[Former Member]

Bryan,

Try uninstall DTW, and then reinstall it from the package (do not install DTW from server intallation option). Remember to run upgrade after installed.

[Former Member]

Hi Phong Dang,

It has nothing got to do with DTW. I cannot see the list of companies when I click Change Company in the SAP B1 Client.

[kothandaraman_nagarajan]

Hi Bryan,

Please check replied from http://scn.sap.com/thread/3356015

Thanks & Regards,

Nagarajan

[Former Member]

Hi All,

Problem solved. I removed and re-enter the Server Name in the (Service Manager) connecting settings and re-started B1. All companies appeared.

Many thanks to all who provided a response.

Kind regards

Earl

[Former Member]

Earl,

Can you tell me how you do it step by step. Thank you so much.

[Former Member]

Hi Earl,

Do you only get empty list in the Choose Company List? Are the databases upgraded from old version or not?

[Former Member]

Hi Gorden,

Just an empty list and the DB's were not upgraded from a previous version.

Best regards

Earl

[Former Member]

What is your server spec?

Thanks,

Gordon

[Former Member]

Hi Gordon,

HW = HP Server

Processor@ Inter (R) Xeon 5140 2.33 GHz ( 2 Processors)

Ram: 4GB

Disc: 170GB (Lots free)

O/S: Windows Server 2008 R2 Standard.

SQL 2008

Best regards

Earl

[Former Member]

Is the licensing server in the same box as db server?

[Former Member]

Yes, everthing is on one box..and teh Licensing service is up and running...

[Former Member]

Have you installed B1 client on some other PC to check?

[Former Member]

This will be a task for the morning..

[Former Member]

Hi Earl,

I have come across this issue. Say when you start the db it will not appear in the list. Have you checked in selecting the SQL component in the list and just clikcing on SQL 2005 and again on SQL 2008 in the choose company windowdoes it still not work for you

Regards,

Rakesh N

[Former Member]

Hi Earl,

Can you also ensure that one of your companies do not have a character such as ' or % etc as the DTW will fail to load if this is the case.

Cheers,

Lisa

[Former Member]

HI Earl,

Have you used the refresh key on choose company list>change server>enter ip of the server>enter valid credentials ok and then checked?

Thanks,

Joseph

[Former Member]

Hi Earl,

This issue you are experiencing if you click on the refresh nothing will take place to the action . List the SQL type and just change and revert back it will list the databases.

Give it a try

Regards,

Rakesh N

[Former Member]

Have you cnfigured security in your license manager? If you have configured trusted connections, you must give user group access to the databases in SQL management Studio

[Former Member]

Hi Rakesh,

This is a brand new server and SQL 2005 was not installed on it.

BR Earl

[Former Member]

Unfortunately the change server button is missing!

[Former Member]

Hi Lisa,

Unfortunately the issue I am having is not related to the DTW. When the B1 client is started the company databases are missing.

The refresh option does not make them appear. The change server button is also missing. This is a brand new server with SQL 2008 & B1 8.8 PL12 installed to it.

BR Earl

[Former Member]

Hi Gordon,

Yes, I have now checked the workstations and they are all exhibiting the issue. The choose from screen shows:

SQL 2008

Correct Server Name

I have also checked the 'Configure Security' in the service manager to make sure that the B1SiteUser password is correct and the rest of the settings.

But no companies!

BR Earl

[Former Member]

Hi Earl......

First of all let me tell you, the change server button is not available in SAP 8.8 when you login.

You have to set your Server Name in Server Tools->License Manager> Change Security> Enter B1iSiteUses Password--> Give SQL Server Name and give sa and its password.

This will appear your server and its DB list during SAP Login.

Now in order to make it success please check the Microsoft SQL 2008 Native Client is there installed in Client Machine or not.

If not then first install it and then also check whether that PC is in same workgroup or not......

This will make you success........

Regards,

Rahul

[Former Member]

Hi Julie,

Not using Trusted.

BR Earl

[Former Member]

Hi Rahul,

Yes, I forget that that setting is now moved to the Service Manager and Yes the SQL 2008 Native client is installed to all workstations.

BR Earl

[Former Member]

Hi Earl.....

Once you done these settings just restart all the SAP services and restart your server....

Regards,

Rahul