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

Connection problem

Strange database problem.
I have 2 servers one running as webserver and the other as Database server running MSSQL 2000 SP3.
They are connected i 2 ways. Through a public net using static IP and through a direct cable using another IP.

My problem is that I cannot connect to or from the database through the crossed cable (I run a DTS which imports a zipped access file from an FTP account on the webserver).
Running through the public net works fine but not through the crossed/direct cable.
All other connecting (ping, filesharing, FTP not through DTS, etc) works fine through that cable but ODBC connections from the webserver don't and neither does DTS access from the database server.
Does anyone have a clue.I assume there is a different IP associated with the crossed-cable connection. Configure your ODBC to use that IP address instead of the server name.|||That's what I couldn't do. However everything worked out after restarting the webbserver. Seems like it was just a glitch.sqlsql

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

connection pool problem using in Tomcat

I use "SQL Server 2000 Driver for JDBC SP3" to connect SQLServer2000 under
Tomcat App server.
I wish to control the number of physical connections made to the database to
50. Can somebody guide me about this.
At the moment even with as low as 30 concurrent hits we see a very high
number of phyiscal connection to the database as high as 200.
I am using the following settings in SERVER.XML
<Resource name="jdbc/ECTDB" auth="Container"
type="com.microsoft.jdbcx.sqlserver.SQLServerDataS ource"/>
<ResourceParams name="jdbc/ECTDB">
<parameter><name>maxActive</name><value>30</value></parameter>
<parameter><name>maxIdle</name><value>20</value></parameter>
<parameter><name>maxWait</name><value>10000</value></parameter>
<parameter><name>factory</name><value>com.microsoft.jdbcx.sqlserver.SQLServe rDataSourceFactory</value></parameter>
<parameter><name>driverClassName</name><value>com.microsoft.jdbcx.sqlserver.SQLServe rDataSource</value></parameter>
<parameter><name>user</name><value>..</value></parameter>
<parameter><name>password</name><value>..</value></parameter>
<parameter><name>driverName</name><value>SQLServer</value></parameter>
<parameter><name>serverName</name><value>127.0.0.1</value></parameter>
<parameter><name>portNumber</name><value>1433</value></parameter>
<parameter><name>databaseName</name><value>..</value></parameter>
<parameter><name>selectMethod</name><value>cursor</value></parameter>
<parameter><name>loginTimeout</name><value>60</value></parameter>
</ResourceParams>
Thanks a lot
| Thread-Topic: connection pool problem using in Tomcat
| thread-index: AcSMuy5kABS/93PSRZ6MtRi1273r1w==
| X-WBNR-Posting-Host: 202.134.106.86
| From: "=?Utf-8?B?a2FpY2FsbA==?=" <kaicall@.discussions.microsoft.com>
| Subject: connection pool problem using in Tomcat
| Date: Fri, 27 Aug 2004 21:55:03 -0700
| Lines: 30
| Message-ID: <22AD57F5-91A6-48C5-81BF-F9B84365D03F@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.jdbcdriver:6282
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| I use "SQL Server 2000 Driver for JDBC SP3" to connect SQLServer2000
under
| Tomcat App server.
|
| I wish to control the number of physical connections made to the database
to
| 50. Can somebody guide me about this.
|
| At the moment even with as low as 30 concurrent hits we see a very high
| number of phyiscal connection to the database as high as 200.
| I am using the following settings in SERVER.XML
| <Resource name="jdbc/ECTDB" auth="Container"
| type="com.microsoft.jdbcx.sqlserver.SQLServerDataS ource"/>
| <ResourceParams name="jdbc/ECTDB">
| <parameter><name>maxActive</name><value>30</value></parameter>
| <parameter><name>maxIdle</name><value>20</value></parameter>
| <parameter><name>maxWait</name><value>10000</value></parameter>
<parameter><name>factory</name><value>com.microsoft.jdbcx.sqlserver.SQLServe
rDataSourceFactory</value></parameter>
<parameter><name>driverClassName</name><value>com.microsoft.jdbcx.sqlserver.
SQLServerDataSource</value></parameter>
| <parameter><name>user</name><value>..</value></parameter>
| <parameter><name>password</name><value>..</value></parameter>
| <parameter><name>driverName</name><value>SQLServer</value></parameter>
| <parameter><name>serverName</name><value>127.0.0.1</value></parameter>
| <parameter><name>portNumber</name><value>1433</value></parameter>
| <parameter><name>databaseName</name><value>..</value></parameter>
| <parameter><name>selectMethod</name><value>cursor</value></parameter>
| <parameter><name>loginTimeout</name><value>60</value></parameter>
| </ResourceParams>
|
|
| Thanks a lot
|
|
If you are using SelectMethod=direct, then it is possible that you are
seeing an increase in connections due to the creation of cloned
connections. These additional connections are necessary because each
statement requires its own connection. Your Tomcat settings have no
bearing on this particular behavior, as it is inherent in the JDBC driver
itself.
Are you using transactions in your code? Can you provide code that
reproduces the problem behavior?
Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
|||Carb Simien ,
Yes, I use connection in my code and use a following function for getting
conncection.
public static Connection getConnection() throws Exception {
Connection dbConnection = null;
InitialContext ctx = new InitialContext();
Context envCtx = (Context) ctx.lookup("java:comp/env");
ConnectionPoolDataSource ds =
(ConnectionPoolDataSource) envCtx.lookup("jdbc/ECTDB");
Connection conn = ds.getPooledConnection().getConnection();
conn.setAutoCommit(false);
return conn;
}
Is this funciton cause the problem?
Thanks a lot.
kaicall
""Carb Simien [MSFT]"" wrote:

