How can we administrate SQL remotely?

Hi,
customer has a W2k SBS with SQL installed. We recently
installed McAfee Protection Pilot, which uses SQL as data
storage for the client configurations. All works well.
Our problem is, that we can logon as local admin and open
this database OK. But when we connect via terminal server,
log in as admin and try to open the database we get the
error: "You can not log on as database administrator. Make
sure that your are logged in as local administrator".
Is there a way to overcome this "logon as local admin"
requirement? How else could one administrate the SQL
database remotely?
Thanks
Wolf
Make sure you have TCP/IP setup in sql client config.
Make sure you have Authentication mode setup to "Windows and SQLServer"
"w.haunzwickl" <anonymous@.discussions.microsoft.com> wrote in message
news:afd501c49991$d00bd300$a601280a@.phx.gbl...
> Hi,
> customer has a W2k SBS with SQL installed. We recently
> installed McAfee Protection Pilot, which uses SQL as data
> storage for the client configurations. All works well.
> Our problem is, that we can logon as local admin and open
> this database OK. But when we connect via terminal server,
> log in as admin and try to open the database we get the
> error: "You can not log on as database administrator. Make
> sure that your are logged in as local administrator".
> Is there a way to overcome this "logon as local admin"
> requirement? How else could one administrate the SQL
> database remotely?
> Thanks
> Wolf

How can we administrate SQL remotely?

Hi,
customer has a W2k SBS with SQL installed. We recently
installed McAfee Protection Pilot, which uses SQL as data
storage for the client configurations. All works well.
Our problem is, that we can logon as local admin and open
this database OK. But when we connect via terminal server,
log in as admin and try to open the database we get the
error: "You can not log on as database administrator. Make
sure that your are logged in as local administrator".
Is there a way to overcome this "logon as local admin"
requirement? How else could one administrate the SQL
database remotely?
Thanks
WolfMake sure you have TCP/IP setup in sql client config.
Make sure you have Authentication mode setup to "Windows and SQLServer"
"w.haunzwickl" <anonymous@.discussions.microsoft.com> wrote in message
news:afd501c49991$d00bd300$a601280a@.phx.gbl...
> Hi,
> customer has a W2k SBS with SQL installed. We recently
> installed McAfee Protection Pilot, which uses SQL as data
> storage for the client configurations. All works well.
> Our problem is, that we can logon as local admin and open
> this database OK. But when we connect via terminal server,
> log in as admin and try to open the database we get the
> error: "You can not log on as database administrator. Make
> sure that your are logged in as local administrator".
> Is there a way to overcome this "logon as local admin"
> requirement? How else could one administrate the SQL
> database remotely?
> Thanks
> Wolf