Hello Duncan Evans,
I can suggest that you use Windows Authentication for connecting to your SQL server if possible (Integrated Security
). Then on your SQL server you need to add a login for the identity of your application pool in which your Sitefinity websites run. After you create the login you should assign this user to the db_owner role for your databases.
the Telerik team