locked
Installing SQL Tools (Profiler) into SBS2011 SQL Version RRS feed

  • Question

  • I need to access SQL Profiler for our database. We presently are using the SQL version automatically installed in SBS2011. I have tried to use the Management Studio to access Profiler but the Tools option is greyed out. Can you provide some instructions and clarity.

    1) What is the version of SQL that is included in SBS2011 Standard?

    2) How do I install Tools for this version?

    3) Is there another option besides Tools that would be simpler?

    Thank you.

    Tuesday, June 2, 2015 6:33 PM

Answers

  • Hi jdublyu,

    As indicated in this article, the SQL Server included in SBS 2011 Standard is SQL Server 2008 R2 Express. SQL Profiler doesn’t come with SQL Server 2008 R2 Express, you can get the SQL Profiler from SQL Server full edition such as Standard, Enterprise and so on.

    Alternatively, you can trace SQL Server Express without using SQL Profiler. Start the SQL Express Service from the command prompt (run command prompt as Administrator) with the following Trace Flag. For more details, please review this blog.

    net start MSSQL$SQLEXPRESS /T4032

    Thanks,
    Lydia Zhang

    If you have any feedback on our support, please click here.


    Lydia Zhang
    TechNet Community Support




    Wednesday, June 3, 2015 1:53 AM