Re: ISA 2004 - disable MSDE
From: Cyskon (cyskon_at_msn.com)
Date: 10/29/04
- Next message: Microsoft Newsgroups: "Reports and summaries are empty"
- Previous message: Pilar: "Re: Intrusion-All port scan"
- In reply to: Chad Wickenheiser: "Re: ISA 2004 - disable MSDE"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 29 Oct 2004 08:36:48 -0500
By default, when installing the version of MSDE contained in the MS SQL
server CD, MSDE is set to operate in Windows Authentication mode only. The
same error is reported when using an MS SQL Client using SQL authentication.
To solve this issue you have to run the MDSE setup with a parameter that
configures the instance to use SQL Server Authentication.
1.. Uninstall the desktop engine (if you see an installation of MSDE for
ISA, DO NOT UNINSTALL IT!, just the other MSDE installation).
2.. Reboot the machine
3.. Run the desktop engine setup with the parameter 'SECURITYMODE=SQL'
Go to a command prompt in the directory that has the setup.exe file for
MSDE and type the following : setup SECURITYMODE=SQL
4.. Start the MSSQLServer service manually as it is not started by the
installation of database desktop.
If those steps don't work, try looking at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/dis
tsql_84xl.asp
"Chad Wickenheiser" <chadw01@hotmail.com> wrote in message
news:5aa5f047.0410280926.3bdda627@posting.google.com...
> I tried following the instructions on how to enable ISA logging
> through SQL Server in this article:
>
> http://support.microsoft.com/?id=838253
>
> I got through all the way to the end, and when I saved the changes the
> Firewall service failed to startup.
>
> This message appeared in the event log:
>
> ----------------------------
> The Microsoft Firewall was unable to open ODBC Data Source , Table:
> FirewallLog, under User Name []. The ODBC Error description is:
> [State=28000][Error=18452][Microsoft][ODBC SQL Server Driver][SQL
> Server]Login failed for user '(null)'. Reason: Not associated with a
> trusted SQL Server connection. .
> -----------------------------
>
> The message at the bottom of the KB article states:
>
> "Note After you configure ISA Server logging to a SQL server, if the
> ISA Server computer cannot contact or log on to the SQL server. The
> Firewall service cannot start, and it logs an error message in the
> application event log."
>
> Is it me, or does this note not make any sense at all???
>
> Thanks.
- Next message: Microsoft Newsgroups: "Reports and summaries are empty"
- Previous message: Pilar: "Re: Intrusion-All port scan"
- In reply to: Chad Wickenheiser: "Re: ISA 2004 - disable MSDE"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
