Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I connect to MSDE using SQL Server Enterprise Manager in the SCIS Labs?

April 26, 2017Connect Enterprise Labs manager MSDE SCIS SQL Server

0

Posted

How do I connect to MSDE using SQL Server Enterprise Manager in the SCIS Labs?

1 Answer

0

Posted

• Open Enterprise Manager from the Programming\Microsoft SQL Server section of the Start menu. • Expand the Microsoft SQL Servers node • Right-click on SQL Server Group and select New SQL Server Registration… • Click Next >. The Available servers: textbox already contains the name of the computer you are using. Simply append the text \VSSQLSERVER to the end of that name, so you end up with something like CS1234567890AB\VSSQLSERVER. • Click Add >, then click Next >. • Select the default, The Windows account information… and click Next >. • Click Next > again and click Finish. That’s it. You should now be able to manage the local MSDE instance using SQL Server Enterprise Manager. You’ll need to repeat this procedure for each new machine you log on to.