Hello Everyone,
I've also posted this in the SQL Server and VB.Net forums, but hopefully somebody here can help.
My problem is this. I have recently installed SQL Server Express 2005 to a Windows 2000 SP4 Small Business Server for a client of mine, and have successfully started the SQL Server Service, but when I try to start the SQL Browser Service, it errors stating that the service "did not start in a timely fashion".
I have trawled the net and found some articles which suggest that either the remote connections setting isn't enabled, or the incorrect port is being specified.
The client software I am trying to connect to the Server does not pass a port number so needs to have the SQL browser running. I have enabled remote connections via TCP/IP, and have enabled remote connections using the Surface Area Configuration pgm, but still no go.
I think it may be that the port (1433 or 1434) is in use by another service (they have Veritas Backup Exec loaded which installs an instance of SQL Server), but I am not sure. If anyone can help, I'd be very grateful.
Regards
I've also posted this in the SQL Server and VB.Net forums, but hopefully somebody here can help.
My problem is this. I have recently installed SQL Server Express 2005 to a Windows 2000 SP4 Small Business Server for a client of mine, and have successfully started the SQL Server Service, but when I try to start the SQL Browser Service, it errors stating that the service "did not start in a timely fashion".
I have trawled the net and found some articles which suggest that either the remote connections setting isn't enabled, or the incorrect port is being specified.
The client software I am trying to connect to the Server does not pass a port number so needs to have the SQL browser running. I have enabled remote connections via TCP/IP, and have enabled remote connections using the Surface Area Configuration pgm, but still no go.
I think it may be that the port (1433 or 1434) is in use by another service (they have Veritas Backup Exec loaded which installs an instance of SQL Server), but I am not sure. If anyone can help, I'd be very grateful.
Regards