Hello,
I have two SQL 2K server, both are running fine with public IP address.
i.e.
Server #1: 100.100.100.101
Server #2: 200.200.200.202
I use SQL Server #1 Client Network Utility to create an Alias i.e. SQL2.
The alias has the ip 200.200.200.202 and port 1433
Then I use SQL Server #1 Enterprise Manager to register SQL2 with SQL Server
authentication. (login name: sa and password)
Then I got the following error message:
"SQL2 - SQL Server does not exist or access denied. Connection(Connect("
Thanks
Try to see if connectivity is possible at all - ie register the IP address
in enterprise manager and see it this works on its own.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||No,
Can not register IP address or Alias.
Thanks
"Paul Ibison" wrote:
> Try to see if connectivity is possible at all - ie register the IP address
> in enterprise manager and see it this works on its own.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||But I can ping each other.
Thanks
"Paul Ibison" wrote:
> Try to see if connectivity is possible at all - ie register the IP address
> in enterprise manager and see it this works on its own.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Check on the server whose IP address is being registered, using the server
network utility, to confirm that port 1433 is being used.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hello,
There is no IP address is being registered.
Yes, the port is 1433
Thanks
"Paul Ibison" wrote:
> Check on the server whose IP address is being registered, using the server
> network utility, to confirm that port 1433 is being used.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
|||My guess is that there is a firewall between the computers which hasn't got
port 1433 open.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hello,
How to check the port 1433 is open or not?
One server is behind Cisco 1720 router with direct IP address.
One server is behind DSL router, I forward port 21, 80, and 1433 to this
server.
I try to use FTP and Web, and I don't have any problem.
Thanks
"Paul Ibison" wrote:
> My guess is that there is a firewall between the computers which hasn't got
> port 1433 open.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
>
|||It seems you have some sort of network problem rather than a replication
issue, as you can ping the server, but using the same IP address and port
1433 fails at the registration level, even before replication is set up.
Sorry - I doubt I can help you directly much more with this. In my case I
have a network guy that checks the firewall logs to ensure that port 1433
traffic passes from one server to the other through the firewall - maybe you
can have the same done.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Which group should I post to ask the question?
Thanks a lot!!!
"Paul Ibison" wrote:
> It seems you have some sort of network problem rather than a replication
> issue, as you can ping the server, but using the same IP address and port
> 1433 fails at the registration level, even before replication is set up.
> Sorry - I doubt I can help you directly much more with this. In my case I
> have a network guy that checks the firewall logs to ensure that port 1433
> traffic passes from one server to the other through the firewall - maybe you
> can have the same done.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
>
>
Showing posts with label internet. Show all posts
Showing posts with label internet. Show all posts
Friday, March 23, 2012
New SQL Server Registration
I have two (Server A & Server B)SQL Servers located in a
different site and they are connected via DSL internet. I
want to add the other server B to server A using New SQL
Server Registration in server A. How should I do it? Both
sides is using Firewall.
Thanks a lot in advance!Hi
You may want to check out:
http://support.microsoft.com/?id=287932
John
"sim" <anonymous@.discussions.microsoft.com> wrote in message
news:008b01c3ac00$c5230550$a001280a@.phx.gbl...
> I have two (Server A & Server B)SQL Servers located in a
> different site and they are connected via DSL internet. I
> want to add the other server B to server A using New SQL
> Server Registration in server A. How should I do it? Both
> sides is using Firewall.
> Thanks a lot in advance!sql
different site and they are connected via DSL internet. I
want to add the other server B to server A using New SQL
Server Registration in server A. How should I do it? Both
sides is using Firewall.
Thanks a lot in advance!Hi
You may want to check out:
http://support.microsoft.com/?id=287932
John
"sim" <anonymous@.discussions.microsoft.com> wrote in message
news:008b01c3ac00$c5230550$a001280a@.phx.gbl...
> I have two (Server A & Server B)SQL Servers located in a
> different site and they are connected via DSL internet. I
> want to add the other server B to server A using New SQL
> Server Registration in server A. How should I do it? Both
> sides is using Firewall.
> Thanks a lot in advance!sql
Saturday, February 25, 2012
New db?
I am going to design a new db that will be accessed thru web pages on my
intranet and the internet. Currently I am using a MS Access db and I have
been told that this is not the best, most efficient "core" for a db. Will
the "Express" edition of MS SQL give me what I am looking for or do I need
to look at the Workgroup Edition? I want to make sure that what ever I use,
it will be robust enough to handle growth.
Hello,
Express edition has a limitation 4 GB database size, So it may not be a good
oprion for you. COnsidering the features available in SQL Server standard
edition
I will recommend you for standard edition over workgroup edition. Take a
look into the below URL:-
http://www.sqlservercentral.com/columnists/bknight/comparisonofsqlserver2005editions.asp
Thanks
Hari
"Jeff Klein" <jklein@.nospam> wrote in message
news:%232IHD9jRHHA.3592@.TK2MSFTNGP06.phx.gbl...
>I am going to design a new db that will be accessed thru web pages on my
>intranet and the internet. Currently I am using a MS Access db and I have
>been told that this is not the best, most efficient "core" for a db. Will
>the "Express" edition of MS SQL give me what I am looking for or do I need
>to look at the Workgroup Edition? I want to make sure that what ever I
>use, it will be robust enough to handle growth.
>
|||Since you're coming from Access/JET, SQL Server Express would be the best
first step. Yes, it has a 4GB database limit but unless you're storing BLOBs
in the database, this would be more than enough for a seriously large
database. Yes, there are features in the Workgroup and Standard that might
prove useful (eventually), but (again), given that you're coming from JET, I
don't expect you'll need them.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Jeff Klein" <jklein@.nospam> wrote in message
news:%232IHD9jRHHA.3592@.TK2MSFTNGP06.phx.gbl...
>I am going to design a new db that will be accessed thru web pages on my
>intranet and the internet. Currently I am using a MS Access db and I have
>been told that this is not the best, most efficient "core" for a db. Will
>the "Express" edition of MS SQL give me what I am looking for or do I need
>to look at the Workgroup Edition? I want to make sure that what ever I
>use, it will be robust enough to handle growth.
>
intranet and the internet. Currently I am using a MS Access db and I have
been told that this is not the best, most efficient "core" for a db. Will
the "Express" edition of MS SQL give me what I am looking for or do I need
to look at the Workgroup Edition? I want to make sure that what ever I use,
it will be robust enough to handle growth.
Hello,
Express edition has a limitation 4 GB database size, So it may not be a good
oprion for you. COnsidering the features available in SQL Server standard
edition
I will recommend you for standard edition over workgroup edition. Take a
look into the below URL:-
http://www.sqlservercentral.com/columnists/bknight/comparisonofsqlserver2005editions.asp
Thanks
Hari
"Jeff Klein" <jklein@.nospam> wrote in message
news:%232IHD9jRHHA.3592@.TK2MSFTNGP06.phx.gbl...
>I am going to design a new db that will be accessed thru web pages on my
>intranet and the internet. Currently I am using a MS Access db and I have
>been told that this is not the best, most efficient "core" for a db. Will
>the "Express" edition of MS SQL give me what I am looking for or do I need
>to look at the Workgroup Edition? I want to make sure that what ever I
>use, it will be robust enough to handle growth.
>
|||Since you're coming from Access/JET, SQL Server Express would be the best
first step. Yes, it has a 4GB database limit but unless you're storing BLOBs
in the database, this would be more than enough for a seriously large
database. Yes, there are features in the Workgroup and Standard that might
prove useful (eventually), but (again), given that you're coming from JET, I
don't expect you'll need them.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Jeff Klein" <jklein@.nospam> wrote in message
news:%232IHD9jRHHA.3592@.TK2MSFTNGP06.phx.gbl...
>I am going to design a new db that will be accessed thru web pages on my
>intranet and the internet. Currently I am using a MS Access db and I have
>been told that this is not the best, most efficient "core" for a db. Will
>the "Express" edition of MS SQL give me what I am looking for or do I need
>to look at the Workgroup Edition? I want to make sure that what ever I
>use, it will be robust enough to handle growth.
>
Subscribe to:
Posts (Atom)