Hi.
Rookie question.
Is it possible to add a MS SQL 7.0 server in a MS SQL 2000 Server Enterprise
Manager consol? I've added a login on the MS SQL 7.0 server, dedictaed to
the MS SQL 2000 login, but the 7.0 server appear to be "not associated with
a trusted SQL Server connection" when I try to register the 7.0 server in
the 2000 consol.
Please guide me on this one if you can.
Regards
Mr. SmithHi
SQL Server 2000 EM can manage SQL Server 7.0 installations.
Your problem is security. Are you logged on using an account that has
permissions on the SQL Server 7.0 server and domain? If not, you need to be
given the rights. Else, connect using SQL Server security by passing in a
Username and Password.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mr. Smith" <nospam@.blindfolded.gone> wrote in message
news:e08lOn32EHA.924@.TK2MSFTNGP14.phx.gbl...
> Hi.
> Rookie question.
> Is it possible to add a MS SQL 7.0 server in a MS SQL 2000 Server
Enterprise
> Manager consol? I've added a login on the MS SQL 7.0 server, dedictaed to
> the MS SQL 2000 login, but the 7.0 server appear to be "not associated
with
> a trusted SQL Server connection" when I try to register the 7.0 server in
> the 2000 consol.
> Please guide me on this one if you can.
> Regards
> Mr. Smith
>
No comments:
Post a Comment