Dial-up replication - same domain?

Hi,

When setting up dial-up replication (via RAS, not Internet) is it possible for the 2 servers to be in different domains?

I've seen a lot of comments that suggest that both ends should be in the same domain, but I'm wondering if this is required, or simply suggested for ease of configuration.

Any advice much appreciated.

AndrewAs long as both domains are trusted to each other then no worries.|||Sounds good. Both domains will be Windows 2K, so I should be able to set up what I need.

Thanks for the feedback.|||For instance try to copy file between domains and see the results;|||File copying works a treat.

Now on to the difficult bit ... replication :-)|||It is but be prepared and refer to books online for initial help.|||I've already got replication working across the LAN so I'm comfortable enough with that, (in an amateur kind of way) but I've just made a discovery that might make my life really difficult...

I'm hoping to replicate from one SBS 2K machine to another SBS 2K machine via dial-up. The RAS dial-up connectivity works, but visibility seems to be one way. I can only map drives &c from the machine that initiated the call. From the RAS server, I can't see/map drives on the client that dialled in. If this is not normal/expected behaviour, then I'm guessing that its a trust issue and I started looking at that, only to discover that it seems you can't create inter-domain trusts with SBS. It seems to be a limitation of the SBS version of Windows 2000.

Sooooo....., if my dial-up login credentials aren't enough to give me all I need to get replication happening, I don't know what I'll do.

Fleeing the country comes to mind ... !

I'm going to try replication now and see what happens.

