how to reset sql login account

[reynoldsj]

I am having trouble resetting my sql login for checkbox. It is seeing the install and only allowing me to update modules or patches. Can anyone refresh my memory. I have given permissions to iusr,network service and aspnet.

I am using v4.4.0.5

[jrjespersen]

If you mean the SQL login that Checkbox uses to access the database, that is stored in the connectionStrings section in the web.config in the application root directory.

[pwiesner]

Dear Jon,

If you are looking to change the username and password that Checkbox uses to connect to the database jrjespersen has it. This value is stored in the web.config file. You will want to edit the connectionStrings node. It looks like

<add name="DefaultConnectionString" connectionString="server=pwiesner;database=Checkbo x_4.4.1.14;uid=USERNAME;pwd=PASSWORD;Application Name=Checkbox Survey Server;" />

You will also need to make sure that the new SQL account has access to the Checkbox tables and data.

[reynoldsj]

I was able to change the connection string. Thanks for the help