Hi Guys,
I have installed a new application that uses a SQL Server Express database.
The problems are with connecting from clients across the LAN. It seems to be a port issue. If I try an connect a new client machine then the connection fails. I have to go into set a Data Source in the control panel admin section. Once there I have to specify the port to match the port that has been specified in the Sql Server configuration manager. The dynamic port system doesn’t seem to function at all.
Once the connection is made then the application works fine. So when this manual connection is made, what am I doing ? Is the registry being updated, is it profile dependent on local machine dependent ? Is it going to lose this information in the future.
If it is a registry entry, in which case does anyone know where i can get this in a script so we can out it in the start up ???
Otherwise I fear that this problem will keep re-occuring.
Thanks alot
Matt
