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?
No comments:
Post a Comment