Tag Archives: SQL Server

Cannot connect to Microsoft SQL server after installing an IIS SSL Certificate

If you cannot connect to your Microsoft SQL Server after installing a web SSL Certificate, you may need to get the thumbprint of your certificate and copy it (without spaces) to your registry. Go to Hkey_Local_Machine\software\Microsoft\Microsoft SQL Server\{Find your instance … Continue reading

Rate this:

Posted in Technology, Windows Security, Windows Server | Tagged , , | Leave a comment

Slow SQL Connection or Network in Windows 10 – Update

Finally found a small problem with Windows 7, 8, 8.1 and 10.  After upgrading, we have discovered that Windows  was responding slow to our SQL Server 2008 and SQL Server / other versions.  What we discovered is below. Slow response … Continue reading

Rate this:

Posted in Information Technology, Microsoft, Microsoft Windows, Microsoft Windows 10, network, Networking, Technology, troubleshooting, Windows, Windows 10 Quick Tips, Windows Server | Tagged , , , | Leave a comment

Slow SQL Connection or Network in Windows 10 – Update

Finally found a small problem with Windows 7, 8, 8.1 and 10.  After upgrading, we have discovered that Windows  was responding slow to our SQL Server 2008.  What we discovered is below. Slow response times in Windows to a SQL … Continue reading

Rate this:

Posted in Computer Security, Computers, freeware, Information Technology, network, Technology, Windows 10 Quick Tips, Wireless | Tagged , , , , , , , , , , , , , , , | 15 Comments

Installing Microsoft SQL on Server 2012 R2

Resources: Windows Server 2012 R2 Microsoft SQL 2012 Can be obtained from TCAT’s DreamSpark – http://e5.onthehub.com/WebStore/ProductsByMajorVersionList.aspx?ws=5dee02e7-a65d-e111-8056-f04da23e67f6&vsro=8&JSEnabled=1 Note: you can use the trial software on Server and SQL if you do not have a Dreamspark account. Files to use as demos: … Continue reading

Rate this:

Posted in Technology | Tagged , , , , , , , , , | Leave a comment

Learn SQL with these Online Emulators

SQLCourse has been around for sometime.   With Microsoft’s DreamSpark, students can download SQL Server to build databases and to learn how to retrieve data by performing queries  (basically asking the database for specific data).   SQLCourse gives you step by step … Continue reading

Rate this:

Posted in Technology | Tagged , , , , , | Leave a comment

Adjusting network card properties to fix slow network response

If you have slow or non responsive program properties; such as a database or other network program…Right Click on My Computer, go to Properties, select Hardware, Device Manager, click the + sign on Network, Right Click on your network card, … Continue reading

Rate this:

Posted in Computer hardware, Computers, Information Technology, network, Networking, Windows | Tagged , , , , , , , | Leave a comment

SQL Setup Error 50000

If you receive a SQL Setup Error (usually if you install from a file and not the CD/DVD set),  run disk two setup and select the components you wish to install.   This will correct the error 99% of the … Continue reading

Rate this:

Posted in Computers | Tagged , , , , | Leave a comment

Free Microsoft Resources

Want to see how remote access and VPNs work?  Microsoft’s technet has hundreds of demos, virtualizations, books and other materials.  Here’s a lab on vpns – Test Lab Guide: Demonstrate Remote Access VPNs  So what else is available over at TechNet? Books, Magazines, … Continue reading

Rate this:

Posted in Computers, Education, Information Technology | Tagged , , , , , , , , , , , , , , , , , , , | Leave a comment

Slow Network?

Do you have a computer that responds slow on the network or hesitates?  Follow these steps and you will see a significant difference. (Because we have not shown how to disable advanced settings in your network card, simply go to … Continue reading

Rate this:

Posted in Computer Security, Computers, Information Technology, network, Technology, Wireless | Tagged , , , , , , , , , , | Leave a comment

Free SQL Server 2008 Book

Microsoft offers a free SQL Server 2008 Book.   Get it here. Microsoft also offers a free SQL Server 2003 Book.  Get it here.

Rate this:

Posted in Computers | Tagged , , , , | Leave a comment

SQL Server Native Client

You can download SQL Server 2008 Native Client here You can download SQL Server 2005 Native Client from here

Rate this:

Posted in Computers | Tagged , , , , , , | Leave a comment

SQL Connection Strings

When making a connection to a database you can use ODBC to connect to the database (Such as using MS Access to connect to an SQL database).  [ODBC is found under the Control Panel | Administrative Tools] If you are … Continue reading

Rate this:

Posted in Technology | Tagged , , | Leave a comment