|
Home > Archive > Microsoft Content Management Server > April 2006 > CMS2002 and SQL 2005 Issues
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 |
CMS2002 and SQL 2005 Issues
|
|
|
| Since installing SQL Server 2005, I can't export .sdo packages from the
Site Manager. I have read about a hotfix, but it doesn't address my
situation exactly.
http://support.microsoft.com/default.aspx?id=913400 says that it is for
SQL Authentication, but when I run the DCA, it shows that I have a
Trusted Connection.
I run the DCA, click the Select Database button. It has the Trusted
Connection box checked. I click OK and I get the follwing error..
You do not have database owner (dbo) rights
[Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this
server you must use SQL Server Management Studio or SQL Server
Management Objects (SMO).
-2147165949
Microsoft SQL-DMO (ODBC SQLState: 42000)
I have gone into the database msmcs_repository and verified that the
credentials that I am logged onto the development machine with (myself)
have dbo rights.
Should I still try hotfix 931400?
| |
|
|
John wrote:
> Since installing SQL Server 2005, I can't export .sdo packages from the
> Site Manager. I have read about a hotfix, but it doesn't address my
> situation exactly.
>
> http://support.microsoft.com/default.aspx?id=913400 says that it is for
> SQL Authentication, but when I run the DCA, it shows that I have a
> Trusted Connection.
> I run the DCA, click the Select Database button. It has the Trusted
> Connection box checked. I click OK and I get the follwing error..
> You do not have database owner (dbo) rights
> [Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this
> server you must use SQL Server Management Studio or SQL Server
> Management Objects (SMO).
> -2147165949
> Microsoft SQL-DMO (ODBC SQLState: 42000)
>
> I have gone into the database msmcs_repository and verified that the
> credentials that I am logged onto the development machine with (myself)
> have dbo rights.
>
> Should I still try hotfix 931400?
| |
| Stefan [MSFT] 2006-04-01, 2:40 pm |
| Hi John,
there is another hotfix which is required:
http://download.microsoft.com/downl...6a/MCMS+2002+-+(complete)+FAQ.htm#AF0A8BBF-1488-450F-ADD1-E555312ADEC9
Cheers,
Stefan
--
This posting is provided "AS IS" with no warranties, and confers no rights
New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
Check out the new book as well: Advanced MCMS development:
http://tinyurl.com/8ugwj
----------------------
"John" <john.way@milliken.com> wrote in message
news:1143743928.739471.290530@g10g2000cwb.googlegroups.com...
>
> John wrote:
>
| |
|
| Stefan,
I have upgraded to MCMS 2002 SP2 and I have installed hotfixes 913400
and 913401. I wasn't sure if I had installed 913401 correctly, but when
I connected to my existing SQL Server 2000 database, it prompted me for
an upgrade and ran successfully, so I assume that I did it correctly.
Here is my new problem..
I am now trying to connect to database on SQL 2005. This SQL Server was
originally a SQL Server 2000 with a database built with the SP1a
version of CMS2002. It was migrated to SQL2005.
When I try to connect to the database using the DCA, I get an error,
"Unable to connect to database
[Microsoft][ODBC SQL Server Driver][SQL Server] To connect to this
server you must use SQL Server Management Studio or SQL Server
Management Objects (SMO).
55555
Microsoft SQL-DMO (ODBC SQLState:42000)"
I am using a sql server login that I created with db_owner,
db_ddladmin, db_datawriter and db_datareader.
Any ideas what I need to do to get connected?
Thanks,
John
Stefan [MSFT] wrote:[vbcol=seagreen]
> Hi John,
>
> just to add: you need to have all machines connecting to the same DB on the
> same service pack level.
> But SDO exports imports are compatible between the environments.
> Be aware that SQL 2005 is only supported with SP2 (and the hotfixes outlined
> in the earlier mails).
>
> Cheers,
> Stefan
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> New to MCMS?
> Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
> Check out the new book as well: Advanced MCMS development:
> http://tinyurl.com/8ugwj
> ----------------------
>
>
> "John" <john.way@milliken.com> wrote in message
> news:1143837131.514177.56740@i40g2000cwc.googlegroups.com...
| |
| Stefan [MSFT] 2006-04-27, 7:27 am |
| Hi John,
sounds as if the SQL Server 2005 client tools are not installed on this box.
Cheers,
Stefan
--
This posting is provided "AS IS" with no warranties, and confers no rights
New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
Check out the new book as well: Advanced MCMS development:
http://tinyurl.com/8ugwj
----------------------
"John" <john.way@milliken.com> wrote in message
news:1145464355.247993.60720@i39g2000cwa.googlegroups.com...
> Stefan,
>
> I have upgraded to MCMS 2002 SP2 and I have installed hotfixes 913400
> and 913401. I wasn't sure if I had installed 913401 correctly, but when
> I connected to my existing SQL Server 2000 database, it prompted me for
> an upgrade and ran successfully, so I assume that I did it correctly.
>
> Here is my new problem..
> I am now trying to connect to database on SQL 2005. This SQL Server was
> originally a SQL Server 2000 with a database built with the SP1a
> version of CMS2002. It was migrated to SQL2005.
>
> When I try to connect to the database using the DCA, I get an error,
> "Unable to connect to database
> [Microsoft][ODBC SQL Server Driver][SQL Server] To connect to this
> server you must use SQL Server Management Studio or SQL Server
> Management Objects (SMO).
> 55555
> Microsoft SQL-DMO (ODBC SQLState:42000)"
>
> I am using a sql server login that I created with db_owner,
> db_ddladmin, db_datawriter and db_datareader.
>
> Any ideas what I need to do to get connected?
>
> Thanks,
>
> John
>
> Stefan [MSFT] wrote:
>
|
|
|
|
|