SSMS to second sql server gives me SSPI error help

I have 2 sql servers TEST1 & TEST2

Both are windows 2008 R2 64BIT

Both are updated with the same patches and service patch

TCP/IP, NAME PIPES & SHARED MEMORY are all enabled on both servers

The first SQL server (TEST1) has 2 instances installed

- Analysis, intergration, & reporting services installed under the default instance

- Second instance contains SQL engine, SQLEngine\Fulltext, Analysis Services, Reporting Servies (TEST1\TEST)

Shared components are: SSMS, ADV_SSMS, CONN, IS

2nd SQL server (TEST2) has default instance with everything installed

With SSMS & windows authentication from TEST2 I can connect to TEST1\TEST, no errors

With SSMS & windows authentication from TEST1, I get the "Cannot generate SSPI context" error when I try to connect to TEST2

Using sql authentication from TEST1 I can connect to the TEST2 with no errors

I need the windows authentication to work and I can't see where the problem is
iamuserAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
iamuserConnect With a Mentor Author Commented:
i found the problem, the service account was the issue, they had different service accounts
0
 
iamuserAuthor Commented:
The windows account that I am using is listed to both SQL servers. And they both have identical permissions
0
 
markterryCommented:
firewall is set to allow the SQL port through?
1433? that is the windows firewall on the 2008 server, as well as any possible hardware firewalls inbetween.
0
 
iamuserAuthor Commented:
on Test1 the  port is set to dynamic ports. That wasn't set by anyone, it just seemed to be set to dynamic by default. Test2 is set to port 1433

0
 
iamuserAuthor Commented:
i found the solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.