SQL Server 2005 Install on XP Pro home Wireless Network

Posted on 2010-01-11
Medium Priority
Last Modified: 2013-11-09
Hi Experts,

I am about to install SQL Server 2005 on my Desktop and I hope to be able to access same via ODBC across
my wireless network from my laptop.

I know that I should not go for Windows Authentication when setting up the server and also that I
need to open a port to allow access as SQL server is running on XP.

Can you guys provide some assistance on the actual detail of what I need to do to achieve a successful install.

My desktop is running Norton Internet Security which I am guessing I need to disable.

I have installed SQL server before successfully but only using Windows authentication. I am not sure regarding
what I need to do re the security/ the port opening/ & Norton & any other considerations. (ie Security as I do access the web from the desktop)

All assistance gratefully received.


Michael. (Non techie)
Question by:MJOAP
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
  • 2
  • 2
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 26288133
>what I need to do re the security/ the port opening
By default sql server uses ports 1433 and 1434 , so if you want to access this machine from outside  you may have to open these ports

Author Comment

ID: 26288165
Should I open the ports before install or after? Does it matter?
LVL 75

Accepted Solution

Aneesh Retnakaran earned 1000 total points
ID: 26288300
i doesnt matter

Author Closing Comment

ID: 31675781
Very little assistance given.
Two one liners, just a little help offered.

I have installed SQL Server on my desktop running on XP Pro SP3, and I have managed to get a wireless ODBC connection from my Access 2007 on my laptop to the SQL server.
I have used SQL server authentication and opened ports 1433 and 1434 in order to get same to work. There was no need to turn of Norton Antivirus.

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

It is only natural that we all want our PCs to be in good working order, improved system performance, so that is exactly how programs are advertised to entice. They say things like:            •      PC crashes? Get registry cleaner to repair it!    …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

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