tag:blogger.com,1999:blog-4709366045487299539.post5317205246570656357..comments2023-01-11T02:06:22.814-08:00Comments on Supplier of ID Card Printers in Middle East AND Africa: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that uUnknownnoreply@blogger.comBlogger7125tag:blogger.com,1999:blog-4709366045487299539.post-10569440576789498832010-04-25T12:43:37.846-07:002010-04-25T12:43:37.846-07:00hi friend,
i am using SQL Server 2008.
my problem ...hi friend,<br />i am using SQL Server 2008.<br />my problem is i am unable to connect to server through sqlconnection.<br />i am able to retrive the data from db to gridview directly by using sqldataSource control. but my requirement is like this..<br />i have a form and if i click on a button i have to insert some data into my database.so, i though of adding the code in the button click event.<br />i started writing like this...<br /><br />SqlConnection connection = new SqlConnection();<br /> connection.ConnectionString = "Data Source=A-56AEB715133C4\\SQLEXPRESS;Initial Catalog=States;Integrated Security=True";<br /> <br /> connection.Open();<br /> SqlTransaction transaction=null;<br /> <br /> transaction = connection.BeginTransaction();<br /> SqlCommand command = new SqlCommand("insert into state_info values('x','1234')",connection);<br /> command.ExecuteNonQuery();<br /> transaction.Commit();<br /><br /> connection.Close();<br /><br />it is showing the following error..<br /><br />Format of the initialization string does not conform to specification starting at index 0.<br /><br />i tried changing the connectionstring by using web.config file..but it is showing the same erro...<br />please help me out for this..Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4709366045487299539.post-29629590955105163372010-02-20T13:35:57.073-08:002010-02-20T13:35:57.073-08:00Hi all,
I was having the same problem here, and I...Hi all,<br /><br />I was having the same problem here, and I couldn't find a solution until I turned off the firewall state of all profile of windows 2008 server. After that you will be able to ping your windows 2008 server and to connect to your SQL server. This link describes what I'm trying to say here:<br />http://blog.benhall.me.uk/2009/01/unable-to-access-or-ping-windows-2008.html<br /><br />Thanks,,Mohamed Shakerhttp://www.galileosolutions.netnoreply@blogger.comtag:blogger.com,1999:blog-4709366045487299539.post-4479561590347514272010-01-15T21:37:27.561-08:002010-01-15T21:37:27.561-08:00Ys using
start->run->cmd->ping your ser...Ys using <br /><br />start->run->cmd->ping your server<br /><br />If it comes with error you first ask network people to correct that<br /><br /><br />Then make sure your remote server is using sql server enterprise edition start in the server by<br /><br />Click on start->programs->microsoft sql server 2005->Configuration tools->sql server surface area connction->surface area configuration for services and connections.<br /><br />Follow the below steps<br /><br />http://aspnetmembershipprovider.blogspot.com/2009/02/eanble-remote-connections-on-instance.html<br /><br />Please make sure you are doing this changes in remote server not in your laptop which is client.Top Bloggerhttps://www.blogger.com/profile/01874549730168551695noreply@blogger.comtag:blogger.com,1999:blog-4709366045487299539.post-73005081318927029212010-01-14T17:15:20.322-08:002010-01-14T17:15:20.322-08:00Sorry,, i dunno actually how to do ping the remote...Sorry,, i dunno actually how to do ping the remote server? is it by using command telnet in cmd?<br />Cause if so, it come out with the problem on port 23: connect failed<br /><br />Please provide the steps to make me easier to understand,,<br />thank you very much! *really need ur helpmutiartshttps://www.blogger.com/profile/00768839785065639558noreply@blogger.comtag:blogger.com,1999:blog-4709366045487299539.post-71971007589311458292010-01-13T21:05:49.021-08:002010-01-13T21:05:49.021-08:00Hi Mutia
can u ping frm ur laptop to ur remote s...Hi Mutia <br /><br />can u ping frm ur laptop to ur remote server<br /><br />If yes try to connect with sql server located in remote machine with the CTP in ur laptop and try to open tables with ur laptop CTPJasmin Paulnoreply@blogger.comtag:blogger.com,1999:blog-4709366045487299539.post-57983402785848361972010-01-13T19:31:41.717-08:002010-01-13T19:31:41.717-08:00yea,, i agree with u.. ive done all the instructio...yea,, i agree with u.. ive done all the instructions n restart my laptop so many times but still got same error!mutiartshttps://www.blogger.com/profile/00768839785065639558noreply@blogger.comtag:blogger.com,1999:blog-4709366045487299539.post-50347373050884687172009-11-24T22:58:05.941-08:002009-11-24T22:58:05.941-08:00every body describes the same instruction as u but...every body describes the same instruction as u but i still getting this error 40..... i wanted to connect 5 system with 1 server server having live ip and windows server.....3 of the systems are working fine.... but 2 of them raising the same exception... wts this bullshitAnonymousnoreply@blogger.com