Solved

Connecting to SQL Server 2005 Remotely

Posted on 2015-01-16
6
175 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 47

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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 47

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 47

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

813 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now