|
Home > Archive > Microsoft Content Management Server > December 2004 > CMS connected to a named instance db
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
CMS connected to a named instance db
|
|
|
| Hi,
When I connect CMS to dbserver\instance1, CMS is read-only. Every attempt to
write to it from Site Manager failed. (the read-only box of the database is
not checked of course)
I then made a backup of the db and restored it on a db-server without named
instances and CMS was now able to write to the database.
Does CMS have a problem with named instances?
Best Regards,
Frank
| |
| Stefan [MSFT] 2004-12-23, 5:51 pm |
| Hi Ros,
no there are no such issues.
Maybe the system account does not have the db_datawriter permissions?
Cheers,
Stefan
"ROS" <ROS@discussions.microsoft.com> wrote in message
news:BD11A9D3-674D-46A1-BD88-C6A755F35687@microsoft.com...
> Hi,
>
> When I connect CMS to dbserver\instance1, CMS is read-only. Every attempt
to
> write to it from Site Manager failed. (the read-only box of the database
is
> not checked of course)
> I then made a backup of the db and restored it on a db-server without
named
> instances and CMS was now able to write to the database.
>
> Does CMS have a problem with named instances?
>
> Best Regards,
>
> Frank
| |
|
| Stefan,
I read something about case-sensitive named instances and problems with CMS.
But we did not change the collation to case sensitive, so that should not be
the problem. To fix things I created a whole new database on the
dbserver\instance1. I no longer experience problems when using CMS site
manager.
Could it be that the datase became inconsistent or something. And is it
possible to repair such a database?
Regards,
Frank
"Stefan [MSFT]" wrote:
> Hi Ros,
>
> no there are no such issues.
> Maybe the system account does not have the db_datawriter permissions?
>
> Cheers,
> Stefan
>
> "ROS" <ROS@discussions.microsoft.com> wrote in message
> news:BD11A9D3-674D-46A1-BD88-C6A755F35687@microsoft.com...
> to
> is
> named
>
>
>
|
|
|
|
|