|
Home > Archive > MS SQL Server > May 2005 > Connection Open (Create File()) /SQL server registration
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Connection Open (Create File()) /SQL server registration
|
|
| Pirmin 2005-05-23, 3:23 am |
| Hello,
i have SQL 7.0 servers A, B, C, D
when tryin to register server (mmC) A on B,C,D i get the errormessage
"Client unable to establish connection Connection Open (Create File())"
This worked 2 weeks ago.. and we didn't change anything..
Network wise B,C,D "see" A (ping, net-share..) only "sql-server" wise we
have this problem
THX a lot
PIrmin
| |
| Aleksandar Grbic 2005-05-23, 7:23 am |
| check connection with QA
try TCP and NP connection
"Pirmin" wrote:
> Hello,
>
> i have SQL 7.0 servers A, B, C, D
> when tryin to register server (mmC) A on B,C,D i get the errormessage
> "Client unable to establish connection Connection Open (Create File())"
>
> This worked 2 weeks ago.. and we didn't change anything..
> Network wise B,C,D "see" A (ping, net-share..) only "sql-server" wise we
> have this problem
>
> THX a lot
> PIrmin
| |
| Pirmin 2005-05-23, 7:23 am |
| Hi,
sorry.. your answer was litl short 4 me..
wht do you mean with "check connection with QA"
Where do i set the connection frm TCP to NamedPipes on the
ServerRegistration..
Thx
Pirmin
"Aleksandar Grbic" wrote:
[color=darkred]
> check connection with QA
> try TCP and NP connection
>
> "Pirmin" wrote:
>
| |
| Aleksandar Grbic 2005-05-23, 7:23 am |
| you can use Query Analyzer (QA - SQL graphical query tool) - isqlw.exe to
check connectivity with sql server
use tcp:<server> to connect with tcp
or
use np:<server> to connect with Named Pipes
later, configure Client Network utility to use one of these protocol and try
connect from mmc
"Pirmin" wrote:
[color=darkred]
> Hi,
>
> sorry.. your answer was litl short 4 me..
> wht do you mean with "check connection with QA"
> Where do i set the connection frm TCP to NamedPipes on the
> ServerRegistration..
>
> Thx
>
> Pirmin
>
> "Aleksandar Grbic" wrote:
>
| |
| Pirmin 2005-05-23, 7:23 am |
| THX,
well i can't connect via NP nor TCP..
(Pinging works..)
Also checked
"SQL server network config"
TCP and NP are configured..
Anyother idea?
THX
Pirmin
"Aleksandar Grbic" wrote:
[color=darkred]
> you can use Query Analyzer (QA - SQL graphical query tool) - isqlw.exe to
> check connectivity with sql server
>
> use tcp:<server> to connect with tcp
> or
> use np:<server> to connect with Named Pipes
>
> later, configure Client Network utility to use one of these protocol and try
> connect from mmc
>
>
> "Pirmin" wrote:
>
| |
| Aleksandar Grbic 2005-05-23, 9:23 am |
| firewall?
consult your network admin?
can you connect from server A?
server A listen on 1433?
"Pirmin" wrote:
[color=darkred]
> THX,
>
> well i can't connect via NP nor TCP..
> (Pinging works..)
> Also checked
> "SQL server network config"
> TCP and NP are configured..
>
> Anyother idea?
>
> THX
>
> Pirmin
> "Aleksandar Grbic" wrote:
>
|
|
|
|
|