We have CMS version 9 and used MS SQL as its database. When we try to create a new project, we get an error says "Project: CreateProjectDatabase: RdConnection: Error # -2147217900 Generated by Microsoft OLE DB Provider for SQL Server Execute Description CREATE TABLE permission denied in database 'Team project'. Create Table IO_AME( AME0 varchar (32) NOT NULL , AME1 nvarchar (255) NULL , AME2 int NULL , AME3 int NULL , AME4 varchar (32) NOT NULL , AME5 int NULL ) ON [PRIMARY] ADO Error # -2147217900 NativeError 262 Description CREATE TABLE permission denied in database 'Team project'. Source Microsoft OLE DB Provider for SQL Server RdConnection: Error # -2147217900 Generated by Microsoft OLE DB Provider for SQL Server Execute Description CREATE TABLE permission denied in database 'Team project'. Create Table IO_AUT( AUT0 varchar (32) NOT NULL , AUT1 nvarchar (255) NULL , AUT2 varchar (32) NULL , AUT3 varchar (32) NULL , AUT4 varchar (32) NULL , AUT5 int NULL , AUT6 int NULL ) ON [PRIMARY] ADO Error # -2147217900 NativeError 262 Description CREATE TABLE permission denied in database 'Team project'. Source Microsoft OLE DB Provider for SQL Server RdConnection: Error # -2147217900 Generated by Microsoft OLE DB Provider for SQL Server Execute Description CREATE TABLE permission denied in database 'Team project'. Create Table IO_BIN( BIN0 varchar (32) NOT NULL , BIN1 nvarchar (255) NULL , BIN2 image NULL , BIN3 float NULL , BIN4 float NULL , BIN5 varchar (255) ....". Looks like it is a database related project. Could it because we set up something wrong in CMS setting or something changed by our DBA?
Thanks -- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/reddot-cms-users?hl=en.
