Connect to named instance on different domain

I am having trouble connecting to a named instance on a different domain. For example, I am in the domain mydomain.com, the machine is in ops.mydomain.com.

In Query Analyzer I have tried to connect (without success) to:

machinename\instance

machinename

i.p. address

i.p. address\instance

Within the same domain I can successfully connect to

machinename\instance

Any ideas? Also, this machine is part of a cluster...not sure if that matters. I have full permissions to connect to this machine.

ThanksNever mind...the instance was setup to a port different than 1433. We changed it to 1433, rebooted the server, and now I can connect.

One issue though: I can only connect by specifying the i.p. address, i.e.

255.255.255.0\instancename

Using the server name or setting up an alias doesn't seem to work.

Originally posted by banderson
I am having trouble connecting to a named instance on a different domain. For example, I am in the domain mydomain.com, the machine is in ops.mydomain.com.

In Query Analyzer I have tried to connect (without success) to:

machinename\instance

machinename

i.p. address

i.p. address\instance

Within the same domain I can successfully connect to

machinename\instance

Any ideas? Also, this machine is part of a cluster...not sure if that matters. I have full permissions to connect to this machine.

Thanks

Conflict resolution logs

Is conflict resolution data stored somewhere? For example: If you resolve a
conflict and choose not to have the logs mailed to you. Is there a way to go
back and see what record it was that had the conflict?
TIA
Paul Bauer
Paul,
look for a table whose name starts with 'conflict' and ends with the
article's 'tablename'. This table has the same structure as the table on
which it is based and is stored at the Publisher for applications that use
centralized conflict logging, and at the Subscriber for applications that
use decentralized conflict logging. Another conflict table generated during
merge replication setup is MSmerge_delete_conflicts. The table is a log for
deleted conflicts. It contains information for deleted rows that conflicted
with an update and lost the conflict, or because a delete was undone to
achieve data convergence.
You can look at these tables directly or use the conflict viewer.
HTH,
Paul Ibison
|||Paul,
This table contains no data. I believe this is because the conflict has been
resolved. Is there another place where the resolution of the conflict is
stored?
Paul
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OX5LN7OhEHA.244@.TK2MSFTNGP10.phx.gbl...
> Paul,
> look for a table whose name starts with 'conflict' and ends with the
> article's 'tablename'. This table has the same structure as the table on
> which it is based and is stored at the Publisher for applications that use
> centralized conflict logging, and at the Subscriber for applications that
> use decentralized conflict logging. Another conflict table generated
> during
> merge replication setup is MSmerge_delete_conflicts. The table is a log
> for
> deleted conflicts. It contains information for deleted rows that
> conflicted
> with an update and lost the conflict, or because a delete was undone to
> achieve data convergence.
> You can look at these tables directly or use the conflict viewer.
> HTH,
> Paul Ibison
>
|||Paul,
resolved conflicts still go into these tables for the conflict viewer. There
are no other tables apart from if you are doing some custom logging (custom
conflict resolution).
HTH,
Paul Ibison

Confined by table cells .. Col span option?

Under a table with headers, groups, details and footers .. say I want
two sets of details that should not align with the headers. Or for
example, say I have a subreport in a group that I would lke to span the
entire width of the the table.. How do I do this?
Thansk.Have you tried merging the cells?
"jobs" <jobs@.webdos.com> wrote in message
news:1162310445.109140.233360@.m73g2000cwd.googlegroups.com...
> Under a table with headers, groups, details and footers .. say I want
> two sets of details that should not align with the headers. Or for
> example, say I have a subreport in a group that I would lke to span the
> entire width of the the table.. How do I do this?
> Thansk.
>|||Noob here. How do you select more than one cell so the merge option is
enabled? shift right arrow does not seem to work for me and I can't
seem to lasso inside a table.
Sebasti=E1n G=F3mez wrote:
> Have you tried merging the cells?
> "jobs" <jobs@.webdos.com> wrote in message
> news:1162310445.109140.233360@.m73g2000cwd.googlegroups.com...
> >
> > Under a table with headers, groups, details and footers .. say I want
> > two sets of details that should not align with the headers. Or for
> > example, say I have a subreport in a group that I would lke to span the
> > entire width of the the table.. How do I do this?
> >
> > Thansk.
> >|||Select the cells you want to merge, then right click 'Merge Cells'.
"jobs" wrote:
> Noob here. How do you select more than one cell so the merge option is
> enabled? shift right arrow does not seem to work for me and I can't
> seem to lasso inside a table.
> Sebastián Gómez wrote:
> > Have you tried merging the cells?
> >
> > "jobs" <jobs@.webdos.com> wrote in message
> > news:1162310445.109140.233360@.m73g2000cwd.googlegroups.com...
> > >
> > > Under a table with headers, groups, details and footers .. say I want
> > > two sets of details that should not align with the headers. Or for
> > > example, say I have a subreport in a group that I would lke to span the
> > > entire width of the the table.. How do I do this?
> > >
> > > Thansk.
> > >
>