SQL Error

[Kang Lee]

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

[TonyGayter]

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.