Authentication Modes

I am trying to install and configure Office Server Extensions on our web server, but when I configure them and put the information about the discussion server and press next it bombs on me. I already created the database and gave it a user name and password. I tried to look up the error message and found only one that seemed like it was close. Our SQL server is set up with SQL Server and Windows authentication mode. The fix for the error I found says that I thought edit SQL Server Registration properties and change under Connection from Windows Authentication to Use SQL Server authentication. I want to try this and see if this fix works to configure the OSEs correctly. My question is can I change SQL server to Use SQL server authentication without any problems with the other databases or will someone logging into the server be blocked from access the database they need? ThanksAccording to the info you provided, your server is already configured to handle SQL Server Authentication. There is no conflct in haveing both athentication modes active at the same time.

Authenication Mode

I've been reading on the authentication modes - Windows and mixed (sql
server). I'd like some comments on the pros and cons of each and which
most people use.
As I understand it with Windows your windows login is used to get you into
the SQL server. What happens after that - do you still need to assign
users to the database?
Thanks.
--
Brett I. Holcomb
brettholcomb@.R777bellsouth.net
Remove R777 to emailHi,
Yes. Login will just allows you to authenticate to SQL Server. After that
you will have associate the login with a database user and
assign permission for that database user to access each of the required
databases.
Thanks
Hari
SQL Server MVP
"Brett I. Holcomb" <brettholcomb@.bellsouth.net> wrote in message
news:%23yDEYNu1GHA.1256@.TK2MSFTNGP02.phx.gbl...
> I've been reading on the authentication modes - Windows and mixed (sql
> server). I'd like some comments on the pros and cons of each and which
> most people use.
> As I understand it with Windows your windows login is used to get you into
> the SQL server. What happens after that - do you still need to assign
> users to the database?
> Thanks.
> --
> Brett I. Holcomb
> brettholcomb@.R777bellsouth.net
> Remove R777 to email|||Brett I.Holcomb
http://vyaskn.tripod.com/sql_server_security_best_practices.htm --security
best practices
"Brett I. Holcomb" <brettholcomb@.bellsouth.net> wrote in message
news:%23yDEYNu1GHA.1256@.TK2MSFTNGP02.phx.gbl...
> I've been reading on the authentication modes - Windows and mixed (sql
> server). I'd like some comments on the pros and cons of each and which
> most people use.
> As I understand it with Windows your windows login is used to get you into
> the SQL server. What happens after that - do you still need to assign
> users to the database?
> Thanks.
> --
> Brett I. Holcomb
> brettholcomb@.R777bellsouth.net
> Remove R777 to email

Authenication Mode

I've been reading on the authentication modes - Windows and mixed (sql
server). I'd like some comments on the pros and cons of each and which
most people use.
As I understand it with Windows your windows login is used to get you into
the SQL server. What happens after that - do you still need to assign
users to the database?
Thanks.
Brett I. Holcomb
brettholcomb@.R777bellsouth.net
Remove R777 to emailHi,
Yes. Login will just allows you to authenticate to SQL Server. After that
you will have associate the login with a database user and
assign permission for that database user to access each of the required
databases.
Thanks
Hari
SQL Server MVP
"Brett I. Holcomb" <brettholcomb@.bellsouth.net> wrote in message
news:%23yDEYNu1GHA.1256@.TK2MSFTNGP02.phx.gbl...
> I've been reading on the authentication modes - Windows and mixed (sql
> server). I'd like some comments on the pros and cons of each and which
> most people use.
> As I understand it with Windows your windows login is used to get you into
> the SQL server. What happens after that - do you still need to assign
> users to the database?
> Thanks.
> --
> Brett I. Holcomb
> brettholcomb@.R777bellsouth.net
> Remove R777 to email|||Brett I.Holcomb
http://vyaskn.tripod.com/sql_server...t_practices.htm --sec
urity
best practices
"Brett I. Holcomb" <brettholcomb@.bellsouth.net> wrote in message
news:%23yDEYNu1GHA.1256@.TK2MSFTNGP02.phx.gbl...
> I've been reading on the authentication modes - Windows and mixed (sql
> server). I'd like some comments on the pros and cons of each and which
> most people use.
> As I understand it with Windows your windows login is used to get you into
> the SQL server. What happens after that - do you still need to assign
> users to the database?
> Thanks.
> --
> Brett I. Holcomb
> brettholcomb@.R777bellsouth.net
> Remove R777 to email