Click here to Skip to main content
15,867,330 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
HTML
<add name="ABCCarcareEntities" connectionString="metadata=res://*/DataAccess.ABCCarcare.csdl|res://*/DataAccess.ABCCarcare.ssdl|res://*/DataAccess.ABCCarcare.msl;provider=System.Data.SqlClient;provider connection string="Data Source=117.121.0.201;Initial Catalog=ABCCarcare_uat;Persist Security Info=True;user id=ABCstages;password=ABCstages;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient"/>


Hi this is my connectionstring for my current application. i can connect it from my local pc to the remote database, but when i deploy it on the server it cannot access the database on sqlserver 2012. please help
Posted
Updated 11-Mar-13 0:13am
v11
Comments
Orcun Iyigun 11-Mar-13 6:01am    
update your question and write your connection string please.
Orcun Iyigun 11-Mar-13 6:05am    
7 th update and still no connection string :)
littleheartzzz 11-Mar-13 6:06am    
hi updated
littleheartzzz 11-Mar-13 6:14am    
hi do u have any idea of whats wrong in the connection string

1 solution

XML
ok i found out it was not because of the connection string, there is a different setting for different versions of iis
<pre lang="HTML">
  	<!-- For IIS 7.0-->
		<!-- ============================================== -->
		<!--<system.webServer>
			<handlers>
				<add name="ajaxhandler"  verb="*" path="*.ashx" type="AjaxPro.AjaxHandlerFactory,AjaxPro.2"/>
			</handlers>
		</system.webServer>-->
		<!-- For IIS 6.0-->
		<!-- ============================================== -->
		<system.web>
			<httphandlers>
				<add verb="*" path="*.ashx" type="AjaxPro.AjaxHandlerFactory,AjaxPro.2" />
			</httphandlers>
		</system.web>
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900