> --
> | Thread-Topic: connection pool problem using in Tomcat
> | thread-index: AcSMuy5kABS/93PSRZ6MtRi1273r1w==
> | X-WBNR-Posting-Host: 202.134.106.86
> | From: "=?Utf-8?B?a2FpY2FsbA==?=" <kaicall@.discussions.microsoft.com>
> | Subject: connection pool problem using in Tomcat
> | Date: Fri, 27 Aug 2004 21:55:03 -0700
> | Lines: 30
> | Message-ID: <22AD57F5-91A6-48C5-81BF-F9B84365D03F@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.jdbcdriver
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.jdbcdriver:6282
> | X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
> |
> | I use "SQL Server 2000 Driver for JDBC SP3" to connect SQLServer2000
> under
> | Tomcat App server.
> |
> | I wish to control the number of physical connections made to the database
> to
> | 50. Can somebody guide me about this.
> |
> | At the moment even with as low as 30 concurrent hits we see a very high
> | number of phyiscal connection to the database as high as 200.
> | I am using the following settings in SERVER.XML
> | <Resource name="jdbc/ECTDB" auth="Container"
> | type="com.microsoft.jdbcx.sqlserver.SQLServerDataS ource"/>
> | <ResourceParams name="jdbc/ECTDB">
> | <parameter><name>maxActive</name><value>30</value></parameter>
> | <parameter><name>maxIdle</name><value>20</value></parameter>
> | <parameter><name>maxWait</name><value>10000</value></parameter>
> <parameter><name>factory</name><value>com.microsoft.jdbcx.sqlserver.SQLServe
> rDataSourceFactory</value></parameter>
> <parameter><name>driverClassName</name><value>com.microsoft.jdbcx.sqlserver.
> SQLServerDataSource</value></parameter>
> | <parameter><name>user</name><value>..</value></parameter>
> | <parameter><name>password</name><value>..</value></parameter>
> | <parameter><name>driverName</name><value>SQLServer</value></parameter>
> | <parameter><name>serverName</name><value>127.0.0.1</value></parameter>
> | <parameter><name>portNumber</name><value>1433</value></parameter>
> | <parameter><name>databaseName</name><value>..</value></parameter>
> | <parameter><name>selectMethod</name><value>cursor</value></parameter>
> | <parameter><name>loginTimeout</name><value>60</value></parameter>
> | </ResourceParams>
> |
> |
> | Thanks a lot
> |
> |
> If you are using SelectMethod=direct, then it is possible that you are
> seeing an increase in connections due to the creation of cloned
> connections. These additional connections are necessary because each
> statement requires its own connection. Your Tomcat settings have no
> bearing on this particular behavior, as it is inherent in the JDBC driver
> itself.
> Are you using transactions in your code? Can you provide code that
> reproduces the problem behavior?
> Carb Simien, MCSE MCDBA MCAD
> Microsoft Developer Support - Web Data
> Please reply only to the newsgroups.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
>
|||CarbinoS@.online.microsoft.com ("Carb Simien [MSFT]") wrote in message news:<zzuzMF7jEHA.2516@.cpmsftngxa10.phx.gbl>...
> If you are using SelectMethod=direct, then it is possible that you are
> seeing an increase in connections due to the creation of cloned
> connections. These additional connections are necessary because each
> statement requires its own connection. Your Tomcat settings have no
> bearing on this particular behavior, as it is inherent in the JDBC driver
> itself.
> Are you using transactions in your code? Can you provide code that
> reproduces the problem behavior?
> Carb Simien, MCSE MCDBA MCAD
> Microsoft Developer Support - Web Data
> Please reply only to the newsgroups.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
This is a little scary isn't it? If I have a J2EE app that starts out
pre-preparing (for subsequent re-use) N prepared statements per
connection and I have M concurrent clients using the app then we'll
require N*M physical database connections. Is that correct? That
number could be pretty huge for even a mid size app..
Is there any plans to address this in any future driver?
Grant M
|||grantmitchell7@.yahoo.com wrote:

