Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alyno
Starting Member
1 Post |
 Posted - 2005-06-21 : 07:40:52
|
Hello!I'm writing from Italy, so please excuse my poor english (and approssimatives translations too) I'm working in a Sharepoint Services Environment and it's the first time I use SQL Server 2000 (Usually I've been working with MySQL or Access). My problem is that I can't create tables! I get the error:ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The DDL instruction is not allowed. (it's a translation: I use an italian version of SQL Server)In order to explain my situation this is a list of what I've done / what I use:- Windows Server 2003 + SQL Server 2000 SP4 + Sharepoint Services SP1;- I've installed Sharepoint which installed MSDE to create its own DB;- then I've installed SQL Server and linked it to the Sharepoint DB on the same machine (server/SPdb);- I try to create a new table in the Sharepoint DB but I get the above error;- I've been using Enterprise Manager, a CREATE TABLE query in Query Analyzer and Web Data Administrator: allways got the same error- I can create new DB but even in those I can't creae table;- I've tryed to log as local user, local admin, domain user (with admin privileges) and even domain admin;- Sql authentication is "Windows Only";- on the DB I would use there are the users: dbo, guest, NT AUTHORITY\NET SERVICE and my account (Server\username);- these two last have roles public, db_owner and db_ddladmin;- access account (I don't know the right translation...it's on Enterprise Manager's tree under the db list -> Security?) are BUILTIN\Administrators, NT AUTHORITY\NET SERVICE and my account with server access granted;- I've even executed a GRANT ALL TO server\myaccount query, got no errors, but CREATE TABLE wont work!I think it's a security problem and I guess it should be rather easy to solve, but I really can't figure out how!Thx for any suggestionAle |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-21 : 07:47:21
|
| Can you post the actual DDL statement you're trying to run? |
 |
|
|
|
|
|
DDL instruction not allowed