This script connects to a SQL Server instance and enumerates all the databases available in it.
Using This script you can list all SQL server databases
using System.Data; using System.Data.SqlClient; .... public static void GetDatabaseList() { String conStr= "Data Source=MYSERVER; User ID=Username;Password=password;"; using (SqlConnection sqlConx = new SqlConnection(conStr)) { sqlConx.Open(); DataTable tblDatabases = sqlConx.GetSchema("Databases"); sqlConx.Close(); foreach (DataRow row in tblDatabases.Rows) { Console.WriteLine(String.Format("Database Name : {0}" , row["database_name"])); } } }