C# Windows application: connection string to connect to remote sql server 2008 using windows authentication
-
I am developing a windows form application using c#. I want to connect to sql server 2008 which is in the server using windows authentication. Can anyone please provide me the connection string? Note: 1. domain is created in my server. 2. Remote access is enabled for the sql server 3. TCP/IP port is also enabled. Please help me. I am struggling for this since 3 days.
-
I am developing a windows form application using c#. I want to connect to sql server 2008 which is in the server using windows authentication. Can anyone please provide me the connection string? Note: 1. domain is created in my server. 2. Remote access is enabled for the sql server 3. TCP/IP port is also enabled. Please help me. I am struggling for this since 3 days.
AshwiniSH wrote:
Can anyone please provide me the connection string?
http://www.connectionstrings.com/[^]
AshwiniSH wrote:
1. domain is created in my server. 2. Remote access is enabled for the sql server 3. TCP/IP port is also enabled.
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.
Check these Steps to troubleshoot SQL connectivity issues[^] SQL Server 2005 Connectivity Issue Troubleshoot - Part I[^] Troubleshoot Connectivity Issue in SQL Server 2005 - Part II[^] Troubleshoot Connectivity Issue in SQL Server 2005 - Part III[^]
AshwiniSH wrote:
I am struggling for this since 3 days.
:confused: Hangover? Last 3 days're holidays.