> CarbinoS@.online.microsoft.com ("Carb Simien [MSFT]") wrote in message news:<zzuzMF7jEHA.2516@.cpmsftngxa10.phx.gbl>...
>
> This is a little scary isn't it? If I have a J2EE app that starts out
> pre-preparing (for subsequent re-use) N prepared statements per
> connection and I have M concurrent clients using the app then we'll
> require N*M physical database connections. Is that correct? That
> number could be pretty huge for even a mid size app..
Not to mention if you plan to do anything transactionally, or use temp tables,
which would be limited to one real connection, and not involve all the
under-the-covers connections involved in one logical connection.
I am confident that an upcoming version of the free MS driver will
address this. In the mean time you have the option of using commercial
drivers, or ensuring you run with selectMethod=cursor. As I recall, the
original poster actually already showed he was running with selectMethod=cursor...
Joe Weinstein at BEA
> Is there any plans to address this in any future driver?
> Grant M
|||Joe Weinstein <joeNOSPAM@.bea.com> wrote in message news:<4136035E.9000108@.bea.com>...[vbcol=seagreen]
> grantmitchell7@.yahoo.com wrote:
>
> Not to mention if you plan to do anything transactionally, or use temp tables,
> which would be limited to one real connection, and not involve all the
> under-the-covers connections involved in one logical connection.
> I am confident that an upcoming version of the free MS driver will
> address this. In the mean time you have the option of using commercial
> drivers, or ensuring you run with selectMethod=cursor. As I recall, the
> original poster actually already showed he was running with selectMethod=cursor...
> Joe Weinstein at BEA
Yes the transactional problem is alarming.. Does the driver transact
all the cloned connections for statement when the original connection
is transacted? Who knows but I suppose a test would be relativly
quick.
In regards to selectMethod=cursor - our tests show that result sets
generated with server side cursors can be up to 8 times more expensive
on the database (and slower) than forward only, 'client side' result
sets (depending on the characteristics of the cursor). So instead of
having N*M connections we might end up with N*M server side cursors.
I'm not sure which is worse..
Therefore I would argue that server cursor based result sets are a
major obstacle to scalability and should be avoided at all costs
(except possibly for singleton processes that need a table snapshot
like a report for example).
I hope you are right that an upcoming release resolves this although I
remain skeptical since my guesss is that changing this behavior would
mean a major structural change in the driver's architecture.
On this newsgroup there has been recent reference by Microsoft to a
"new" JDBC driver for SQL 2005. However when I tried to get more
details on this driver there was no response. Perhaps someone from
Microsoft could comment on the "new" driver, and specifically comment
on whether it resolve this serious issue..
Grant

Connection failed to local SQL server

