connecting to sql server express

Help Needed

10y987

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?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava10y ago
Hi,
You need to start two setup.
1.Managment studio
2.SQl server express.
0
Ajay Malik10y ago
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.
0
Nitin Sontakke10y ago
You didn't mention which application you are using. Is it SQL Server Management Studio? Please specify.
0