connecting to sql server express

Question

Hi

I am sorry. I do not know whether I can ask this question here or not.

I was working with sql server from morning. Just now I was trying to create different project and when clicked on "New connection" In connection properties I see different server name which is not related to me. I am the only one who uses this sever. but howcome I see a random servername. Is my computer safe?

Bikesh Srivastava · Answer

Hi You need to start two setup. 1.Managment studio 2.SQl server express.

Ajay Malik · Answer

If sql server is installed on your machine you should check Programs -> Microsoft SQL Server 20XX -> Configuration Tools -> SQL Server Configuration Manager -> SQL Server Services You'll see SQL Server (MSSQLSERVER) Programs -> Microsoft SQL Server 20XX -> Configuration Tools -> SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER -> TCP/IP Make sure it's using port number 1433 If you want to see if the port is open and listening try this from your command prompt... telnet 127.0.0.1 1433 And yes SQL Express installs use localhost\SQLEXPRESS as the instance name by default.

Nitin Sontakke · Answer

You didn't mention which application you are using. Is it SQL Server Management Studio? Please specify.