<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/platform.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar.g?targetBlogID\x3d11356004\x26blogName\x3dxception\x26publishMode\x3dPUBLISH_MODE_BLOGSPOT\x26navbarType\x3dBLUE\x26layoutType\x3dCLASSIC\x26searchRoot\x3dhttps://openrent.blogspot.com/search\x26blogLocale\x3den_US\x26v\x3d2\x26homepageUrl\x3dhttp://openrent.blogspot.com/\x26vt\x3d-4655156434419967503', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script>

Testing a SQL database connection

This should ideally be performed on a web server that you feel is not seeing the database server.

1) Open notepad and save a blank file with the name "connection.udl" to your desktop.
2) Right-click on connection.udl to open and run it with the credentials used to access the database.
3) On the Provider tab, choose "Microsoft OLE DB provider for Sql Server" and click Next.
4) On the Connection tab, enter the server name and connection method.
5) Choose a database from the populated list in "Select a database on this server" drop-down list.
6) Click the "Test the connection" button.

posted on September 01, 2009
| Permalink |