Archive

Archive for August, 2010

How to change SCVMM 2008 R2 default library share

August 22, 2010 Leave a comment

 

You can only do this on the same server using the same share name. There is no other way. It’s because default library share points to that share.

Use the following steps:

  • Stop the SCVMM service using the following command: net stop vmmservice
  • Write down the name and permissions (including NTFS) that has been set on the default VMM Share
  • Remove (delete) the existing share and create a new share on a new folder using the information you recorded
  • Create the same folder structure and move all your files to the new location (if you don’t you might end up with loads of missing items)
  • Start the SCVMM service using the following command: net start vmmservice
  • Make sure that you can access the new share

PS! Special thanks to Matthew Mattoon

-Eric

Advertisements

Enable Remote Connections on SQL Server 2008 R2

August 20, 2010 1 comment

There are few things that needs to be sorted in order to get this running properly.

  • Enable TCP/IP and Named Pipes protocols. In order to do that open Sql Server Configuration Manager (Start > All Programs > Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Configuration Manager). Now on the left go SQL Server Network Configuration and select Protocols for YourInstanceName. Enable Named Pipes and TCP/IP.
  • Allow Remote Connections. Open Management Studio, right click on SQL server and select properties. Under Properties select connections and make sure that under Remote Server Connections Allow Remote Server Connections has been ticked. If its not then tick it (enable it) and click ok.
  • Create Firewall rules. Go to Control Panel > Administrative Tools and open Windows Firewall with Advanced Security.
    SQL Server rule. Select Inbound Rules, right-click and select “New Rule”. Select Program and click Next, enter the path to the SQL server program (C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\sqlserver.exe), click Next three times, then enter the name of the firewall rule (e.g. SQL Server), then click finish.
    SQL Server Browser rule. Select Inbound Rules, right-click and select “New Rule”. Select Program and click Next, enter the path to the SQL server program (C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe), click Next three times, then enter the name of the firewall rule (e.g. SQL Server Browser), then click finish.

Once all this is done, you should have Remote Connections enabled for SQL Server 2008 R2.

-Eric

Categories: Microsoft, SQL Tags: