how to configure sql becaz user id pwd is not valid it is sw

Question

Frnds I am login in sql server .when i put the pwd like sa n 1234 so i am getting error.and i m sending screen short .other thing in my object explorer window is showing blank so can;t go to security folder also

Ankit Sharma · Answer

try this solution https://social.technet.microsoft.com/wiki/contents/articles/1411.ssms-error-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server.aspx

Anjali Khan · Answer

solved.thanks for the update.

Anjali Khan · Answer

frnds my sql configuration problem is not solvsd.si i unstalled sql server n again install sql. but in start menu no option getting for sql management studio where can login.i m snding screen shorts also

Manish Kumar · Answer

I think sa is login id and 1234 is your password. But in server name it is showing sa. I want to know the sql server name. Do one thing. goto sql server configuration manager then click sql server services in that right side you will get sql server name. I have attached the screen show.

Anjali Khan · Answer

hi ankit i am sharing the snap short

Anjali Khan · Answer

yes sa n 1234 .but which error i got i shared the screen shorts

Ankit Sharma · Answer

Hi Anjali Your reply is not clear . you have not mentioned any error mesaage??? get SQL server2012 from here https://www.microsoft.com/en-in/download/details.aspx?id=29062

Manish Kumar · Answer

What is the name of sql server instance name . Is it sa? (It seems server name is wrong.)

Anjali Khan · Answer

HI ankit now m getting the below error You are getting SQL server error : 53 . Please check below link /. please share any link where i can download sql server 2012 for 64 bit

Amit Gupta · Answer

Hey Do check the below points 1. Make sure that SQL service instance is running. 2. Make sure you typed the correct id and pwd 3. Make sure you had enabled mixed mode authentication in server properties.

Ankit Sharma · Answer

Hi You are getting SQL server error : 53 . Please check below link https://stackoverflow.com/questions/16445243/cannot-connect-to-remote-sql-database-with-sql-server-management-console-error