Security :: Web Site Admin Tool - Cannot Establish Connection?
Aug 25, 2010
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."
View 6 Replies
Similar Messages:
May 14, 2010
I am using sqlserver express 2008 (Microsoft Web Platform Installer) and visual studio 10 professionnel.
I am also using last Silverlight4_Tools.exe.
When i enter in Web Site Administration Tool / security I obtain this error
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may in diagnosing the problem:
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
When I try userprovider
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.
View 1 Replies
Nov 15, 2010
I am building a web site and am trying to run the web site administration tool.
I have reinstalled SQL Server 2008 express and have run the command line administration utilites. When I try to run the administration tool, get the following error when I click on the security tab is
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
I have ensured that I have user instances are enabled
When I click on Choose Data Store I get the following 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.
View 2 Replies
Oct 5, 2010
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 ?
View 5 Replies
Apr 28, 2010
I am trying to send an email using the gmail smtp server. I am trying to enter the SMTP settings into the Web Site Admin tool. I have set
Server Name: smtp.gmail.com
server port: 587
from: myemail@gmail.com
Sender's User Name: my real gmail username
Sender's Password: my real gmail password
I am getting the following error when I try to send an email as a result on using the CreateUserWizard after successfully creating a new user.
Code:
The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first. i29sm30127820vcr.12
View 2 Replies
Nov 27, 2010
I am having some major headaches trying to get a Web Dev 2010 and SQL Server Express 2008 R2 to work together. At one point I hade Web Dev Express 2008 and SQL Express 2008 working together just fine, then I upgraded to 2008 Express R2 and have never been able to recover.
I have attempted to uninstall and reinstall several times, browsed the forums, watched videos, and while I have picked up a few things, I am still far from being able to get these two apps to work together for basic user authentication.
Here is where I am at. Web Dev Express 2010, .Net 4.0, and SQL Server Express 2008R2 installed. I have ran the .v4 aspnet_regsql.exe app against SQLEXPRESS, but when I bring up the Web Site Admin Tool, it cannot connect.
My machine.config connectin info is: [Code]....
Thinking that I may have some uninstalled connection info causing problems, I reviewed several of the security videos on this site, and decided to attempt to use my own database install rather then the default ASPNETDB.
So I now have 2 Database Engines (SQLEXPRESS and LOC). I created a new databases on LOC, named LOC and AspNetServicesDB. I then created users named LOCADMIN and AspNetServicesUser, made then the owners, and set the default database for eacg.Next I ran aspnet_regsql.exe from the v4.0.30319 folder, connected successfully, and installed the tables under AspNetServicesDB. The new tables (roles, membership, profiles) were installed. I then proceeded to copy the above machine.config connection info to the web.config file, and modified it as Joe Stagner did in this video. My edited web.config info:
[Code]....
Note that password is set to the real password in my config file.
Yet when I bring up the Web Site Administration Tool test the single provider, I get this error:
[Code]....
View 2 Replies
Dec 16, 2010
I've created an ASP.Net 4.0 web application. It uses Forms Authentication. I have an ASPNETDB.mdf file in my App_Data folder courtesy of SQLEXPRESS. I have appropriate settings in my web.config for connection strings and providers (since I know it will be asked for:
<add name="ApplicationServices" connectionString="data source=.SQLEXPRESS;Integrated Security=SSPI;
AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>).
I have roles and users setup. I have been running this with absolutely no problems in both my dev environment (i.e. Cassini) and on a "production" (not really, but a machine that was published to). And the "production" machine still has no problems.
So, everything has been working perfectly fine until early this afternoon and all of a sudden it all stopped. The only things I did from when it worked until it stopped was: I connected to and checked in all my code to a TFS server (2010) and then I updated namespaces all around. I have not made any changes to my web.config since it worked, nor to the database. I'm really not sure what happened. Oh, and the "production" machine never got the namespace updates. But, it did get a publish immediately before I uploaded everything into TFS.
It started with me getting a login failure in my app. I know the login is correct (it still works on the published system). So, I went into the Website Admin Tool and clicked onProvider Configuration -> Select a single provider... -> Click on Test next to AspNetSqlProvider (only option). I get back an error: "Could not establish a connection to the database." So, this tells me that for some reason, it can't see my database. All my roles and users still show up though in Security.
Since these two actions, I have wiped out all my code locally and refreshed from the first changeset in TFS. Still no workie. I still get the "Could not establish..." in WAT. Every post I can find online keeps talking about connectionStrings and database configuration (i.e. aspnet_regsql). However, since this was just working with no issues, I'm pretty sure none of these are my problem. Especially since I refreshed my code to an earlier "working" state (prior to namespace changes) to no effect.
I am not yet at the point that I'm willing to wipe my database and start over. Again, because this was working before. I have noticed and read several posts by Sukumar Raju among others (including his blog posts, one here) and none of them helped or were quite related to my specific issue. Good information, but not what I needed.
I'm sure something went offline somewhere and I can't see it. I did check to make sure that the SQLEXPRESS services (including Browser, etc.) were started. Even restarted them to no avail. I'm sure it has to be something simple and I'm just missing it somewhere.
View 2 Replies
Jan 31, 2010
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 don't know where to go next as this error message does't give many leads. I have already configured that database with the aspnet_regsql tool. In SQL Mngt. Studio I can see that the database aspnetdb has been created. I'm not sure where to go from here. The only connection string in my web.config file is the one for connecting to my content database.
View 4 Replies
Jan 9, 2010
Currently I'm learning on one of Joe Stagner video "SEC-009-CreateMembershipSchema" I followed exactly as told except for that Joe's is building the database in his JoeStagner server and not JoeStagnerSQLEXPRESS. But in my case I built my database in my MACHINENAMESQLEXPRESS. Another different thing is Joe's using SQL Management 2005 and I'm using the free version of SQL management 2008.
So I followed every step, inch by inch but when I tried to run a test on the AspNetSqlProvider, I'm getting this 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.
here's the connection string I added in just like in Joe's video
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="data source=.SQLEXPRESS;DataBase=AspNetServicesDB;Uid=AspNetServicesUser;Pwd=password"/>
</connectionStrings>
View 3 Replies
Apr 17, 2010
I'm looking for a way to create a login control without the use of web admin tool
Here are my system requirements
Windows 7 Visual Studio 2008 Professional Edition Microsoft SQL Server 2005 Express Edition ESET Anti-virus but SQL and Studio files excluded from being scanned. I have got a database. I've created the front end of the user login control manually not using the toolbox. Basically what I need is that once a user has registered. He then logs in. when he enters his username and password how do I code it so the database realises it's him/her and takes them to their LOGGED IN user
View 7 Replies
Oct 29, 2010
I'm dealing with a scenario where a legitimate user doesn't have a clue about his password, secret question or the answer. So, I was trying to create an admin tool that would help me in situations like these where the admin should be able to type in username and reset the password without having to know/enter answer to secret question. I understand that I need to make some changes to the web.config for this to work. I thought I made all the changes but my ResetPassword() requests are still not working.
Here's my web.config settings for the provider.
[Code]....
View 4 Replies
Dec 12, 2010
i have been trynig to have "ASP.Net Web Site Administration Tool" save all user information in my database , is that doable?
if yes, how i can have all those asp_tables in mine?
View 6 Replies
Mar 22, 2011
Working on my first asp.net webpage. i have followed video tutorials and implemented asp.net membership for login/security.Using Visual Studio 2010 i can open the Asp.net configuration page for management locally.But then if I want my site admin to manage users/security online, how is this done? Like manage through a web browser. I guess this asp.net configuration GUI is not available on the internet?
View 4 Replies
Aug 9, 2010
In my web.config I have:
[Code]....
If I just have ADProvider1 it works, when I add ADProvider2, even though for testing I only use ADProvider1 I get an error: "Unable to establish secure connection with the server" Am I adding the second provider to the membership section incorrectly?
View 11 Replies
Jun 23, 2010
I got an error when trying to configure roles:
The following message may help in diagnosing the problem: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
The schema is there and i configure web.config for using roles.
Web.config
[Code]....
Can this corce by insufficient permission?
View 7 Replies
Aug 10, 2010
login control portion of Murach's web dev w/ c# book. According to the books instructions, you create a Login.aspx page, add the login control to the page, and create the users and roles for the directories within the asp.net web site configuration tool. I still do not get prompted for user name and passord to access the pages I want to be secured. Why is this? Isn't the asp.net configuration tool supposed to edit the web.config file? I'm trying to follow the book to the letter and ensure that I am following correctly before posting for answers online. According to the book you do not have to edit anything or write code withing login.aspx page.
View 3 Replies
Feb 19, 2010
I get the following error while running ASP.Net Web site administration tool: ASP.Net Web site administration tool I am using visual web developer 2008 express edition and windows XP pro version 2002 service pack 3. I am following Microsoft Visual web developer 2008 express edition by Eric Griffin and in chapter 4 I need to use the administrator tool to set up passwords.
View 1 Replies
Aug 5, 2010
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?
View 6 Replies
Jan 8, 2010
This is my third site that I use role management, but the first time this happens. I have two roles: Member and Admin. If Admin user login, Admin node on sitemap shows. It works very well on my local machine in Visual Studio Express 2008 and in Visual Studio Team 2008. But once I deploy files to live site, even admin login, the Admin node doesn't show. I have a Member management page from which I may see member's role, and I can see that user name is in the role Admin. What could be wrong?
I used ASP.Net Configuration manager to create roles, users, and access roles. Here is the code:
in general site.config
<siteMap enabled="true " defaultProvider="XmlSiteMapProvider">
<providers>
<add name="XmlSiteMapProvider" description="Default SiteMap provider." type="System.Web.XmlSiteMapProvider"
siteMapFile="Web.sitemap" securityTrimmingEnabled="true"/>
[Code]....
View 6 Replies
Jan 22, 2011
I can't get past the "Test" link on the "Provider" tab in my Web Site Admin Tool (WSAT).
I'm running SQL Express (10.0.2531.0) and have created my "ASPNETDB" database using the version of aspnet_regsql that came with .Net 2.0. (When that work, I re-ran the version that came with 4.0.)
I have the following in my web.config:
[Code]....
And this:
[Code]....
When I go into the WSAT, to the Provider tab, I select "AspNetSqlProvider" and click test.
The error message I get is this:
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.
View 2 Replies
Nov 9, 2010
web.config file. when i go to test connection, i get this errorCould not establish a connection to the database.f 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 providerCan someone help me pls i am trying to deploy it to the remote server. Here is the codes:
<configuration>
<connectionStrings>
<add
name="ApplicationServices"
[code]...
View 1 Replies
Mar 23, 2010
Does anyone know how do i establish a connection through this platform(aspx.vb) with another computer if LAN connection are the only option. Hope some kind soul can guide me through and if possible provide some example so that i can study on it.
View 9 Replies
May 21, 2010
need a simple video that can expalin me the simple connection between a web form and sql db i am a begineer, i am learning all the things from these website, i need a video tutoorial that will explain me that how to create a simple form and simple database and conect them and manage those datas, can you people understand what i am expecting, for example, just a user login page with user name and password , and we have to store that details with a data base, and how to see the details what we stored, thats it and how to edit those details, atleast i need the first set of connection and manupulating video.
View 4 Replies
May 20, 2010
I have run aspnet_regsql.exe beaucoup times and it creates the database aspnetdb.db. I have created it in my primary database connection and in the SQLExpress connection.
Then I open Visual Studio 2008 and run the ASP.net Web Site Configuration Tool. I click on Provider tab and select Select a single provider for all site management data. The provider shown is AspNetSqlProvider. A book that I'm reading says it should be aspnetdb.
When I click on the test link, I get the following 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.
In my book, it looks like the aspnetdb database should appear in the app_Data folder of my web site. What is supposed to put it there? Does it get moved from the SQL Server Data folder?
View 1 Replies
Dec 28, 2010
I am having a domain name and web space (the web is running, its ASP.net 3.5). I am working on a project in which I need to connect 2 computers over the internet.
Is it possible to do that with a simple ASP.Net website? What other things I do need to do this?
EDIT
Actually I want to send the data from one computer to another in real time, I mean as we do chatting we exchange text to one another. The same thing I want to achieve.
View 3 Replies
