logo
Hosting
Solutions
Resources
Data Center
Affiliate
Contact Us
VPS HostingVPS HostingResources isolated, For websites and applicationsDedicated HostingDedicated HostingDedicated resources, Optimal performance, Bare metalGPU ServerGPU ServerUsed in deep learning, Android emulator, Gaming, etcCloud hostingCloud hostingWebsite data is distributed in the cloudWeb HostingWeb HostingStore and maintain files. Put website onlineDomain RegistrationDomain RegistrationChoose from .com, .name, .net, .org, .biz, .us and .infoSSL CertificateSSL CertificateSecure transmitted data over the internet
RDP ServerRDP ServerRemote Desktop Connection on WindowsVPN ServerVPN ServerSecure connection, protect your network trafficHA DatabaseHA DatabaseIncrease the service availability and data safetyNetwork Load BalancingNetwork Load BalancingDistributed algorithm to balance network trafficForex VPSForex VPSRun multiple trading terminals and platformsDatabase HostingDatabase HostingSQL, NoSQL, and NewSQL database server hostingKubernetes HostingKubernetes HostingFully Managed Kubernetes Clusters
BlogBlogLearn everything about server industryKnowledgeBaseKnowledgeBaseKnowledge Base articles on server operationsFAQsFAQsSummary of frequently asked questions
Live ChatLive ChatStart an instant online chat with our support teamTicketTicketSubmit us tickets for technical assistanceEmailEmailSend us emails for technical assistanceMessageMessageSend your message to us online
Hosting
Solutions
Resources
Data Center
Affiliate
Contact Us

How do I Connect to a Database using SQL Server Management Studio?

Start SQL Server Management Studio. Please refer to Microsoft if you need a copy of SQL Server Management Studio, The current version, SQL Server Management Studio 2012, is compatible with MS SQL 2005, 2008, and 2012. Fill in the database connection information:

• Server Name: the name or IP of the database server. Type PORT after the IP or name to specify a different port (e.g. “,2433″).

• Authentication: SQL Server Authentication is listed by default.

• Login: Your username you have set up for the database.

• Password: Your password you have set up for the user.

Connect to SQL Server

To connect to a specific database only, click on the Options button. Click on the Connection Properties tab. Type in the name of the database. Please note it is required that you specify the database for most MS SQL 2012 connections. Click Connect. If you need any assistance with this process, or encounter any issues, please don’t hesitate to contact our Technical Support Department.