SQL Server Connection Tester

06 Jun 2022 19119 views 0 minutes to read Contributors

Purpose

This solution tries to connect to SQL Server.

Sometimes a simple telnet 1433 does not give you the 100% guarantee a connection to SQL Server will actually be possible. If you do not have a SQL Server management studio tool available then this one can help you out.

Making a real connection to SQL Server gives you the guarantee that you can connect.

Download SQLConnection here. The tool doesn't do anything else than make a connection. It does not perform any query.

Input

The solution is a console application and needs no setup. You can start the application from the commandline and it starts asking for details.

Output

It will try to make a connection to the specified SQL Server, either with Windows authentication or SQL authentication.

Download Visual Studio C# solution

Source Code

		
			
T-SQL
			
Transact-SQL
			

			
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Test_SQL_Connection
{
    class Program
    {
        static void Main(string[] args)
        {

            string serverName;
            string userId="";
            string password="";
            bool integratedSecurity;

            Console.WriteLine("SQLTreeo (c) 2019 - SQL Server Connectivity test v1.0\n");
            Console.Write("Enter SQL Server name (servername/ip-address)[,portnumber]: ");
            serverName = Console.ReadLine();
            Console.Write("Integrated security (Y/N): ");
            if (Console.ReadLine().ToUpper() == "Y")
            {
                integratedSecurity = true;
            }
            else
            { 
                integratedSecurity = false; 
            }
            if (!integratedSecurity)
            {
                Console.Write("Enter SQL Loginname : ");
                userId= Console.ReadLine();
                Console.Write("Enter Password: ");
                password = Console.ReadLine();
            }

             var connectionString = integratedSecurity ? string.Format("Data Source={0};Integrated Security=SSPI;Connection Timeout=5", serverName)
                                                        : string.Format("Data Source={0};User ID={1};Password={2};Connection Timeout=5", serverName, userId, password);

            var connection = new System.Data.SqlClient.SqlConnection(connectionString);

            try
            {
                using (connection)
                {
                    connection.Open();

                    Console.WriteLine("Connection to SQL Server successful.Press a key to quit.");
                }
            }
            catch (Exception exception)
            {
                Console.WriteLine(exception.Message);
                Console.WriteLine("Failed to connect to SQL Server. Press a key to quit.");
            }
            finally
            {
                connection.Close();
                Console.ReadKey();
            }

        }
    }
}

			

				

					

				

					
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
				
						
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
 
namespace Test_SQL_Connection
{
    class Program
    {
        static void Main(string[] args)
        {
 
            string serverName;
            string userId="";
            string password="";
            bool integratedSecurity;
 
            Console.WriteLine("SQLTreeo (c) 2019 - SQL Server Connectivity test v1.0\n");
            Console.Write("Enter SQL Server name (servername/ip-address)[,portnumber]: ");
            serverName = Console.ReadLine();
            Console.Write("Integrated security (Y/N): ");
            if (Console.ReadLine().ToUpper() == "Y")
            {
                integratedSecurity = true;
            }
            else
            { 
                integratedSecurity = false; 
            }
            if (!integratedSecurity)
            {
                Console.Write("Enter SQL Loginname : ");
                userId= Console.ReadLine();
                Console.Write("Enter Password: ");
                password = Console.ReadLine();
            }
 
             var connectionString = integratedSecurity ? string.Format("Data Source={0};Integrated Security=SSPI;Connection Timeout=5", serverName)
                                                        : string.Format("Data Source={0};User ID={1};Password={2};Connection Timeout=5", serverName, userId, password);
 
            var connection = new System.Data.SqlClient.SqlConnection(connectionString);
 
            try
            {
                using (connection)
                {
                    connection.Open();
 
                    Console.WriteLine("Connection to SQL Server successful.Press a key to quit.");
                }
            }
            catch (Exception exception)
            {
                Console.WriteLine(exception.Message);
                Console.WriteLine("Failed to connect to SQL Server. Press a key to quit.");
            }
            finally
            {
                connection.Close();
                Console.ReadKey();
            }
 
        }
    }
}