Re: Questions about SQL on SBS Premium

Thanks Costas and Bass_Player! I appreciate the help and advise.

I'll let the customer know we should be good to go!

"bass_player [SBS-MVP]" <bass_player@xxxxxxxx> wrote in message
news:emv8jOplHHA.1776@xxxxxxxxxxxxxxxxxxxxxxx
Installing a DEFAULT SQL Server instance will not affect anything in SBS
(SharePoint, Monitoring, etc.). Think of an instance as a separate
"server" within the same box. You can start-stop-restart services in this
instance without affecting the other instance. This answers your second
question. Changing the authentication from Windows to Mixed mode will not
affect any other instance. Just make sure you secure this SQL Server
instance, especially the "sa" account by using a complex pass-phrase. If
you have SQL Server Enterprise Manager installed, open the Properties page
of the defautlt SQL Server instance (should be named "local"). On the
Security tab, under the Authentication section, select SQL Server and
Windows. Restart SQL Server service after this for the changes to take
effect. If you don't have SQL Server Enterprise Manager, then you do have
to tweak the registry for this. I have a blog entry on how to do this at
http://bassplayerdoc.spaces.live.com/ (Change MSDE's authentication mode)

Let me know if you need anything else

bass_player
MCP MCDBA MCAD MCSD MCT MCTS MCITP:DBA
"Helping people grow and develop their full potential as God had plan for
them"

"Lesa H." <itsplesa@xxxxxxxxxxxxxx> wrote in message
news:evp%23W6olHHA.5084@xxxxxxxxxxxxxxxxxxxxxxx
I need a little advise from someone who knows a little more about SQL than
I do. I have a client who has SBS 2003 Premium R2 with SQL Server
Workgroup Edition and is considering a line of business application that
utilizes SQL as the back end for the software. There requirements are as
follows:

1. The software needs to be installed in the Default SQL instance.

2. The authentication mode needs to be set to mixed mode (it is currently
set to Windows).

My concerns are will installing anything in the default instance of SQL
break anything in SBS (SharePoint, Monitoring, etc.), and will changing
from Windows authentication to mixed mode break anything?

Finally, how do I go about changing the authentication mode if it's not a
problem?

Thanks in advance!

Lesa H.





.

Relevant Pages

  • Re: Permission problem
    ... SQL Server has two Authentication mode: ... mixed mode (Windows and SQL Server). ... One of my costumers have a program that connects to a servers MSDE ...
    (microsoft.public.sqlserver.msde)
  • Re: User Login Failed
    ... But after I changed it to Mixed Mode, ... up the security tab again, it's back to Windows only. ... > Does SQL Server allow mixed mode? ...
    (microsoft.public.sqlserver.connect)
  • Re: Cannot open database requested in login
    ... Ive just checked that and it is set to mixed mode. ... > you sql server is in windows authentication mode, ... > you should see security tab, change authentication to "SQL ...
    (microsoft.public.sqlserver.security)
  • Re: Regarding setup for SharePoint Services 2.0...
    ... But after installation, all WSS functionality will ... continue to work if you switch back to Mixed Mode. ... like) that get real flaky if you are not running in Windows Only SQL Server ... advantages to Microsoft from a security perspective moving to a Windows Only ...
    (microsoft.public.sharepoint.windowsservices)
  • Answer: Access creates DB in MSDE in SQL Server Authentication mod
    ... I've confirmed that MS Access will create an ADP project in MSDE only if the server is set to Mixed (SQL Server and Windows) authentication mode. ...
    (microsoft.public.sqlserver.msde)