How to create database on SQL?

  • Thread starter Thread starter wdsnews
  • Start date Start date
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.
 
The first thing you should check is whether you have permission to create
databases on the SQL Server.

HTH
Van T. Dinh
MVP (Access)
 
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.
 
Back
Top