A Windows XP help forum. PCbanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » PCbanter forum » Microsoft Windows XP » Security and Administration with Windows XP
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

MBSA complains about SQL Server Authentication Mode / Can't Fix BC



 
 
Thread Tools Display Modes
  #1  
Old December 10th 05, 05:09 AM posted to microsoft.public.windowsxp.security_admin
external usenet poster
 
Posts: n/a
Default MBSA complains about SQL Server Authentication Mode / Can't Fix BC

Hi,
I'm a little baffled; perhaps someone here can help. MBSA 2.0 complains as
below.
The problem is the only contents of the SQL Server 2005 folder in Programs
is Configuration Tools. I've tried re-installing SQL Server Express to see
if it would install the proper tools to make the changes as described in the
help but no joy. The problem is with the instance installed by Business
Contact Manager.

This system is Win XP SP2; Outlook 2003 with Business Contact Manager (and
the latest updates); Visual Studio Express Edition 2005 with Visual Web
Developer

Thanks for any help you can offer!

Rob

Issue:
Service Accounts:

Result:
SQL Server and/or MSDE authentication mode is set to SQL Server and/or MSDE
and Windows (Mixed Mode).

How to correct this:

SQL Server Authentication ModeIssue
In Mixed Mode, user name and password information is stored in Microsoft®
SQL Serverâ„¢. Mixed Mode is only intended for use in networks in which the
servers, clients, and network infrastructure are physically protected, and
all users are trusted. It is included in SQL Server 7.0 to provide backward
compatibility with previous releases and to allow interoperability with
products that do not support Windows NT® authentication.

In contrast, Windows NT Authentication Mode uses the typical Windows NT
authentication mechanism, which was built for use in environments where
security is important. All authentication information is housed on the domain
controller rather than SQL Server, and it is protected because the
information is encrypted.

Solution
Change SQL Server on your system that uses Mixed Mode to Windows
Authentication Mode, if possible.

Instructions
To change SQL Server from Mixed Mode to Windows Authentication Mode

Click Start, point to Programs, point to Microsoft SQL Server, and then
click Enterprise Manager.
Double-click Microsoft SQL Servers and SQL Server Group, right-click the
server that you want to secure, and then click Properties.
In the SQL Server Properties dialog box, click the Security tab.
Under Authentication, click Windows only.

Ads
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Fast User Switching in Domain Member mode / Authentication Tic Shurick Security and Administration with Windows XP 1 September 28th 05 12:42 AM
Outlook Express unwanted startup Famine Windows XP Help and Support 6 April 28th 05 04:14 PM
XP very slow [email protected] General XP issues or comments 12 April 5th 05 05:46 AM
Task Manager ARmand General XP issues or comments 12 October 15th 04 08:49 PM
Firewall won't stay enabled jay Security and Administration with Windows XP 30 July 26th 04 01:04 PM






All times are GMT +1. The time now is 02:16 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 PCbanter.
The comments are property of their posters.