Re: security SQL

no other sites than the usual hosted by SBS,


"Claus" wrote:

Are you hosting a public website on your SBS box?

--
Claus
"rostie" <rostie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A38A0060-C329-418D-9CB6-29EBA1389433@xxxxxxxxxxxxxxxx
after running some days with the ports disabled. i still get my errors.

source: MSSQLSERVER
event-id: 18452
latest event: 16-1-2008 21:39
total events 5 *
Login failed for user 'sa'. The user is not associated with a trusted SQL
Server connection. [CLIENT: 145.52.250.194]

this is not my domain IP. how can i get other computers not contacting
my
SQL?





"rostie" wrote:

i disabled all packages using port 1433 and 1434 on my internet line on
the
NAT configuration. i hope this keeps the messages from getting into my
system.


"bass_player [SBS-MVP]" wrote:

Make sure port 1433 and port 1434 are not opened on your
router/firewall.
Also, the SA account is disabled by default in SQL Server 2005

"rostie" <rostie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CB13CB14-75A5-4E9E-B33E-AB63F19AE0D5@xxxxxxxxxxxxxxxx
I recently installed SQL workgroup edition (it came with my SBS
premium)
sine then i have in a daily base multiple errors of user SA that cant
connect to the database because the logon failed.

i tracked the IP-records on the failures and noticed that they all
came
from
all over the world.

is my SQL open to everyone on this planet and if so how can i get it
to be
only usable within my domain (i dont need to publish online YET)

i didnt configure the SQL server yet so i guess its on windows
authentication.
i just dont like those errors in my reports.

thanks







.

Relevant Pages

  • Re: how do I change the user install wizard to create user folder in different location?
    ... > Dont get me wrong, I appreciate the wizards for certain, especially since ... > file where I'm suppose to register the SHAREPOINT instance of SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... It is called ACCESS DATA ... SQL Server has taken over the world. ... I still disagree with your understanding of the popularity of Access. ... I dont think that there is a single company in the nation with more ...
    (microsoft.public.excel)
  • Re: self referential database table
    ... in case a person change his name or any details we dont want to update ... I would recommend that you have a table PersonHistory that holds ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Any good Project Programming resources/books?
    ... I dont think that would be the best way to tackle this because it isn't ... Oracle 9i and Sql Server 2000. ... All the database connection information ... >> about is an internal ASP.NET app. ...
    (microsoft.public.project.vba)
  • Re: security SQL
    ... total events 5 * ... the SA account is disabled by default in SQL Server 2005 ... sine then i have in a daily base multiple errors of user SA that cant ... only usable within my domain (i dont need to publish online YET) ...
    (microsoft.public.windows.server.sbs)