| Author |
 Topic  |
|
|
jajapuppy
Starting Member
9 Posts |
 Posted - 26 April 2008 : 15:55:41
|
Hi All,
Attempting a new instal
3.4.06
IIS6
SQL2005 SP2
Windows 2003 Server
Whenever I try the setup program I get this
Error: -2147217900 [Microsoft][ODBC SQL Server Driver][SQL Server]The specified schema name "dbo" either does not exist or you do not have permission to use it.
strSql: CREATE TABLE FORUM_CATEGORY ( CAT_ID int IDENTITY (1, 1) NOT NULL , CAT_STATUS smallint NULL , CAT_NAME nvarchar (100) NULL , CAT_MODERATION int NULL CONSTRAINT FORUM_SnitzC1020 DEFAULT 0, CAT_SUBSCRIPTION int NULL CONSTRAINT FORUM_SnitzC1021 DEFAULT 0, CAT_ORDER int NULL CONSTRAINT FORUM_SnitzC1022 DEFAULT 1 )
I have created a user with SQL authenticateion and asigned him into the db_owner schema and mapped fim to my database
What am I missing?
Thanks
Steve |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 26 April 2008 : 16:51:05
|
Did you also assign him db_owner role?
P.S.: Please use a title that conveys some information about your problem. I've changed the title, so that it's clear the type of problem you're facing. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
jajapuppy
Starting Member
9 Posts |
Posted - 26 April 2008 : 17:39:54
|
Appologies for the title. After several hours of battling, frustration was beginning to set in.
Yes I have. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 26 April 2008 : 18:59:35
|
Must say I never faced that situation. Usually giving a user db_owner role and default schema db_owner works without problems. Maybe try granting CONTROL permissions on the schema to your user:
GRANT CONTROL ON SCHEMA::db_owner TO YourUserName
As an alternative, you could create a new schema and assign that schema as the default one for the user:
CREATE SCHEMA NEW_SCHEMA AUTHORISATION YOURUSERNAME;
ALTER USER YOURUSERNAME WITH DEFAULT_SCHEMA = NEW_SCHEMA
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
jajapuppy
Starting Member
9 Posts |
Posted - 27 April 2008 : 04:17:24
|
Hi ruirib,
Thanks for your help. Neither of them worked, but they did give me an idea.
It turns out that what is happening is despite specifying a user name and password with create table permissions on the setup form, the code tries to still use the IUSR account. I agve the same permissions to IUSR as you suggested (which have now been removed again) and it has created the tables fine.
Thanks
Steve |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
