Re: problem in connecting sql server
- From: Duane Arnold <notme@xxxxxxxxx>
- Date: Sun, 24 Apr 2005 22:38:44 GMT
"arsh_e_maah" <arsh_e_maah@xxxxxxxxx> wrote in
news:1114376037.207388.258080@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:
> hello
> i am new to sql server and .net programing here is a problem i got
> while trying to connect sql server over internet
>
> Dim conect As New SqlConnection("data source =202.154.228.184;net =
> 'dbmssocn';database = pmec ; user id = sa;password = sa ")
> but the following exception is thrown
>
> "sql server does not exists or access denied"
>
> kindly help me solve this problem, i need to solve it badly
> thanks
>
It is a programming question. You say you're coming over the Internet. Is
the SQL Server behind a firewall? If this is true, the SQL Server port
must be open on the FW. That's port 1433 and 1434 may come into play too.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q287932
If there is a router setting there, then port forwarding on the router
must be used to forward the ports to the IP/machine that needs the ports
open.
In addition, you should supplement the protection of the machine with
IPsec to further protect the SQL Server.
http://www.petri.co.il/block_ping_traffic_with_ipsec.htm
http://www.analogx.com/contents/articles/ipsec.htm
You may also want to change the user-id and psw and not use the SA since
everyone else in the world knows this and can attack Sql Server.
You should set up a generic user-id and psw and give ths user-id the
appropriate rights to access the database. In addition, change the SA psw
to something else.
You should think about applying the SQL Server security updates from M$
if you have not done so.
HTH
Duane :)
.
- References:
- problem in connecting sql server
- From: arsh_e_maah
- problem in connecting sql server
- Prev by Date: Re: programming job market in bay area in US
- Next by Date: Re: Unable to open include file 'stdio.h'
- Previous by thread: Re: problem in connecting sql server
- Index(es):
Relevant Pages
|
