2

This is two part questions:
Does SharePoint 2010 support Trusted_Connection(Integrated Security=Yes;) when connecting to SQL Servers 2008/2012 for retrieving custom list?

If it does how can I set it up?

Currently I tried to go to Data Sources, clicked on new Database Connection. Selected "User custom connection string" inserted connection string in the following format


v1. Data Source=ServerName;Initial Catalog=databaseName;Integrated Security=Yes;
v2. Server=ServerName;Database=databaseName;Trusted_Connection=True;
v3. Server=ServerName;Database=databaseName;Integrated Security=Yes;

I get the same error message with all the different combinations.
"Server Error: An error occured while retrieving the list of Databases from ServerName: The server for the data source returned a non-specific error when trying to execute your query. Check the format and content of your query and thy again. If the problem persists, contact the server administrator."

note: I do not want/can not use SQL Authentication so don't even suggest it.

Improve this question
3
  • Anyone have any suggestions where I can find the error log for my error? Should I be looking on SharePoint server or the SQL Server? This morning I have started SQL Server Profiler and enable most areas that would be relevant to connection but I stil did not see anything in the Trace file that would be connected to the error message. From my SharePoint server, I went to central administrator and enabled all logging. Replicated the error message but still did not find the error in log.
    – Vladimir Oselsky
    Jul 17, 2013 at 14:41
  • you can try to look in the uls log formsharepoint. there will be logged all events from sharepoint.
    – Sascha
    Oct 28, 2014 at 19:57
  • We have to make few changes in "manage service applications" under central administration to enable windows authentication or Single sign on authentication. The below link gives complete description about how to do it. Hope this helps :) For Windows authentication to connect to external data source
    – 1Sherlock
    Sep 25, 2015 at 11:05

1 Answer 1

Reset to default
0

It seems that there is some mistake in query and not in connection string.

pls make sure that the query is ...

SELECT Name FROM master.sys.databases

Improve this answer
4
  • I don't get to the query part, once I feel in connection string and hit next I get the error.
    – Vladimir Oselsky
    Jul 16, 2013 at 14:58
  • Sorry...Not clear to me...Why don't you post the whole code related to it and clearly mention which line you are getting the error.
    – Pushpendra
    Jul 16, 2013 at 15:02
  • I posted 3 different connection strings, I said that I tried 3 different ways to use the same connection string not sure where you found the query?
    – Vladimir Oselsky
    Jul 16, 2013 at 15:18
  • Oh Man! The connection string correct. There somewhere else where you are making the mistake.
    – Pushpendra
    Jul 16, 2013 at 15:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.