• Sales: 1-800-961-2888
  • Support: 1-800-961-4454

Feedback

Let us know what you think of our Knowledge Center!

Open Cloud Community

Learn about Rackspace products, ask questions, and share your knowledge in our Open Cloud Community.

Configuring SSMS to Connect to SQL Server on Windows

  • Article ID: 304
  • Last updated on June 24, 2011
  • Authored by: Rackspace Support
  • (3 Comments)

This Article will tell you how to configure your SQL Server Management Studio to connect with your SQL Server housed on your Windows Cloud Server.


1. Start SQL Server Management Studio by going to Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studi

2. The is the Connect to Server box. You want the Server Type to be Database Engine. The Server name should be the IP address of your Windows Cloud Server. The Authentication should be either SQL Server Authentication (If this is your first time using this tool or you are not using a Domain) or Windows Authentication if you are using it. The Login and Password fields are self explanatory. Once these fields are populated click on connect.

ssmsconnect.PNG

 

3. This will now bring up the SSMS Main window. You are now connected!

ssmsmain.PNG

 

 



© 2011-2013 Rackspace US, Inc.

Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License


See license specifics and DISCLAIMER

3 Comments

If you are still unable to connect, try adding the port number to the end of the IP. I was lucky to get it my first try (port#4120) Hope this helps!
By Mo Nash on Jul. 30, 2012

by using an ip i can connect my sql to the cloud sqlserver but how about if i'm going to use the actual server name of the cloud can i connect through my local SSMS?
By Anonymous on Jul. 30, 2012

If I understand you correctly, you would be able to use a domain name to describe the server it's connecting to, but it wouldn't know the server name in your Cloud Control Panel. Generally the IP address is the safest way to go since that's less likely to change than a domain name.
By jered.heeschen on Jul. 30, 2012

Add new comment