flynny
asked on
Connecting to SQL Server 2005 Remotely
Hi All,
Hopefully it a quick simple solution.
I have an instance of SQL Server 2005 running on the server as localhost/SQLEXPRESS2005.
I've enable remote connections ont he database and enabled TCP/IP on the configuration.
I've downloaded Port Query and run
TCP port 1433 (ms-sql-s service): NOT LISTENING
portqry.exe -n <server ip> -e 1433 -p TCP exits with return code 0x00000001.
The browser servies is running and windows firewall is currnetly off.
ANy ideas on what going one here?
Hopefully it a quick simple solution.
I have an instance of SQL Server 2005 running on the server as localhost/SQLEXPRESS2005.
I've enable remote connections ont he database and enabled TCP/IP on the configuration.
I've downloaded Port Query and run
TCP port 1433 (ms-sql-s service): NOT LISTENING
portqry.exe -n <server ip> -e 1433 -p TCP exits with return code 0x00000001.
The browser servies is running and windows firewall is currnetly off.
ANy ideas on what going one here?
You need to check in which port that instance is listening.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
Is it something like the domains are different?
Is it something like the domains are different?
In the same window you've configured the TCP/IP, right-click on TCP/IP and go to Properties then IP Addresses tab. You would confirm by TCP Port field which one the instance is using.
ASKER
Barry,
First of all many thanks for your quick response.
- Please confirm that the MSSQLServer service is running - use either Windows Services Console or SQL Server
Thanks for your help, for some reason the SQL Server Agent Service had stopped running.
Once Again I appreciate you help.
First of all many thanks for your quick response.
- Please confirm that the MSSQLServer service is running - use either Windows Services Console or SQL Server
Thanks for your help, for some reason the SQL Server Agent Service had stopped running.
Once Again I appreciate you help.
have an instance of SQL Server 2005 running on the server as localhost/SQLEXPRESS2005.
for some reason the SQL Server Agent Service had stopped running.
Strange, since SQLExpress Edition doesn't has SQL Agent service.