How to Create a System DSN of SQL Server

This is a few steps on how to Create a System DSN of SQL Server

Locate your Control Panel then Click Administrative Tools

Then Click Data Source (OBDC)

 

















Click the System DSN Tab then click ADD button

hen Locate for the SQL Driver named
SQL Server then click Finish

then Create a New Data Source to SQL Server Dialog will prompt
under Name:(give the name of your connection)
Description:(give the name of your connection)
Server: (browse your active server) then press NEXT

at this time we will connect on Windows authentication for


SQL Server authentication you just simply provide for the
Log-In ID and Password of your active SQL Server

Login ID: sa

Password:***********

then mark Check the Change the Default Database to: then
select your Database Name then press Next

then Click FINISH

the OBDC Configuration will prompt the click  
Test Data Source

then OBDC Data Source Test dialog prompt and you got a
TESTS COMPLETED SUCCESSFULLY

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

Tags: Database, SQL Server