Solved

Connecting to SQL Server 2005 Remotely

Posted on 2015-01-16
6
180 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 49

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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 49

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 49

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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.
Viewers will learn how the fundamental information of how to create a table.

762 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