I am using SQL Server tools (Enterprise Manager and Query Analyser) that are
installed on my local PC to work on databases that are on another server. The
other server is not on this network -- I access it via the internet. At the
moment I acess it using it's IP address and a SQL ...

I am in Enterprise Manager on ComputerA, logged in as user xyz. I am
attempting to add a new SQL Server registration for the SQL Server on
ComputerB, using SQL Server authentication based on SQL Server login abc. The
registration fails, stating that the SQL Server does not exist ...

Does anyone know why the NT AUTHORITY\NETWORK SERVICE account is considered
to be an NT group instead of just  an NT user? This causes sp_verify_job to
raise an exception in SQL Server 2000 sp3 running on Windows 2003 when a
session running as this account calls sp_add_job.

We currently have a foxpro app that is retrieving data from a sql server.  We
are using sql security but need to change it to integrated security.  
However, short of installing an application level firewall, can we insure
that users setup with integrated security only access the ...

I've just run the updated sp_MSdbuseraccess SP so that users can only see
databases listed in EM that they have access to but does anyone know of a
way to update this so that the Master, MSDB and tempDB databases are not
displayed as well?

MBSA is saying that I currently have MSXML 2.6 SP2, and that I should
upgrade to SP3.  When I did a search on the net, not only is SP3 not
publicly available, it is also included in MS SQL 2000 SP3 that I
already have installed.

I have linked SQL Server "SRV2" to SQL Server "SRV1" through
sp_addlinkedserver.
In my scenario, Windows user "U1" has access to "SRV1" while Windows
user "U2" has access to "SRV2".

I am having problems scheduling backups. It seems pretty straight-forward,
but will not work. I have tried a few different approaches.
1. in EM, under Management>Database Maintenance Plans, I have tried to set
up a Database Maintenance Plan, but whenever I try to schedule a backup, ...

I'm looking for an answer to this - I have a SQL Server 2000 with Windows
Authentication and I can't switch to mixed mode in this particular
environment (security reasons). Is there a way to connect to this server
from Enterprise Manager installed on another machine that is not ...

I am currently running SQL Server 2000 + MS03-031 (815495) + MS04-003
(832483).  Is it safe to say that the security patches above have been
incorporated into SP4?  Also, are there any new security patches that need to
be appled once SP4 is installed?

I cant figure this one out for the life of me...
On some workstations (XP).. in the enterprise manager, they can only
connect and browse the server if they use the IP address of the server,
using the fully qualified name:  ie:   Server1  It will error out and

I use enterprise manager for my SQL-Server databases.
I got a new-used computer recently - our computer support folks tell me they
re-built it from the ground up.
On my old workstation, I could open enterprise manager, open one of my

My company has an SQL server hosted at a server farm.  An outside
consultant is developing some stored procedures to generate some
reports using the data in the SQL Server database that our application
uses.

I was wondering if people could point me to some documentation about
allowing access to SQL Server over the Internet.  Any posts, links,
articles, pros/cons, issues to consider, potential problems, strategies or
recommendations are greatly appreciated!