DAta base digram for navision database in SQL2005

Business Central/NAV Technical Forum
1

HI , As I am new in SQL 2005 …

My question is :

when i am trying to do database digram to navision database from SQL2005 …I am getting this message …

Database diagram support objects cannot be installed because this database does not have a valid owner '. To continue , first use the Files page of the database properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login , then add the database support objects

I don’t understand from the message …what i should do … Can you help me to let the database diagrm works ??

thank you

2

Hi,

Yesterday I installed few updates to SQL Server 2005, (update 387424) and after that I am also getting this error.

Run the following SQL query and try after that:

USE [master]
EXEC sp_dbcmptlevel ‘DatabaseName’, ‘90’;
ALTER AUTHORIZATION ON DATABASE::“DatabaseName” TO “UserName”
EXECUTE AS USER = N’dbo’ REVERT

Though this didn’t help me, I will dig and find out the solution and let you know

3

Hi Jouhayna,

Can you let me know your SQL Server version?

SQL Server Management Studio>> Help>> About

Mine is

Microsoft SQL Server Management Studio 9.00.3042.00.

I reverted back to earlier version, which was 9.00.1300 and then I was able to make Database Diagram.