.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Cannot establish connection to sql2008 aspnetdb - WebSite Administration tool

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :ASP.Net
 

Good Afternoon all.

Noobie to asp.net and Admin Tool Site

Getting error: "Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
"  

I am not usign SQL Express

1. Installed VS2008 + sp1 after that Installed SQL 2008 Standard x86 + sp1

2. Used aspnet_regsql to add aspnetdb to the sql (I can see that db in MSSMS)

3. From my WebProject I can access WSAT but when I click on the Provider and try to test I am getting above error.

Tried diffetent settings in the web.config and also check machine.config

Check different solutions form different forums but nothing seams to work.

I strongly believe there is something wrong with my <connectionString/> as by default WSAT points to .\SQLEXPRESS but I do not know which file should I update (web.config or machine.config or Web.config) 

Do I need to add <connectionStrig> tag to web.config ?

All suggestions highly appreciated and appologise if this topic should no


View Complete Post


More Related Resource Links

Web Site Admin Tool - cannot establish connection

  

Hello,

I have a question with this tool.  I have a database listed in the App_folder, and the database has a connection in Server explorer.  The connection string is listed in the web.config file, and I am able to add users and roles with the Web Admin Tool.  However, when in the Web Admin Tool, under Configuration tab, I receive an error when I click on the "test" button.  The error reads

 " Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider."

How can this be, and how do I correct this?

thanks

 


Share point website connection with Certral administration

  

Here is the situation , although I have SBS server 2008 I posted this same problem there , but I want here also to ask.

I followed link http://technet.microsoft.com/en-us/library/dd548330(WS.10).aspx and here are the  results.

In SBS console there is companyweb and it is marked as online. DNS also has entry for companyweb and nslookup works.  When I try to recreate internal website , which is described as 2nd step, my IIS server  is started, in IIS7 my website is running, but when I try to see in central administration if my site exist (web application list)  it isn't listed. So I tried to recreate it and I  followed directions from upper link in section repair user access to the internal website but when I want to delete web site , it is not listed. And after when I want to extend I cannot once again because it is not listed. Any suggestions and is there an

Error in creating User through ASP.net website administration tool

  

i am creating some users and assign them different roles through website administration tool but when i am going to create new user all time validation control display same error and user could not created

Error

Password length minimum: 7. Non-alphanumeric characters required: 1.



localhost is not set up to establish a connection on port 51624 with this computer

  

I'm trying to run asp.net locally, but getting the error

localhost is not set up to establish a connection on port 51624 with this computer

How can I fix it?


How to Establish a Remote Web Site Connection in SharePoint Designer 2007

  

