May 29, 2020
    • SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server Basics, Training, etc - MyTechMantra.com
    SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server Basics, Training, etc - MyTechMantra.com
    FacebookTwitterPinterestEmailGoogle+LinkedInWhatsApp
    DBADevelopersSQL Server

    How to Configure a Contained Database Feature in SQL Server

    Chetna Bhalla Chetna Bhalla
    Add comment
    10,279 views
    5 min read

    Click here to read “How to Configure a Contained Database Feature in SQL Server” article from the beginning.

    How to Connect to Contained Database in SQL Server

    Step 1. In Connect to Server, Login tab enter Server Name, choose Authentication, enter Login and Password as shown in the below snippet and click on Connection Properties tab.

    How to Connect to a Database in SQL Server

    Step 2: In Connection Properties tab specify the database name as shown in the snippet below and finally click the Connect button.

    Connection Properties in SQL Server 2012
    Connection Properties in SQL Server 2012

    In the below snippet you could see that using the contained database login you could just see only one database to which your login belongs and the login doesn’t have access to Database Engine.

    Conclusion

    Now that you have successfully connected to a contained database you can easily easily create the Backup of the Contained Database and Restore it on any other instance of SQL Server.

    1 2 3 4
    Chetna Bhalla

    Chetna Bhalla

    LESS ME MORE WE

    Chetna Bhalla, the founder of MyTechMantra.com, believes that by sharing knowledge and building communities, we can make this world a better place to live in. Chetna is a Graduate in Social Sciences and a Masters in Human Resources and International Business. She is an alumnus of Vignana Jyothi Institute of Management, Hyderabad, India. After graduation, Chetna founded this website, which has since then become quite a favorite in the tech world. Her vision is to make this website the favorite place for seeking information on Databases and other Information Technology areas. She believes that companies which can organize and deploy their data to frame strategies are going to have a competitive edge over others. Her interest areas include Microsoft SQL Server and overall Database Management. Apart from her work, Chetna enjoys spending time with her friends, painting, gardening, playing the violin, and spending time with her son.

    View all posts

    You may also like

    Add comment

    Newsletter Signup! Join 15,000+ Professionals




    Be Social! Like & Follow Us...

    Follow us

    Don't be shy, get in touch. We love meeting interesting people and making new friends.

    Advertisement