Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do I know whether I have a local SQL Server on my system? If there is what are the login details to the local SQL Server ? I have a windows 7.

share|improve this question

migrated from stackoverflow.com Dec 10 '09 at 16:59

This question came from our site for professional and enthusiast programmers.

how do i know whether i have a local mssql server on my system.

Check in Program Files, for a folder called Microsoft SQL Server - assuming a default install.

share|improve this answer
  • In Administrative Tools\Services look for SQl Server, SQL Server Browser.
  • Login as an administrator to your machine.
  • If you do not have Management Studio, you can download Express version it from Microsoft.
share|improve this answer

What you're looking for is SQL Server Management Studio Express. It will auto auth with your system credentials and show you the current databases on your system.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .