473,326 Members | 2,175 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,326 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 13939


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: 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: 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...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.