Configuration :: Cannot Connect Database SQL Server 2000 After Deploy To IIS
Jun 17, 2010
my web cannot connect database SQL server 2000 after i deploy to IIS.
I can connect sql server to another computer from my query analyzer and Enterprise Manager.
but after i deploy to IIS 5.1. I cannot Login .
it always return message like this:
"A network-related or instance-specific error occured while establishing a connection to sql server. the server was not found or was not accessible. verify that 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)"
how to Deploy ? because my program work correctly in Visual Studio 2008.
but after i publish and move to wwwrooot in inetpub. my web cannot login.
i suspect my method deploy in IIS is not correct.
View 4 Replies
Similar Messages:
Oct 12, 2010
I'm using MS Visual Web Developer 2010 Express to build a website that connects to a SQL server 2000 database. Is it possible to connect to SQL 2000 using providerName="System.Data.SqlClient"? I'm guessing not. Or am I limited to using providerName="System.Data.OleDb" ? And seems both connections are under this ADO.NET umbrella. confirm one way or the other ... I'm a bit confused.
From web.config:
<connectionStrings>
<add name="SubscrTypeConnectionString" connectionString="Provider=SQLOLEDB;Data Source=my-server-host;Persist Security Info=True;Password=123abcde;User ID=test;Initial Catalog=Apps"
providerName="System.Data.OleDb" />
</connectionStrings>
So I believe I need to use OleDbCommand calls. I've seen many examples to do gridview select/edit/delete using SqlClient but not OleDb calls in VB code. Links to sample code would be great.
View 2 Replies
Jan 24, 2011
Can I do this using SqlClient or do I have to use the ODBC route > ? I get error's in VS but from reading through the other post it appears to be an IDE specific problem.
View 3 Replies
Feb 2, 2011
When i click this button connection should establish ...
my coding is protected void Button1_Click(object sender, EventArgs e)
{
[code]...
View 3 Replies
Jan 20, 2011
I tried to connect to the SQL Server (2000) with the VS 2010 Express. I got error saying "This server version is not supported. You must have Microsoft SQL Server 2005 or later".
View 1 Replies
May 27, 2013
i have database that is stored on local.user should also be able to upload the database to online server . i am able to save it on local .But it is not saving on server.It shows request time out. Is it due to server not allowing external access.
View 1 Replies
Nov 26, 2010
I am trying to connect my sql server 2000 using the sql server utility. It is perfecly working fine on my system but when try it on some other system i am getting an error message as "Could not find the server".
Is there any other configuration change that i need to make? I am connecting using TCP/IP
View 3 Replies
Mar 8, 2011
I am developing web application using asp.net. Here i need to access two databases in which one is present on other server. I am able to connect to database present in same server but not with database present in other server.
I am using MS-access. I dont know the changes to be done and syntax for database connection.
View 3 Replies
Sep 6, 2010
I've been trying to restore a SQL Server 2008 database in SQL Server 2000 and it seems impossible. Does anyone know how to do it or maybe will be able to point me in the right direction?
View 3 Replies
Mar 19, 2010
I have a website running on a private Ip 1.2.3.4 with url "www.xyz.com" and which has external IP 7.8.9.10.
My question is If I want to add one more website on same server with different URL "www.pqr.com" What am I suppose to do? Can I use same External IP for the new website or Do I need one more External IP? And even if we can use same external IP for both website How do I route request to particular website.
Note:- My network is behind firewall and I have internal DNS server as well
View 3 Replies
Jan 14, 2011
I want to convert sql server 2000 database into sql server 2005 database. I am using sql server 2005 express.
I am trying by taking backup/Restore method, but it not work.
View 1 Replies
Apr 10, 2010
I have an 2008 server behind a ISA 2000 server at a remote location. I am trying to use web deloy to publish web sites to that location. this server was tested at this location and we were able to publish to it, it was then disjoned from the network and joined to the remote network.
I have opend port 8172 in the isa server and router. web deployment and web management services are running, I set up a deligation rule will all roles and added my Administrators account to it.I cant get it to publish using eithe htttps or http, with https is get Start Web Deploy Publish the Application/package to
https://thatsit.net.au:8172/msdeploy.axd?site=ThatsIT ...
C:Program FilesMSBuildMicrosoftVisualStudiov10.0WebMicrosoft.Web.Publishing.targets(3481,5): Error : Web deployment task failed.(Remote agent (URL https://server.com:8172/msdeploy.axd?site=ThatsIT) could not be contacted. Make sure the remote agent service is installed and started on the target computer.)
Make sure firewall and network settings on your computer and on the server are configured to allow connections between them. If the issue is not resolved, please contact your local or server administrator.
Error details: if i use http it hangs on this line in the output
Start Web Deploy Publish the Application/package to http://seerver.com/MSDEPLOYAGENTSERVICE
View 2 Replies
Dec 27, 2010
i have created simple hello world WCF services it is working fine in local machine but when i try to uploaded to the server and then run that service it not at al start like http://localhost:8080/wcf/helloservice.svc
i am trying to modified the webconfig file <endpoint> address i have changed to my servername.com/wcf/helloservice.svc again it shows error can give usefull link to creation and deployment to the server
View 1 Replies
Sep 1, 2010
how to deploy ASP.net Website having SQL Server on IIS server on Different Computer..
View 2 Replies
Mar 27, 2010
I want to synchronise two databases from two different platforms i.e. MS Sql Server 2000 and MySql. I have two applications one is desktop application which uses Mysql and other is Web application which uses MSSql. When any changes made to MySql from Desktop application, then that changes should get reflected to MS Sql database and vice versa. I am novice for this kind of situation.
View 4 Replies
Jan 13, 2011
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not find row in sysindexes for database ID 14, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. Could not open new database 'BILL'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476
------------------------------
BUTTONS:
OK
i have both sql2000 & 2005 on my system
i want attach tha database in sql2005.
if in case the database was mad ein sql2000 how do i attach in sql2005
or wht can be done??
View 6 Replies
May 4, 2010
I have developed web application i need to deploy it on remote server.i am using asp.net 3.5 ,c# 3.0 and visual studio 2008,sql server 2005.using visual studio 2008 how i can make msi file to deploy application on server
View 5 Replies
Jul 21, 2010
I have managed to deploy my website written using ASP.NET MVC2, C#, .NET Framework 4 and Visual Studio 2010 on my PC running Windows XP Service Pack 3 and IIS 5.1 (see [URL] The website is accessible on [URL] I need to install a separate ASP.NET Web Forms application under the folder Apps so that it is accessible as follows: [URL] Do I need to disable the wildcard maps on the folder Apps?
View 3 Replies
Jul 31, 2010
I have developed a web application with ASP.Net 2.0 (VB Code Behind) and I am using My SQL as database.
I wish to sell the web application from my other website to multiple users. What would you suggest to be the best way to deliver this application? Fact is I can compile the front end script and provide the compiled version but I am not sure how to provide the associated MySQL database to them. I need to make sure that the buyers are not able to alter any code in the application or modify the preset data in the MySQL database. I do not wish to use the Setup Based deployment method as it will require the buyers to have administrative rights on the server, which may not be available on shared hosting.
But at the same time they must be able to get the web application up and running with minimal effort. I must be honest with you that I have developed only HTML based static websites till now and this would the first time I am launching an ASP.Net application.
View 1 Replies
Mar 20, 2011
for the last couple of days i've been trying to deploy an application that uses a sql express db on to my iis.up until now i was trying to upload it onto iis 5.1, but now i a brand new iis7.5 but i still get this annoying error:An attempt to attach an auto-named database for file C:application_nameApp_DataDatabase1.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.needless to say that there is no database with this name on my computer. i've set the application pool to .net framework 4.0.
View 2 Replies
Sep 20, 2010
I having worked with asp.net in while.Working in VS 2008 it seems it embeds the database in the solution.I have a external database,that is used by other applications.How do I connect into that?
View 2 Replies
Jun 9, 2010
how can i select data into temp table from another database in sql server 2000
View 2 Replies
Nov 11, 2010
How to deploy Asp.net web site in IIS 6.0 my Environment is windows server 2003 64 bit and port ruining 81.
View 1 Replies
May 11, 2010
i have develop my silver light application using asp.net and i want to deploy it , i am using vs 2010 and planing to use vsweb deployment project 2010 for beta
View 1 Replies
Nov 28, 2010
I want to deploy asp.net 4.0 web site on windows server 2003, Now I already have a classic asp site running on it. Would there be any problem if I install .net 4.0 framework for my new site. Will the existing site (the one in classic asp) be affected?
View 2 Replies
