Diap-up Connection Problem

Hi,
I want to replicate data between two SQL Servers but I have connection
problem:
Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
Server A dials to server B. Server A can ping server B (using IP) and I
registered the SQL Server of B on A (in E.M). But server B cannot ping
Server A. I have disabled any kind of anti-virus or ISA service. All of
ports are open, no active firewall. What are the other things that I must
check?
Any help would be greatly appreciated.
LeilaRun tracert to determine exactly where it is failing. It could also be a
name resolution problem. ping -a should help you with this.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:e1YmastyGHA.5048@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I want to replicate data between two SQL Servers but I have connection
> problem:
> Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
> Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
> Server A dials to server B. Server A can ping server B (using IP) and I
> registered the SQL Server of B on A (in E.M). But server B cannot ping
> Server A. I have disabled any kind of anti-virus or ISA service. All of
> ports are open, no active firewall. What are the other things that I must
> check?
> Any help would be greatly appreciated.
> Leila
>

Diap-up Connection Problem

Hi,
I want to replicate data between two SQL Servers but I have connection
problem:
Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
Server A dials to server B. Server A can ping server B (using IP) and I
registered the SQL Server of B on A (in E.M). But server B cannot ping
Server A. I have disabled any kind of anti-virus or ISA service. All of
ports are open, no active firewall. What are the other things that I must
check?
Any help would be greatly appreciated.
LeilaRun tracert to determine exactly where it is failing. It could also be a
name resolution problem. ping -a should help you with this.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:e1YmastyGHA.5048@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I want to replicate data between two SQL Servers but I have connection
> problem:
> Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
> Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
> Server A dials to server B. Server A can ping server B (using IP) and I
> registered the SQL Server of B on A (in E.M). But server B cannot ping
> Server A. I have disabled any kind of anti-virus or ISA service. All of
> ports are open, no active firewall. What are the other things that I must
> check?
> Any help would be greatly appreciated.
> Leila
>

Development DB to Production DB

We have a development SQL server and a production SQL server. Is there
anyway to replicate what we create on the Dev box over to production box
when we are finished our testing?
Thanks.
TomHi,
DId you meant to replicate database in development to Production, if that
is the case you can go for any of the below options,
1. Detach the database in development and attach it in production
2. Backup the development database and Restore in production
Thanks
Hari
MCDBA
"Tom Pennington" <NONEt2pennington@.comcast.net> wrote in message
news:OKUPhQdDEHA.2768@.tk2msftngp13.phx.gbl...
> We have a development SQL server and a production SQL server. Is there
> anyway to replicate what we create on the Dev box over to production box
> when we are finished our testing?
> Thanks.
> Tom
>|||Backup and restore, detach/attach/Alter scripts, update/insert queries...
Depending on exactly what you want to Move (anywhere from entire database
with data to one stored procedure) there a number of ways to accomplish
this.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Tom Pennington" <NONEt2pennington@.comcast.net> wrote in message
news:OKUPhQdDEHA.2768@.tk2msftngp13.phx.gbl...
> We have a development SQL server and a production SQL server. Is there
> anyway to replicate what we create on the Dev box over to production box
> when we are finished our testing?
> Thanks.
> Tom
>|||We use ErWin To make changes to Dev.
Then we Point ErWin to QA, Etc and have it generate "Diff Scripts" for us.
The scripts are included with our Roll to Production plan.
Just another way to do the same thing
ErWin is Not "CHEAP" but I think it is a very powerful, valuable tool.
It's primary competitor is ER-Studio which I think is a little better.
Cheers
Greg Jackson
PDX, Oregon