Microsoft SQL Server forum - problem in registering sql server in enterprise manager

Author

problem in registering sql server in enterprise manager

arsh_e_maah

2005-04-24, 8:23 pm

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(conne
ct())"
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.184;net=
'dbmssocn';database = 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\)

2005-04-24, 8:23 pm

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.net

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

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

"arsh_e_maah" <arsh_e_maah@yahoo.com> wrote in message
news:1114376305.720198.166410@g14g2000cwa.googlegroups.com...
> 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(conne
ct())"
> 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.184;net=
> 'dbmssocn';database = 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
>

Erland Sommarskog

2005-04-24, 8:23 pm

arsh_e_maah (arsh_e_maah@yahoo.com) writes:
> 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(conne
ct())"
> please advice me how to solve this problem

Try http://support.microsoft.com/defaul...B;EN-US;q328306

> 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.184;net=
> 'dbmssocn';database = pmec ; user id = sa;password = sa ")
> but the same exception is thrown

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@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

arsh_e_maah

2005-04-26, 3:23 am

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 "establishing
connection to the client"
in client and server network utility tcp/ip port is same--have also
tried 1433
take best care -- bye

Sponsored Links