Hello,
One day when i try to open my database om my local computer (Win 2000
server, SQL 2000 EE, sp3) i get message:
A connection could not be established to (LOCAL)
Reason: cannot open user default database. Login faied..
Please verify SQL Server is running and check your SQL Server
registration properties (by right-clicking on the (LOCAL) node) and try again.
SQL Server is running and right-clicking produces just the same message.
Can anybody say what happend and what to do.
Thanks a lot.1. check which database is default database for your login
2. default database exist on server?
3. check permissons on your default database
"olsh" wrote:
> Hello,
> One day when i try to open my database om my local computer (Win 2000
> server, SQL 2000 EE, sp3) i get message:
> A connection could not be established to (LOCAL)
> Reason: cannot open user default database. Login faied..
> Please verify SQL Server is running and check your SQL Server
> registration properties (by right-clicking on the (LOCAL) node) and try again.
> SQL Server is running and right-clicking produces just the same message.
> Can anybody say what happend and what to do.
> Thanks a lot.|||Sorry, how can i check these if i have no access to SQL Server?
"Aleksandar Grbic" wrote:
> 1. check which database is default database for your login
> 2. default database exist on server?
> 3. check permissons on your default database
>
> "olsh" wrote:
> > Hello,
> > One day when i try to open my database om my local computer (Win 2000
> > server, SQL 2000 EE, sp3) i get message:
> > A connection could not be established to (LOCAL)
> > Reason: cannot open user default database. Login faied..
> > Please verify SQL Server is running and check your SQL Server
> > registration properties (by right-clicking on the (LOCAL) node) and try again.
> >
> > SQL Server is running and right-clicking produces just the same message.
> >
> > Can anybody say what happend and what to do.
> >
> > Thanks a lot.|||use ISQL
sample
ISQL -S<server> -U<user> -P<password>
if your default database not exist on server, isql will use master database
then, check your default database
select name,dbname from syslogins where name='<yourlogin>'
go
...
and if shall
exec sp_defaultdb 'login','database'
go
"olsh" wrote:
> Sorry, how can i check these if i have no access to SQL Server?
>
> "Aleksandar Grbic" wrote:
> > 1. check which database is default database for your login
> >
> > 2. default database exist on server?
> >
> > 3. check permissons on your default database
> >
> >
> > "olsh" wrote:
> >
> > > Hello,
> > > One day when i try to open my database om my local computer (Win 2000
> > > server, SQL 2000 EE, sp3) i get message:
> > > A connection could not be established to (LOCAL)
> > > Reason: cannot open user default database. Login faied..
> > > Please verify SQL Server is running and check your SQL Server
> > > registration properties (by right-clicking on the (LOCAL) node) and try again.
> > >
> > > SQL Server is running and right-clicking produces just the same message.
> > >
> > > Can anybody say what happend and what to do.
> > >
> > > Thanks a lot.|||Thanks, everything is OK now!!
"Aleksandar Grbic" wrote:
> use ISQL
> sample
> ISQL -S<server> -U<user> -P<password>
> if your default database not exist on server, isql will use master database
> then, check your default database
> select name,dbname from syslogins where name='<yourlogin>'
> go
> ...
> and if shall
> exec sp_defaultdb 'login','database'
> go
>
> "olsh" wrote:
> > Sorry, how can i check these if i have no access to SQL Server?
> >
> >
> > "Aleksandar Grbic" wrote:
> >
> > > 1. check which database is default database for your login
> > >
> > > 2. default database exist on server?
> > >
> > > 3. check permissons on your default database
> > >
> > >
> > > "olsh" wrote:
> > >
> > > > Hello,
> > > > One day when i try to open my database om my local computer (Win 2000
> > > > server, SQL 2000 EE, sp3) i get message:
> > > > A connection could not be established to (LOCAL)
> > > > Reason: cannot open user default database. Login faied..
> > > > Please verify SQL Server is running and check your SQL Server
> > > > registration properties (by right-clicking on the (LOCAL) node) and try again.
> > > >
> > > > SQL Server is running and right-clicking produces just the same message.
> > > >
> > > > Can anybody say what happend and what to do.
> > > >
> > > > Thanks a lot.

Connection failed to local SQL server

Hello,
One day when i try to open my database om my local computer (Win 2000
server, SQL 2000 EE, sp3) i get message:
A connection could not be established to (LOCAL)
Reason: cannot open user default database. Login faied..
Please verify SQL Server is running and check your SQL Server
registration properties (by right-clicking on the (LOCAL) node) and try again.
SQL Server is running and right-clicking produces just the same message.
Can anybody say what happend and what to do.
Thanks a lot.
1. check which database is default database for your login
2. default database exist on server?
3. check permissons on your default database
"olsh" wrote:

