服务器资源管理器和SQL Server [英] Server Explorer and SQL Server
问题描述
有些东西搞砸了......
我使用的是MSDE,但我只是买了/安装了SQL Server而且东西
已经停止工作了。我曾经能够通过
VS2002(和VS2003)的服务器资源管理器窗口连接到服务器,从那里我可以添加/编辑
数据库,表格和存储过程。
安装SQL Server后,我已经读取/只能访问服务器。这是非常令人沮丧的
:-)
有没有人知道我可能没有正确设置?我已经将我的Windows帐户设置为SQL Server中的管理员,因此我应该拥有sa帐户所具有的所有权利。我不介意使用sa帐户甚至
但是我不相信服务器资源管理器以任何方式连接,除非使用当前的Windows帐户使用
。
现在我被困......任何想法?
谢谢,
Tom
Something is messed up...
I was using MSDE but I just bought/installed SQL Server instead and stuff
has stopped working. I used to be able to connect to the server through
VS2002 (and VS2003)''s Server Explorer window and from there I could add/edit
databases, tables and stored procedures.
Upon installing SQL Server I have read/only access to the server. This is
getting very frustrating :-)
Does anybody have any idea what I may have failed to set properly? I''ve set
my Windows account as an administrator in SQL Server so I should have all
the rights that the sa account does. I don''t mind using the sa account even
but I don''t believe that the Server Explorer connects in any way except by
using the current Windows account.
And now I''m stuck... any ideas?
Thanks,
Tom
推荐答案
嗨汤姆,
这可能是一个简单的调整,但我不喜欢不知道。我强烈建议您发布到microsoft.server.sqlserver.server
- 他们总是有我需要的sql
服务器答案。
伯尼
Tom Leylan < ge*@iamtiredofspam.com>在留言中写道
news:d7 ********************* @ twister.nyc.rr.com ...
Hi Tom,
It''s probably a simple tweak, but I don''t know it. I''d strongly recommend
you post to microsoft.server.sqlserver.server - they always have the sql
server answer I need.
Bernie
"Tom Leylan" <ge*@iamtiredofspam.com> wrote in message
news:d7*********************@twister.nyc.rr.com...
有些东西搞砸了......
我使用的是MSDE,但我只是买了/安装了SQL Server而且东西
已经停止工作了。我曾经能够通过VS2002(和VS2003)的服务器资源管理器窗口连接到服务器,从那里我可以
添加/编辑数据库,表格和存储过程。
<安装SQL Server后,我已经读取/只能访问服务器。这非常令人沮丧:-)
有没有人知道我可能没有正确设置?我已将
设置为Windows帐户作为SQL Server的管理员,因此我应该拥有sa帐户所具有的所有权限。我不介意使用sa账户
,但我不相信服务器资源管理器以任何方式连接,除非使用当前的Windows帐户。
现在我被困......任何想法?
谢谢,
Tom
Something is messed up...
I was using MSDE but I just bought/installed SQL Server instead and stuff
has stopped working. I used to be able to connect to the server through
VS2002 (and VS2003)''s Server Explorer window and from there I could add/edit databases, tables and stored procedures.
Upon installing SQL Server I have read/only access to the server. This is
getting very frustrating :-)
Does anybody have any idea what I may have failed to set properly? I''ve set my Windows account as an administrator in SQL Server so I should have all
the rights that the sa account does. I don''t mind using the sa account even but I don''t believe that the Server Explorer connects in any way except by
using the current Windows account.
And now I''m stuck... any ideas?
Thanks,
Tom
Bernie Yaeger <是***** @ cherwellinc.com>写道......
"Bernie Yaeger" <be*****@cherwellinc.com> wrote...
这可能是一个简单的调整,但我不知道。我强烈建议您发布到microsoft.server.sqlserver.server - 他们总是有我需要的sql
服务器答案。
It''s probably a simple tweak, but I don''t know it. I''d strongly recommend
you post to microsoft.server.sqlserver.server - they always have the sql
server answer I need.
谢谢伯尼......我现在已经发布了它。就像
一样复杂,这些日子里的一切都是它总是存在的东西。 :-)
Tom
Thanks Bernie... I''ve posted it over there now. As complicated as
everything is these days "it''s always something." :-)
Tom
我们严格使用SQL服务器进行SQL身份验证,而Server Explorer使用那么,所以它b / b
肯定会与windows auth以外的其他东西一起工作。
Tom Leylan < ge*@iamtiredofspam.com>在留言中写道
news:d7 ********************* @ twister.nyc.rr.com ...
We use SQL server strictly with SQL Authentication, and the Server Explorer works with that, so it
will definitely work with something other than windows auth.
"Tom Leylan" <ge*@iamtiredofspam.com> wrote in message
news:d7*********************@twister.nyc.rr.com...
有些东西搞砸了......
我使用的是MSDE,但我只是买了/安装了SQL Server而且东西
已经停止工作了。我曾经能够通过VS2002(和VS2003)的服务器资源管理器窗口连接到服务器,从那里我可以添加/编辑数据库,表格和存储过程。
<安装SQL Server后,我已经读取/只能访问服务器。这非常令人沮丧:-)
有没有人知道我可能没有正确设置?我已经将我的Windows帐户设置为SQL Server的管理员,因此我应该拥有sa帐户所具有的所有权利。我不介意使用sa帐户
但是我不相信服务器资源管理器以任何方式连接,除非使用当前的Windows帐户。
现在我被卡住......任何想法?
谢谢,
Tom
Something is messed up...
I was using MSDE but I just bought/installed SQL Server instead and stuff
has stopped working. I used to be able to connect to the server through
VS2002 (and VS2003)''s Server Explorer window and from there I could add/edit
databases, tables and stored procedures.
Upon installing SQL Server I have read/only access to the server. This is
getting very frustrating :-)
Does anybody have any idea what I may have failed to set properly? I''ve set
my Windows account as an administrator in SQL Server so I should have all
the rights that the sa account does. I don''t mind using the sa account even
but I don''t believe that the Server Explorer connects in any way except by
using the current Windows account.
And now I''m stuck... any ideas?
Thanks,
Tom
这篇关于服务器资源管理器和SQL Server的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!