Solved

Connecting to SQL Server 2005 Remotely

Posted on 2015-01-16
6
200 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 51

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
Database Solutions Engineer FAQs

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller single-server environments.

 
LVL 51

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 51

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

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

634 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