I am trying to connect to my SQL 2005 database using Single Sign-On authentication form Sharepoint Designer. I know my username and password but for some reason it doesn't let me connect this is the error that I get:
Server Erro: An error occured while retrieving the list of Databases from XXXXX: An authentication error occured. Your logon information may be inccorectly 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.
If I try to connect using the other method provided ( save the username and password in the data connection ) it works fine.
Why can't I connect to my SQL Database and how can I resolve it.