+ Reply to Thread
Results 1 to 4 of 4

SQL2008 Express managed by machine with SQL2008 Standard?

  1. SQL2008 Express managed by machine with SQL2008 Standard?

    We have a small DB app for a customer and want to use SQL 2008 Express. Can
    I install the Express and then use the Management Studio from my Laptop
    install to manage the Express install for the Initial Setup?

    Thanks,
    Scott<-


  2. RE: SQL2008 Express managed by machine with SQL2008 Standard?

    Hi Scott,
    Welcome to Microsoft TechNet Managed Newsgroup Services. My name is Charles
    Wang. It is my pleasure to work with you on this post.

    From your description, I understand that you would like to know whether you
    can use the SQL Server Management Studio (SSMS) installed on your laptop to
    connect to the your SQL Server 2008 Express instance to manage it.
    If I have misunderstood, please let me know.

    Yes, you can use SSMS to connect to your SQL Server 2008 Express instance.
    If your express instance is located on a remote server, please ensure:
    1. The TCP/IP protocol is enabled for it;
    2. SQL Server Browser Services is enabled;
    3. The listening TCP port is added into the exception list of the firewall.

    You can refer to this article, http://support.microsoft.com/kb/914277/en-us
    for more information. Though this KB article is for SQL Server 2005, you
    can also refer it to configure the settings for your SQL Server 2008
    instance.

    Please do not hesitate to let me know if you have any other questions or
    concerns.

    Best regards,
    Charles Wang
    Microsoft Online Community Support
    Get Secure! - www.microsoft.com/security
    =========================================================
    Delighting our customers is our #1 priority. When responding to posts,
    please "Reply to Group" via your newsreader so that others may learn
    and benefit from your issue.
    =========================================================
    This posting is provided "AS IS" with no warranties, and confers no rights.
    =========================================================



  3. Re: SQL2008 Express managed by machine with SQL2008 Standard?

    Thank you for the reply!

    What is the lowest end version of SQL 2008 that comes with SQL Server
    Management Studio? Does the Workgroup Ed come with SSMS?

    Thank you,
    Scott<-
    ""Charles Wang [MSFT]"" wrote in message
    news:dLBmM7FrJHA.1636atTK2MSFTNGHUB02dotphx.gbl...
    > Hi Scott,
    > Welcome to Microsoft TechNet Managed Newsgroup Services. My name is
    > Charles
    > Wang. It is my pleasure to work with you on this post.
    >
    > From your description, I understand that you would like to know whether
    > you
    > can use the SQL Server Management Studio (SSMS) installed on your laptop
    > to
    > connect to the your SQL Server 2008 Express instance to manage it.
    > If I have misunderstood, please let me know.
    >
    > Yes, you can use SSMS to connect to your SQL Server 2008 Express instance.
    > If your express instance is located on a remote server, please ensure:
    > 1. The TCP/IP protocol is enabled for it;
    > 2. SQL Server Browser Services is enabled;
    > 3. The listening TCP port is added into the exception list of the
    > firewall.
    >
    > You can refer to this article,
    > http://support.microsoft.com/kb/914277/en-us
    > for more information. Though this KB article is for SQL Server 2005, you
    > can also refer it to configure the settings for your SQL Server 2008
    > instance.
    >
    > Please do not hesitate to let me know if you have any other questions or
    > concerns.
    >
    > Best regards,
    > Charles Wang
    > Microsoft Online Community Support
    > Get Secure! - www.microsoft.com/security
    > =========================================================
    > Delighting our customers is our #1 priority. When responding to posts,
    > please "Reply to Group" via your newsreader so that others may learn
    > and benefit from your issue.
    > =========================================================
    > This posting is provided "AS IS" with no warranties, and confers no
    > rights.
    > =========================================================
    >
    >



  4. Re: SQL2008 Express managed by machine with SQL2008 Standard?

    Hi Scott,
    If you refer to SQL Server Management Studio RTM, all SQL Server 2008 RTM
    editions from Workgroup to Enterprise include it. It can also be used to
    manage SQL Server 2008 Express instance. For SQL Server 2008 Express, there
    is also a specific SSMS named SQL Server 2008 Management Studio Express
    (SSMSE) which you can download from this link:
    http://www.microsoft.com/downloads/d...683-4cb2-454e-
    b908-e805e9bd4e28&displaylang=en
    If you install SQL Server 2008 Express Advanced Edition, it will be
    installed to your computer by default.

    For more information, you can refer to the section "Management Tools" in
    this article:
    Features Supported by the Editions of SQL Server 2008
    http://msdn.microsoft.com/en-us/library/cc645993.aspx

    Hope this helps. Any further questions or concerns are greatly welcomed!

    Best regards,
    Charles Wang
    Microsoft Online Community Support
    Get Secure! - www.microsoft.com/security
    =========================================================
    Delighting our customers is our #1 priority. When responding to posts,
    please "Reply to Group" via your newsreader so that others may learn
    and benefit from your issue.
    =========================================================
    This posting is provided "AS IS" with no warranties, and confers no rights.
    =========================================================





+ Reply to Thread