With sharepoint  when you go to create  a connection  to a SQL server  and no SQL
Servers populate  the dropdown  list - does that mean you don't have rights  to
them under domain/login name - or does that mean they are just set  not to show
up on a network  directory list?

Having trouble  connecting to SQL table. And when they are supposed  to populate
in a drop  down list  of SQL servers  to choose  from nothing shows. I can remote
into it but they don't populate on a list. There is one.

I created  1 connection with a custom  string - It shows  the database  at 1 point
but the data  doesn't transfer  thru.

A couple of things.

First, you can't use a windows authentication domain/login name in a custom
connection string  to connect to a SQL in SPD. Windows Authentication is
turned off.

Second, The Data Source dialog in SPD has a textbox for SQL server  name, not
a dropdown  list. There is a dropdown for tables AFTER you have supplied the
servername. That dropdown won't populate  unless you authenticate correctly.
You can't do it with Windows credentials unless you use SSO. For a
connection string you would need to use SQL credentials, which don't have a
domain name.