Archive for March, 2011

How to create a MS SQL database

Hello ,

You can create a MS SQL database from MS SQL management Studio . Login to MSSQL management studio , right click on Databases, click new database , type the database name and click ok .

Now you will have to create  a database user for the database . Expand the security options , Right click on Logins and  click new login , type the database user name , select SQl server authentication and type the password  , select the default database as the database name which you have created , click ok . Also you have to  give permissions to the user through the User Mapping option .

Regards,

Prashant.J

ARP is Which layer Protocol

ARP that is Address Resolution Protocol is a Layer 2 protocol i.e. a data link layer protocol . It is layer 2 protocol because even though ARP maps IP address to mac address , ARP has a limit or boundaries and it never gets routed , it stays on the Data link layer only .

Regards,
Prashant.J.
Windows System Administrator.

What Services Should be running for Network Sharing

For Network sharing the following services should be running

1) Computer Browser

2) Server

3) Workstation

You can access the files on other computer or a server through , start => run and type \\IP address\D$ , you will be prompted for the other servers login details . You can then login and access the  files on the other computer .

Regards,

Prashant.J

Windows System Administrator.

(adsbygoogle = window.adsbygoogle || []).push({}); //--> Feedjit Flag Counter