How should you reconfigure the server so that the users can access the application without being prompted for a login and a password?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_Prod. ABC.com is using Microsoft SQL Server
2005 Analysis Services (SSAS) that is accessed by an Internet Information Services application.
You get complaints from users that say they can’t access the information SQL Server 2008. They
are prompted for authentication.
How should you reconfigure the server so that the users can access the application without being
prompted for a login and a password?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_Prod. ABC.com is using Microsoft SQL Server
2005 Analysis Services (SSAS) that is accessed by an Internet Information Services application.
You get complaints from users that say they can’t access the information SQL Server 2008. They
are prompted for authentication.
How should you reconfigure the server so that the users can access the application without being
prompted for a login and a password?

A.
You should consider setting the Security\RequireServerAuthentication server configuration to
False.

B.
You should consider setting the Security\RequireClientAuthentication server configuration to
False.

C.
You should consider setting the Security\RequireClientAuthentication server configuration to
True.

D.
You should consider setting the Security\RequireClientAuthentication server configuration to
the Default Value.

E.
You should consider setting the Security\RequireServerAuthentication server configuration to
Default value.

F.
You should consider setting the Security\RequireServerAuthentication server configuration to
True.

Explanation:

By default, Microsoft SQL Server Analysis Services requires clients to be authenticated by the
Microsoft Windows operating system in order to establish a connection with the service. By

default, Microsoft SQL Server Analysis Services will reject all requests from unauthenticated
clients.
To modify the client authentication requirement, the administrator must change the value of the
Security \ RequireClientAuthentication server configuration property.



Leave a Reply 0

Your email address will not be published. Required fields are marked *