Cant connect to SQL Express Edition Witness

Hi,
I have implementing Database mirroring with two standard windows 2003 (64bit) servers running 2005 sql (64 bit). I have installed a SQL Express Edition on my Windows XP SP2 PC to act as a witness. But, when I try to connect to the witness PC from SQL Mgmt Studio from the principal server, it comes back with a an error saying that "By default, remote connections will be disabled, Microsoft SQL Server Error 2.

Can someone help. I tried everything in the following link
http://www.cryer.co.uk/brian/sqlserver/hresult_0x2%20npp_error_establishing_connection.htm
Thanks.
CromwellhospitalAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NightmanCTOCommented:
1. Try disabling windows firewall first to see if that is blocking connectivity.
2. Check that TCP is enabled, and running.
3. Can you connect from another machine?
0
CromwellhospitalAuthor Commented:
Firewall is disabled, TCP is enabled
I can ping my XP machine, but can't connect from SQL Mgmt Studio.
0
NightmanCTOCommented:
1. Have you enabled the remote connections using the Surface Area Configuration?
2. Are you connecting to a named instance or the default instance?
3. Are you connecting with windows authentication, and are the machines all on the same domain?
4. I am assuming that you can connect from Management Studio on the XP machine. Please can you confirm this.
5. can you telnet onto the TCP port on the XP "server" from one of the other servers?
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

CromwellhospitalAuthor Commented:
I have enabled remote connections using SA Config
Default instance
Windows Authentication
Telnet on port 1433 onto the XP machine fails
And, how can I get Mgmt Studio in the XP machine? All I have is Configuration Tools.
0
NightmanCTOCommented:
You can download the Management Studio for Express from Microsoft (alternatively, you should be able to install the 32-bit Client Tools from the SQL Server Media).

Is SQL running on port 1433 on the XP box? It may not be, so you need to confirm this.
0
CromwellhospitalAuthor Commented:
The TCP/IP is enabled and the properties says that it is looking at port 1433.
0
NightmanCTOCommented:
If remote connections and TCP are enabled, and you can't even telnet to the port, then that suggests incorrect instance name, network connectivity or permissions.
0
CromwellhospitalAuthor Commented:
The instance name is sqlexpress on the express edition and I can ping the XP machine and I am trying to connect using a domain admin account !!!
0
NightmanCTOCommented:
I understand that. But the fact that you can't telnet to the port suggests that the either the service is not running, TCP is not enabled or there is something blocking the connection (such as windows firewall).
0
CromwellhospitalAuthor Commented:
I installed Mgmt Studio for SQL Express Edition in XP machine and I can't connect to the same instance. It throws the same error.

 "By default, remote connections will be disabled, Microsoft SQL Server Error 2.
0
NightmanCTOCommented:
1. Check to see if the SQL Service is running
2. Is named pipes enabled?
3. Are you connecting to MACHINENAME\SQLExpress (named instance)?
0
CromwellhospitalAuthor Commented:
Its connecting now both ways. But, when I try to add the witness, this error comes up

microsoft sql server, error 1498
0
NightmanCTOCommented:
Is that the entire error message?
0
NightmanCTOCommented:
Sorry - You are using the RTM version of SQL 2005 in which does not support mirroring.

Install SP1.
0
CromwellhospitalAuthor Commented:
And, I have installed SP1 for Express Edition.
0
NightmanCTOCommented:
Have you installed SP1 on all of the servers?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.