How to Solve SqlServer2008 r2 Login Error

Question

Hi I have Attached SqlServer2008 r2 Login Error page not open so pls how to solve this problem. Error: a connection was successfully established with the server but then an error during login process sql server 2008 r2 Thanks

Ravi Kumar · Answer

hi try the fallowing go to all programs-->micro soft sql server 2008 R2-->Configuration Tools-->sql server configuration manager--->sql server network configuration-->protocals for sql express click enable TCP/IP

Ramchand Repalle · Answer

Hi Nirmal It relates to the IP restriction for that server or other TCP settings issue. you can check the below link it would be helpful to you. http://escapekeys.com/microsoft-sql-server-error-64-a-connection-was-successfully-established-with-the-server/89 Thanks Ramchand