SQL Studio Management help

Question

I am on LENOVO Computer user name is Rakshith and Pwd is Raksheeth2401.

and using vs 2015 and SQL SERVER MANAGEMENT STUDIO 2014 and database Engine...

in installation of database engine SSMS, I have given Windows and Sql authentication and given the Login name default "Lenovo\Rakshith" and pwd "Raki2401".

after completion I opened Sql management studio I tried to login with user Rakshith (or Lenovo\Rakshith) and pwd Raki2401 But shows login for use "Rakshith" failed.

(also failed in vs 2015 data connection string ...)

when I tried Windows authentication no user no pwd automatically successfully logged on. 

help me how to login with sql authenticatio

This is VS 2015 vb data connection project. .login failed

Answer 1

Try with . for Server Name in Management Studio & localhost for server in the connection string of your code

---

It all Happenz Sendil

Answer 2

Login failed with sql authentication

Logi success using windows authentication

Answer 3

Check your login credentials...

---

It all Happenz Sendil

Answer 4

All are correct credentials. .. But not working

Answer 5

Start Management Studio with Windows authentication and check again if you have the access — see the Security, Logins node in Object Explorer. Maybe even create here a new SQL user. Also make sure that the user has rights to access the required databases.

Before continuing with Visual Studio, you should be able to access the server with Management Studio.