unable to connect to SQL repository

when I perform this step, see attached, when I select type, the program takes a long time to display the SQL server list, same thing when I click on test the connections. I'm using 5.2.3.7

Note: This works fine if I was using PostgreSQL but still the first step of clicking on the + bottom takes a long time. I'm starting to believe that MS SQL wouldn't work correctly with either ETL or ATE. I hope I'm wrong

I also got this error "SQL server doesn't exist or access denied"

This is normal behavior for SQL server.

On large network it might take long time to get list of SQL servers.
We use standard Microsoft API to get list of servers.

Just imagine if you have 1000+ computers.
What is the way of checking if some of them have SQL SERVER installed? (I am just guessing here)
Sending message to every single one of them asking for this kind of information.
Or finding a server which holds this kind of information.
In both of the situations it will be very slow.

An there is nothing we can do to make this process faster

Here is what we use

msdn.microsoft.com/en-gb/library/ms130926.aspx

And this is what Microsoft says:

Due to network issues, SQLBrowseConnect might not receive a timely response from all servers. Therefore, the list of servers returned can vary for each request.

Mike

Apart from "slow list of sql servers"

Are you getting any errors/having problems?

Mike

I also got this error "SQL server doesn't exist or access denied"

Info about SQL server doesn't exist or access denied

support.microsoft.com/kb/328306

Mike

Unfortunately you did not tell us anything about you version of SQL server so we have to guess
You may need to allow SQL server TCP/IP connection



Mike