数据库权限错误 [英] Database permission error
问题描述
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屋!