InstantASP Community Forums / Old Forums / InstantKB.NET 1.x / Installation / Update / Install - Changing SQL connection string / Latest Posts

RE: Install - Changing SQL connection string

Mark Christianson — Mon, 12 Dec 2005 15:54:03 GMT

Try it like this...

[code]<add key="InstantASP_ConnectionString" value="server=yourdatabaseserver;user id=youruserid; pwd=yourpwd;database=instantforumdb;"/>[/code]

RE: Install - Changing SQL connection string

Steve Billingsley — Mon, 12 Dec 2005 14:22:56 GMT

Our installation has SQL on another box using a sql account in the connection string. The navigation of the site works fine, but if I try to click on search I get the following. (I changed the machine name for this post)

[code]

<Message>Login failed for user 'XXXX\ASPNET'.</Message>

<Source>.Net SqlClient Data Provider</Source>

<StackTrace> at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)

at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)

at System.Data.SqlClient.SqlConnection.Open()

etc., etc.

[/code]

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

Thanks!

RE: Install - Changing SQL connection string

Ryan Healey — Thu, 05 Aug 2004 09:57:04 GMT

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

RE: Install - Changing SQL connection string

Class.NET — Thu, 05 Aug 2004 09:51:25 GMT

Hi All
I have windows 2000 professional and sql developer edition. I have installed the Installed the instantkb. But when i start it , I get the following error "SQL Server Does not exist or access denied" ..I had taken the following steps
1) Added ASPNET user in sql server and provided the permission of owner,read and write
2)Created another user in windows and added it to the sql database, gave the above permission and changed the connection string to
value="server=localhost;uid=xxxxx;password=yyyyyy;database=InstantKB12"
3)I added both aspnet and the above usernames in the security--login in sql server , still couldnt get...

Can anyone tell me where am i going wrong?

Regards
Sicilian

RE: Install - Changing SQL connection string

Ryan Healey — Wed, 22 Oct 2003 13:22:00 GMT

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,

Install - Changing SQL connection string

Sam Roberts — Wed, 22 Oct 2003 13:12:00 GMT

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'.]