473,287 Members | 1,651 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

A connection was successfully established with the server, but then an error occurred during the login process

i saw a similar post from last year, but i didnt see any clear
solution. the error message:

"A connection was successfully established with the server, but then an
error occurred during the login process. (provider: TCP Provider,
error: 0 - The specified network name is no longer available.)

Exception Details: System.Data.SqlClient.SqlException: A connection was
successfully established with the server, but then an error occurred
during the login process. (provider: TCP Provider, error: 0 - The
specified network name is no longer available.)"
....it would appear to have something to do w/ SQL Server connectivity.
when i get it, i get it repeatedly. however, if i go to a non-db page,
then page to a db-page, it's cleared up.

i am running ASP.NET 2.0, on a commerical hosting environment
(www.datapacket.net), w/ a SQL 2000 server. no problems in dev, usually
works in this prod env.
any ideas what would cause this strangeness?

thanks,
matt

May 16 '06 #1
3 13937


Do a google search for

"Network Library"
"dbmssocn"

You can add some extra "hints" to the connection string, which might help.

You should post your connection string to the group, so it can be evaluated
also.


<ma*************@shell.com> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.com...
i saw a similar post from last year, but i didnt see any clear
solution. the error message:

"A connection was successfully established with the server, but then an
error occurred during the login process. (provider: TCP Provider,
error: 0 - The specified network name is no longer available.)

Exception Details: System.Data.SqlClient.SqlException: A connection was
successfully established with the server, but then an error occurred
during the login process. (provider: TCP Provider, error: 0 - The
specified network name is no longer available.)"
...it would appear to have something to do w/ SQL Server connectivity.
when i get it, i get it repeatedly. however, if i go to a non-db page,
then page to a db-page, it's cleared up.

i am running ASP.NET 2.0, on a commerical hosting environment
(www.datapacket.net), w/ a SQL 2000 server. no problems in dev, usually
works in this prod env.
any ideas what would cause this strangeness?

thanks,
matt

May 16 '06 #2
connection string:

<connectionStrings>
<add name="FooBar"
connectionString="server=x.x.x.x; database=FooBar; UID=foo; Pwd=bar"
providerName="System.Data.SqlClient"/>
</connectionStrings>

May 16 '06 #3
sloan wrote:
Do a google search for

"Network Library"
"dbmssocn"


ok can you be a littler more specific here (or, even, completely
clear)? i found some links that indicate this is a way one can set the
network library via the conn string:

http://support.microsoft.com/kb/q238949/

and the 2nd post here:

http://www.mcse.ms/archive85-2004-10-1155447.html

....says "dbmssocn" is the TCP/P network library and "dbnetlib" is the
new.

but, i have no idea what network libraries are, or why id want to use
them. none of the ASP.NET 2.0 articles/docs/code examples ive come
across specify a network library in the conn strings. what are these?
why did you refer them to me? are you aware of ongoing connection
difficulities if specifiying one is omitted?
thanks,
matt

May 16 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Ray Valenti | last post by:
I am able to preview this data in the development environment, but when I run the application the error below shows up. How do I set up a Trusted Connection? -Ray Server Error in...
4
by: rrober07 | last post by:
Hello, My Setup is I have a Web Server machine(Devweb01), Database SQL Machine(Devsql01), a Client Machine(local machine) I have configured the SQL machine as follows: 1) Added local Aspnet...
7
by: Keith Norris | last post by:
I cannot successfully create a connection object in a web form. In the page_load event I try the following code: Dim sConnection As String = "server=MIDATLANTICUS;" & _ database=Pubs;integrated...
2
by: embers_fire | last post by:
Does anybody know what might cause this error? I rebooted a server today running an asp.net 2.0 beta application and when it came back online, this error occured Exception Details:...
0
by: tony dong | last post by:
Hi there I use vs.net 2005 with standard sql 2005 under machine\sql2005 for instant when I create webpart, the code get from quickstart as follow: <%@ Page Language="C#" %> <%@ Register...
1
by: Chris Love | last post by:
I have already asked this, but no one seems to know the answer. Here is the timeline. I wanted to use the membership/roles functionality in a site. I got all sorts of errors trying to get this...
5
by: Suresh | last post by:
Hi Guys I have Db2 server installed on remote server. i am connecting to that remote server by using VPN. I want to connect that remote DB2 server instance using my local machine DB2...
3
by: Ted | last post by:
In WSAT, I get the following error when trying to set up my provider: Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site...
1
by: sahillihas8487 | last post by:
1.Unable to successfully establish a connection to web-server retrieving URI . "Web-server closing the connection after connection was just established." 2."General un-handled exception occurred...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.