SQL Server Management Studio Express

Discussion in 'Databases' started by j-w-thomas, May 1, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. j-w-thomas

    j-w-thomas

    I have been told that I can use SQL Server Studio Express to access my DiscountASP.Net account on line and work with the SQL Server 2005 account that I have.

    Is this true?

    Or, is there any other tool such as myLittleAdmin that allows me to work with my db directly?

    I am used to working with a mySQL db through phpMyAdmin. It is a great program, but I want to move to a SQL Server db ASAP.

    Any help would be appreciated...

    Thanks
     
    j-w-thomas, May 1, 2007
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    yes. You should be able to connect to our database via Management Studio.

    See http://kb.discountasp.net/article.aspx?id=10436

    > Or, is there any other tool such as myLittleAdmin that allows me to work with my db directly?

    No. We do not have a web interface for SQL 2k5 because the client tool is so readily available.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, May 1, 2007
    #2
  3. Bruce

    Bruce DiscountASP.NET Staff

    John,


    i am confused.
    "Web Data Administrator" with two options, IIS or "Cassini" should have nothing to do w/ SQL Management Studio Express!!

    What did you download and installed?

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, May 1, 2007
    #3
  4. j-w-thomas

    j-w-thomas

    Obviously the wrong thing


    I downloaded a file called: SQLServer2005_SSMSEE.msi


    from the Microsoft website
     
    j-w-thomas, May 1, 2007
    #4
  5. j-w-thomas

    j-w-thomas

    OK Bruce,


    I have the right program running...it's a long story, don't ask...


    How do I make a connection to the remote server on my hosted site at DiscountASP ?


    I have a login window, but I do not see how to connect via the web...
     
    j-w-thomas, May 1, 2007
    #5
  6. j-w-thomas

    j-w-thomas

    Thanks Bruce, that's great.


    I had actually downloaded and installed the software already, but after trying several things, I can not log in.


    The only thing that shows up on my menu is the "Web Data Administrator" with two options, IIS or "Cassini".


    What should I do at this point? Or is there a website that I need to log into first?


    In other words what do I do now?


    Thanks


    John
     
    j-w-thomas, May 1, 2007
    #6
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page