problem in registering sql server in enterprise manager

[arsh_e_maah]

hello
i am new to sql server and .net programing here is a problem i got
while trying to register sql server over internet on sql server
enterprise manager , i open register sql server wizard
click next, gave ip address of the sql server( i want to register) in
available servers and add it , gave sql authentication
but got the error
"sql server does not exist or access denied coonectionopen( connect())"
please advice me how to solve this problem
note: tcp/ip network library is enabled on my server and the client as
well
i have also tried this in vb.net
Dim conect As New SqlConnection(" data source =202.154.228.18 4;net=
'dbmssocn';data base = pmec ; user id = sa;password = sa ")
but the same exception is thrown

kindly help me solve this problem, i need to solve it badly
thanks

[Mike Epprecht \(SQL MVP\)]

Re: problem in registering sql server in enterprise manager

Hi

Either SQL Server is not running or a firewall is blocking your connection.
Check what port SQL Server is configured to listen on (Server Network
Utility). It may not be the standard 1433.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.n et

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"arsh_e_maa h" <arsh_e_maah@ya hoo.com> wrote in message
news:1114376305 .720198.166410@ g14g2000cwa.goo glegroups.com.. .[color=blue]
> hello
> i am new to sql server and .net programing here is a problem i got
> while trying to register sql server over internet on sql server
> enterprise manager , i open register sql server wizard
> click next, gave ip address of the sql server( i want to register) in
> available servers and add it , gave sql authentication
> but got the error
> "sql server does not exist or access denied coonectionopen( connect())"
> please advice me how to solve this problem
> note: tcp/ip network library is enabled on my server and the client as
> well
> i have also tried this in vb.net
> Dim conect As New SqlConnection(" data source =202.154.228.18 4;net=
> 'dbmssocn';data base = pmec ; user id = sa;password = sa ")
> but the same exception is thrown
>
> kindly help me solve this problem, i need to solve it badly
> thanks
>[/color]

[Erland Sommarskog]

Re: problem in registering sql server in enterprise manager

arsh_e_maah (arsh_e_maah@ya hoo.com) writes:[color=blue]
> i am new to sql server and .net programing here is a problem i got
> while trying to register sql server over internet on sql server
> enterprise manager , i open register sql server wizard
> click next, gave ip address of the sql server( i want to register) in
> available servers and add it , gave sql authentication
> but got the error
> "sql server does not exist or access denied coonectionopen( connect())"
> please advice me how to solve this problem[/color]

Try http://support.microsoft.com/default...;EN-US;q328306
[color=blue]
> note: tcp/ip network library is enabled on my server and the client as
> well
> i have also tried this in vb.net
> Dim conect As New SqlConnection(" data source =202.154.228.18 4;net=
> 'dbmssocn';data base = pmec ; user id = sa;password = sa ")
> but the same exception is thrown[/color]

I believe DBMSSOCN is obsolete. The library to use for TCP/IP is
DBNETLIB. Then again, you should really need Net Library in the
connection string at all.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[arsh_e_maah]

Re: problem in registering sql server in enterprise manager

well mike thanxs but
how i would come to know that a firewall is blocking and how to unblock
it
in eventlog last event written by the mssqlserver is "establishi ng
connection to the client"
in client and server network utility tcp/ip port is same--have also
tried 1433
take best care -- bye