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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
|
|
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 |