Could not load file or assembly ‘Microsoft.SqlServer.Sqm, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. (SqlMgmt)

Trying to attach a database .MDF file via a fresh install of SSMS (SQL Server Management Studio) and you get this dialog?

“Could not load file or assembly
‘Microsoft.SqlServer.Sqm …”

This FIX worked for  me:

Copy the file Microsoft.SqlServer.Sqm.dll located on
C:\Program Files\Microsoft SQL Server\100\Shared to folder
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE

Found here: Just a Reminder

Advertisements

Warning 26003. MS Server 2008 R2 Setup Support Files cannot be uninstalled because the following products are installed: SQL Server 2008 R2 Common Files SQL Server 2008 R2 Database Engine Shared”

For many, many weeks I was stuck in SQL Server hell, and almost, nearly, resigned to having to wipe my hard drive clean, in order to get SQL Server to un-install and re-install successfully !!!

SQL Server un-install wizard kept on getting stuck halfway through the un-install process…as it kept asking for, but would refuse to accept, the sqlsupport.msi file, even when pointing to a valid original install location!

Until I found the answer to my woe (amazingly it works… Like a magic charm!)

Solution:
Save a file as “sql.reg” on your desktop with the following text (use copy-paste) shown in italics:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Bootstrap]
“BootstrapDir”=”C:\\Program Files\\Microsoft SQL Server\\100\\Setup Bootstrap\\”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Bootstrap\Setup]
“PatchLevel”=”10.50.1600.00”

After saving the file to desktop, double click the file and accept the dialog to merge this to your registry.

Then copy the following files from your installation folder to the location :

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2

Note: If you don’t see these folders just create them with the exact name

What is to be copied:

folder: x64/x86/ia64 (depending on 64bit, 32bit or itanium architecture),

folder: resources

file: setup.exe

Now run setup.exe from your installation folder again. Your fresh installation should begin.

Hopefully this helps you too.

See : Only the good stuff

Apache HTTP Server error: ‘An attempt was made to access a socket in a way forbidden by it’s access permissions. AH00072: make_sock: could not bind to address 0.0.0.0:80. AH00451: no listening sockets available, shutting down.’

I discovered that this error was caused by ‘SQL Server Express 2008 Reporting Services’ also using TCP Port 80. Apache HTTP Server also uses TCP Port 80 by default.

Fix: Reconfigure either your SQL Server Reporting Services or the Apache HTTP Server to use another port other than TCP Port 80.
Or you can temporarily stop the SQL Server Reporting Services service in order to continue using your Apache HTTP Server.

SQL Server Reporting Services
Note that the SSRS service can remain active even if you uninstall SQL Server. To stop the service:

  1. Open SQL Server Configuration Manager.
  2. Select “SQL Server Services” in the left-hand pane.
  3. Double-click “SQL Server Reporting Services”.
  4. Hit Stop.
  5. Switch to the Service tab and set the Start Mode to “Manual”.

    If this doesn’t fix your issue then it could be there’s another Windows program using TCP Port 80. You can find out by entering the following on the Windows command line:

    netstat -ao

    The active TCP addresses and ports will be listed. Look for the line where Local Address is “0.0.0.0:80″ and make note of the value in the PID column.

    Now start Task Manager. Navigate to the ‘Processes’ tab. If there’s no ‘PID’ column, click View > Select Columns… to ensure “PID (Process Identifier)” is checked. You can now locate the PID you made a note of above. The ‘Description’ and ‘Image Path’ properties should identify which application is using the port.

    Task Manager can allow you to kill the process, but be very cautious about doing that if it’s a System Process, such as “NT Kernel & System”.

‘This page can’t be displayed’ – Internet Explorer

How I fixed “This page can’t be displayed” error message/error page on Internet Explorer(v10), after being unable to browse secure internet web sites:

(I suspect a recent Windows 7 auto-update may have wiped out previous ‘stable’ settings, considering this problem surfaced suddenly out of the blue, sort of, after many months of relatively trouble-free SSL surfing.)

Make sure TLS and SSL protocols are enabled: Go to Tools > Internet Options > Advanced > Settings > Security

May work for some…

٭ Click Tools menu and select Internet Options

