return a array from a class java

You can use an array for each record but a better approach would be to create an object for each record and collect all these records into a list.

Example:

class Record {

    private String username;
    private String environment;
    private String webDealer;
    private String webAgent;
    private String webPassword;
    private String internalUser;
    private String internalPassword;
    private String browser;

    public Record(String username, String environment, String webDealer, String webAgent, String webPassword,
                  String internalUser, String internalPassword, String browser) {
        this.username = username;
        this.environment = environment;
        this.webDealer = webDealer;
        this.webAgent = webAgent;
        this.webPassword = webPassword;
        this.internalUser = internalUser;
        this.internalPassword = internalPassword;
        this.browser = browser;
    }

    public String getUsername() {
        return username;
    }

    public String getEnvironment() {
        return environment;
    }

    public String getWebDealer() {
        return webDealer;
    }

    public String getWebAgent() {
        return webAgent;
    }

    public String getWebPassword() {
        return webPassword;
    }

    public String getInternalUser() {
        return internalUser;
    }

    public String getInternalPassword() {
        return internalPassword;
    }

    public String getBrowser() {
        return browser;
    }
}

And then you can use it:

// the method signature has changed and now it returns a list of records
public List<Record> connect2SQLServer() throws SQLException, ClassNotFoundException {
    // ...


    // create the list that will hold the results (records)
    List<Record> results = new LinkedList<>();
    while (rs.next()) {

        String username = rs.getString("username");
        String environment = rs.getString("environment");
        String webDealer = rs.getString("webDealer");
        String webAgent = rs.getString("webAgent");
        String webPassword = rs.getString("webPassword");
        String internalUser = rs.getString("internalUser");
        String internalPassword = rs.getString("internalPassword");
        String browser = rs.getString("browser");

        // create a new record
        Record record = new Record(username, environment, webDealer, webAgent,
                                   webPassword, internalUser, internalPassword, browser);

        // add the record to results
        results.add(record);
    }

    return results;
}

Comment: I took the liberty to modify the names of your variables to . not start with capital-case in order to comply with Java code conventions

I think this is what you are trying to do:

public String[][] connect2SQLServer() throws SQLException, ClassNotFoundException {
    // code..
    List<String[]> data = new LinkedList<>();
    while (rs.next()) {
        // more code..
        String[] sqlArr = {Username, Environment, WebDealer, WebAgent, WebPassword, InternalUser, InternalPassword, Browser};
        data.add(sqlArr);
    }
    return data.toArray(new String[data.size()][]);
}

And your Main:

public class Main {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Connect2SQLServer con = new Connect2SQLServer();
        String[][] data = con.connect2SQLServer();
    }
}

if you want to use arrays then you'll need to declare a multidimensional array before the while loop specifying the number of rows the query will return (which is difficult considering records could be inserted and removed from the source table) along with the number of columns that the table has.

Thus, I'd recommend that you use a nested ArrayList to store the records. each ArrayList of the outer ArrayList will consist of the values for each field of each record.

how to accomplish the aforementioned?

1. create the nested ArrayList before the while loop to accumulate the other ArrayList's.
2. for each iteration of the loop create a local ArrayList to store the fields of each record then add that ArrayList to the ArrayList outside of the loop.
3. ensure that the method connect2SQLServer has a return type of ArrayList<ArrayList<String>>
4. return the nested ArrayList.

you could easily extend this by creating a concrete type which represents each record of the source table and then you wouldn't need a nested ArrayList<ArrayList<String>> but rather just an ArrayList<TheType>.

As a rule of thumb, you shouldn't include all the logic inside connect2SQLServer as this methods sole purpose should be to connect to the DBMS. Rather you should have 4 methods representing the CRUD SQL commands (if you need all them), each method doing its job. However, in this case, since you're only performing a read command you can separate that logic away from the connect2SQLServer method making your code easier to maintain and less error prone when the code gets larger.