数据库权限错误 [英] Database permission error

查看:87
本文介绍了数据库权限错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

Andy,


我是SQL新手。很难弄清楚如何安装它。


我知道我是以管理员身份登录的。在Windows中。


我的小服务器盒右下角有圆圈

角(工具栏)。 SQL Server服务管理器。


我试图在我的驱动器上搜索sp_helpsrvrolemember命令。它是

不在服务器上。


有什么想法吗?


有人有什么建议吗?


感谢您的帮助,

T


" Andy Svendsen" <一个******** @ NOMORESPAM.yahoo.com>在消息中写道

新闻:#3 ************** @ TK2MSFTNGP10.phx.gbl ...

Andy,

I am new to SQL. It was hard just to figure out how to install it.

I know I am logged in as a Admin. in Windows.

I have the little server box with the round circle on it in the bottom right
corner(toolbar). The SQL Server Service Manager.

I tried to search for the sp_helpsrvrolemember command on my drive. It''s
not on the server.

Any ideas?

Do anyone have any suggestions?

Thanks for your help,
T

"Andy Svendsen" <an********@NOMORESPAM.yahoo.com> wrote in message
news:#3**************@TK2MSFTNGP10.phx.gbl...

你是否正在联系可信连接或sa。听起来你没有创建数据库所需的访问权限。确保您作为该计算机上Administrators组的成员进行连接,以便
成为sysadmin(aka System Administrators)角色的一部分。最低
,您需要dbcreator角色级别访问权限。运行

sp_helpsrvrolemember '' 系统管理员 ''
- 或 -
sp_helpsrvrolemember'dbcreator ''

会告诉你谁属于这些角色。查看查询窗口
标题栏将告诉您登录的是谁。

< servername>。< database name>。< loginname>或< DOMAIN> \<用户名> (对于Win
NT身份验证)

重新启动并共享该文件夹无济于事。你可能想查看
NT权限。

-
********************** **************************** *****************
安迪S.
MCSE NT / 2000,MCDBA SQL 7/2000
***** ***@NOMORESPAM.yahoo.com

请在回复之前删除NOMORESPAM。

始终保持您的防病毒和Microsoft软件
最新最新的定义和产品更新。
怀疑每个电子邮件附件,我永远不会发送
或发布除http://链接文本以外的任何内容,也不会直接发布链接到一个文件供下载。

这个帖子是原样提供的。没有保证
并且不赋予任何权利。

****************************** ******************** *****************
太史 < TA ******** @ hotmail.com>在消息中写道
新闻:%2 **************** @ TK2MSFTNGP10.phx.gbl ...
Are you connecting with a trusted connection or as sa. It sounds like you
do not have the access required to create a database. Make sure you are
connecting in as a member of the Administrators group on that machine so you become part of the sysadmin (aka System Administrators) role. At a minimum you need the dbcreator role level access. Running

sp_helpsrvrolemember ''sysadmin''
-- or --
sp_helpsrvrolemember ''dbcreator''

will tell you who belongs to these roles. Looking at the Query window title bar will tell you who you are logged in as.

<servername>.<database name>.<loginname> or <DOMAIN>\<username> (for Win NT authentication)
Reboot and sharing the folder will not help. You might want to check the NT permissions though.

--
************************************************** *****************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
an********@NOMORESPAM.yahoo.com

Please remove NOMORESPAM before replying.

Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.

This posting is provided "as is" with no warranties
and confers no rights.

************************************************** *****************
"Taishi" <ta********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
Windows Pro

收到以下错误:

在数据库master中拒绝CREATE DATABASE权限。无法将数据库''pubs''附加到文件''D:\Program Files \ Microsoft Microsoft SQL
Server \ MSSQL $ NETSDK \Data \pubs.mdf''。

以下是尝试解决问题的一些事项:

重启4-5次
共享文件夹
Web共享文件夹
感谢您的帮助,
T.
Windows Pro

Receiving the following error:

CREATE DATABASE permission denied in database ''master''. Could not attach
database ''pubs'' to file ''D:\Program Files\Microsoft SQL
Server\MSSQL$NETSDK\Data\pubs.mdf''.

Here are some things done to try to resolve the problem:

Reboot 4-5 times
Shared out the folder
Web shared the folder
Thanks for your help,
T.



推荐答案

NETSDK \ data \pubs.mdf''。

以下是尝试解决问题的一些方法:

重启4-5次 Web共享文件夹

感谢您的帮助,
T.
NETSDK\Data\pubs.mdf''.

Here are some things done to try to resolve the problem:

Reboot 4-5 times
Shared out the folder
Web shared the folder
Thanks for your help,
T.




Taishi(ta********@hotmail.com)写道:
Taishi (ta********@hotmail.com) writes:
我试图在我的网站上搜索sp_helpsrvrolemember命令驾驶。它不在服务器上。
I tried to search for the sp_helpsrvrolemember command on my drive. It''s
not on the server.




正在搜索驱动器?那里你找不到它。这不是命令

您运行资源管理器或命令行窗口。


这是一个在SQL Server附带的查询分析器中运行的命令。

从查询分析器,您可以将任何T-SQL命令传递给SQL Server,并从中获取结果。


-

Erland Sommarskog,SQL Server MVP, so****@algonet.se


SQL Server SP3联机丛书
http://www.microsoft.com/sql/techinf...2000/books.asp


I我使用WIN XP专业版,SQL是MSDE。


如何查看我的访问权限?


如何解决以下错误? ?


数据库''master''中的CREATE DATABASE权限被拒绝。无法附加

数据库''pubs''到文件''D:\Program Files \ Microsoft SQL

Server \ MSSQL
I am using WIN XP Pro and the SQL is the MSDE.

How can I check my access?

How can I resolve the following error?

CREATE DATABASE permission denied in database ''master''. Could not attach
database ''pubs'' to file ''D:\Program Files\Microsoft SQL
Server\MSSQL

这篇关于数据库权限错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