"SELECT @@servername" will give you the answer.
Obviously, that presumes that you have already connected to SQL Server. If you are asking for what the name of the SQL Server instance in your environment, you need to talk to somewhere that works there. No one here has a clue how your environment looks like.
If you have installed SQL Server on your on own desktop/laptop, try one of . (that is, a single dot) or .\SQLEXPRESS, depending on which edition of SQL Server you installed.
I want to know the server name for MS SQL 2014 windows authentication.Can you please help me?My email id is tharun82@live.com.Please send me the solution.Thanking you.
You can also go to SQL Server configuration manager and see list of (names as well) all SQL Server installed.
You can also go to command prompt and type osql -L