How To Connect to Your MS SQL 2012 Database and Disable Collation

How To Connect to Your MS SQL 2012 Database and Disable Collation

You will need to have Microsoft SQL Server Management Studio 2012 installed to complete these steps. Microsoft SQL Server Management Studio Express is available for free from Microsoft, and can be downloaded through this link: 
  1. Open MS SQL Management Studio.
  2. Connect to the Server with the server name and login credentials 
    1. Your SQL Server's domain name is your website's domain.  You may alternately use the IP address of the server that your website is hosted on.
    2. Your login credentials are located within your web.config in the connection-string area as uid: and pwd:
  3. On the left navigation bar click on Databases.
  4. Press F7, and Object Explorer Details should open on the right side of the window.
  5. Right click on the Name column header
  6. Uncheck Collation
  7. Refresh the Databases by clicking on the blue box with green circular arrows.
You should now be able to expand the list of databases, and expand your database name.

Additional Information
All MS SQL Servers on our network run on the standard MS SQL Server port of 1433.  Sometimes, when trying to connect to your database, you may receive an error like this:

------------------------------ SQL server does not allow remote connections. ------------------------------

If you receive an error stating that SQL server doesn't allow remote connections, your ISP (Qwest, ComCast, Cox, RoadRunner, Verizon, etc) is blocking you from connecting to SQL servers.  In order to resolve that problem, you will need to contact the company providing you with internet access and have them unblock port 1433. 

If you are receiving this error while trying to connect to MS SQL on a dedicated server you may also change the port used by MS SQL by following the instructions in the article located at How To Configure MS SQL Server on your Dedicated Server for an Alternate Port

Add Feedback