Remote Access to SQLServer Enterprise Manager

  • Thread starter Thread starter Rob King
  • Start date Start date
R

Rob King

We have a user that remotely administers a SQL Server via
the Internet. For some reason he now cannot access any
DB via Enterprise Manager on our beta box, but he still
can on the commercial box. We do not know of anything
that has changed to casue this on the server.

If I log in with Remote Desktop (Admin account) I can
acces the SQL DB's fine. If he logs in he can access the
desktop but is denied access to the SQL DB's.

He is using XP SP1 Remote Desktop 5.2.3790
I am using 5.1.2600.

Any suggestions?
 
Have you checked the security on the DB's on the "beta" box? It
sounds like the user doesn't have access authority for the DB.

Jeffrey Randow (Windows MVP - Networking & Smart Display)
(e-mail address removed)

Please post all responses to the newsgroups for the benefit
of all USENET users. Messages sent via email may or may not
be answered depending on time availability....

Remote Networking Technology Wiki -
http://www.remotenetworktechnology.com
Smart Display Support - http://www.smartdisplays.net
Windows XP Expert Zone - http://www.microsoft.com/windowsxp/expertzone
 
Back
Top