unable to start t-sql debugging. could not attach to sql server process sql 2008 r2 [Resolved]

Posted by Ermahesh2009 under Sql Server on 9/3/2012 | Points: 10 | Views : 25386 | Status : [Member] | Replies : 5

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Dear all

IN my SQL server and its client firewall is disable . login sa have sysadmin role
but i am able to start debugging in sql server r2
unable to start t-sql debugging. could not attach to sql server process sql 2008 r2

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Pandians on: 9/3/2012 [Member] [MVP] Silver | Points: 50

0	Kindly ensure whether you have Windows authentication in SQL Server (Which login you are using to Login into the Server!) Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions Ermahesh2009, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ermahesh2009 on: 9/5/2012 [Member] Starter | Points: 25

0	Dear i connect it at my server using Windows authentication and it successfully connected and debug . But on my client when i connect using Windows authentication i got the error message Cannot generate SSPI context. (.Net SqlClient Data Provider) whats the reason i dont know kindly let me know what i need to do / Ermahesh2009, if this helps please login to Mark As Answer. \| Alert Moderator

Dear i connect it at my server using Windows authentication and it successfully connected and debug .
But on my client when i connect using Windows authentication i got the error message

Cannot generate SSPI context. (.Net SqlClient Data Provider)

whats the reason i dont know kindly let me know what i need to do /

Ermahesh2009, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Hariinakoti on: 9/5/2012 [Member] Starter | Points: 25

0	@Mahesh Follow this below link step by step process is there.I think it is useful to u. http://blog.sqlauthority.com/2007/12/29/sql-server-change-password-of-sa-login-using-management-studio/ Thanks & Regards Hari Ermahesh2009, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Hariinakoti on: 9/5/2012 [Member] Starter | Points: 25

0	@Mahesh, Check this link also http://worthposting.wordpress.com/2008/11/01/sql-server-reset-sa-password/ Thanks & Regards Hari Ermahesh2009, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jasminej on: 9/5/2012 [Member] Starter | Points: 25

0	@Hariinakoti The question is to enable DEBUGGING in sql server! But, Not How to reset the Password!!!!!!! Kindly post atleast relevent reply! thanks Ermahesh2009, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts