Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Data Source Library Connection Setup - Shows No SQL Servers Availabl

  Asked By: Daniel    Date: Oct 04    Category: Sharepoint    Views: 1446

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.

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Santana Osborn     Answered On: Oct 04

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.

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

 
Answer #2    Answered By: David Brown     Answered On: Oct 04

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
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.

 




Tagged: