The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.

Return to the list of database connections, and the new SQL server connection displays. Advertisement. Article continues below this ad. More For You. How to Wrap Text in Microsoft Excel 2003.

Do you need to find out where the location of your SQL Server's database is? Here's a quick tip. Written by Arthur Fuller, Contributor. Contributor. March 4, 2004 at 12:45 a.m. PT.