469,914 Members | 2,329 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,914 developers. It's quick & easy.

problem in registering sql server in enterprise manager

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

Jul 23 '05 #1
3 2047
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: mi**@epprecht.net

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

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

"arsh_e_maah" <ar*********@yahoo.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.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(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.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

Jul 23 '05 #2
arsh_e_maah (ar*********@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(connect())"
please advice me how to solve this problem
Try http://support.microsoft.com/default...;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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #3
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

Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by David Gray | last post: by
6 posts views Thread by John Morgan | last post: by
14 posts views Thread by David Tilman | last post: by
3 posts views Thread by Steve Blair | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.