A web-based database architecture provides access to a database using a web brow

Question

A web-based database architecture provides access to a database using a web browser as the client. Research database access using web-based technologies. Explore some aspect of this topic. For example, you could discuss how this technology works and what is required, or compare it with customized client software used to access network databases through its own graphical user interface. You might want to examine what information is required to connect to a database over the network. I need some help please

Explanation / Answer

In a Client-Server scenario, you will have the SQL Server installed on your server machine.

Clients will be the computers accessing that SQL Server using a client software (can be SQL Server Management Studio, web/forms application, Excel worksheet, etc).

Each of the client will provide you a way of making a connection to the SQL Server Instance running on the server. From server you will need IP Address or Servername along with SQL Server Instance name. They both combined form host name.

Data Source = ServerNameInstanceName
Note: Instance name not required for default instance.

User name: You need to add user from domain or a sql server authenticated user under security tab (SSMS) on the SQL Server.

Password: Corresponding password.

Note: Once you add a user to SQL Server Instance, do not forget to attach the user to databases you want the user to access and provide appropriate role(s).

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.