|
|
 Posted 15/03/2005 14:56:25 |
|
|
Forum Newbie
Group: Customers
Last Login: 30/03/2005 12:11:00
Posts: 2,
Visits: 1
|
|
OK, I realise I've fallen at the first hurdle, but I've installed MSDE and when I install InstantASP the error I get is...
"SQL Server not found or access denied"
Any help/pointers very much appreciated
|
|
|
|
| Posted 15/03/2005 14:56:58 |
|
|
Support Supremo
Group: Customers
Last Login: 13/11/2008 12:44:07
Posts: 568,
Visits: 2,507
|
|
Dear ubiquitas,
It looks like you are using a trusted sql server connection, which is the
default setting of the connection string. This being the case, the
EMTWEB01\IUSR_EMTWEB01 and 'EMTWEB01\ASPNET' users need to be added to the SQL Server logins, and need to be given access to the InstantForum database.
They will also need to be members of the dbo role in the InstantForum
database.
|
|
|
|
| Posted 16/03/2005 12:26:54 |
|
|
Forum Newbie
Group: Forum Members
Last Login: 15/03/2005 20:48:00
Posts: 1,
Visits: 1
|
|
I had the same issue using MSDE, and I fixed it by changing the InstantForum_DSN key value in the web.config file to use a connection string implementing SQL Authentication instead of Windows Authentication. Here's the exact value I have (sans password): "server=MAIN;uid=sa;pwd=***;database=instantforum34"
|
|
|
|