Client Server Database Connection Testing Using universal data link (.udl) file

Client Server Database Connection Testing Using universal data link (.udl) file
Step 1 : On Sever computer install SQL Server and MSDE (MicroSoft Desktop Engine) and  create a   database.
Step 2 : On client Computer Install only MSDE.
Step 3 : On client Computer Open Notepad and Save as "Test.udl" Universal Data link file format.

To configure a universal data link (.udl) file

1. Double-click the universal data link (.udl) file. The Data Link Properties dialog box opens, displaying the following tabs: Provider, Connection, Advanced, and All. Choose Next to navigate from tab to tab.
2. On the Provider tab, select a database provider. Select "Microsoft OLE DB provider for SQL Server"
3. On the Connection tab, either select SQL Server Name From drop-down list or Enter Manually. Here Choose SQL Sever Name installed on Server. If you have provided Security then Enter User Name And Password. Then It shows available database on Server. Select Database Name created on Server.
4. Click on Test Connection. If Test Connection Successful it means you can access database on Server to that client system. 
5. Choose OK to save the connection string to the Universal Data Link (.udl) file.

Note : IF Test connection fails then Please check following causes.
1) Open services by typing "services.msc" on Sever Computer Run Window.
    Check SQL Server Browser It requires Automatic and Started.
2) Check LAN connection.
IMP : You can get Connection String by Using universal data link (.udl) file to use in programming by Opening "Test.udl" file into Notepad.

Hope this will help you,
Feedback me at
chatrabandg@gmail.com.