Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 Security Risk Accessing SQL Server 2005

Author  Topic 

joseta
Starting Member

2 Posts

Posted - 2010-09-09 : 09:28:17
Hi Everyone,

I would like to know, how to secure my SQL Server 2005 accessing through Public IP. I have changed the SQL port to different number and doing nat from the Cisco Router.

So I can able to connect my SQL Server from internet. But I afraid from the hackers.

Can anyone help me how I can protect my database?

Regards,
Jose

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-09 : 11:23:38
Make sure you are not vulnerable to SQL injection.

What will be accessing the SQL Server directly?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

joseta
Starting Member

2 Posts

Posted - 2010-09-10 : 10:26:00
The question is,

1. Can someone read the information from the tcp/ip packets between client and server?

2. Is there any way to access the database server?

This I want to know. The matter experience of SQL Server is secondary.

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-10 : 13:46:21
1. Yes. If you are concerned about this, encrypt your data.
2. Yes. If you open it up to the public, then you need to make sure you are protected.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-09-10 : 16:51:11
you should be using VPN for this
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-10 : 17:11:20
+1 to russell's post

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -