• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

SQL Server 2005 controlled remotely?

M

Mabrito

Supreme [H]ardness
Joined
Dec 24, 2004
Messages
7,004
I currently have SQL Server 2005 installed on my desktop. When im at school for the day I would like to connect to it from my laptop so I can work on my project im doing on it. How would I do this? Can I just install SQL Server Management Studio on my laptop and somehow connect to it from that?
 
or remote desktop to your computer at home. Both of these solutions will depend on if your network guys arent blocking the ports.
 
A simpler (but not necessarily secure) option is to make sure port 1433 is open all the way to your desktop box - i.e., through any routers and software firewalls between the Internet and your desktop.

Then Management Studio (express) can connect directly to your SQL server.
 
Any of those options would work fine ... but as BlasterJaack pointed out, your choices may be limited by what your school's network will allow to pass through it.
 
If you desktop is @ home, I would say open a port OTHER than 1433 and do port triggering/forwarding to your PC's port 1433 or just change your SQL server port on the PC to something other than 1433.

This would protect your SQL DB from known port/brute force attacks.
 
Alright thanks. Yeah ill probably just setup remote desktop. Question on the port 1433 and using Management Studio. If I was to go that route, what do I type in the Connect to Server screen then if im at school? Under server name, do I put the IP Address?
 
Lazy_Moron said:
Alright thanks. Yeah ill probably just setup remote desktop. Question on the port 1433 and using Management Studio. If I was to go that route, what do I type in the Connect to Server screen then if im at school? Under server name, do I put the IP Address?
Click to expand...

yep! IP address of your computer running SQL server.
 
You must log in or register to reply here.
Back
Top