I have hosted a webservice in my server and i need to access the same in a web aplication and smart device project . Added the same in both solutions its working fine in a webapplication. But in smart device project we added the web reference and while deploying we are getting an error
"Could not establish connection to network"
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]...
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 Repliesneed 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 RepliesI 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?
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.
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.
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.
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>
I'm having a problem, which I haven't had with other projects, in setting up membership. I have set up a aspnetdb database using the asp.net confirguration tool. The database is in the app data folder and I can set up users and roles etc from the web site administration tool. However, trying to log in within the application, using the login control I get "Login attempt was not successful".
I have noted the following :-
1. On the home page of the Web site administration tool the application:/ shows no application where as normally it would show the name of the application.
2. Clicking the AspNetSqlProvider test button, I get the error "could not establish a connection to the database"
3. Although various lines have been added to the web config file, no connection string has been created to the aspnetdb file in the app data folder.
4. If you right click on the aspnetdb file within the solution explorer, there is an option of "include in project". Selecting this doesn't however solve the problem.
I have sql server 2008 express edition. I'm trying to use the wsat to set up the provider but I keep getting the 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.
[code]....
I m getting error while running page(.aspx)
"Login failed for user 'HOME-D6A8A84CE4ASPNET'." and at the same time i m also getting error
Firefox can't establish a connection to the server at localhost:1452.
although the the pages(website was running properly as before)
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 RepliesGetting 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 ?
IIS 6 installed on Vista (Virtual PC) not member of domain, Visual studio 2008 based website. Active Directory Membership configured in web.config.
Trust level set to Full. Using Login control to authenticate.
[Code]....
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.
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.
I cannot get a successful connectiong to the active directory when logging onto a web form. Here is the code I have in the web.config:
<configuration>
<appSettings/>
<connectionStrings>
[code]...
We're having an error similar to the one detailed here. We get the error noted above when trying to do AD authentication from our .net (3.5) mvc 2 app. This is our first .net mvc app ...
http://forums.asp.net/t/1161047.aspx
- We are re-using a forms auth library written for a .Net 2 app
- that library/app/config used a service account with min. privileges for binding to AD
- This error occurs in VS 2008, have not tried deploying the app to a server yet (a little early for that)
- like the other user at the previously referenced thread, I can get the 'unable to establish ...' error to go away and display the log on page by putting *MY* credentials in instead of the service account (but not successfully authenticate)
- moving the service account into the same AD OU as my account does not seem to change it ... only using my account credentials does.
- trust level is set to full
Is this some odd permissions trick that is new with .Net 3.5 (even though the ADmembershipProvider is still a 2.0 libary)? This should have nothing to do with MVC itself.
Config looks like this (very standard, like every one else's)
[Code]....
The line/portion highlighted in the debug/stacktrace is:
type="System.Web.Security.ActiveDirectoryMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
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?
I have this following requirement.
My Web Application is hosted on Server A. My Database is hosted on Server B.
Server A and Server B are not on same network. How can i point my connection string to the database in this scenario? Can any one give an example for this kind of Connection String?
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.
Is it possible to create a wap having a mssql connection?
View 1 Replies 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]....
When I load the asp.net config tool in vs2010 it loads the page up fine but as soon as I click on security I get the following error:-
Code:
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 diagnose the problem: 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. I have tried a blank project with a login control on but get the same.
