Errore Database Diagram SqlServer

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 diagram support
objects.

Se aprendo il Diagram di Microsoft SqlServer vi appare una cosa simile, la soluzione è la seguente :

EXEC sp_dbcmptlevel '$NOMEDB', '90';

ALTER AUTHORIZATION ON DATABASE::$NOMEBD TO "$NOMEMACCHINA\$USERNAME"

Naturalmente sostituendo :

  • $NOMEDB con il nome del database in cui risiedono i diagram;
  • $NOMEMACCHINA con il nome del vostro pc (lo trovate in "Propriet√† del sistema > Nome computer > Nome completo computer");
  • $USERNAME con il vostro username che inserite nel momento del login al pc.

Error when you try to install SQL Server Express: The SQL Server service failed to start

When you try to install Microsoft SQL Server 2005 Express Edition or Microsoft SQL Server Express Edition with Advanced Services, you receive the following error message:

The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

To work around this problem, grant the Network Service account the Full Control permission on the Protect folder. To do this, follow these steps:

  1. Open My Computer.
  2. Type C:\Documents and Settings\NetworkService\Application Data\Microsoft in the address bar, and then press ENTER.
  3. Right-click the Protect folder, and then click Properties.
  4. In the folder Properties dialog box, click the Security tab.
  5. Under Group or user names, determine whether NETWORK SERVICE is listed. If NETWORK SERVICE is not listed, follow these steps to add this account:
    1. Click Add to show the Select Users or Groups dialog box.
    2. Click Locations, select your computer name in the Locations dialog box, and then click OK to return to the Select Users or Groups dialog box.
    3. Type Network Service in the Enter the object names to select box, and then click Check Names.
    4. Click OK to close the Select Users or Groups dialog box.
  6. Click NETWORK SERVICE under Group or user names, and then click to select the Allow check box for Full Control under Permissions for NETWORK SERVICE.
  7. Click OK to close the folder Properties dialog box.
  8. Click Retry in the error message dialog box to continue to install SQL Server Express Edition or SQL Server Express Edition with Advanced Services.

Tratto dall'articolo: http://support.microsoft.com/kb/920114/en-us/

Site Search

Who's Online

Abbiamo 13 visitatori e nessun utente online

Stats

Visite agli articoli
161150
banner mym
banner mym