٭ Select the Advanced tab

٭ Scroll down to Security section

٭ Make sure “Use SSL 2.0 / Use SSL 3.0” are selected. Particularly, as in my case, also be sure to select “Use TLS 1.2”

٭ If necessary, restart your browsing session

“MIDI device or the audio device to be used for VSC’s audio output cannot be opened. Playback unavailable at this time”

Relates to VSC (Virtual Sound Canvas) and band-in-a-box by PG Music


When you try to
open the VSC as a stand-alone application, (and you are trying to use the Roland VSC as your MIDI output driver), you may get the message “MIDI device or the audio device to be used for VSC’s audio output cannot be opened. Playback unavailable at this time”:

There are a few possible solutions. You should be able to resolve the problem by following one or more of the suggestions below. Alternatively, use the VSC-DXi instead of the VSC-3 stand-alone version.

Select something other than the VSC as your default MIDI driver in Windows

  1. On Windows XP go to Start | Control Panel | Sounds and Audio Devices | Audio tab.
    or  Win2000 Start | Settings | Control Panel | Sounds and Multimedia | Audio.
  2. Select something other than the Roland VSC for default audio and MIDI playback.
  3. Restart your computer.

Make sure vscvol and vsc32cnf are enabled at startup.

  1. Go to the Start menu | Run, type “msconfig” and press OK. This should open the System Configuration Utility. Note: Windows 2000 doesn’t have the system configuration utility.
  2. Click on the Startup tab and make sure there are checkmarks beside ‘vscvol’ and ‘vsc32cnf’.
  3. Press [Apply], then [OK], and restart your computer.


Reinstall the VSC

  1. Uninstall the Roland VSC using the Add/Remove Programs utility.
  2. Right-click on My Computer and select ‘Properties’.
  3. Click on the Hardware tab and press the [Device Manager] button.
  4. Expand ‘Sound, Video and Game Controllers’ and look for ‘Virtual Sound Canvas’. If you see it listed there, right-click on it and select ‘uninstall’. Restart your computer.
  5. Reinstall the Roland VSC. If you get a message saying that the VSC has not passed Windows Logo Testing, you can “Continue Anyways”. You should be prompted to restart your computer again after the VSC has been installed.
  6. Go back to ‘Sound Video and Game Controllers’ in the Device Manager.
  7. Right-click on the Virtual Sound Canvas 3.2 and select ‘Properties’. Make sure that Device Usage is set to “Use this device (enable)”.

Using the VSC-DXi version, rather than the stand-alone VSC
If you are still having trouble with the stand-alone VSC, PG Music suggests that you use the VSC-DXi instead. Band-in-a-Box 2004 and higher support DXi plugins, and the VSC-DXi would have been included with your Band-in-a-Box purchase. The DXi version has the same set of sounds as the stand-alone version, but is used a little differently with Band-in-a-Box.

To use the VSC-DXi, you need to first install it on your computer. To choose the VSC-DXi as your MIDI output device in Band-in-a-Box, go to Opt. | MIDI Driver Setup and place a checkmark in the “Use DXi Synth” checkbox.

When the DirectX window opens up, choose the VSC-DXi as your plugin. Close the DirectX window, and you should be back in the MIDI Driver Setup dialog. By default, Band-in-a-Box will set the Driver Latency to around 2000 milliseconds. This is a high setting, but is safe even on older computers. With most computers, you should be able to choose a Driver Latency of around 200 ms or lower. You can experiment with the Driver Latency until you hear audio glitches. A lower latency will give you a quicker response time.

If you were used to using the “Direct Render to wave” feature of the VSC, you will find that the “DXi Direct Render” feature in Band-in-a-Box will give you the same results. It is also a quicker and easier method of rendering your songs to wave.

Cannot connect to [database name]. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

Server Name: Make sure you are typing server name (i.e. host name or computer name) correctly along with the proper instance name of an installed instance of SQL Server.

As, even using ‘(local)’ or ‘(localhost)’ can also cause this error:

Correct format is: Server-name\db-instance-name. e.g. Server01\SQLExpress2008

Also (if using Windows Authentication mode) make sure the format of the username is as follows: Server-name\User-name. e.g. Server01\Administrator