Link to home
Start Free TrialLog in
Avatar of iamuser
iamuser

asked on

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
Avatar of iamuser
iamuser

ASKER

The windows account that I am using is listed to both SQL servers. And they both have identical permissions
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.
Avatar of iamuser

ASKER

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

ASKER CERTIFIED SOLUTION
Avatar of iamuser
iamuser

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of iamuser

ASKER

i found the solution