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)