How To Login To SQL Server 2005 Express Management Studio?

1. 1. Home
   2. Questions
   3. Tags
   4. Users
   5. Companies
   6. Labs
   7. Jobs
   8. Discussions
   9. Collectives

   10. Communities for your favorite technologies. Explore all Collectives

2. Teams

   Ask questions, find answers and collaborate at work with Stack Overflow for Teams.

   Try Teams for free Explore Teams
3. Teams

4. Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Learn more about Collectives

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more about Teams

Get early access and see previews of new features.

Learn more about Labs How to login to SQL Server 2005 Express Management Studio? Ask Question Asked 14 years, 1 month ago Modified 9 years, 6 months ago Viewed 8k times 0

I've just installed SQL Server 2005 Express and I'm trying to login to Management Studio but I don't know what the "Server Name" is to be able to login.

I've tried:

localhost\SQLEXPRESS 127.0.0.1\SQLEXPRESS SQLEXPRESS <computer name>\SQLEXPRESS <username>\SQLEXPRESS

The authentication mode is Windows Authentication.

The error message I'm getting is:

Could not connect to <computer name>\SQLEXPRESS. Additional information A network related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (proveder: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)

Does anyone point me in the right direction?

• authentication
• sql-server-2005
• ssms

Share Improve this question Follow edited May 12, 2015 at 13:36 Dylan Corriveau 2,55744 gold badges3030 silver badges3636 bronze badges asked Oct 22, 2010 at 12:52 TurgsTurgs 1,79922 gold badges2222 silver badges5050 bronze badges 3

• Can you tell us the error message you are getting? – Neil Knight Commented Oct 22, 2010 at 12:54
• I've edited my description above to include the error message. Thanks – Turgs Commented Oct 22, 2010 at 13:00
• did you change the instance name when installing? And you correctly specified your Windows account as a login? – slugster Commented Oct 22, 2010 at 13:16

Add a comment |

1 Answer 1

Sorted by: Reset to default Highest score (default) Trending (recent votes count more) Date modified (newest first) Date created (oldest first) 0

Is the SQL Server Express service even up and running??

The local machine can be defined as . or (local) for SQL Server, and the SQL Server Express instance name is SQLExpress by default.

So .\SQLExpress or (local)\SQLExpress ought to work.

If they don't, maybe the service isn't up and running??

Share Improve this answer Follow answered Oct 22, 2010 at 13:03 marc_smarc_s 752k183183 gold badges1.4k1.4k silver badges1.5k1.5k bronze badges Add a comment |

Your Answer

Reminder: Answers generated by artificial intelligence tools are not allowed on Stack Overflow. Learn more

Thanks for contributing an answer to Stack Overflow!

• Please be sure to answer the question. Provide details and share your research!

But avoid …

• Asking for help, clarification, or responding to other answers.
• Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Draft saved Draft discarded

Sign up or log in

Sign up using Google Sign up using Email and Password Submit

Post as a guest

Name Email

Required, but never shown

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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

• authentication
• sql-server-2005
• ssms

or ask your own question.

• The Overflow Blog
• We'll Be In Touch - A New Podcast From Stack Overflow!
• The app that fights for your data privacy rights
• Featured on Meta
• More network sites to see advertising test
• We’re (finally!) going to the cloud!
• Call for testers for an early access release of a Stack Overflow extension...

Related

231 How to connect to local instance of SQL Server 2008 Express 1 Sql Server Management Studio Express 0 Issues with connection in SQL Server 2008 Management Studio Express 5 Cannot connect to SQL Server Management Studio 1 Connect to SQL Express with SSMS 2 Accessing SQL Server 2008 R2 Express with SQL Server Management Studio 23 Cannot connect to SQL Server express from SSMS 19 How to add users to SQL Server 2008 Management Studio 0 SQL Server 2008 Management Studio username and password 1 How to connect to SQL Server using SQL Server Management Studio using Windows and SQL Authentication

Hot Network Questions

• Constrained optimization problem
• What are rests in the realm of rhythm and melody?
• logical error probability independent from distance in STIM default repetition code
• Can the same arguments used to reject metaphysical solipsism also support accepting the existence of God?
• What is the correct article before a letter sound?
• How to create a thesis flowchart using Mathematica?
• What is someone to do if they inherited a laptop containing illegal images
• Given extensive protections in modern operating systems that make buffer overflow exploits unfeasible, should I even bother studying these?
• What are the ethical considerations regarding mandatory class participation?
• What happens to your original form when you lose body parts while under the effect polymorph or alter self?
• caber in different expressions
• A linked list in C, as generic and modular as possible, for my personal util library
• To “digitize” means to turn something into a digital format that was previously not digital. What to call changing one digital format into another?
• Are there any existing (indigenous) European languages with aspirated/unaspirated versions of consonants which are different phonemes?
• Can the Attorney General, with a cooperating president, naturalize all undocumented immigrants?
• Why doesn't Hotelling's law seem to apply to the stances taken by political parties?
• Sci-fi movie that starts with a man digging his way out of a crashed spacecraft and promptly being torn in half
• How quickly could a probe reach the heliopause?
• Using a platinum loop to light a gas stove in Oliver Sacks's memoir
• How would Merfolk make a solar oven
• If the president pardons you for illegally entering the country, can you begin immigration paperwork immediately?
• Is it potentially dangerous to run a bash script with sh?
• Is it safe to solder 230V wire on relay?
• Could air traffic control radars pick up a large stationary floating object?

more hot questions Question feed Subscribe to RSS Question feed

To subscribe to this RSS feed, copy and paste this URL into your RSS reader.

lang-sql