i




 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQL Connection issue
09-27-2015, 12:47 PM
Post: #1
Not Solved SQL Connection issue
Hi,

I am using below SQL connection string to open the connection.

<add name="Test" connectionString="server=Myserver;database=Mydatabase;uid=Myuid;password=Myserver;Connection Timeout=30000;"/>

when i am opening sql connection for a server, it is getting hanged but not returning anything.

Strangely when i try with different sql server it is getting opened. I able to open the connection from a standalone application but unable to open after deploying iis.

Thanks,

Gopi Santosh Boni


Quote
10-12-2015, 06:21 PM
Post: #2
Not Solved RE: SQL Connection issue
Try the following format.
Code:
<connectionStrings>
    <add name="ConnStringDb1" connectionString="Data Source=localhost;Initial Catalog=YourDataBaseName;Integrated Security=True;" providerName="System.Data.SqlClient" />
  </connectionStrings>

[Image: 2604595733.png]
Quote
11-22-2016, 01:29 PM
Post: #3
Not Solved RE: SQL Connection issue
Basically, when you failed to connect to your SQL Server, the issue could be:
1) Network issue,
2) SQL Server configuration issue.
3) Firewall issue,
4) Client driver issue,
5) Application configuration issue.
6) Authentication and logon issue.
Quote


Possibly Related Threads...
Thread: Author Replies Views: Last Post
  SQL back up issue praveen 0 2,520 08-07-2015 05:20 AM
Last Post: praveen
  encrypt the connection string in the app.config file ? dongtrien 2 2,136 11-06-2014 02:39 AM
Last Post: dongtrien
  SQL connection in the app.config file? dongtrien 0 1,226 10-29-2014 03:52 AM
Last Post: dongtrien
  Can use SQL Server 2005 to Connection (link table) mySQL table ? dongtrien 5 1,980 08-22-2013 10:43 AM
Last Post: magnum_2007
  Problem with connection to sql server trytaher 2 1,669 08-01-2013 09:45 AM
Last Post: magnum_2007



User(s) browsing this thread: 1 Guest(s)