How to create database on SQL?

W

wdsnews

I'm new to both Access and SQL Server. I think I'm having a permissions
problem.

The 'New Project' wizard in Access gives me this error message when I
attempt to create a new project:

"An error occurred while trying to create the database; the wizard can't
continue. (Server Error 262: CREATE DATABASE permission denied in database
'Master'.) Your ADP file will not be connected to a server database."

I'm using Access 2002 sp2 on WinXP over a LAN to SQL 2000 on Microsoft Small
Business Server 2000.

As usual, a search of Microsoft's Knowledgebase reveals nothing about
"Server Error 262" or any of the other word phrases in the error message.

Thanks for your gentle help.
 
V

Van T. Dinh

The first thing you should check is whether you have permission to create
databases on the SQL Server.

HTH
Van T. Dinh
MVP (Access)
 
W

wdsnews

Now it works. I don't know why. I don't why it didn't work. I don't why
it works now. I spent hours logging in as various users, checking
permissions, using Query Analyzer as 'sa', using Query Analyzer as a domain
user, etc.

All I can say is here's yet another thing that works intermittently and
returns error messages that Microsoft fails to document.
 
Top