Home Classroom C# .NET C# .NET Part 10

C# .NET Part 10

905

During the past few articles we discussed the various aspects which involves in C#.NET.  We discussed some of the most important things we have to in programming with C#.NET. Having a good understanding about these programming idioms is very important. Apart from that there is another very important aspect in programming. That is to work with databases.  Applications connected to a database are very common in programming. When it comes to C#.NET there are lots of DataBase Management Systems that could be used. SQL Server, MySql, Oracle… etc.

In this article we would concentrate on one of those DBMSs. It is the most commonly used DBMS with C#.Net. So I thought of sharing some information with you with related to setting up SQL server and using it. This article covers the aspects of installing it. In the following articles we would discuss more on how to program with C#.NET and SQL Server.

SQL Server 2005

First get the SQL server 2005 setup, at present SQL server 2008 is also available. But here we use the 2005 version for the process of installing the product.

  • This is the initial screen of the installation process.

  • Accept the term and agreement and then you would be directed to this page.

  • Then insert the product key, for SQL server 2005.

  • After selecting the necessary components, select ‘default instance’ from the next window.

  • in the next select Local System from “Use the built-In System account”

  • Then in the next window select ‘Mixed Mode’. And enter a ‘System Administrator’ password. This would be the main user of the SQL server and would be used to log into the database system.

  • Then in the next window select ‘Mixed Mode’. And enter a ‘System Administrator’ password. This would be the main user of the SQL server and would be used to log into the database system.

  • After the installation process there would be a link called ‘Microsoft SQL Server 2005’ and ‘SQL Server Management Studio’ would be the main interface of the SQL server.
  • If the server is installed in your local machine, the machine name would be the server name.
  • ‘sa’ would be the login name and enter the ‘sa’ password.

 

In the next article would we would surf around the SQL server and would start connecting a SQL server database with C#.NET.

Comments

comments

Lakpriya Kottahachchi is an Undergraduate at the Faculty of Information Technology, University of Moratuwa. He enjoys programming with Java and C#.

NO COMMENTS

Leave a Reply