InstantASP Community Forums / InstantForum.NET 4.x / Installation / Upgrades / Community Support / MSDE connection woe / Latest Posts

RE: MSDE connection woe

andyf — Fri, 18 May 2007 09:11:24 GMT

Thank you very much for your suggestion, however, I've resolved this another way, (by changing the connection to use explicit SQL authentication, rather than a trusted connection.)

I can see the forum now on my test page and from my remote connection. :D

BTW there seems to be a small bug in your installer. The "Test page" shortcut placed in the start menu tries to launch:

http://localhost/instantforum414/

But the installer has created the application as InstantForum413 in IIS, so the above should read:

http://localhost/instantforum413/

to make it work :)

Thanks again for your reply though, but I'm more familiar with SQl authentication, so I'll leave it at as it is if it all works :)

Andyf

RE: MSDE connection woe

Ryan Healey — Fri, 18 May 2007 09:01:36 GMT

Hi Andy,

Try adding the NETWORKSERVICE windows account to the InstantForum414 database within MSDE and give this db_owner privledges. If you don't have a GUI available you'll need to use OSQL. You can use the SQL below to associate a user...

USE [InstantForum414]
GO
DECLARE @username SYSNAME
SELECT @username = HOST_NAME() + '\NETWORKSERVICE
USE Master
EXEC sp_grantlogin @username
USE [InstantForum414]
EXEC sp_grantdbaccess @username
EXEC sp_addrolemember N'db_owner', @username
GO

You'll need to save this locally to say AddForumUser.sql then use OSQL to execute this against your database from the command prompt...

osql -E -S (local)\instance_name -i c:\AddForumUser.sql

If you have a GUI such as MSDE admin or the SQL Server Web Data Administrator this could be a little easier.

I hope this helps. Please respond if you continue to have any problems.

MSDE connection woe

andyf — Fri, 18 May 2007 08:23:40 GMT

Hi, I've bought IF and trying to get it going.

The installer has created a DB in my MSDE server

When I try to run the site, I get :

Exception Type: System.Data.SqlClient.SqlException
Exception Message: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
Exception Source: .Net SqlClient Data Provider
Exception Target Site: GetConnection

Looks like the app can't connect to my DB....but I can't see why.

My connection string in web.config is:

server=localhost;trusted_connection=true;database=InstantForum414

I've tried 127.0.0.1, (local), S1523xxx (the server name), but all to no avail.

TCP is enabled for MSDE, on 1433

I just don't know what to try now... any ideas...?

Could I use a hard coded non-trusted connection using SQL authentication?

Is the web.config the ONLY place that the connection is defined?

Thx in advance