18 Feb 2004
13 May 2008
Link to this post
I'm a bit stuck with setting up my project in a production enviroment. I thought it wasn't that hard, but after some hours I do not have it clear anymore:
I just want to use a SQL2005 database on a remote server instead of on the IIS webserver. Both servers are inside the same domain. I first tried to use a SQL Login account, since this seems to be the most simple solution. That didn't worked. I was getting an error something like 'Login failed for user <user>'.
Then I tried to access the database with trusted settings, using a domain user. Turn on impersonation and configured SQL server, but it still comes with an error about users that don't have the appropiate rights etc.
Now I don't have a clear view on what the steps are to configure my Sitefinity project with just a simple SQL Server account on a remote server?
It's a windows 2003 server (IIS6) and SQL 2005.
Is there any documentation available or knowlegde base items as far as you know?
Any help would be appriciated!