protected void CreateConnection() { try { if (settings.UseIntegratedAuthentication) { connection = new SqlServerConnection(settings.ServerName); } else { connection = new SqlServerConnection(settings.ServerName, settings.UserName, settings.Password); } connection.Connect(); if (!connection.IsUserValid()) { string msg = string.Format( "The user is not valid for SQL Server {0}", settings.ServerName); throw new SqlExporterConnectionException(msg); } } catch (Exception ex) { string msg = string.Format( "There was an error while trying to connect to the SQL Server {0}", settings.ServerName); throw new SqlExporterConnectionException(msg, ex); } }