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.

Authentication

Hi,
I would like to configure a SOAP Endpoint on SQLServer 2005 as
AUTHENTICATION = (DIGEST) (.. PORTS = (CLEAR) ...), but when I do this, even
the IE can't connect anymore. Has anybody experience with this
authentication-method ?
The intention is to connect a small device, which only speaks TCP/IP to the
SQL Server. Or are ther any other possibilities to to this ?
Thanks,
SoerenHi Sren,
Just a guess, but are you running SQL Server on Windows XP SP2? The version
of IIS on this OS can't share port 80. So, if this is the case, run either
the HTTP Endpoint or IIS on a different ports. In HTTP Endpoint, its just a
parameter in the PORTS keyword.
Cheers,
Bob Beauchemin
http://www.SQLskills.com/blogs/bobb
"Sren Rose" <rose@.inray.de> wrote in message
news:eTvULM5iGHA.1640@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I would like to configure a SOAP Endpoint on SQLServer 2005 as
> AUTHENTICATION = (DIGEST) (.. PORTS = (CLEAR) ...), but when I do this,
> even
> the IE can't connect anymore. Has anybody experience with this
> authentication-method ?
> The intention is to connect a small device, which only speaks TCP/IP to
> the
> SQL Server. Or are ther any other possibilities to to this ?
> Thanks,
> Soeren
>|||Hi Bob,
I'm running Win2003 Server, so thats not the problem, but I figured out what
the problem was: I have to create a domain and use a User from the domain. I
tried it with an local user an this faild. This is documented on the MS
Website too:
"The credentials sent as part of a digest authentication over HTTP must be
mapped to a valid Windows domain account. Local user accounts are not
supported for Windows-based digest authentication. "
Now it works :-)
Thanks,
Soeren
"Bob Beauchemin" <bobb_no_spam@.SQLskills.com> schrieb im Newsbeitrag
news:#JQRkB#iGHA.1204@.TK2MSFTNGP02.phx.gbl...
> Hi Sren,
> Just a guess, but are you running SQL Server on Windows XP SP2? The
version
> of IIS on this OS can't share port 80. So, if this is the case, run either
> the HTTP Endpoint or IIS on a different ports. In HTTP Endpoint, its just
a
> parameter in the PORTS keyword.
> Cheers,
> Bob Beauchemin
> http://www.SQLskills.com/blogs/bobb
>
> "Sren Rose" <rose@.inray.de> wrote in message
> news:eTvULM5iGHA.1640@.TK2MSFTNGP02.phx.gbl...
>sql