up vote 0 down vote favorite
share [g+] share [fb]

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.

link|improve this question
belongs on superuser.com – ChristopheD Dec 10 '09 at 6:40
feedback

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

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

3 Answers

up vote 1 down vote

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.

link|improve this answer
feedback
up vote 1 down vote
  • 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.
link|improve this answer
feedback
up vote 0 down vote

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.