Happy Friday,
We’ve created a test version of Researcher’s Edge on SQL Server 2005, having moved it from SQL Server 2000. We use Windows authentication for Researcher’s Edge & when I try to get into the program, I get an “unable to connect” error message. If I login to the workstation as an administrator, I get the login box to choose the server & login (using SQL authentication) so I know that I can connect to the database.
Is there some permissions setting that we’re missing that’s not recognizing the users?
Thanks for your help,
Pat