• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 160
  • Last Modified:

SQL Server 2005 Install on XP Pro home Wireless Network

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.

Thanks.

Michael. (Non techie)
0
MJOAP
Asked:
MJOAP
  • 2
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
>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
0
 
MJOAPAuthor Commented:
Should I open the ports before install or after? Does it matter?
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
i doesnt matter
0
 
MJOAPAuthor Commented:
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.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now