"Unable to select database:" with internal MS SQL DB

[TakeMarket]

We we just experienced a strange issue.

We just installed once of 2 instances of sugarcrm on a new server, the first install went smoothly without any issues, but when we tried to install the 2:nd instance we received the error message "Unable to select database".

We made a test and changed the name of the db, even removed it and made a new db, but the results is the same.

General info:
Server:
MS windows Enterprise 2003 SP2
MS SQL 2005 Enterprise SP2
Sugarcrm 5.0 b
php 5.2

This is very strange the first instance runs without any issues at all!
2:nd well, we get get it installed before this nut is cracked!

Thanks for help in advance.

[dpatech]

Is the SQL Server a separate instance, or simply a second database within the same instance? The settings in the config.php need to specify both the correct instance name and database name.

[TakeMarket]

Is the SQL Server a separate instance, or simply a second database within the same instance? The settings in the config.php need to specify both the correct instance name and database name.

Thanks for your reply.

It looks like this:

1 machine with OS MS 2003 server installed and:

1 MS Sql server 1:ISS web server: (and of course php5)

"The system runs (should/will be) several different instances of SugarCRM, but for now it only runs 1 sugarcrm instance."

The SQL server on the system has for now 2 configured client data bases - lets call the "client X" and "client Z"

SQL server have a "secure" user for the CRM system(s) which is used in both cases.

Case 1)
We have successfully i installed the client X crm instance.
The database is called "clientX"
Case 2)
We have not successfully installed client Z crm instance as we receive the "unable to select database error on this case.
The database is called client_Z

---------------------------
Anyhow - we are still investigating this error - any guidance to solving this matter is much appreciated!

Thanks!

[eggsurplus]

Make sure Named Pipes is enabled on the MSSQL server and that the port is open if the db/app are on different servers.

[TakeMarket]

Hi Guys, thank you all for your nice input!

We have finished the investigation and solved the error.

After some trial and error we found out that the sugarcrm isn't quite happy about special names/character/symbols etc.

Example of NOT working my.data_base or crm.client-database.com

So it will only work with simple names as mydatabase or crmclientdatabsecom

So if the db starts with above example/s and you try to rename it wont work.

You need to setup the whole DB from scratch with permission etc and use only letters.


SugarCRM instance 2 is now up and running and (only tcp) named pipes is not needed, which will provide (hopefully) better security.

Thanks the assistance.