Home
Help
Login
Register
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Search
Advanced Search
VPS forum, VPS hosting forums, VPS discussions, VPS web hosting solutions, issues, providers, virtual web hosting questions, VPS hosting
Databases
MSSQL server
connect MS SQL 2005 database from MS SQL Management studio
Pages: [
1
]
« previous
next »
Topic: connect MS SQL 2005 database from MS SQL Management studio (Read 950 times)
0 Members and 1 Guest are viewing this topic.
connect MS SQL 2005 database from MS SQL Management studio
« on: July 20, 2009, 10:13:34 PM »
Janak
Administrator
Full Member
Posts: 160
In order to connect MS SQL 2005 database from MS SQL Management studio follow below mentioned steps:
1. Start SQL Server Management Studio.
2. Click the 'Register Servers' icon on the toolbar.
3. The Register Servers panel should now be visible at the left hand frame, with a node 'Database Engine'. Right click on the node 'Database Engine' and from the context menu, select New -> Server Registration.
4. The 'New Server Registration' window will be visible:
* Server Type: Database Engine
* Server Name: Enter the Public IP Address of the database server and port number in the format IP address, port number. (For example, 12.14.1.1,1533)
* Authentication type: SQL Server Authentication
* Login: The database username you created in your Database Manager within your Helm Control Panel for the domain.
* Password: The database username password you created in your Database Manager within your Helm Control Panel for the domain.
5. Connect.
Thanks!
Janak
Logged
Windows Hosting
|
Jobs Search Engine
Best WordPress Themes
Web Hosting Directory
Pages: [
1
]
« previous
next »
Jump to:
Please select a destination:
-----------------------------
NEWS, Alert and Entertainment!!!
-----------------------------
=> Introduce yourself
=> Latest NEWS
=> Suggestions
-----------------------------
Virtualization technologies
-----------------------------
=> Windows VPS Servers
===> Virtuozzo & OpenVZ
===> HyperV
=> Linux VPS servers
===> Xen Server
-----------------------------
Cloud Hosting
-----------------------------
=> Cloud Providers
-----------------------------
VPS providers
-----------------------------
=> Review Windows VPS provider
=> Review Linux VPS provider
-----------------------------
System Administration
-----------------------------
=> Site and Server security
=> Server Administration
===> Apache
===> Microsoft IIS
-----------------------------
Website Design and Development
-----------------------------
=> Development
===> ASP.NET
===> PHP
=> WordPress Themes
=> HTML, CSS and Website Design & Programming
-----------------------------
Shared Web Hosting
-----------------------------
=> Windows Shared Hosting
=> Linux Shared Hosting
-----------------------------
Databases
-----------------------------
=> MSSQL server
===> MSSQL 2005
===> MSSQL 2008
=> MySQL
-----------------------------
Search Engines
-----------------------------
=> Google
=> Yahoo
=> Search Engine optimization and Link Exchange
-----------------------------
How to's
-----------------------------
=> WHM/cPanel
=> IIS
===> IIS 6.x
===> IIS 7.x
=> SmarterMail
===> SmarterMail 6.x
===> SmarterMail 7.x
=> Virtuozzo
=> Hyper V
=> VDSmanager