SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Classes
About Us
Login / Register
Subscribe RSS Feed 

Idera Virtual Database

Using a UDL File for Database Connectivity Testing

UDL (universal data link) files are a fast and easy way to test that you can connect to a server from a workstation, and without having to install an application or SQL Server Management Studio. It's also a good way to quickly test that specified credentials will connect to a server, and to build a connection string, something most of us don't do every day. Whether you're a developer or a DBA, it's a technique you'll find useful more often than you might think.

Duration:
3 mins 58 secs
Skill Level:
100
Rating:
4.58 out of 5
Publish Date:
January 25, 2010
Using a UDL File for Database Connectivity Testing Watch Video Now  Watch it later!
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Andy Warren
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

References

There are no downloads or recommended reading links for this video

Comments
Mike Salo on 1/25/2010
Good tip. This will be very helpful for me. Thanks.

pete on 1/25/2010
This was new to me and something that I can see an immediate use for. Thanks Andy, another great video!!

Brent Templeton on 1/25/2010
very useful tip

Gnana Sambantham on 1/25/2010
Simple.. Yet not commonly known.

John on 1/25/2010
So, so cool. Very helpful!

Chris Williams on 1/25/2010
Good vid. Been using UDLs for a long time.

K on 1/25/2010
Thanks Andy

Dave Yoder on 1/25/2010
This was GREAT. A nice simple tool that I was unaware of. Thanks.

Mounib on 1/25/2010
very slick! Thumbs up!

michael murphy on 1/25/2010
Loved it, thanks!

Munna Bhai on 1/25/2010
This is extremely helpful. Thanks once again for sharing this.

skaykov on 1/25/2010
useful tip

Vladimir Sotirov on 1/25/2010
You will find if the connection is ok when you try to select database. Also you need the SQL Native Client installed on the machine.

Vishwas on 1/26/2010
Awesome

Michelle Poolet on 1/26/2010
Learned something new today, thank you!

luther smith on 1/26/2010
Excellent presenter, good information

nilanaksha on 1/26/2010
Good to learn this..

AEE49878AC on 1/27/2010
Excellent, I had forgotten all about this.

Deepak on 1/29/2010
Good one.

salvio on 1/29/2010
Thanks a Lot.... Everyday I checking my E-MAil for your new Videos.. Keep on posting

kaushal yadav on 2/1/2010
provide uses of UDL

William Ringland on 2/2/2010
Great info. A real time saver.

achied on 2/5/2010
Never thought of it. it's an easy way to get the connection string.

achied on 2/5/2010
Never thought of it. it's an easy way to get the connection string.

Jim Butters on 2/6/2010
I have used this technique for years. It surely takes the connection and authentication out of the list of possible causes when there is a problem. I had not used it to create a connection string. Makes sense.

manu jaidka on 2/8/2010
Quiet useful.

Rob Wingate on 2/18/2010
Awesome tip! Thanks Andy

Sandip on 2/18/2010
Great share.

Denise Yu on 3/4/2010
I didn't see how it will conntact to Sql? or when actual connects to Sql's screen? in other word, how that user can logon without Sql client to install to the locaiton PC. Thank you,

James Lawrence on 3/11/2010
This will come in handy!

Cordelia on 5/6/2010
I would have rated it a 5 after I've successfully verified the usage. Great tip! Thanks Andy.

James Lawrence on 7/9/2010
Very handy thing to know!

Denise Yu on 8/11/2010
Thank you so much for this webcast....

Steve Culshaw on 8/25/2010
The multiple zoom in/out on the notepad display was a bit distracting



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions