Books online says clearly that on the SQLServer agent properties (Connection tab) you should select Windows authentication if you are
running on NT or Windows 2000. It doesnt't say why. My version of Books
doesn't give a recommendation for Windows 2003.
Most of our instances don't seem to care which way it is set. Works
either way. I have one (of several) clustered instance where the agent
won't start if set to SQL Server auth. Failover fails too.
3 questions.
1. Anybody know why the recommendation is for Windows authentication?
2. Anybody got a guess why one cluster cares and others don't?
3. What is the recommendation for Windows 2003?
Upgrade from SQL 2000 Standard to SQL Enterprise Edition ... I see that the books online and several posts say that this is easy. ... I have SQL SP3 installed and it is on a Windows 2003 server.... (microsoft.public.sqlserver.setup)
Re: Requirement to use Management Studio for local instances ... machines with different OS (Windows 2000, Windows 2003, and Windows XP) ... I should add that I mainly tested with SQLCMD,... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...Books Online for SQL Server 2005 at ... (microsoft.public.sqlserver.tools)
Re: Why??? Point me to a reference?? ... > Can you Point me to a reference why... ... If you are on Windows XP, try the Help and Support Center. ...Books Online for SQL Server SP3 at ... (microsoft.public.sqlserver.programming)
Re: General questions about LDAP, GC and access permissions ...Windows Communication Foundation) they are authenticated with the regular ... this is done by examing what groups the user is a member of. ... Since the regular windows authentication is used, ... trusted domain in an external forest.... (microsoft.public.windows.server.active_directory)
Re: Help please to authenticate Windows users ... status error code as well as Win32 error code -- I know the HTTP status code ...Windows Authentication automatically works if the machines are joined to the ... Is VS.Net on the same machine as IIS... (microsoft.public.inetserver.iis.security)
