MSSQL connection through SPS it not working with Windows authentication

Hi,

I am trying to connect SQL management studio to a SQL server through MSSQL connection of SPS.

The connection using the Windows authentication is not working giving error 

No username specified
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (.Net SqlClient Data Provider)

when using the sql authentication it is working fine.

did any one receive this issue or how to fix this.may be i am missing some simple config

Best Regards,

Abubakar

Parents
  • Hi Abubakar

    I cannot give you a definitive answer here and I have very limited knowledge of SQL but based on what you are describing and my knowledge of SPP I would hazard an educated guess that what you are seeing is by design.

    When you select the platform for the system you wish to manage this defines the way SPP communicates with that target system.

    So I am guessing that you have defined and SQL platform against the target system and that from your description this is working and It will be using SQL authentication to carry out management tasks.

    So I suspect that when  you try to use Windows authentication it is still using SQL authentication and so fails.

    Maybe you could try defining another target system this time selecting a Windows platform type for your SQL server and see if this works. My thinking is that this will then try to authenticate to the target server using Windows authentication rather than SQL authentication.

    If this does not work, I an sure that there are other on this forum who have greater knowledge of SQL operations than me who will be able to give advice.

    Good luck

    Best regards

    Tim

Reply
  • Hi Abubakar

    I cannot give you a definitive answer here and I have very limited knowledge of SQL but based on what you are describing and my knowledge of SPP I would hazard an educated guess that what you are seeing is by design.

    When you select the platform for the system you wish to manage this defines the way SPP communicates with that target system.

    So I am guessing that you have defined and SQL platform against the target system and that from your description this is working and It will be using SQL authentication to carry out management tasks.

    So I suspect that when  you try to use Windows authentication it is still using SQL authentication and so fails.

    Maybe you could try defining another target system this time selecting a Windows platform type for your SQL server and see if this works. My thinking is that this will then try to authenticate to the target server using Windows authentication rather than SQL authentication.

    If this does not work, I an sure that there are other on this forum who have greater knowledge of SQL operations than me who will be able to give advice.

    Good luck

    Best regards

    Tim

Children