Solved

Connecting to SQL Server 2005 Remotely

Posted on 2015-01-16
6
178 Views
Last Modified: 2015-01-16
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?
0
Comment
Question by:flynny
6 Comments
 
LVL 48

Expert Comment

by:Vitor Montalvão
ID: 40553130
You need to check in which port that instance is listening.
0
 
LVL 17

Accepted Solution

by:
Barry Cunney earned 500 total points
ID: 40553139
Hi flynny
Please confirm that the MSSQLServer service is running - use either Windows Services Console or SQL Server Configuration Manager
 SQL Server Configuration Manager will give you the Process ID if it is running.
You can also look in Task Manager for an entry for 'sqlservr.exe'

If it is running and you can get the Process ID, then you can use netstat command
netstat -ano | find "<process id>"

This will help you confirm if the MSSQLSERVER service is running or not and the process id and port details
0
 
LVL 19

Expert Comment

by:Rikin Shah
ID: 40553141
Hi,

Is it something like the domains are different?
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 48

Expert Comment

by:Vitor Montalvão
ID: 40553145
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.
0
 

Author Comment

by:flynny
ID: 40553147
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.
0
 
LVL 48

Expert Comment

by:Vitor Montalvão
ID: 40553151
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.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question