Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
micklowe
Starting Member
4 Posts |
 Posted - 2010-03-05 : 11:58:21
|
| Hi,First post so hello everyone.I have a small problem configuring the DPM backups for SQL server. I was led to believe that TCP was the fasted protocol for SQL to use with applications (is this correct?), I removed the shared memory option from the protocols in SQL config manager and everything seemed to work ok except the DPM backup failed on all the SQL databases. The error seemed to be related to VSS, not sure why. I've been back in and enabled the shared memory option again and the backups now work ok. Anyone know what the issue is?ThanksMick |
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-03-07 : 00:22:41
|
| http://support.microsoft.com/kb/919023Judging from that article it looks like it is probably an authentication issue and the VSS service account cannot connect to the SQL Server except through shared memory. Of course it's after midnight where I am, so someone correct me if I am wrong. |
 |
|
|
micklowe
Starting Member
4 Posts |
Posted - 2010-03-08 : 12:10:18
|
| Does this mean it cannot be configured to run without shared memory on? |
|
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-03-09 : 11:11:57
|
| No, if I understand the article correctly the VSS service needs to have a login account that is able to access resources on the SQL Server. In it's default configuration VSS uses a system account. |
|
|
|
micklowe
Starting Member
4 Posts |
Posted - 2010-03-10 : 08:56:12
|
| So moving to an admin account might be an option? |
|
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-03-10 : 09:04:58
|
| I believe so. A domain account with *local* admin rights. I would say read that article and some other KBs on VSS. If you have any sort of support agreement for DPM talk to your VAR or even MS directly. If you use VMware or Hyper-V you might want to try in a test environment first. |
|
|
|
micklowe
Starting Member
4 Posts |
Posted - 2010-03-11 : 06:40:55
|
| Ok, thanks for the help, much appreciated. |
|
|
|
|
|
|
SQL and DPM