When connecting to a newly installed SQL Server 2005, an error appeared "(provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)", which in layman's term means, the client PC cannot establish a connection to the database server. There could be more that one reason why such error is encountered. One possible reason is a restriction from the Windows firewall where the SQL server was installed. You can fix this by adding the port 1433 on the exceptions (control panel > Firewall Settings > Exceptions > Add Port). Another possible reason why you can't open a connection is a disabled TCP/IP and/or Name Pipes protocols. To check if these protocols are enabled, follow these steps: 1. Go to Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager. 2. From SSCM, click SQL Server 2005 Network Configuration > Protocols for MS SQL Server. 3. Now check if the status of TCP/IP and Name Pipes protocols are enabled. If not, enable it accordingly by right-clicking on it and choose Enable from the context menu.
(Take Note: You can also do the same for SQL Native Clients)
4. Restart the SQL Server Service.
To stay up-to-date on SQL Server Tips, subscribe now.
MS Word is arguably the best word processor for PC's today. But due to its price, many users opt to use alternative software such as OpenOffice and Google Docs. Another better alternative to MS Word is DevVicky Word 2010. I said better because of its familiar interface similar to MS Word which doesn't need extra time to get accustomed to. It is pretty stable word processor that can handle a wide variety of file formats, including Microsoft's proprietary .docx as well as ODF. Aside from support for different file formats, DevVicky Word 2010 also has built-in conversion tool for HTML, PDF and ODT.
Another plus feature of this Word alternative is the support for Mail Merge which Microsoft introduced just recently to Word 2010. DevVicky Word 2010 works only on Windows OS and for this article I tested it on Windows 7.
Remote desktop connection is the most frequently used tool for server administrators who manages several servers and workstations. Although the built-in MMC Remote Desktops snap-in of Windows can suffice the requirement of connecting to a remote PC, using RDCMan gives you more flexibility. RDCMan is a free Windows utility for managing server labs where you need regular access to each machine such as automated checkin systems and data centers. To start managing group of remote machines, you need to create a new group by going to File menu and clicking New button. You will be asked for the path where you want to save the group file, click Save afterwards. To add a server/workstation on the newly created group, just right click the group icon and select "Add server..." from the context menu.
Just fill-up the information such as Server Settings, Logon Credentials, Remote Desktop Settings and etc.
To connect to a server, you can right-click the server from the list and choose "Connect server" from the context menu. You also can connect to all the servers inside a group by right-clicking the group's icon and then selecting "Connect group".
Wanted to hide some confidential files from other people without being suspicious? How about this? Hide your secret files in pictures. Who will ever thought that beyond those pictures files lies your secret files. With the use of JPG FileBinder, you can bind or merge any compressed files with an ordinary JPEG image file, making it look like just an JPEG image file but the truth is it contains all your secret files. When other people browse the files, they will see an ordinary image file. To reveal the secret files, just open it with any compression tool like WinRar, WinZip, 7Zip, etc.
JPG FileBinder is a portable software so there is no need for installation. This tool is ideal for hiding files with a size of a maximum image file. Hiding huge files in to an image would giveaway that something is not right.
Take Note: This tool doesn't encrypt or secure your files. Other users who are aware of the method can also access the files like you.
Although many are aware of the favorites/bookmarks feature of internet browsers, some don't know that the same feature exist on Windows 7's explorer. This feature works like bookmarking which allows you to mark any directory as favorite so that it can be quickly accessed later. Favorites section can be seen on the left side bar of your Windows Explorer. To add any folder in your Favorites, just follow these easy steps. 1. Open the Windows Explorer and locate the folder you want to bookmark. 2. Right click Favorites then select "Add current location to Favorites" option from the context menu (make sure that you are inside the folder that you want to save to favorites)
3. When your done, you will see a newly added folder on your Favorites section.
Now next time you need to locate folder, you'll just have to go to your Favorites. This saves you from the hassle of going through several folder just to locate the desired folder.
GnuPG is commonly used encryption standard for email, xml and other data. It is a free implementation of the OpenPGP standard as defined by RFC4880. GnuPG or also known as GPG allows you to encrypt and sign your data and communication with a versatile key managment system. Since its a public domain version, it can be freely used, modified and distributed under the terms of the GNU General Public License. Recently we worked with a bank that uses GnuPG as their standard encryption. We are using VB.Net as our front-end, after some research we found a very good VB.Net class wrapper that implements GPG. To use the GnuPG encryption, you need to download the following. 1. VB.Net GnuPG Wrapper 2. GnuPG Source
Commands/Options Supported by this GnuPG's Wrapper 1. Initial Key Generation 2. Signing and Encryption 3. Decryption 4. Importing of a Friend's Public Key to Your Public Key Ring 5. Exporting of Your Public Key to a Friend's Public Key Ring
Read the full article that explains the wrapper codes.
To stay up-to-date on Coding Tips & Tricks, subscribe now.
When printing a document, usually we have to open it. Theres nothing wrong with that unless your printing many documents. Opening each document just to print it is a tedious task and also may consume much system resources that can slowdown your computer. If your task is just to print, then you just need PrintConductor to print all documents in batches without opening them. This free tool lets you print large numbers of files, including Adobe PDF, Microsoft Word DOC, Microsoft Excel XLS, Autodesk AutoCAD DWG, Microsoft PowerPoint PPT, etc. The usage is simple, just specify the files and Hit the Run button.
Aside from Batch Printing, you can also use PrintConductor with Universal Document Converter to convert any number of documents to PDF.
PrintConductor works on Windows only. I tested it using Windows 7.
