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.

If you are a developer experiencing “Connect to Server” errors using SQL Server Management Studio on your local machine or development box, consult the checklist below to quickly find, and fix ...

In this example, you use an alias to connect to a Microsoft SQL Server database and select a subset of data from the payroll table. The SAS/ACCESS engine uses OLE DB Services to connect to OLE DB ...