Showing posts with label Aastra BMS and SQLSERVER EXPRESS 2005. Show all posts
Showing posts with label Aastra BMS and SQLSERVER EXPRESS 2005. Show all posts

Wednesday, May 5, 2010

Aastra BMS and SQLSERVER EXPRESS 2005

That is quite a mouthful - yet also appropriate for this fault. The new BMS ships with EXPRESS 2005 as a database installer. However, on a recent install I found that the software could not read from the database - no systems could be created or stored. And it was rather slow.

The resultant problem is that SQL did not have a default TCP port to connect to:

*SQL Server Configuration Manager
*Native Data Configuration -> Client protocols
*TCP/IP -> Enabled and a default port = 1433

*Server 2005 Network Configuration
*Protocols for EXPRESS2005 -> TCP/IP -> IP Adresses
*IP1 and IP All -> TCP port = 1433


If this doesn't solve the problem, are you sure SQL is running?