Cluster Node Communications

I just rebuilt a 2 node W2k/SQL2k cluster that resides in
a NT4 domain. The cluster itself seems to be working
fine, the website that runs off of the virtual SQL server
is running fine.
However, both nodes in the cluster are not able to
communicate with other machines in my 2 other
trusted/trusting domains. My other 2 domains are W2k
based domains. Prior to the rebuild there were no
communication problems accross domains.
If I try to browse to the nodes in Windows Explorer I get
the message "No logon servers currently available to
service your request" and if I try to logon to one of the
nodes at the console using my user name and domain, it
says the domain is unavailable.
Any assistance would be greatly appreciated.
Patrick G.
You can check a few things.
1. Make sure your domain trust(s) are still in place and functioning correctly. If you don't have the W2K support tools installed (ie in a prod environment), run dsa.msc and check that you can browse the remote domain and list groups and users in the rem
ote domain (eg attempt to add a global group from the remote domain to a local domain group - you can do this with committing the change).
2. Make sure the account you are using has a valid SQL Server login on the remote SQL Server (or your account is in the builtin admins group on the remote server - if the other domain are willing to trust you with local admins on the remote server or the
remote domain).
Are both domains in W2K native or do you have W2K and W2K3 forests in the mix?

Client side SQL manager tool?

I host my website with a 3rd party and need something to manage my SQL
database. Can someone please recommend a good client side tool for XP?
Thanks.MS has a free web-based SQL admin tool you might take a look at...
Duh! Now that I think about it, you can still use SQL Enterprise Manager ,
just register and connect to the IP and port number...
Also ask your hosting company, many provide tools for you.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob Smith" <noemail@.please.com> wrote in message
news:lDHjd.39122$Om6.2911@.bignews5.bellsouth.net...
> I host my website with a 3rd party and need something to manage my SQL
> database. Can someone please recommend a good client side tool for XP?
> Thanks.
>|||Hi Bob,
Thanks MVP Wayne for his perfect suggestions and here is some links for
your reference
Download: SQL Server Web Data Administrator
http://www.microsoft.com/downloads/...A798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:
- Create and edit databases in SQL Server 2000 or Microsoft SQL Server
2000 Desktop Engine (MSDE 2000)
- Perform ad-hoc queries against databases and save them to your file
system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Bob,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Client side SQL manager tool?

I host my website with a 3rd party and need something to manage my SQL
database. Can someone please recommend a good client side tool for XP?
Thanks.
MS has a free web-based SQL admin tool you might take a look at...
Duh! Now that I think about it, you can still use SQL Enterprise Manager ,
just register and connect to the IP and port number...
Also ask your hosting company, many provide tools for you.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob Smith" <noemail@.please.com> wrote in message
news:lDHjd.39122$Om6.2911@.bignews5.bellsouth.net.. .
> I host my website with a 3rd party and need something to manage my SQL
> database. Can someone please recommend a good client side tool for XP?
> Thanks.
>
|||Hi Bob,
Thanks MVP Wayne for his perfect suggestions and here is some links for
your reference
Download: SQL Server Web Data Administrator
http://www.microsoft.com/downloads/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:
- Create and edit databases in SQL Server 2000 or Microsoft SQL Server
2000 Desktop Engine (MSDE 2000)
- Perform ad-hoc queries against databases and save them to your file
system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi Bob,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Client side SQL manager tool?

I host my website with a 3rd party and need something to manage my SQL
database. Can someone please recommend a good client side tool for XP?
Thanks.MS has a free web-based SQL admin tool you might take a look at...
Duh! Now that I think about it, you can still use SQL Enterprise Manager ,
just register and connect to the IP and port number...
Also ask your hosting company, many provide tools for you.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob Smith" <noemail@.please.com> wrote in message
news:lDHjd.39122$Om6.2911@.bignews5.bellsouth.net...
> I host my website with a 3rd party and need something to manage my SQL
> database. Can someone please recommend a good client side tool for XP?
> Thanks.
>|||Hi Bob,
Thanks MVP Wayne for his perfect suggestions and here is some links for
your reference:)
Download: SQL Server Web Data Administrator
http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:
- Create and edit databases in SQL Server 2000 or Microsoft SQL Server
2000 Desktop Engine (MSDE 2000)
- Perform ad-hoc queries against databases and save them to your file
system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Bob,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!