Adding device license in SQL server 2012 standard edition

Posted on 2012-09-10
Last Modified: 2012-09-23
Hi Team,

We are planned to buy SQL server 2012 standard edition with 30 device licensing.

1) Can any one provide me the link to download sql server 2012 standard evaluation version?
2) Can i have any installation documentation for adding the device with sql server?
3) how to check device is added and working fine with sql server?
4) Also,can i have a query how to check principal server is UP and running fine with DB Mirroring.

Kindly,check and let me know how to work on the above issues.

Question by:COS_IT_AU
    1 Comment
    LVL 28

    Accepted Solution

    Here's the download link for the SQL 2012 Evaluation:

    I'm not sure what device you intend to "add" or how you intend to connect it, but each client is different - you'd have to read the documentation for the client you're using. If it's just SQL Management Studio, then it's easy to connect and there are a number of tutorials you can find online (like this one:

    As far as mirroring status, this query is probably closest to what you'll need (found at

    , ISNULL(b.mirroring_role_desc, 'NOT MIRRORED') as mirroring_role_desc
    , ISNULL(b.mirroring_state_desc, '') as mirroring_state_desc
    , ISNULL(mirroring_safety_level_desc, '') as mirroring_safety_level_desc
    FROM sys.databases a
    INNER JOIN sys.database_mirroring b on b.database_id = a.database_id
    WHERE NOT IN ('master', 'msdb', 'model', 'tempdb', 'distribution')

    Open in new window


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    737 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

    17 Experts available now in Live!

    Get 1:1 Help Now