| Author |
 Topic  |
|
|
knowbetter
Starting Member
33 Posts |
 Posted - 19 July 2002 : 11:32:45
|
I am switching hosting providers (finally got tired of having to wait 24 hours for someone from Interland to give me a non-answer).
All of my site data is in Access, but my Snitz forums are in SQL Server 7. I need some way to get the data out of the Interland SQL Server and into my new SQL Server (SQL Server 2000).
A few notes: I can't seem to get Enterprise Manager to connect - it always returns "Connection Failed". I have the SQL Server 2000 version of EM and its default protocol is TCP/IP. I do have an online ability to execute queries.
BTW, my forum URL is http://knowbetter.com/forum/
Thanks for your help.
--Kelly
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 19 July 2002 : 11:38:06
|
if it is failing to connect, ask yor host to check that they have set the correct default database for your user, this is normally what causes login failures.
|
 |
|
|
knowbetter
Starting Member
33 Posts |
Posted - 19 July 2002 : 11:41:25
|
Thanks HuwR. I'll check it out. Hopefully it will be something simple like that.....
--Kelly
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 19 July 2002 : 12:11:46
|
also ask what ver/servie pack they are running, this can also make a difference
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 19 July 2002 : 20:25:36
|
You can not connect to SQL2000 using the SQL7 version of Enterprise Manager, is it possible thats the cause?
If not then also try increasing the logon timeout value in Enterprise Manager options as it may just be a slow connection causing the difficulties.
www.daoc-halo.com |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 19 July 2002 : 20:35:07
|
You may need to set up an alias to your remote SQL server using the Client Network Utility on your computer.
Perhaps your host uses a non-default TCP port.
======
Doug G
====== |
|
|
|
jsrobinson
Starting Member
USA
3 Posts |
Posted - 20 July 2002 : 02:21:49
|
I would say good luck getting Interland to expose their SQL server administrative interfaces. Ask for the DBF files, or a backup file. They will probably try to charge you for this 'service' but you need to stay tough and press the issue that the data belongs to you, and the fact that they 'have to go through extra steps' to give this data to you is not your problem. The process of extracting the backup from the database, zipping it up, and posting to your ftp users directory takes about 10 minutes of user time.
This is coming from a former customer (and now co-locating my own servers and administrating SQL databases). Good luck, and don't give a second thought to escalating this issue up to Interland management.
|
|
|
|
knowbetter
Starting Member
33 Posts |
Posted - 24 July 2002 : 10:30:36
|
Well, it took a few days to get an adequate response from Interland, but here's the current state of things.
I'm running Enterprise Manager (2000) behind ISA Server running on Win2K Small Business Server. They said I needed to open up port 1433. In looking through MS docs and newsgroup postings, it seems that other people have had the same problem (and they all seem to get conflicting answers). From what I can gather, I need to open up port 1433 for TCP and 1434 for UDP.....
I think I've done that (although I'm a programmer and not a network guy). However, it's still not working.
Other info: we're connected via DSL and a Cisco Router.
Does this help anyone in diagnosing the problem?
FYI: I'm using Enterprise Manager for SQL Server 2000 and I'm trying to connect to a SQL 7 DB at Interland.
Thanks for your help and input.
--Kelly
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 July 2002 : 10:49:37
|
Are you running a firewall? Which one? Why don't you temporarily add Interland's server to your trusted zone (or whatever your firewall calls it) so that you can connect to it and receive connections from it without a problem.
Anyway I find that a bit weird. I've connected to many SQL Server server's with my EM and I never needed to open my firewall to the other machines. Of course, my firewall is configured to allow EM to connect to the Internet and that's all that I need (I use ZoneAlarm).
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
knowbetter
Starting Member
33 Posts |
Posted - 24 July 2002 : 12:25:50
|
My firewall is ISA Server, which comes with Small Business Server 2000. Again, I'm not a network guy, so here's what you can specify for ISA Server:
ISA Server has Access Policies which can be 1 one of 3 types of rules:
1) Site and Content Rules
2) Protocol Rules
3) IP Packet Filtering
I tried setting this up using IP Packet Filters - one for TCP and one for UDP.
For each IP Packet Fileter you can specify:
1) IP Protocol
2) Direction (Inbound, Outbound, Both)
3) Local Port (All Ports, Fixed Port, Dynamic)
4) Local Port # (if a fixed port)
5) Remote Port (All Ports, Fixed Port)
6) Remote Port # (if a fixed port)
Additionally, on the "Local Computer" Tab you can choose to apply the filter to:
1) "Default IP Address(es) on the external interfaces" OR
2) "This ISA Server's external IP Address" OR
3) "This computer (on the perimeter network)" - specify an IP... OR
4) "These computers (on the perimeter network)" - specify subnet and mask.
On the "Remote Computer" Tab you can apply the filter to:
1) All Remote Computers OR
2) This Remote Computer (specify IP) OR
3) These Remote Computers (specify subnet and mask)
Here's an MS article I used as reference:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_1zuc.asp
Any ideas?
Thanks,
Kelly
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 July 2002 : 13:56:04
|
Well I don't know ISA Server. Maybe someone else who does know it, can help you with it, sorry.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 24 July 2002 : 15:46:34
|
To set up an allow rule for TCP port 1433 in ISA, open the ISA MMC snapin, then open the Access Policy node. Make a new IP Packet Filter for port 1433 if there isn't one there already.
On one of my servers, the filter is for TCP, port 1433, both directions, local fixed port 1433, any remote port.
======
Doug G
======
Edited by - Doug G on 24 July 2002 15:48:11 |
|
|
| |
Topic |
|
Topic Locked