> Hello,
> One day when i try to open my database om my local computer (Win 2000
> server, SQL 2000 EE, sp3) i get message:
> A connection could not be established to (LOCAL)
> Reason: cannot open user default database. Login faied..
> Please verify SQL Server is running and check your SQL Server
> registration properties (by right-clicking on the (LOCAL) node) and try again.
> SQL Server is running and right-clicking produces just the same message.
> Can anybody say what happend and what to do.
> Thanks a lot.
|||Sorry, how can i check these if i have no access to SQL Server?
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> 1. check which database is default database for your login
> 2. default database exist on server?
> 3. check permissons on your default database
>
> "olsh" wrote:
|||use ISQL
sample
ISQL -S<server> -U<user> -P<password>
if your default database not exist on server, isql will use master database
then, check your default database
select name,dbname from syslogins where name='<yourlogin>'
go
...
and if shall
exec sp_defaultdb 'login','database'
go
"olsh" wrote:
[vbcol=seagreen]
> Sorry, how can i check these if i have no access to SQL Server?
>
> "Aleksandar Grbic" wrote:
|||Thanks, everything is OK now!!
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use ISQL
> sample
> ISQL -S<server> -U<user> -P<password>
> if your default database not exist on server, isql will use master database
> then, check your default database
> select name,dbname from syslogins where name='<yourlogin>'
> go
> ...
> and if shall
> exec sp_defaultdb 'login','database'
> go
>
> "olsh" wrote:

Connection failed to local SQL server

Hello,
One day when i try to open my database om my local computer (Win 2000
server, SQL 2000 EE, sp3) i get message:
A connection could not be established to (LOCAL)
Reason: cannot open user default database. Login faied..
Please verify SQL Server is running and check your SQL Server
registration properties (by right-clicking on the (LOCAL) node) and try agai
n.
SQL Server is running and right-clicking produces just the same message.
Can anybody say what happend and what to do.
Thanks a lot.1. check which database is default database for your login
2. default database exist on server?
3. check permissons on your default database
"olsh" wrote:

> Hello,
> One day when i try to open my database om my local computer (Win 2000
> server, SQL 2000 EE, sp3) i get message:
> A connection could not be established to (LOCAL)
> Reason: cannot open user default database. Login faied..
> Please verify SQL Server is running and check your SQL Server
> registration properties (by right-clicking on the (LOCAL) node) and try ag
ain.
> SQL Server is running and right-clicking produces just the same message.
> Can anybody say what happend and what to do.
> Thanks a lot.|||Sorry, how can i check these if i have no access to SQL Server?
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> 1. check which database is default database for your login
> 2. default database exist on server?
> 3. check permissons on your default database
>
> "olsh" wrote:
>|||use ISQL
sample
ISQL -S<server> -U<user> -P<password>
if your default database not exist on server, isql will use master database
then, check your default database
select name,dbname from syslogins where name='<yourlogin>'
go
...
and if shall
exec sp_defaultdb 'login','database'
go
"olsh" wrote:
[vbcol=seagreen]
> Sorry, how can i check these if i have no access to SQL Server?
>
> "Aleksandar Grbic" wrote:
>|||Thanks, everything is OK now!!
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use ISQL
> sample
> ISQL -S<server> -U<user> -P<password>
> if your default database not exist on server, isql will use master databas
e
> then, check your default database
> select name,dbname from syslogins where name='<yourlogin>'
> go
> ...
> and if shall
> exec sp_defaultdb 'login','database'
> go
>
> "olsh" wrote:
>

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.

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.

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 Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

connection error after 15 minutes of restart

