Your reddot user doesnt have permission son teh sql server, make sure you have a user with the same name and password that you used to install reddot with in the sql server security.
When I install I always make sure I use the same username and password to create a local admin on both the cms server and the db server and also a sql user with the same name and password. The user in the DB should have sysadmin privileges. Check your user in the sql server has permissions. On Dec 18, 2:35 pm, Kang Lee <[email protected]> wrote: > 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.
