go to ISQsolutions.com | Contact Us

 
Q10241 - FAQ: How do I connect to the MS SQL 2000 Server using SQL Enterprise Manager?


ISQsolutions policy requires us to close port 1433 of MS SQL Server to inbound connections from outside of our network.

To connect to the MS SQL 2000 Server through enterprise manager, please follow these steps:

- Open SQL Server Client Network Utility
- Click 'Alias',
- Click 'Add'
- In Network Library select 'TCP/IP'
- server Alias type the desire name. ( ISQ-SQL )
- server name type the host address of the sql server listed in the hosting manager under databases main tab
- Un-check Dynamically determine port and then type 3434 as port.
- click 'OK', click 'Apply', Click 'OK'.

Now open the SQL Enterprise Manager.

- right click 'SQL Server Group' and select 'New SQL Server registration'
- click 'Next'.
- select the alias server listed and click 'Add'
- select SQL login and complete the wizard.

*be aware that this policy only affect inbound connections from outside of our network, your application web can connect to the sql server through the standard port ( 1433 ).

Related Articles
Q10148 - FAQ: How can I transfer my existent SQL database to my SQL database at ISQsolutions.com servers?
Q10251 - FAQ: What is the URL of MS SQL Web-based administration ?

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
mssql1.isqsolutions.com shoul that be different for each user? where is our unique ID? Approved: 2/12/2006 7:02:00 PM
Created on 8/8/2005 4:25:00 PM.
Last Modified on 6/3/2008 11:57:00 AM.
Last Modified by ISQ Solutions Inc.
Article has been viewed 7377 times.
Rated 7 out of 10 based on 23 votes.
Print Article