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 : 21223 | Status : [Member] | Replies : 5
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




Responses

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

Up
0
Down

Resolved
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

Up
0
Down
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

Up
0
Down
@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

Up
0
Down
@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

Up
0
Down
@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

Login to post response