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
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
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.
1433? that is the windows firewall on the 2008 server, as well as any possible hardware firewalls inbetween.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i found the solution
ASKER