How to find a MS SQL SERVER name?

[infomamun]

Hi there,
I want to make a database program with SQL SERVER installed in my office. My office server is MS SQL SERVER which are linked with more than 12 computers/pc. I have already created a Database and an User from SQL SERVER Management Studio. But I am confused about what will be the server name in the connection string. When I open Management studio, it shows me SERVER\SQLEXPRESS as Name. Is it the name which I have to write in the Data Source value or anything else? In which place, I can find the server name at once?
Thanks

[jcis]

Shouldn't it be the computer name under Windows? from Sql Query Analyzer execute this:

select @@servername

[Hack]

Managment Studio will display the server name when you open it.

When I open it, I get both ther server name (red arrow) as well as the my windows login id (blue arrow) displayed.

[infomamun]

Thanks a lot. I will test it at next sunday.

[GaryMazzone]

You connect name (Server) will be ServerName\SQLEXPRESS. Remember that SQL Express out of the box will not allow remote connections to the database. You will need to modify the connection setting using the configuration mananger.