Error while establishing connection to database in Sharepoint designer
Hi Friends,Sharepoint designer is giving error while connecting to Sql server 2005. Can anybody help me to get solution for this. Thank you.1. When igivemyservername in form of "ABC\XYZ", myusername and password, i got:"Server error: an error occurred while retrieving the list of Database from ABC\XYZ: An authentication error occurred. 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. Contact the server administrator for more information."2. When igive my servername in form of just "ABC" and my username and password, i got:"Server error: an error occurred while retrieving the list of Database from ABC: The data retrieval service encountered an error during connection to the data source. Contact the server administrator for more information."3. When igive 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 query may contain errors, the data source may be unavailable or configured improperly, or your Web site is behind a proxy server or firewall.If your Web site is behind a proxy server or firewall, verify that your server administrator has configured the Data Retrieval Services HTTP proxy server setting for Microsoft Windows SharePoint Services." Vimala Paluri
September 1st, 2009 9:18am

SPD questions go to Design/Customization. Moving this there. It doesn't in any case to me seem to be a Programming question (which is what this forum is for)WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx
Free Windows Admin Tool Kit Click here and download it now
September 1st, 2009 9:51am

If your account name is not added under designer group, please add it to get connect the site using SPD Go to People and Groups: Designers page, New > Add Users enter the account name and then OK There can be some other cases like Locking Down SharePoint Designer
September 1st, 2009 10:15am

If your account name is not added under designer group, please add it to get connect the site using SPD Go to People and Groups: Designers page, New > Add Users enter the account name and then OK There can be some other cases like Locking Down SharePoint Designer
Free Windows Admin Tool Kit Click here and download it now
September 1st, 2009 10:15am

Hi Raj, I am a site collection administrator. Not sure why I was getting those errors to connect to the sql server 2005.Vimala Paluri
September 1st, 2009 11:44am

Hi, From your first error information, please try the following steps: 1. Ensure your SQL server is configured properly, and that you are using a local SQL account. 3. Try connecting with the SA account, and check the effect. 4. If SA account works, if explains to you that the issue is probably permission related. 5. Go to the SQL server, change the problematic SQL user account's password, and ensure it had mappings to some databases. 6. Try the account again in SharePoint Designer and check the effect. 7. Also make sure that you have set the SQL server authentication mode to mixed mode i.e. "SQL Server and Windows Server Authentication" and Enable SQL Server login. For detail steps, please check the following steps: SQL Server and Windows Server Authentication: a) Open SQL server management studio, b) Right-click on the server node and select 'Properties'. c) Select 'Security' from the left menu under 'Select a page'. d) Under 'Server Authentication', select the 'SQL Server and Windows Authentication mode option'. e) Click 'OK' to close the dialog. 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'. b) Right click on the login name and select 'Properties'. c) Enter a password and confirm the password for the login. d) Select 'Status' from the left menu under 'Select a page'. e) Set the 'Login' option to 'Enabled'. f) Click 'OK' to close the dialog. If anything is unclear, please let me know. Hope it helps. Rock WangRock Wang MSFT
Free Windows Admin Tool Kit Click here and download it now
September 2nd, 2009 11:33am

Hi Rock Wang,Thank you so much for your solution. I have tried it and it works for me, now I am successfully displaying table values in Data view webpart. Vimala Paluri
September 3rd, 2009 9:37am

THANKS, IT worked for me.
Free Windows Admin Tool Kit Click here and download it now
June 21st, 2010 9:38pm

Sorry, this doesnt work.
December 9th, 2010 6:37am

Sorry, this doesnt work.
Free Windows Admin Tool Kit Click here and download it now
December 9th, 2010 6:37am

Will this ONLY work on databases that are in mixed mode? Our databases are WIA. thanks!
April 13th, 2011 5:10pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics