|
|
 Posted 05/12/2003 08:28:00 |
|
|
Forum Newbie
Group: Customers
Last Login: 23/03/2005 10:51:00
Posts: 4,
Visits: 1
|
|
Hi Ryan, I installed IKB on W2k3 server and setup Db with ASPNET user but get this error: [SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.] Looks like the system tries to login into DB using NETWORK SERVICE instead of ASPNET.  Thanks for any suggestions.
|
|
|
|
 Posted 05/12/2003 08:38:00 |
|
|
IF.NET 4.2 Coming Soon
Group: Administrators
Last Login: 19/11/2008 16:29:04
Posts: 1,956,
Visits: 3,018
|
|
Hi Barbos, It will use this account on Windows 2003 by default when connecting using a trusted connection. You simply need to apply to appropriate permissions to this user account and the application should have no problems. Alternatively you could create a user account for your database and update the knowledge base connection string to use a SQL server account and not a trusted connection. I hope this helps 
Kindest Regards,
Ryan Healey
Director / Developer
 Explore our products...
http://demos.instantasp.co.uk/
|
|
|
|
| Posted 05/12/2003 08:42:00 |
|
|
Forum Newbie
Group: Customers
Last Login: 23/03/2005 10:51:00
Posts: 4,
Visits: 1
|
|
Thanks a lot Ryan! I asigned specific user in DB and web.config. It works fine now.
|
|
|
|
| Posted 05/12/2003 08:46:00 |
|
|
IF.NET 4.2 Coming Soon
Group: Administrators
Last Login: 19/11/2008 16:29:04
Posts: 1,956,
Visits: 3,018
|
|
Hi Barbos, Great - i will include this in the installation guide soon. Anything else please let me know
Kindest Regards,
Ryan Healey
Director / Developer
Explore our products...
http://demos.instantasp.co.uk/
|
|
|
|
| Posted 18/03/2004 04:11:23 |
|
|
Forum Newbie
Group: Customers
Last Login: 18/03/2004 06:11:00
Posts: 1,
Visits: 1
|
|
I am having this same problem and i have setup the aspnet user in SQL as well as tried a sql connection... This is what i used in web.config <!-- Connection string for your database --> <add key="InstantForum_DSN" value="server=webserver1/database1;uid=sa;pwd=xxxx;database=instantforum33;"/> How can I fix???
|
|
|
|
| Posted 18/03/2004 04:28:11 |
|
|
IF.NET 4.2 Coming Soon
Group: Administrators
Last Login: 19/11/2008 16:29:04
Posts: 1,956,
Visits: 3,018
|
|
Hi, Because you have specified a dedicated username and password within the connection string this user information must exist as a SQL Server account. The ASPNET and NETWORK SERVICE accounts are only required when your connecting to the database via the default trusted connection method. You should ensure your dedicated user account has do_datareader and db_datawriter to your tables and execute permissions for the stored procedure. I hope this helps,
Kindest Regards,
Ryan Healey
Director / Developer
Explore our products...
http://demos.instantasp.co.uk/
|
|
|
|
| Posted 17/06/2004 03:10:58 |
|
|
Forum Newbie
Group: Customers
Last Login: 20/09/2004 12:29:00
Posts: 2,
Visits: 1
|
|
Hi I seem to be getting the same error. I am trying to install the InstantKB. I did locate the ASPNET user account and gave it permissions as was indicated above, but that didn't seem to help. I do not see a NT Authority or Network Service user account. Nor do I see a reference to it in the web.config file. I am stuck. Any help is appreciated. Thanks The error when I connect to the KB from the desktop shortcut is: Server Error in '/instantkb12' Application.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
|
|
|
|
| Posted 17/06/2004 03:14:33 |
|
|
IF.NET 4.2 Coming Soon
Group: Administrators
Last Login: 19/11/2008 16:29:04
Posts: 1,956,
Visits: 3,018
|
|
Hi, I suspect the Network Service account has not been added to your Logins within the Security node in Enterprise Manager. This is why this is not available to associate to your database. Are you running Windows 2003 ? Could you ensure the NetworkService account is added to SQL Server / Security / Logins. If you would be willing to provide access to this server i'll happily review your SQL Server settings to ensure this is correct. You should only use the trusted connection when developing locally. You should not use this for production Hope this helps a little,
Kindest Regards,
Ryan Healey
Director / Developer
Explore our products...
http://demos.instantasp.co.uk/
|
|
|
|
| Posted 21/07/2004 04:23:10 |
|
|
Forum Newbie
Group: Customers
Last Login: 21/07/2004 14:43:00
Posts: 1,
Visits: 1
|
|
Hey guys, I had similar problems as outlined in this thread, I didn't have the Network Service account either. I have a Windows 2003 server. To make it work, I went back in to add/remove programs, windows components, and installed asp.net. It is not installed by default. Also, in IIS Manager, ensure that under Web Service Extensions, Active Server Pages are allowed. All is rosy now with mine. Cheers  Symon
|
|
|
|
| Posted 21/07/2004 04:23:57 |
|
|
IF.NET 4.2 Coming Soon
Group: Administrators
Last Login: 19/11/2008 16:29:04
Posts: 1,956,
Visits: 3,018
|
|
|
| |