Restricting SA Account to IP Address List

[RichardParry]

Is it possible, within SQL 2005 to restrict access to the SA user to one or more IP addresses? I have looked around at security hardening guides and will be following many of the suggestions, but none of them include info on if it is possible to restrict by IP.

Thanx! Richard

 

[onpnt]

I've never attempted to do this and someone may post that has but I beleive you may be looking for TDS Endpoints.

here is a short article that can explain it

http://msdn2.microsoft.com/en-us/library/ms191220.aspx

[sub]____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[mrdenny]

TDS endpoints should work to limit connections for accounts other than the sa account. As far as I know there is no way to limit the sa account to only connect to specific endpoints.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[onpnt]

Thanks Denny


[sub]____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com