I do not want to use the default connection string. I want to add a user and password to connect to the database. Is it as easy as changing the connection string in the web.config file?

I am getting the following error when I use the default connection string:

[SqlException: SELECT permission denied on object 'InstantKB_Articles', database 'InstantKB12', owner 'dbo'.]

Hi Sam,

Yes it is that simple. The error your receiving is because the database object don't have the correct permissions for whatever user account your using within the connection string.

Your connection string should look something like...

server=mysqlserver.com;uid=myusername;pwd=mypassword;database=instantkb12

Please ensure that whatever user you have created within the SQL server database has db_owner rights to your database. In the users node in Enterprise Manager right click the user and click db_owner apply the settings.

This will fix this error. I would recommend you do a some research into securing your user account when moving to a production environment

Hope this helps,

Explore our products...
http://demos.instantasp.co.uk/

Hi Sicilian,

Could you try the following connection string...

server=localhost;trusted_connection=true;database=instantkb12;

And ensure the ASPNET account appears within the users node of your database. Add this user if necessary and provide the do_owner database role to this ASPNET account.

This should allow you to use the software locally using a trusted connection. Of course you will need to change the connection string to use your dedicated SQL Server account once you move to a live environment. Please let me know if this helps

Explore our products...
http://demos.instantasp.co.uk/

Is there a way to get the search function to work without a trusted connection?

Thanks!