Wish me luck ...|||Our setup replicates between serveral servers of which all but one are *not* on a domain. Took a bit of fiddling with IDs (there are several places you have to set user id's and passwords) but it can be done.|||OK, cool, so I should be able to get it to work then.

Now for the really silly question ...

How do I actually get to see the server over dial-up so I can setup the subscription? When I establish the dial-up link I can't see the server at the other end using Enterprise Mgr so I can't define the Pull subscription. Should I be able to just register it and it should just work?

I know I'm missing something really dumb here!

TIA|||Update: I've got the server registration going over dial-up now, but only by IP address, not by server name.

Then trying to define the Pull subscription generates an error which I'm guessing is because the remote server is registered by IP address & not by name.

DNS setup problem?

Dialup Dead - Slammered again?

HI I am trying to logon to a remote server with Enterprise Manager via
dialup, which worked fine for the last 6 months. I can connect to the
server but Now I am getting the egg timer for ever when expanding the
database node. At the same time my dialup maxes out (around 3 kB / sec)
and seems to load ridiculous amounts of data (by dialup standards x-p).
I have SP4 installed, is this a new version of Slammer or what?
PS: I can connect with Query Analyzer and run queries. My version
number is 8.00.2039 (SP 4).
any idea what to do, did I miss a new patch / virus?
Axelrealraven2000@.hotmail.com wrote:
> any idea what to do, did I miss a new patch / virus?
> Axel
>
Since you can connect with QA, you should be able to run sp_who2 or look
at the sysprocesses table. Attempt your EM connection again, and while
it's spinning, jump into QA and look at sysprocesses to see what's
running. Look for blocking, or some other intensive process that might
be running.

diagrams in sql server 2005

is there a tool to make diagrams in sql server 2005?
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
You should discuss SQL2005 in the appropriate newsgroups for the beta...
That feature is currently not in B2.
(P.S. features in B2 are not considered NDA at this time)
Brian
"alex" <anonymous@.devdex.com> wrote in message
news:%23MziLZQgEHA.236@.tk2msftngp13.phx.gbl...
> is there a tool to make diagrams in sql server 2005?
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

diagrams in sql server 2005

is there a tool to make diagrams in sql server 2005?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!You should discuss SQL2005 in the appropriate newsgroups for the beta...
That feature is currently not in B2.
(P.S. features in B2 are not considered NDA at this time)
--
Brian
"alex" <anonymous@.devdex.com> wrote in message
news:%23MziLZQgEHA.236@.tk2msftngp13.phx.gbl...
> is there a tool to make diagrams in sql server 2005?
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Diagramming Error?

I am using the April CTP.

I created a diagram. Via the diagramming tool, I added a new table. Added some columns. Decided I didn't like it. Deleted the table from the database.

Later I decided I did want the table. So I tried to create it again, but the diagram tool said that the table is make for deletion and couldn't be added. I looked at the table list and it was not there.

What can I do so that I can create another table with the same name?Hi Jim,
I could reproduce your results if I deleted the table before saving the diagram. Essentially the table never gets added to the database, but the diagram tool has the name recorded somewhere and that cache isn't getting cleared. I've filed a bug on your behalf for this incorrect behavior.

As a work around, you should be able to reuse the table name if you close SQL Server Management Studio, reopen SSMS and then modify the diagram.|||Thank you!

Developer Edition having issues connecting to server via TCP/IP

Don't know if there is a simple solution for this one or not. When
running SQL server on a machine with 2000 loaded and the complete SQL
package I don't have any issues. Now I'm trying to login using my XP
machine with MSSQL developer edition, and I can not connect to my
remote servers via TCP/IP. It can see the server, and it establishes a
connection, but I can't access my files, and the connection seems
incredibly slow. I have checked my firewall, and its fine. I'm just
wondering why my 2000 system can access it, but my XP can't. Any
ideas?Chris (chris.wisherd@.kenblanchard.com) writes:
> Don't know if there is a simple solution for this one or not. When
> running SQL server on a machine with 2000 loaded and the complete SQL
> package I don't have any issues. Now I'm trying to login using my XP
> machine with MSSQL developer edition, and I can not connect to my
> remote servers via TCP/IP. It can see the server, and it establishes a
> connection, but I can't access my files, and the connection seems
> incredibly slow. I have checked my firewall, and its fine. I'm just
> wondering why my 2000 system can access it, but my XP can't. Any
> ideas?

I'm confused, can't you connect at all, or is the communication just slow?

On which machine does the SQL Server you are connecting to run? Is the XP
machine in the same domain as the SQL Server machine?

What files are you unable to access? You usually don't use SQL Server
to access files.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland Sommarskog wrote:
> Chris (chris.wisherd@.kenblanchard.com) writes:
> > Don't know if there is a simple solution for this one or not. When
> > running SQL server on a machine with 2000 loaded and the complete SQL
> > package I don't have any issues. Now I'm trying to login using my XP
> > machine with MSSQL developer edition, and I can not connect to my
> > remote servers via TCP/IP. It can see the server, and it establishes a
> > connection, but I can't access my files, and the connection seems
> > incredibly slow. I have checked my firewall, and its fine. I'm just
> > wondering why my 2000 system can access it, but my XP can't. Any
> > ideas?
> I'm confused, can't you connect at all, or is the communication just slow?
> On which machine does the SQL Server you are connecting to run? Is the XP
> machine in the same domain as the SQL Server machine?
> What files are you unable to access? You usually don't use SQL Server
> to access files.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx

I can connect to the server, but it is slow. But I can't access
information such as the databases. It comes up with no items. I also
can't backup any of the data to a local machine. There wasn't any
issue until we loaded the 2003 Developer Edition on our XP machines.
I've loaded both service packs 3 and 4 hoping that would solve the
problem. I've checked TCP/IP setting, and the firewall.

The server I'm trying to access is a remote server running Windows
2000, with service pack 4, and it is in a different domain.|||Chris (chris.wisherd@.kenblanchard.com) writes:
> I can connect to the server, but it is slow. But I can't access
> information such as the databases. It comes up with no items. I also
> can't backup any of the data to a local machine. There wasn't any
> issue until we loaded the 2003 Developer Edition on our XP machines.
> I've loaded both service packs 3 and 4 hoping that would solve the
> problem. I've checked TCP/IP setting, and the firewall.
> The server I'm trying to access is a remote server running Windows
> 2000, with service pack 4, and it is in a different domain.

I realise that I should have asked what you are connecting with and
with which credentials.

From what you say, it sounds as it you connect with Enterprise Manager
with integrated security, but your Windows login has not been added to
BUILTIN\Administrators and on top of all databases are set to autoclose.
When databases are set to autoclose, and you connect as a non-priv user,
EM has to access every database to see if you are permitted, and this
can take forever.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Determining User Role via DMO

I am trying to find a way to check if a user belongs to a program
specific role. Previously we had been using:
// Not Exact but I think it can be followed
hr = m_pDmoSrvr->GetTrueLogin(&login);
LPSQLDMOUSER pUser = 0;
hr = m_pDmoDb->GetUserByName(login, &pUser);
hr = pUser->IsMember(exclRole, &b);
But this does not seem to work if the user is a member of an NT Group
that has been added to the exclRole Role. I may not know what Group was
used to assign the Role.
Is there a way to determine whether the connecting user belongs to a
Role? I tried getting a LPSQLDMOLOGIN and using that but it did not
seem to work.
I'd be grateful for any pointers.
OtisIt looks like your checking to see of a login name, or windows username is a
member of a database role. Logins are not members of database roles; databas
e
users are. You want to test to see if the user that their login maps to is a
member of a database role, not if their login is a member of the role.
"OBQuiet" wrote:

> I am trying to find a way to check if a user belongs to a program
> specific role. Previously we had been using:
> // Not Exact but I think it can be followed
> hr = m_pDmoSrvr->GetTrueLogin(&login);
> LPSQLDMOUSER pUser = 0;
> hr = m_pDmoDb->GetUserByName(login, &pUser);
> hr = pUser->IsMember(exclRole, &b);
> But this does not seem to work if the user is a member of an NT Group
> that has been added to the exclRole Role. I may not know what Group was
> used to assign the Role.
> Is there a way to determine whether the connecting user belongs to a
> Role? I tried getting a LPSQLDMOLOGIN and using that but it did not
> seem to work.
> I'd be grateful for any pointers.
> Otis
>|||"examnotes"
<MarkWilliams@.discussions.microsoft.com> wrote in
news:1F9B3D42-70A4-4474-87A6-7579B2AC8E0D@.microsoft.com:

> It looks like your checking to see of a login name, or windows
> username is a member of a database role. Logins are not members of
> database roles; database users are. You want to test to see if the
> user that their login maps to is a member of a database role, not if
> their login is a member of the role.
>
I believe you are correct but I have not been able to trace through the
options of the SQL-DMO objects to figure out how to manage it.
It seemed like the code I posted was getting the user object. But, at that
level, it seems to only check if the object itself is a member. It does not
check that the object(user) is a member of a group that are all members of
a role. That is what I have to figure out how to do.
Otis