I am using sql server fulll edition.any idea how should I solve this issue, I search on net but not found any helpful answer.
View 4 RepliesI have never created my own solution before now. I have always modified existing solutions and know how to do it. For some reason, this new solution isn't connecting to my SQL server correctly.
I am using VWD 2008 Express Edition.
I have MSSQL 2008 Developer Edition.
I have used aspnet_regsql.exe to create the tables in my SQL DB.
I have added the following to my webconfig:
[Code]....
But for some reason, when I try to use the Web Site Administration Tool it thinks it is not setup.
What am I missing?
I have created a webservice in 2010. And when I call it from my web application sometimes,It generates the follwoing errors:-1. The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.2. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.I have already tried increasing excutonTimeOut etc.
View 2 RepliesThis error stopping my work in my crucial time. The error is "The underlying connection was closed: The connection was closed unexpectedly.".There are multiple WCF service I created in my project. But when I am requesting only one service this error is coming. I compare with other service, no difference. The service works fine in the morning, but afternoon it stops working and raising error.
I installed Silverlight 3.0 Tools for 2008 Sp1, Silverlight 3.0 Developer, WCF RIA Beta and Silverlight 4.0 runtime in my system in the morning. After getting this error I uninstalled WCF RIA Beta. But same issue.Could not find any solution. Please assist me how to solve this issue.
In my asp.net +vb+access web i have made a login page and the code is as under
Dim connectString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:webauth.mdb"
Dim con As OleDbConnection = New OleDbConnection(connectString)
con.Open()
Dim cmd As New OleDbCommand("select * from Users where userid =@userid and Password=@password", con)
cmd.Parameters.AddWithValue("@userid", txtUserName.Text)
[Code] ....
I am getting error The connection was not closed. The connection's current state is open.
I need to know if .net 4.0 is installed on server or not. How can I do that?
View 6 RepliesI have my wcf service and it runs fine. Then from my asp.net application I am trying to connect to this service. Everything is ok, request from asp.net is received in service (as I can debug code) and then when it returns to client I have the following error:underlying connection was closed: The connection was closed unexpectedlyMy contract on WCF service is as follows:
[OperationContract()]
WCFResponseGetAllProducts GetAllProducts(WCFRequestGetAllProducts request);
And WCFResponseGetAllProducts , WCFRequestGetAllProducts classes have [DataContract] attributes. Members of those classes have [DataMember] attribute. However when I added another method to my contract:
[OperationContract()]
int Test();
then I can execute it from asp.net mvc application without a problem.
PS. I host my wcf service in default web server in visual studio 2010 at the moment
I'm using Visual Studio 2008, and my database is SQL Server 2000.
I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.
But when I click OK, I get the error:
Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.
I just installed sql server 2008 R2 on my computer. I am trying to connect to sql server throught my C# code and everytime I run the C# program,
I get this error "A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "
The connection string that I used in my web.config file is
[Code]....
I am not sure what am I doing wrong, but I followed this article below step by step and still I am getting the same error
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
My instance name is MSSQLSERVER and the server that I am using is on my local machine and it has my computer name in it.
I have a Silverlight 3 application. It accesses WCF services that run on IIS. If I let the application sit for a while with no activity, it appears that I lose my connection to the server/login authentication, and my service calls fail.
It would appear that I am being logged out for security purposes, but this is not an area that I understand well. We are using a federated STS to create an encrypted token for security.
Can someone explain what is happening (if my description is clear enought), and how can I detect this event in my Silverlight application and redirect them back to the login page.
I have a web application which runs perfectly in my local machine. But the same when hosted in server, for some pages (which gets large amounts of data) gives me:-
Error 324 (net::ERR_EMPTY_RESPONSE): The server closed the connection without sending any data.-- in chrome
Server not found-- in firefox
and Internet Explorer cannot display the webpage-- in IE
I went through lot of other forums and some were suggesting to put this is web.config file
<httpRuntime executionTimeout="600" maxRequestLength="51200" />
Windows 7 Ultimate 64bit Visual Studio 2008 Team System Using C# SQL Server 2005 Express Management Studio (Service Pack 3) By using Visual Studio 2008,I opened Server Explorer and tried to modify Database connection,i wanted to use SQL Authentication,I entered User name and Passwored after pressing OK button,i got the following... Error message Failed to generate a user instance of SQL Server.Only an integerated connection can generate a user instance.The connection will be closed.
View 4 RepliesIm working with this Arquitecture : Web Service -> DLL(Xml Translator) -> Asp.net.Everything works fine, but,i have a process that takes about 23 minutes, in that time i show a "loading screen" that avoid the user to do anything, but after 20 mins while the web service is working and after debug my code, i get this error :
"The underlying connection was closed: The connection was closed unexpectedly"
Then, my "loading screen" keep visible until the web service completes the work, and after that, the "loading" hides and the web form shows my gridview empty.(its should show data).
I am trying to use Windows Authentication in my asp code. I have read / tried all answers on the web but couldnt my page to connect to sql. I m using classic asp.
My conn string looks like :
OCONN.OPEN ("PROVIDER=SQLOLEDB; DATA SOURCE myserver; INITIAL CATALOG=nrth; Integrated Security=SSPI; trusted_Connection=yes")
but I mgetting error
Microsoft OLE DB Provider for SQL Server
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.error '80004005'
I'm getting the "The underlying connection was closed: The connection was closed unexpectedly." error while trying to POST using the HttpWebRequest class on the production server, on my dev machine it works fine.
I originally tried using the WebClient class but I switched to the HttpWebRequest to try some of the suggestions I found while researching the issue (such as setting KeepAlive to false, PreAuthenticate true and ProtocolVersion to 1.0).
Since it's only happening on the production server, i'm guessing that it might have something to do with IIS.
Here's my code
[Code]....
If set the Target Framework (I used a new project for testing) to 2.0 (I didn't test every version of the framework) it works. I'm guessing that .net handles the security differently in .net 4.0.
From the last few days I am struggling with the error
"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed."
I hav created an asp.net web application with membership shcema. It works fine an my developement machine but when I published it on my web server.
I have written custom code for login and logout...When use clicks on logout button the current session is closed and user is redirected to a login.aspx page...The problem is that when a user click a back button on internet explorer it the previous page he was navigating is shown to him...(altough he cant perform any operation as session is null and their is condition in page load that if session is null user should be redirected to login page)May i have to clear cache of client ??
View 3 RepliesWe recently launched a new web site.there are roughly ~150 users active during peak hours.During peak hours,we are experiencing an issue every few minutes,the exception text is listed below.
System.Web.HttpUnhandledException:
Exception of type 'System.Web.HttpUnhandledException' was thrown.
---> System.Data.SqlClient.SqlException: The client was unable to establish a connection because of an error during connection initialization process before login.
Possible causes include the following:
the client tried to connect to an unsupported version of SQL Server;
the server was too busy to accept new connections;
or there was a resource limitation (insufficient memory or maximum allowed connections) on the server.(provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)
Our data access layer calls various DataTableAdapters using the following syntax.
EDIT
Yes, da is the name assigned to the DataTableAdapter. There is no connection.Open() because the DataTableAdapter takes care of all that, right?
using(TheDataLayer.some.strongly.typedNameTableAdapters.suchAndSuchTableAdapter da
[code]...
The connection string looks something like:
<add name="MyConnectionString"
connectionString="Data Source=myDBServerName;Initial Catalog=MyDB;User ID=MyUserName;Password=MyPassword"
providerName="System.Data.SqlClient" />
I'm trying to rule the problem being in Code.Is there anything "simple" that can be done to minimize this issue?
I published my web.The problem is that the path to the DataBase is not good and i dont know how to change it.heare is the error:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
View 4 RepliesI am having trouble installing SQL Server on my system ... it appears to install ok but when I try to connect it using Visual Web Developer Express 2008 it will not connect and mentions something about versions. I downloaded the Northwind database to carry on with the tutorials .. this also asked me to download the MS SQL 2000 version which I tried and this also did not work, other versions include 2005 and 2008. When I tried to open the program through the programs file from "Start Menu" only the configuration manager folder is there.
I have also tried to install the trial version from the website but to no avail. Each time I have restored to factory settings on my laptop and it still fails to connect. I notice that when I restore to factory settings there are loads of icons where the uninstall window lists all of the programs and there is still SQL Server 2008, lots of Icons. I think that version 2008 came with the laptop as it is a business sony vaio sr vgn-sr46gd model with vista business.
I'm trying to implement a regular ol' out of the box asp.net login system on SQL Server for the first time ever, and it's giving me way more grief than I ever imagined. Everything works great on my local asp.net testing server, but I can't get it working on the web server. I just get the generic- Server Error in '/' Application. A tech at my host mentioned that he thought that it was because I was using an ASPNETDB.MDF file created in SQL Express 2008 on a SQL Server 2005 server. I makes sense but I've seen a half dozen or more possible solutions in the many hours/days I've spent researching this but I hadn't heard of that one.
View 7 Repliesi m running asp.net example code in my vs 2005. I am using following datasource. I have no sql express edition, but i have developer edition of sql server 2005.
[code]...
i have .mdf file and i got following error message.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I have an appliaction that works fine and connect to the database.but when view the event log I can see that every minute I get this:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)
On web.config yo can find:
[Code]....
I've created a small website with a simple sqlite database using vwd 2010 .net 4. In dev and test envionments everything works fine, however when i promote to my hosting provider i receive the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I've been configuring the connection strings (autogenerated from entity framework and attached db) but unable to get it working on the hosting provider, I'm assuming it's related to permissions but not entirely sure how to resolve - here's the web.config as it stands:
<add
name="ApplicationServices"
connectionString="data [code].....
For info the environments are set up as follows:
- Dev environment is vwd express 2010 with sqlite mdf attached
- Test environment is windows 7 server, iis 7 with appdomain identity set to network service
Is it possible to insert a connection string into a web.config file if it isnt there?Would this work?The connection string is for a APS.NET user login and create account database.
View 3 Replies