Hallo Leute,
würd mich freuen, wenn ihr mir bei der folgenden Frage helfen könntet!
One of the two of your Microsoft Windows 2000 computers is running Internet Information Services (IIS),
and the other is running SQL Server 2000. Employees in your company need to connect over the Internet
and query the SQL Server computer. Some employees have computers that do not use Microsoft operating
systems or Web browsers. You need to configure the IIS and SQL Server 2000 computers to allow access
to data by means of the IIS virtual directory. IIS uses Basic Authentication to allow access to the virtual directory.
Only company employees should have access to the databases through the Internet. Employees
should be allowed to make ad hoc queries, and you want to be able to audit successful and failed logins to
the SQL Server computer. The actions you should take to allow employees access to the SQL Server computer
while keeping your security scheme as simple as possible are:
Antwort:
• Configure the IIS virtual directory to allow URL queries.
• Create a Windows Authenticated login for each employee on the SQL Server computer.
•Configure the IIS virtual directory to use Windows Integrated Authentication when connecting to
the SQL Server computer.
Bin mir bei der ersten Teilantwort nicht sicher! Sollte man vielleicht hier ne "template query" statt "URL queries" erstellen, um auf IIS zuzugreifen, da manche über keinen Web-Browser verfügen?
lg
Murik
