Using management console ctp with sql express...

Posted on 2006-04-08
Last Modified: 2013-12-03
So i installed sql express and the management console and have the sql service and browser running.  I try to connect to my instance of sql express with the management console and it says it doenst allow remote connections.


What do i need to do to be able to use the management console?

I was able to connect before off a system refresh and installing everything new, but due to some bad advice, think i stuffed up the whole thing and had to uninstall sql express and the management console.   I re-installed them both but am now getting this error.  what the heck is the deal with this?  It shouldnt be this hard!

This is in relation to an earlier issue i had trying to get to connect to a database from within visual web developer express and now i can connect to my sql express instance but cant get into the managment studio.  :(

I just cant win!  :P  :(
Question by:TheRookie32
    1 Comment
    LVL 8

    Accepted Solution

    Can you connect on the local machine. If you can.. you need to bringup the server properties and go into network properties and add namedpipes and tcp/ip protocols to the enables protocols section. i beleive by default these are turned off when you install or reinstall.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now