The error message:
2705,”42S21″,[Microsoft][ODBC SQL Server Driever][SQL Server]Column names in each table must be unig. Column name ’securityoption’ in table ‘dbo.$ndo$dbproperty’ is specified more than once.
SQL:
ALTER TABLE [dbo].[$ndo$dbproperty] ADD securityoption INTEGER NOT NULL DEFAULT 0
Unfortunately, this error occurs quite often when “converting” a database. The problem is, that the field “securityoption” is added to the table “$ndo$dbproperty” in the beginning of a conversion. Once the upgrade fails, the transactions are not completely rolled back, the field “securityoption” still remains. Now if you try to convert again, this error is raised, because C/SIDE tries to add this column again.
To solve this, you have to delete the field “securityoption” manually from the table “$ndo$dbproperty” via Management Studio and run the conversion again.
This happens in Vista when you try to create a database in microsoft sql 2008. The reason is that by default the administrator account does not have enough rights.
The solution is to grant rights to the administrator
Step 1: Go to Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration.
Step 2: Click on ‘Add New Administrator’.
Step 3: In the ‘SQL Server User Provisioning on Vista’ dialog box, look out for the ‘Member of the SqlServer SysAdmin role ‘ in the ‘Available Privileges’ box. Transfer it to the ‘Privileges that will be granted to’ box. Click Ok.
and at last
Control Panel->User Accounts->Turn User Account Control on or off. turn it off and try again
To set the trace flag
Step 1. Open SQL Server Configuration Manger.
Step 2. In the left pane, click SQL Server 2005 Services.
Step 3. In the right pane, right-click SQL Server (MSSQLSERVER), and on the shortcut menu, click Properties.
Step 4. In the Properties window, click the Advanced tab.
Step 5. Click the Startup Parameters property, and open the drop-down list.
Step 6. Type ;-T4616 at the end of the line in the drop-down list and click OK.
Step 7. In the right pane, right-click SQL Server (MSSQLSERVER), and on the shortcut menu, click Restart..
