MSSQL Server Connection Check with .UDL

Server bağlantı ayarlarını kontrol etmek ve web config vb dosyalarda kullanmak için güzel bir yöntem

1. Create a new blank file and name it test.udl.
2. Double click on it, and a "Data Link Properties" dialog should appear.
3. On "Providers" tab, select "Microsoft OLE DB Provider for SQL Server" or "SQL Native Client"
4. On "Connections" tab, try various settings and use the "Test Connection" button to test them. Click "Ok" when it works.
5. Open the test.udl file in Notepad and copy the line that starts with "Provider=" into your Web.config "ConnectionString" value, BUT delete the little part that says "Provider=SQLNCLI.1;"