you must use the SQL Authentication with username(no domain format) and password. From my SharePoint server, I went to central administrator and enabled all logging. Go to the SQL server, change the problematic SQL user account's password, and ensure it had mappings to some databases. 6. Thanks Snehal Reply lakshmisingh None 0 Points 2 Posts Re: SharePoint designer denies to connect to database server Nov 20, 2007 10:59 AM|lakshmisingh|LINK Hi Steve, I am also facing the have a peek at this web-site
Your logon information may be incorrectly entered, you may not have permission to access this data source, or the requested authentication method may not be supported. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.Would you like to participate? Marked as answer by ziara Wednesday, July 21, 2010 12:53 PM Monday, July 19, 2010 6:51 AM Reply | Quote All replies 0 Sign in to vote Hi, It seem Target Applications A target application is a collection of information that maps a user or users to a set of encrypted credentials stored in the Secure Store database.
The connection string correct. Check the format and content of your query and try again. and no i cannot use the same username and password in SQL Server Management Studio. An Error Occurred While Retrieving Policy For This Computer If you need to switch views, do one of the following: If you are in a personal view and you want to switch to a shared view, click Switch to shared
Thanks. An Error Occurred While Retrieving The List Of Databases From Oracle Tuesday, July 13, 2010 5:41 AM Reply | Quote Answers 2 Sign in to vote yes. If you are not sure which Web Part or Web Part connection is causing a problem on your Web Part Page, it is a good idea to work in a step-by-step Monday, July 19, 2010 3:40 AM Reply | Quote 0 Sign in to vote well when connecting to SQL Server Management Studio I am using just winows authentication.
it seems you are using SQL Authetication. An Error Occurred While Retrieving Policy For This Computer (0x80072ee7) Server error: an error occured while retrieving the list of Tables from the vanarts database: The server for the data source returned a non-specific error when trying to execute your query. Monday, June 21, 2010 6:38 PM Microsoft is conducting an online survey to understand your opinion of the Technet Web site. What should I do???
And a table:Students is created. https://olenicksharepoint.wordpress.com/2010/12/13/error-creating-a-database-connection-to-sql-in-sharepoint-designer-2010/ Friday, July 16, 2010 6:22 AM Reply | Quote 0 Sign in to vote well i simply use username and password I don't use the connection string option Friday, July 16, Sharepoint Designer An Error Occurred While Retrieving The List Of Databases From When i give custom connection string, i got:"Server error: an error occurred while retrieving the list of Database from ABC: The web server cannot connect to the specified data source because the Server Error An Error Occurred While Retrieving The List Of Databases From Sharepoint Designer Now my first issue of connection to remote sql server is resolved and now I am facing problem with restarting of AOS.
If that didn't work, you can follow couple of solutions here: http://support.microsoft.com/kb/831092 http://social.msdn.microsoft.com/Forums/en-US/sharepointcustomization/thread/a8ebe934-72a2-4584-b44b-c3d94096e04f/ Like this:Like Loading... Check This Out SharePoint Designer 2010 Open a sitepage: Home.aspx and click "Edit File" button in the Ribon You can insert a Data View control or Data Form control into [P] tag box. current community chat SharePoint SharePoint Meta your communities Sign up or log in to customize your list. Parthav Savan Disawal 0 2010-12-9 2:32 PM In reply to Parthav: Disconnected then reconnected also Restarted VHD by Turn off Delete Changes but facing the same issue. An Error Occurred While Retrieving The Trend Data From The Database (mon00009)
Ensure your SQL server is configured properly, and that you are using a local SQL account. 3. Other recent topics Remote Administration For Windows. Zipped hard drive image very big Smallness of the catgeory of schemes of finite type Does the existence of Prawn weapons suggest other hostile races in the District 9 universe? Source So Windows authentication users are not supported to connect to SQL Server databases in SharePoint Designer.
Below is the error message: This control does not allow connection strings with the following keywords: 'Integrated Security', 'Trusted_Connection'. f) Right click on the server node and choose 'Restart' for the changes to take effect. Enable SQL Server login: a) In the server node expand 'Security' and 'Logins'. SELECT Name FROM master.sys.databases share|improve this answer answered Jul 16 '13 at 14:51 Pushpendra 1,200612 I don't get to the query part, once I feel in connection string and Error Occurred While Retrieving Policy For This Computer 4005 Connection to SQL Server database can be created in SharePoint Designer.
Because "Use Single-On Authentication" is discontinued, to connect to SQL Server with Security set to "Windows Authentication", you must use "Use custom connection string". In fact the provider was incorrect. Try connecting with the SA account, and check the effect. 4. c) Enter a password and confirm the password for the login.
As the error still occurs when you connect to SQL server with SQL server authentication users, I recommend to check if the SQL Server authentication method is set to be SQL Fabricio Savan Disawal 0 2010-12-10 7:15 AM In reply to Fabricio: Hi Thanks, I was facing space issue on VHD that’s why I was trying to connect to host sql server Also, I tried using SQL authentication test accounts, but that did not work either... I have no idea why.
Selected "User custom connection string" inserted connection string in the following format v1. I know that my windows authentication works on the SQL DB because I'm able to connect to it using the data connection in Excel desktop client. Your logon information may be incorrectly entered, you may not have permission to access this data source, or the requested authentication method may not be supported. Try the account again in SharePoint Designer and check the effect. 7.
Best regards, Victoria April 3rd, 2015 9:13am This topic is archived. Best regards. e) Click 'OK' to close the dialog. I am able to connect using SQL Server Management Studio.
My girlfriend has mentioned disowning her 14 y/o transgender daughter For document class amsart, the page numbers are too close to the last line What happens to aircraft wreckage? Please write if additional information is needed. f) Click 'OK' to close the dialog. If anything is unclear, please let me know. Hope it helps. Rock WangRock Wang– MSFT Marked as answer by Rock Wang–