I am modifying a SharePoint site and so far so good.  Some of the objects were created using Visual Studio 2008 (C#).  I was able to modify these objects and implement them on the targete machine without issue.  The final step is to implement the ASPX pages that were modified using SharePoint Designer 2007.  These are aspx pages that are used to modify items in lists.  All the pages involved in this upgrade are customized.  I need to upgrade the target site with the modified version of these pages.  My intent is to copy the code from the page in the source site and past it into the same page on the target site.  I tried using the Remote Web Site connection tool in SharePoint Designer 2007 but received the following error message:

"Unable to open 'https://(site address)'.  Server Error:  Could not find a Web server at 'website'.  Please check to make sure that the Web server name is valid and your proxy settings are set correctly.  If you are sure that everything is correct, the Web server may be temporarily out of service."

I am not sure how to first check to see if the Web Server is temporarily out of service.  I would appreciate your input on how to verify this.

Background information of target machine:  WinServer 2008, IIS 7, Sharepoint (MOSS2007), site on port 80

WebSite Testing Tool - Best One

  

Hi,

I am lookinf for a Unit testing Tool for asp.net web application. i intended to use visual studio 2008 web test. Please tell me where can i get nice tutorials to start up on this tool. and also suggest me is any other web testing tools out there.


ASP.net Web Site Administration tool unable to connect ro my SQL DB

  
Hi, I am new to VWD and i am trying to use the Provider Configuration in the ASP.net Web Site Administration tool to configure my Web site management data. When ever i select the "Select a single provider for all site management data" there is only one provider "AspNetSqlProvider". When i select "test" it give me the following error message: "Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider." I have the aspnet_regsql to create a DB, my IIS is already installed and enable but the VWD ASP.net Web Site Administration tool refuse to connect to my SQL DB.What may be the problem and how can i rectify it.Thanks

ASP.net Web Site Administration Tool. An error was encountered. Please return to the previous page a

  
I have just installed Visual Studio 2010 trial. Previously I have been using Visual Studio Web Developer 2010 Express. Now every time I try to invoke the ASP.net Cofiguration tool either via the icon or through the Project File Menu item, I get the error message "An error was encountered. Please return to the previous page and try again." I am trying to develop a bog standard Silverlight Business Application. There are no other diagnostics. Is there anywhere I can look for more clues or anything else to do to alleviate the problem? or is this something peculiar to the trial version I am using?   I also think it might have something to do with the fact that I have created this Silverlight Business App on a directory on my D: drive and not the normal, default c: drive path and maybe the web sit admin tool is looking somewhere else. Could this have something to do with it? If so what is my remedy?   Help please.....

Establish GPRS Connection in C#

  
Hi all, I am developing windows application, which has one serial port attached with modem. Now when my application starts GPRS connection should be established once. Can any one give me some code reference or provide me with some links. Any help is appreciated.   Regards Asif

Establish GPRS Connection in C#

  
Hi all, I am developing windows application, which has one serial port attached with modem. Now when my application starts GPRS connection should be established once. Can any one give me some code reference or provide me with some links. Any help is appreciated.   Regards Asif

how the access the Web Site Administration Tool

  
Hello

how can i access the Web Site Administration Tool from my website. in VS2005 i can go to the menu website and then to ASP.NET configuration.

but how can i access this, when my site is published on a webserver????

greetz

Torkel

The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure

  

I've gone through lot of articles and not one solution worked for me:

I'm having IIS 7 on Windows 2k8 with SSRS 2008.

How SSL is configured: Its configured to access SSL over existing web-site. final url looks like https://url/reports. When I enter this URL I get the error message.

But, if I connect to same site using non SSL website from my local machine, it works fine. For example, if i use VS 2008 web server and connect to it, it works and shows me report, but as soon as I deploy it on webserver having SSL enabled, it just throws this message.

 

Somebody please help me wid this one


Not so important

Can not establish a connection to SQL Server 2008 R2 via Visual Studio 2010 Framework 4.0

  

Hello All, I would appreciate any help with this.

I believe my problem exists within the web.config which already had code in it to connect to SQL Server Express 2008.

I uninstalled the SQL Server Express that came with Visual Studio 2010.

I installed SQL Server 2010 R2 Developer, and I'm able to connect via Management Studio and through Visual Studio's Server Explorer's Data Connections I am connected.

I did run aspnet_regsql.exe within the 4.0 folder in order to create the database with Microsoft Service Providers.

Here is the ServerName: USER-5529234649 

Here is the name of the DataBase:  StepByStepChapter9

Here is the name of the Connection within Visual Studio's Server Explorer's Data Connections:  user-5529234649.StepByStepChapter9.dbo

Here is the code I changed in the web.config:

<configuration>
  <connectionStrings>
      <!--<add name="ApplicationServices"
            connectionString="data source=.\SQLEXPRESS;Integrated   Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"
            providerName="System.Data.SqlClient" />-->
      <add name="ApplicationServices" connectionString="data source=user-5529234649\Step

ASP.NET web administration tool error

  

Hi everyone,

I done Googling and I know where could be the problem is but I dun feel like fixing it without knowing what I am doing exactly. I have this error "An error was encountered. Please return to the previous page and try again." whenever I try opening asp.net web administration tool. Normally, when I click the button, VS2010 will automatically open the page on the browser just like I normally run other websites. However, it ain't happening here, so I manually called the page like "localhost:[port]/asp.netwebadminfiles" sth like that but doing so, lead to that problem. Most people suggest that weird characters shouldn't be in the path like whitespace and other special characters. In my case, my project file is in Documents and Settings/My Documents/ something like that. I am not sure I should change those file paths or not. Please advice me if there's an easier way to fix it. thanks all.



C# reverse connection remote screen capture tool

  

Hello , I am coding a reverse connection remote screen capture tool.The server can connect to the client but I cannot make screen capture to work. can someone help me out? this is my code :

<strong>using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Net;
using System.Net.Sockets;
using System.Threading;
using System.IO;

namespace ScreenCap_Client
{
  public partial class Form1 : Form
  {

    private TcpListener captureListener;
    private TcpListener severListener;

    private TcpClient tcpServer;
    

Cannot establish a TCP Connection.

  

Hello,

I've written my own classes to have a TCPServer and TCPClient component in the .NET C# application I'm building. These components work fine and passed all unit tests to validate their working and code. I'm perfectly able to establish connections on my own system and to other systems in the same network. For kicks I tried my component to establish a connection to www.google.com on port 80 and it worked fine as well.

However, when I try to establish a connection to a remote location, I get the following error message:

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because the connected host has failed to respond

This remote location is a network from a large company that is added to our network through a  VPN connection, if I'm not mistaking, and becomes part of our network. I can ping the remote location from my system, establish a connection using the old delphi components and use remote desktop. When I try to use my .NET components however, I cannot establish a connection at all and receive the above error message.

This is the code I use to establish a connection to the remote "server" application. I've read some details on the MSDN regarding security and s

Invalid postback or callback argument in Web Site Administration Tool

  

I get the following when I try to manage access rules in the ASP.NET Web Site Administration Tool.  Does anybody have idea why this might be anf how to fix?

An error was encountered. Please return to the previous page and try again.

The following message may help in diagnosing the problem: Invalid postback or callback argument. Event validation is enabled using in configuration or in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation. at System.Web.UI.ClientScriptManager.ValidateEvent(String uniqueId, String argument) at System.Web.UI.Control.ValidateEvent(String uniqueID, String eventArgument) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend