I have a Coldfusion server with a lot of websites and an MS SQL Server 2008 R2 connected with the webserver. The issue is that all datasources are connected to SQL with the sa which is wrong.

So I tried to create a new user for each website on the SQL with permission on it's own database only. I am creating a new user but it asks also for login? Should I create a new login and a new user for each website? Also what permissions a CF website will need in the database?


When creating a new login or changing a login in SQL, be sure to map it to one or more databases.

enter image description here

Give it a schema (dbo is default) and give him the appropriate rights in every database.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.