I am trying to connect to one of our SQL servers via Ent mgr - I cannot
access and receive an error, see below. I can only see the server in Ent Mgr
if I remote to the server where SQL 2000 resides and run Ent mgr from there.
The SQL 2000 Named Intance resides on a Windows server 2003
The error I receive is:
Cannot generate SSPI Context?
After i change the SQL Server Service Account, i am getting above error
message. I change the service account 5 machines but i have only problem
with one server.
Please any body help me?You can define an alias and force the connection to using "name pipe" , ther
e
is an KB article on it..
"Ram" wrote:
> I am trying to connect to one of our SQL servers via Ent mgr - I cannot
> access and receive an error, see below. I can only see the server in Ent M
gr
> if I remote to the server where SQL 2000 resides and run Ent mgr from ther
e.
> The SQL 2000 Named Intance resides on a Windows server 2003
> The error I receive is:
> Cannot generate SSPI Context?
> After i change the SQL Server Service Account, i am getting above error
> message. I change the service account 5 machines but i have only problem
> with one server.
> Please any body help me?
>|||Or you can add the sqlserver service account to 'impersonate a user after
authentication' user rights assignment in security policy.
"Anthony" wrote:
[vbcol=seagreen]
> You can define an alias and force the connection to using "name pipe" , th
ere
> is an KB article on it..
> "Ram" wrote:
>|||Thanks for reply. we already added local administrator group and SQL Server
security as a sys administrator group also. I can connect using SQL
Authetication but i can't connect using Windows authetication. I also Added
Client network utility alias also. still doesn't work.
Ram
"Olu Adedeji" wrote:
[vbcol=seagreen]
> Or you can add the sqlserver service account to 'impersonate a user after
> authentication' user rights assignment in security policy.
> "Anthony" wrote:
>|||Hi Ram,
What operating system you have on computer from which you want to access SQL
server, is that computer member of workgroup or member of domain?
Regards,
Daniel
"Ram" <Ram@.discussions.microsoft.com> wrote in message
news:7B139AF7-E0E0-403F-B37D-96727A54F08E@.microsoft.com...
> Thanks for reply. we already added local administrator group and SQL
Server
> security as a sys administrator group also. I can connect using SQL
> Authetication but i can't connect using Windows authetication. I also
Added[vbcol=seagreen]
> Client network utility alias also. still doesn't work.
> Ram
> "Olu Adedeji" wrote:
>
after[vbcol=seagreen]
, there[vbcol=seagreen]
cannot[vbcol=seagreen]
Ent Mgr[vbcol=seagreen]
from there.[vbcol=seagreen]
error[vbcol=seagreen]
problem[vbcol=seagreen]|||Hi Ram,
What operating system you have on computer from which you want to access SQL
server, is that computer member of workgroup or member of domain?
Regards,
Daniel
"Ram" <Ram@.discussions.microsoft.com> wrote in message
news:7B139AF7-E0E0-403F-B37D-96727A54F08E@.microsoft.com...
> Thanks for reply. we already added local administrator group and SQL
Server
> security as a sys administrator group also. I can connect using SQL
> Authetication but i can't connect using Windows authetication. I also
Added[vbcol=seagreen]
> Client network utility alias also. still doesn't work.
> Ram
> "Olu Adedeji" wrote:
>
after[vbcol=seagreen]
, there[vbcol=seagreen]
cannot[vbcol=seagreen]
Ent Mgr[vbcol=seagreen]
from there.[vbcol=seagreen]
error[vbcol=seagreen]
problem[vbcol=seagreen]
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment