Hi,
I'm having trouble connecting to the SQL server in a LAN. I can't even
telnet to the port 1433 of the server. Does anyone have any idea how to fix
this problem?
Shafiee.Are you able to ping the SQL Server? What error are you getting when you try
connecting to the server using Query Analyzer?
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"shafiee" <mohamed.shafee@.gmail.com> wrote in message
news:Ov0k0dSrFHA.304@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm having trouble connecting to the SQL server in a LAN. I can't even
> telnet to the port 1433 of the server. Does anyone have any idea how to
fix
> this problem?
> Shafiee.
>|||Hi Narayana,
Yes I am able to ping to the server. The server isn't listening to client
requests. The version of SQL server installed is SQL 2000. Any ideas?
Shafiee.
"Narayana Vyas Kondreddi" wrote:
> Are you able to ping the SQL Server? What error are you getting when you t
ry
> connecting to the server using Query Analyzer?
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "shafiee" <mohamed.shafee@.gmail.com> wrote in message
> news:Ov0k0dSrFHA.304@.TK2MSFTNGP11.phx.gbl...
> fix
>
>|||If SQL Server is running and you can ping the server, one
possibility is that the server is listening on shared memory
only which means only local connections will be allowed. Use
the server network utility on the SQL Server box to make
sure you have protocols enabled. You can also check the SQL
Server error log from when the instance started to see what
protocols, ports SQL Server is listening on. If it's only
Shared Memory, enable TCP/IP on the server using the server
network utility.
-Sue
On Tue, 30 Aug 2005 19:59:04 -0700, "Shafiee"
<Shafiee@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Narayana,
>Yes I am able to ping to the server. The server isn't listening to client
>requests. The version of SQL server installed is SQL 2000. Any ideas?
>Shafiee.
>"Narayana Vyas Kondreddi" wrote:
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment