You must be logged in to post a comment.
Kevin, thanks a lot for all your guides. Great work. Ur blog is now on my favorites
Thanks for this guide !!!!!!!!!!!
Great post to get start for DPM. Thanks Kevin. Your posts are great as usual
Great guide and part about SQL Studio Tools needing be on the DPM server was great since that component check fails when testing the db connection and gives no mention as to where it expected those tools to be loaded.
As always with your SC guides – Excellent!
Hi Kevin, great post, as usual. Here's my question: now that the SSRS instance can run from another machine that not the SQL where the DB is when DPM DB is clustered, do you know whether sharing an SSRS instance among a primary and a secondary DPM Server would be supported? I tested and it seems to work fine, since a new folder in the SSRS is created for each new DPM that points to it, but I wanted to be sure it is really an approved configuration.
Hey Kevin, I'm also having issues when picking a remote instance of SSRS. In the lab, everything works, but in production, there is a network firewall in between the servers. Port 80 is open, I can browse shares on the remote ssrs server from the DPM server, but there is something trying to use a high port that is not specified anywhere in the documentation. The doc here is not very thorough when you're using a SQL cluster, where the RPC can be a different server from the SQL server. So, when it says: "•Enable remote procedure calls (RPC) on the computer on which SQL Server is installed.", does this mean that all RPC communication needs to be in place? Then regular 1433 won't do it.
And in the real world, getting ports open between networks can take days…
Any help is appreciated.
Now that I'm past the firewall restrictions, DPM doesn't seem to like my production cluster. It says it is not clustered. I can log on to FOCM, I can connect to the DB, but DPM doesn't like it.
No reference to the error anywhere.
Mistery solved: if you don't have SQL Client tools installed, the setup program deals with the lack of it as proof that you're not running on a cluster. I figured it by looking at the DPMLog file:
* Exception : => System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Smo, Ve
After installing the SQL Management tools, setup went through.
Kevin, not sure you have seen this or whether you can ask somebody. I'm trying to configure DPM for SMTP notification. Nothing easier than that…you would think. Since I have 3 DPM servers, whose DBs are in a cluster and their SSRS instances are, hence, remote, when I try to save the SMTP info, it complains it can't save the info in the SSRS server. The error message, though, tells me to go to the SQL instance server (not the SSRS) and do the config, which really seems to assume, as it was before, that both should always be together.
One way or another, it doesn't seem to work. It is also funny that I have to have authentication set. I have tried some workarounds deleting registry keys, but it will send the notifications tests but will fail the actual notifications.
Hi There, I’ve been banging my head against the wall whilst trying to resolve this installation error from DPM2012 R2. My Test Lab setup: ================== 2 Servers – WS2012 R2 (VMs) 1 of them : Remote SQL Server (SQL Server 2012 Ent + sp1) Domain User
account for DPM installation has Local Admin rights on both Servers + SysAdmin rights on the Remote SQL Server. I have also been able to test login in to the Remote SQL Server from the DPM Server; and I have been able to create a test table in Target DB, even
though it seems that the errors are permissions related Below are the error messages that I have been receiving ======================================================= *** Error : Setup cannot grant the Test.localSuperTech account access to the DPM database.
Verify that SQL Server is properly installed and that it is running. ID: 832 More from logs ============== [17/02/2014 22:43:36] Data : instanceName = 2013-FARM-PLUS3DPM [17/02/2014 22:43:36] Information : Grant permissions on database [17/02/2014 22:43:36]
Data : Database connection string = Integrated Security=SSPI;server=2013-FARM-PLUS3DPM;Pooling=false;database=DPMDB_2013_FARM_PLUS2;Pooling=false [17/02/2014 22:43:36] Data : Account name = LoginName: Test.localSuperTech MakeDBAdmin: False [17/02/2014 22:43:36]
*** Error : SqlException in CreateSqlLoginAndGrantDBAccess [17/02/2014 22:43:36] * Exception : => System.Data.SqlClient.SqlException (0x80131904): Windows NT user or group ‘Test.localSuperTech’ not found. Check the name again. at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection, Action`1 wrapCloseInAction) and more ======== [17/02/2014 22:43:36] * Exception : => Setup cannot grant the Test.localSuperTech account access to the DPM database.Verify that SQL Server is properly installed and that it
is running.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException: exception —> Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.DatabaseConfigurationException: exception —> System.Data.SqlClient.SqlException: Windows
NT user or group ‘Test.localSuperTech’ not found. Check the name again. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) —————————- I have also saved the whole of
the error log and can email it if required. Any help to resolve this issue will be greatly appreciated.
Hi there, Ganafri5, Have you had any success? I have the exact same issue
Ganafri5, I found the solution. (Well mine at least) Up in the Error log I noticed it complained that it could not find my account on the SQL server. We have completely different Pre-Windows 2000 Domain Name and FQDN. eg. Pre2000 in NETWORK and FQDN is
company.com. You have to use Pre-2000 domain names everywhere in your setup/install procedures.
Eugene, I wasn’t able to rectify the error message. I opted to go for the easier route of installing DPM on a locally installed SQL Server instance instead. I will try it again at some point.
Additional Info: DPM Self Service Recovery – Installation step
I was not able to install this from the DPM2012 R2 iso on a Windows8 Pro client.
I kept on getting the same error:
“Windows installer – Not enough storage is available to process this command.”
This was despite having enough space at my disposal and the Windows Installer (Service) activated.
## Workaround: Install DPM Self Service Recovery from DPM2012 SP1 iso instead, works like a charm.
Thanks for this guide Kevin, much appreciated.
“Install the Central Console” section, what if I don’t have a SCOM server in the lab environment? Is this the same procedure?
Is it possible to host two SQL reporting services in same instance for SCDPM ?
To avoid error "Setup cannot grant the domaincomputer to the DPM database" in the part where DPM asks for a domain user that has sysadmin rights on the SQL server, do not enter your domain name in the format of ‘MyDomain.com’ instead just use ‘MyDomain’.
I just discovered a set of errors that didn’t really explain what was wrong, though I worked every related remedy. It looked like FW was an issue, then AV client. Even after disabling both it wouldn’t connect. It was only until I discovered the SQL Server
Agent service wasn’t running. I hope errors and related MS references get some refinements, but take a look at services. Ours had spontaneously failed to load despite proper config and service acct setups.
Thanks for this great post. I have a problem with the automatic creation of recovery points. I only use DPM, without SCOM. I can only recover files when I manually create a recovery point. Recovery points (and a synchronization just before) are scheduled
every night (can I see in de job window), but never conducted, without error message in de job window or event viewer. Can you help me? Thanks!
Kevin, in your post you seem to indicate that running SSRS on a separate server from the SQL instance is possible for DPM? "If you install Reporting Services on a stand-alone (no DBEngine) server, you will need to configure this manually". I don’t see
how it is possible to configure this during the DPM the install. Please see my post here on TechNet for more details:
ppejovic is right you do not want to select install and configure for you reports server, you want to install and configure later. what will happen it will create a Reports_(whatever you named DPM) and the DPM setup will not find the Reports server and
the installation will fail. I just wasted a full day on this.
Where do you get DPM? I’m not seeing anywhere you can download it from. There is an ‘entire’ VHD for a deployment but I don’t want that. I just want dpm.
You have to download it from the TechNet Evaluation Center web site, or from MSDN (if you have a subscription)
I ran into the 812 and 4387 errors during installation, but running the Reporting Services Config utility fixed that. But I wasn’t aware that you can’t install a DPM console without having SCOM in the environment. Is there a way to use DPM without SCOM at all?