Sunday 25 March 2012

connect to remote sql server failed

I couldn’t connect to the sql server instance (10.192.130.80\development2 and
10.192.130.80\development3) remotely on enterprise manager and query
analyzer. The error is sql server does not exist or access denied. I setup
well in the client network utility and put sever name and port number in it.
But I still got same error. Could someone give me some tips what reason is?
thanks.
Can you ping those servers?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>I couldn't connect to the sql server instance (10.192.130.80\development2
>and
> 10.192.130.80\development3) remotely on enterprise manager and query
> analyzer. The error is sql server does not exist or access denied. I setup
> well in the client network utility and put sever name and port number in
> it.
> But I still got same error. Could someone give me some tips what reason
> is?
> thanks.
>
|||Yes, I can Ping them.
"Arnie Rowland" wrote:

> Can you ping those servers?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>
>
|||Is the SQL Server listening on TCP?
Check the SQL ERRORLOG for a line like:
SQL Server listening on tcp, shared memory, named pipes
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>I couldn't connect to the sql server instance (10.192.130.80\development2
>and
> 10.192.130.80\development3) remotely on enterprise manager and query
> analyzer. The error is sql server does not exist or access denied. I setup
> well in the client network utility and put sever name and port number in
> it.
> But I still got same error. Could someone give me some tips what reason
> is?
> thanks.
>

No comments:

Post a Comment