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.
=========================================================

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.
> =========================================================
>
>

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.
=========================================================