Everyone know System Center products are heavily rely on SQL server, we must prepare the SQL server first in order to proceed with the System Center products installation. Sometimes we would like to verify the connectivity between System Center servers and SQL servers, since we are not SQL server expert, how we gonna achieve that by using tools or is there any other primitive way (such as ping, or telnet command in command prompt) to troubleshoot that?
Here, I would like to share with everyone a good tip.
Create a blank text file on your desktop using Notepad, and then rename the text file extension from 'txt' to 'udl'. Double click the udl file, a Data Link Properties windows will prompt out. Here we go! Now we are able to test out the SQL connectivity by using this small interface! Is that cool?
Although this is not a big news, I doubt a lot of developers knew about this, and I got this tip from my best friend Koh Nyap Hong. He is a great developer and thanks for him to share this tip with me. Now, I would like to share this tool with all IT Professionals, this will be a very useful tool for you to troubleshoot some basic SQL errors.
Subscribe to:
Post Comments (Atom)
2 comments:
i duno wat u talk bout. go back minum susu
helped me...nice little idea. I was able to test that the authentication method I was using didn't work.
Post a Comment