I have a problem with ms sql 2000 installed on windows 2000 server.
Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
Last night security update pack for IE 6 with SP1 was installed on the
server (KB867801)
Since morning sql server is working for 15 minutes, then connection is
not available - I got connection error message: msg: 17, level 16, state
1, SQL Server does not exists or access denied
After restarting SQL Server all works fine for about 15 minutes.
any clue ?
regardsMike Epprecht (SQL MVP) wrote:
> Have you checked the SQL event log for errors?
> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and check
> the number of connections.
> Regards
> Mike
>
> "yooyoo" wrote:
>
>>I have a problem with ms sql 2000 installed on windows 2000 server.
>>Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>>Last night security update pack for IE 6 with SP1 was installed on the
>>server (KB867801)
>>Since morning sql server is working for 15 minutes, then connection is
>>not available - I got connection error message: msg: 17, level 16, state
>>1, SQL Server does not exists or access denied
>>After restarting SQL Server all works fine for about 15 minutes.
>>any clue ?
>>regards
I will do it in some 10 minutes - I restarted server 5 minutes ago.
In SQL Log I have errors:
server SuperSocket Info: Bind failed on TCP port 1433.
server Error: 17882, Severity: 18, State: 1
server Error accepting connection request via Net-Library 'SSNETLIB'.
Execution continuing...
server Error: 17059, Severity: 18, State: 0
server Operating system error 0: The operation completed successfully...|||yooyoo wrote:
> Mike Epprecht (SQL MVP) wrote:
>> Have you checked the SQL event log for errors?
>> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and
>> check the number of connections.
>> Regards
>> Mike
>>
>> "yooyoo" wrote:
>>
>> I have a problem with ms sql 2000 installed on windows 2000 server.
>> Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>> Last night security update pack for IE 6 with SP1 was installed on
>> the server (KB867801)
>> Since morning sql server is working for 15 minutes, then connection
>> is not available - I got connection error message: msg: 17, level 16,
>> state 1, SQL Server does not exists or access denied
>> After restarting SQL Server all works fine for about 15 minutes.
>> any clue ?
>> regards
> I will do it in some 10 minutes - I restarted server 5 minutes ago.
> In SQL Log I have errors:
> server SuperSocket Info: Bind failed on TCP port 1433.
> server Error: 17882, Severity: 18, State: 1
> server Error accepting connection request via Net-Library 'SSNETLIB'.
> Execution continuing...
> server Error: 17059, Severity: 18, State: 0
> server Operating system error 0: The operation completed successfully...
sp_who returned 31 rows|||yooyoo wrote:
> yooyoo wrote:
>> Mike Epprecht (SQL MVP) wrote:
>> Have you checked the SQL event log for errors?
>> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and
>> check the number of connections.
>> Regards
>> Mike
>>
>> "yooyoo" wrote:
>>
>> I have a problem with ms sql 2000 installed on windows 2000 server.
>> Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>> Last night security update pack for IE 6 with SP1 was installed on
>> the server (KB867801)
>> Since morning sql server is working for 15 minutes, then connection
>> is not available - I got connection error message: msg: 17, level
>> 16, state 1, SQL Server does not exists or access denied
>> After restarting SQL Server all works fine for about 15 minutes.
>> any clue ?
>> regards
>>
>> I will do it in some 10 minutes - I restarted server 5 minutes ago.
>> In SQL Log I have errors:
>> server SuperSocket Info: Bind failed on TCP port 1433.
>> server Error: 17882, Severity: 18, State: 1
>> server Error accepting connection request via Net-Library 'SSNETLIB'.
>> Execution continuing...
>> server Error: 17059, Severity: 18, State: 0
>> server Operating system error 0: The operation completed successfully...
>
> sp_who returned 31 rows
The problem was another instance running on the server. But why it all
worked ok untill IE pack ?
regards,|||yooyoo wrote:
> yooyoo wrote:
>> yooyoo wrote:
>> Mike Epprecht (SQL MVP) wrote:
>> Have you checked the SQL event log for errors?
>> Using Query Analyzer, run sp_who or sp_who2 when the error occurs
>> and check the number of connections.
>> Regards
>> Mike
>>
>> "yooyoo" wrote:
>>
>> I have a problem with ms sql 2000 installed on windows 2000 server.
>> Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>> Last night security update pack for IE 6 with SP1 was installed on
>> the server (KB867801)
>> Since morning sql server is working for 15 minutes, then connection
>> is not available - I got connection error message: msg: 17, level
>> 16, state 1, SQL Server does not exists or access denied
>> After restarting SQL Server all works fine for about 15 minutes.
>> any clue ?
>> regards
>>
>> I will do it in some 10 minutes - I restarted server 5 minutes ago.
>> In SQL Log I have errors:
>> server SuperSocket Info: Bind failed on TCP port 1433.
>> server Error: 17882, Severity: 18, State: 1
>> server Error accepting connection request via Net-Library 'SSNETLIB'.
>> Execution continuing...
>> server Error: 17059, Severity: 18, State: 0
>> server Operating system error 0: The operation completed successfully...
>>
>> sp_who returned 31 rows
>
> The problem was another instance running on the server. But why it all
> worked ok untill IE pack ?
> regards,
>
I was too much optimistic. The nightmare started again at 8 a.m. :-(
I try to change port to somethign alse than 1433.
Hope reistall will help
regards|||Mike Epprecht (SQL MVP) wrote:
> Have you checked the SQL event log for errors?
> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and check
> the number of connections.
> Regards
> Mike
>
> "yooyoo" wrote:
>
>>I have a problem with ms sql 2000 installed on windows 2000 server.
>>Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>>Last night security update pack for IE 6 with SP1 was installed on the
>>server (KB867801)
>>Since morning sql server is working for 15 minutes, then connection is
>>not available - I got connection error message: msg: 17, level 16, state
>>1, SQL Server does not exists or access denied
>>After restarting SQL Server all works fine for about 15 minutes.
>>any clue ?
>>regards
sp_who returns just 31 rows
but there huge list on port mapping like: (10 times like this)
TCP 3095 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3096 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3097 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3098 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3099 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3100 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3101 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3102 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3103 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3104 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3105 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3106 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3107 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3108 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3109 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3110 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3111 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3112 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3113 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3114 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3115 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3116 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3117 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3118 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3119 192.168.2.2 TIME WAIT 192.168.2.2:1433
any clue?
regards|||I have the same problem, sp_who only shows < 50 connections. Any other ideas
please?

connection error after 15 minutes of restart

I have a problem with ms sql 2000 installed on windows 2000 server.
Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
Last night security update pack for IE 6 with SP1 was installed on the
server (KB867801)
Since morning sql server is working for 15 minutes, then connection is
not available - I got connection error message: msg: 17, level 16, state
1, SQL Server does not exists or access denied
After restarting SQL Server all works fine for about 15 minutes.
any clue ?
regards
Have you checked the SQL event log for errors?
Using Query Analyzer, run sp_who or sp_who2 when the error occurs and check
the number of connections.
Regards
Mike
"yooyoo" wrote:

> I have a problem with ms sql 2000 installed on windows 2000 server.
> Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
> Last night security update pack for IE 6 with SP1 was installed on the
> server (KB867801)
> Since morning sql server is working for 15 minutes, then connection is
> not available - I got connection error message: msg: 17, level 16, state
> 1, SQL Server does not exists or access denied
> After restarting SQL Server all works fine for about 15 minutes.
> any clue ?
> regards
>
|||Mike Epprecht (SQL MVP) wrote:
[vbcol=seagreen]
> Have you checked the SQL event log for errors?
> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and check
> the number of connections.
> Regards
> Mike
>
> "yooyoo" wrote:
>
I will do it in some 10 minutes - I restarted server 5 minutes ago.
In SQL Log I have errors:
server SuperSocket Info: Bind failed on TCP port 1433.
server Error: 17882, Severity: 18, State: 1
server Error accepting connection request via Net-Library 'SSNETLIB'.
Execution continuing...
server Error: 17059, Severity: 18, State: 0
server Operating system error 0: The operation completed successfully...
|||yooyoo wrote:

> Mike Epprecht (SQL MVP) wrote:
>
> I will do it in some 10 minutes - I restarted server 5 minutes ago.
> In SQL Log I have errors:
> server SuperSocket Info: Bind failed on TCP port 1433.
> server Error: 17882, Severity: 18, State: 1
> server Error accepting connection request via Net-Library 'SSNETLIB'.
> Execution continuing...
> server Error: 17059, Severity: 18, State: 0
> server Operating system error 0: The operation completed successfully...
sp_who returned 31 rows
|||yooyoo wrote:
> yooyoo wrote:
>
> sp_who returned 31 rows
The problem was another instance running on the server. But why it all
worked ok untill IE pack ?
regards,
|||yooyoo wrote:
> yooyoo wrote:
>
> The problem was another instance running on the server. But why it all
> worked ok untill IE pack ?
> regards,
>
I was too much optimistic. The nightmare started again at 8 a.m. :-(
I try to change port to somethign alse than 1433.
Hope reistall will help
regards
|||Mike Epprecht (SQL MVP) wrote:
[vbcol=seagreen]
> Have you checked the SQL event log for errors?
> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and check
> the number of connections.
> Regards
> Mike
>
> "yooyoo" wrote:
>
sp_who returns just 31 rows
but there huge list on port mapping like: (10 times like this)
TCP 3095 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3096 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3097 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3098 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3099 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3100 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3101 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3102 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3103 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3104 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3105 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3106 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3107 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3108 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3109 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3110 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3111 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3112 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3113 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3114 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3115 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3116 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3117 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3118 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3119 192.168.2.2 TIME WAIT 192.168.2.2:1433
any clue?
regards
|||I have the same problem, sp_who only shows < 50 connections. Any other ideas
please?