Hi, All,
SQL7.0, SP3 on Win2000 server+ sp1
I remote access our client in FL, recently I get error
message [DBNMPNTW] Connection write(writefile()) message
then the connection failed.
What's cause the problem how can I fix it.
Thanks and have a nice day
HawkHi Hawk,
Connection write using the Named Pipes library. There could be a
permission problem with Named Pipes /SMB or a restrictive Security Template
setting. Try connecting using TCP.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Kevin,
Thanks, but how can change it to TCP? Could you tell me
more?
Have a good weekend
>--Original Message--
>Hi Hawk,
> Connection write using the Named Pipes library.
There could be a
>permission problem with Named Pipes /SMB or a
restrictive Security Template
>setting. Try connecting using TCP.
>
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||Use the SQL Client Network Utility and create a TCP alias. Enter the
actual servername for the alias, this way the client will use sockets
instead.
If you have MDAC 2.6 on the client you can also try this as a test.
osql -Stcp:ServerNameHere -UuserName -Ppassword
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thank you very much and have a good one
Hawk
Showing posts with label errormessage. Show all posts
Showing posts with label errormessage. Show all posts
Tuesday, March 27, 2012
Sunday, March 25, 2012
connection problem
Hi, All,
SQL7.0, SP3 on Win2000 server+ sp1
I remote access our client in FL, recently I get error
message [DBNMPNTW] Connection write(writefile()) message
then the connection failed.
What's cause the problem how can I fix it.
Thanks and have a nice day
Hawk
Hi Hawk,
Connection write using the Named Pipes library. There could be a
permission problem with Named Pipes /SMB or a restrictive Security Template
setting. Try connecting using TCP.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Kevin,
Thanks, but how can change it to TCP? Could you tell me
more?
Have a good weekend
>--Original Message--
>Hi Hawk,
> Connection write using the Named Pipes library.
There could be a
>permission problem with Named Pipes /SMB or a
restrictive Security Template
>setting. Try connecting using TCP.
>
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>
|||Use the SQL Client Network Utility and create a TCP alias. Enter the
actual servername for the alias, this way the client will use sockets
instead.
If you have MDAC 2.6 on the client you can also try this as a test.
osql -Stcp:ServerNameHere -UuserName -Ppassword
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Thank you very much and have a good one
Hawk
SQL7.0, SP3 on Win2000 server+ sp1
I remote access our client in FL, recently I get error
message [DBNMPNTW] Connection write(writefile()) message
then the connection failed.
What's cause the problem how can I fix it.
Thanks and have a nice day
Hawk
Hi Hawk,
Connection write using the Named Pipes library. There could be a
permission problem with Named Pipes /SMB or a restrictive Security Template
setting. Try connecting using TCP.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Kevin,
Thanks, but how can change it to TCP? Could you tell me
more?
Have a good weekend
>--Original Message--
>Hi Hawk,
> Connection write using the Named Pipes library.
There could be a
>permission problem with Named Pipes /SMB or a
restrictive Security Template
>setting. Try connecting using TCP.
>
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>
|||Use the SQL Client Network Utility and create a TCP alias. Enter the
actual servername for the alias, this way the client will use sockets
instead.
If you have MDAC 2.6 on the client you can also try this as a test.
osql -Stcp:ServerNameHere -UuserName -Ppassword
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Thank you very much and have a good one
Hawk
Tuesday, March 20, 2012
Connection Open (Create File()) /SQL server registration
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
PIrmincheck 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|||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:
> 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|||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:
> 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:
> > 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|||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:
> 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:
> > 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:
> >
> > > 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|||firewall?
consult your network admin?
can you connect from server A?
server A listen on 1433?
"Pirmin" wrote:
> 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:
> > 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:
> >
> > > 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:
> > >
> > > > 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
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
PIrmincheck 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|||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:
> 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|||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:
> 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:
> > 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|||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:
> 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:
> > 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:
> >
> > > 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|||firewall?
consult your network admin?
can you connect from server A?
server A listen on 1433?
"Pirmin" wrote:
> 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:
> > 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:
> >
> > > 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:
> > >
> > > > 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
Connection Open (Create File()) /SQL server registration
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
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
|||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:
[vbcol=seagreen]
> check connection with QA
> try TCP and NP connection
> "Pirmin" wrote:
|||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:
[vbcol=seagreen]
> 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:
|||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:
[vbcol=seagreen]
> 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:
|||firewall?
consult your network admin?
can you connect from server A?
server A listen on 1433?
"Pirmin" wrote:
[vbcol=seagreen]
> 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:
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
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
|||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:
[vbcol=seagreen]
> check connection with QA
> try TCP and NP connection
> "Pirmin" wrote:
|||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:
[vbcol=seagreen]
> 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:
|||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:
[vbcol=seagreen]
> 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:
|||firewall?
consult your network admin?
can you connect from server A?
server A listen on 1433?
"Pirmin" wrote:
[vbcol=seagreen]
> 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:
Connection Open (Create File()) /SQL server registration
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
PIrmincheck 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|||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:
[vbcol=seagreen]
> check connection with QA
> try TCP and NP connection
> "Pirmin" wrote:
>|||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:
[vbcol=seagreen]
> 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:
>|||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:
[vbcol=seagreen]
> 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 t
ry
> connect from mmc
>
> "Pirmin" wrote:
>|||firewall?
consult your network admin?
can you connect from server A?
server A listen on 1433?
"Pirmin" wrote:
[vbcol=seagreen]
> 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:
>sqlsql
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
PIrmincheck 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|||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:
[vbcol=seagreen]
> check connection with QA
> try TCP and NP connection
> "Pirmin" wrote:
>|||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:
[vbcol=seagreen]
> 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:
>|||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:
[vbcol=seagreen]
> 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 t
ry
> connect from mmc
>
> "Pirmin" wrote:
>|||firewall?
consult your network admin?
can you connect from server A?
server A listen on 1433?
"Pirmin" wrote:
[vbcol=seagreen]
> 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:
>sqlsql
Thursday, March 8, 2012
Connection failed
Hi, All,
SQL7.0, SP3 on Win2000 server+ sp1
I remote access our client in FL, recently I get error
message [DBNMPNTW] Connection write(writefile()) message
then the connection failed.
What's cause the problem how can I fix it.
Thanks and have a nice day
Hawk
> Hi, All,
> SQL7.0, SP3 on Win2000 server+ sp1
> I remote access our client in FL, recently I get error
> message [DBNMPNTW] Connection write(writefile()) message
> then the connection failed.
> What's cause the problem how can I fix it.
>
> Thanks and have a nice day
> Hawk
>
You can test named pipes connectivity as follows:
INF: Procedure for Testing Named Pipes
http://support.microsoft.com/?id=68941
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
SQL7.0, SP3 on Win2000 server+ sp1
I remote access our client in FL, recently I get error
message [DBNMPNTW] Connection write(writefile()) message
then the connection failed.
What's cause the problem how can I fix it.
Thanks and have a nice day
Hawk
> Hi, All,
> SQL7.0, SP3 on Win2000 server+ sp1
> I remote access our client in FL, recently I get error
> message [DBNMPNTW] Connection write(writefile()) message
> then the connection failed.
> What's cause the problem how can I fix it.
>
> Thanks and have a nice day
> Hawk
>
You can test named pipes connectivity as follows:
INF: Procedure for Testing Named Pipes
http://support.microsoft.com/?id=68941
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Wednesday, March 7, 2012
Connection failed
Hi, All,
SQL7.0, SP3 on Win2000 server+ sp1
I remote access our client in FL, recently I get error
message [DBNMPNTW] Connection write(writefile()) message
then the connection failed.
What's cause the problem how can I fix it.
Thanks and have a nice day
Hawk
> Hi, All,
> SQL7.0, SP3 on Win2000 server+ sp1
> I remote access our client in FL, recently I get error
> message [DBNMPNTW] Connection write(writefile()) message
> then the connection failed.
> What's cause the problem how can I fix it.
>
> Thanks and have a nice day
> Hawk
>
--
You can test named pipes connectivity as follows:
INF: Procedure for Testing Named Pipes
http://support.microsoft.com/?id=68941
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
SQL7.0, SP3 on Win2000 server+ sp1
I remote access our client in FL, recently I get error
message [DBNMPNTW] Connection write(writefile()) message
then the connection failed.
What's cause the problem how can I fix it.
Thanks and have a nice day
Hawk
> Hi, All,
> SQL7.0, SP3 on Win2000 server+ sp1
> I remote access our client in FL, recently I get error
> message [DBNMPNTW] Connection write(writefile()) message
> then the connection failed.
> What's cause the problem how can I fix it.
>
> Thanks and have a nice day
> Hawk
>
--
You can test named pipes connectivity as follows:
INF: Procedure for Testing Named Pipes
http://support.microsoft.com/?id=68941
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Sunday, February 19, 2012
Connection : trusted
Hi all, in one of my newly configured SQL server logs, I found a error
message like this:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server
connection.
Also in both of my new servers , SQL server logs following message repeated
all the time with differefnt date.
Login succeeded for user 'domain\user1'. Connection: Trusted.
And I couldn't find any similar log messages from the current production
server.
Any ideas? did I do something wrong when I set up new servers?
Thanks a lot.
Your server is not configures for mixed authentication, that why he is
accepting domain users but not the SQL Users:
http://msdn.microsoft.com/library/de...urity_47u6.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Catelin Wang" <CatelinWang@.discussions.microsoft.com> schrieb im
Newsbeitrag news:C3AF754C-DF7F-4D5F-A75E-2A11F9D9559A@.microsoft.com...
> Hi all, in one of my newly configured SQL server logs, I found a error
> message like this:
> Login failed for user 'sa'. Reason: Not associated with a trusted SQL
> Server
> connection.
> Also in both of my new servers , SQL server logs following message
> repeated
> all the time with differefnt date.
> Login succeeded for user 'domain\user1'. Connection: Trusted.
> And I couldn't find any similar log messages from the current production
> server.
> Any ideas? did I do something wrong when I set up new servers?
> Thanks a lot.
|||thanks. But my production server is using the same authentication, why I did
not see the same logs messages?
"Jens Sü?meyer" wrote:
> Your server is not configures for mixed authentication, that why he is
> accepting domain users but not the SQL Users:
> http://msdn.microsoft.com/library/de...urity_47u6.asp
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Catelin Wang" <CatelinWang@.discussions.microsoft.com> schrieb im
> Newsbeitrag news:C3AF754C-DF7F-4D5F-A75E-2A11F9D9559A@.microsoft.com...
>
>
|||Then you have not set the same security options for the new server.
Apparently one of the servers is set to audit all login attempts, the other
is set to audit successful logins.
|||You are right, I set different audit trace for the two servers, but I how can
I find if I set to log successful logins ?
Thanks a lot!
"Scott Morris" wrote:
> Then you have not set the same security options for the new server.
> Apparently one of the servers is set to audit all login attempts, the other
> is set to audit successful logins.
>
>
|||Documentation? BOL -> Search -> "login failure"
|||Thnaks, I found it.
"Scott Morris" wrote:
> Documentation? BOL -> Search -> "login failure"
>
>
message like this:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server
connection.
Also in both of my new servers , SQL server logs following message repeated
all the time with differefnt date.
Login succeeded for user 'domain\user1'. Connection: Trusted.
And I couldn't find any similar log messages from the current production
server.
Any ideas? did I do something wrong when I set up new servers?
Thanks a lot.
Your server is not configures for mixed authentication, that why he is
accepting domain users but not the SQL Users:
http://msdn.microsoft.com/library/de...urity_47u6.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Catelin Wang" <CatelinWang@.discussions.microsoft.com> schrieb im
Newsbeitrag news:C3AF754C-DF7F-4D5F-A75E-2A11F9D9559A@.microsoft.com...
> Hi all, in one of my newly configured SQL server logs, I found a error
> message like this:
> Login failed for user 'sa'. Reason: Not associated with a trusted SQL
> Server
> connection.
> Also in both of my new servers , SQL server logs following message
> repeated
> all the time with differefnt date.
> Login succeeded for user 'domain\user1'. Connection: Trusted.
> And I couldn't find any similar log messages from the current production
> server.
> Any ideas? did I do something wrong when I set up new servers?
> Thanks a lot.
|||thanks. But my production server is using the same authentication, why I did
not see the same logs messages?
"Jens Sü?meyer" wrote:
> Your server is not configures for mixed authentication, that why he is
> accepting domain users but not the SQL Users:
> http://msdn.microsoft.com/library/de...urity_47u6.asp
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Catelin Wang" <CatelinWang@.discussions.microsoft.com> schrieb im
> Newsbeitrag news:C3AF754C-DF7F-4D5F-A75E-2A11F9D9559A@.microsoft.com...
>
>
|||Then you have not set the same security options for the new server.
Apparently one of the servers is set to audit all login attempts, the other
is set to audit successful logins.
|||You are right, I set different audit trace for the two servers, but I how can
I find if I set to log successful logins ?
Thanks a lot!
"Scott Morris" wrote:
> Then you have not set the same security options for the new server.
> Apparently one of the servers is set to audit all login attempts, the other
> is set to audit successful logins.
>
>
|||Documentation? BOL -> Search -> "login failure"
|||Thnaks, I found it.
"Scott Morris" wrote:
> Documentation? BOL -> Search -> "login failure"
>
>
Connection : trusted
Hi all, in one of my newly configured SQL server logs, I found a error
message like this:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server
connection.
Also in both of my new servers , SQL server logs following message repeated
all the time with differefnt date.
Login succeeded for user 'domain\user1'. Connection: Trusted.
And I couldn't find any similar log messages from the current production
server.
Any ideas? did I do something wrong when I set up new servers?
Thanks a lot.Your server is not configures for mixed authentication, that why he is
accepting domain users but not the SQL Users:
http://msdn.microsoft.com/library/d...>
ity_47u6.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Catelin Wang" <CatelinWang@.discussions.microsoft.com> schrieb im
Newsbeitrag news:C3AF754C-DF7F-4D5F-A75E-2A11F9D9559A@.microsoft.com...
> Hi all, in one of my newly configured SQL server logs, I found a error
> message like this:
> Login failed for user 'sa'. Reason: Not associated with a trusted SQL
> Server
> connection.
> Also in both of my new servers , SQL server logs following message
> repeated
> all the time with differefnt date.
> Login succeeded for user 'domain\user1'. Connection: Trusted.
> And I couldn't find any similar log messages from the current production
> server.
> Any ideas? did I do something wrong when I set up new servers?
> Thanks a lot.|||thanks. But my production server is using the same authentication, why I did
not see the same logs messages?
"Jens Sü?meyer" wrote:
> Your server is not configures for mixed authentication, that why he is
> accepting domain users but not the SQL Users:
> http://msdn.microsoft.com/library/d...
urity_47u6.asp
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Catelin Wang" <CatelinWang@.discussions.microsoft.com> schrieb im
> Newsbeitrag news:C3AF754C-DF7F-4D5F-A75E-2A11F9D9559A@.microsoft.com...
>
>|||Then you have not set the same security options for the new server.
Apparently one of the servers is set to audit all login attempts, the other
is set to audit successful logins.|||You are right, I set different audit trace for the two servers, but I how ca
n
I find if I set to log successful logins '
Thanks a lot!
"Scott Morris" wrote:
> Then you have not set the same security options for the new server.
> Apparently one of the servers is set to audit all login attempts, the othe
r
> is set to audit successful logins.
>
>|||Documentation? BOL -> Search -> "login failure"|||Thnaks, I found it.
"Scott Morris" wrote:
> Documentation? BOL -> Search -> "login failure"
>
>
message like this:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server
connection.
Also in both of my new servers , SQL server logs following message repeated
all the time with differefnt date.
Login succeeded for user 'domain\user1'. Connection: Trusted.
And I couldn't find any similar log messages from the current production
server.
Any ideas? did I do something wrong when I set up new servers?
Thanks a lot.Your server is not configures for mixed authentication, that why he is
accepting domain users but not the SQL Users:
http://msdn.microsoft.com/library/d...>
ity_47u6.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Catelin Wang" <CatelinWang@.discussions.microsoft.com> schrieb im
Newsbeitrag news:C3AF754C-DF7F-4D5F-A75E-2A11F9D9559A@.microsoft.com...
> Hi all, in one of my newly configured SQL server logs, I found a error
> message like this:
> Login failed for user 'sa'. Reason: Not associated with a trusted SQL
> Server
> connection.
> Also in both of my new servers , SQL server logs following message
> repeated
> all the time with differefnt date.
> Login succeeded for user 'domain\user1'. Connection: Trusted.
> And I couldn't find any similar log messages from the current production
> server.
> Any ideas? did I do something wrong when I set up new servers?
> Thanks a lot.|||thanks. But my production server is using the same authentication, why I did
not see the same logs messages?
"Jens Sü?meyer" wrote:
> Your server is not configures for mixed authentication, that why he is
> accepting domain users but not the SQL Users:
> http://msdn.microsoft.com/library/d...
urity_47u6.asp
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Catelin Wang" <CatelinWang@.discussions.microsoft.com> schrieb im
> Newsbeitrag news:C3AF754C-DF7F-4D5F-A75E-2A11F9D9559A@.microsoft.com...
>
>|||Then you have not set the same security options for the new server.
Apparently one of the servers is set to audit all login attempts, the other
is set to audit successful logins.|||You are right, I set different audit trace for the two servers, but I how ca
n
I find if I set to log successful logins '
Thanks a lot!
"Scott Morris" wrote:
> Then you have not set the same security options for the new server.
> Apparently one of the servers is set to audit all login attempts, the othe
r
> is set to audit successful logins.
>
>|||Documentation? BOL -> Search -> "login failure"|||Thnaks, I found it.
"Scott Morris" wrote:
> Documentation? BOL -> Search -> "login failure"
>
>
Subscribe to:
Posts (Atom)