Connection Issues

Hi,

I have sql express server running on a network pc. I have created an application on the same pc that is able to access the data contained within the sql express server.

I have depolyed the application to another network pc, but it is not able to access the same data. I have also installed 'ssmse', this cant connect to the database either

I have enabled the TCP/IP Protocol on the server, enabled the browser service, disabled the firewall and restarted all services.

The PC that is unable to see the server via my application IS able to see and successfully connect to the sql server via a "datalink dialog" the test connection button returns "Test Connection Succeded"

Any ideas. Thanks for any help.

If you can connect with the datalink dialog the system should work in principle as long as the security and related systems are right.

But I would now look at your application and add some error checking on the connection so that you can trap the error and find out what is going wrong. You will find that the ado system will return some good error codes that you can trap and investigate.

|||

Hi,

Just discovered that the browser service was set to 'manual startup' and had bot been started afterall.

Thanks for your help & time.