469,632 Members | 1,698 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,632 developers. It's quick & easy.

what level of server access is required in order to view tables with Server Explorer?

I want to get an ASP.Net hosting account with my ISP, and I'm trying
to find out what level of access to the server is requried in order
for me to view the server in Server Explorer in Visual Studio .Net,
where you can see the available database, expand it to get a list of
tables, etc. What level of access is required? Of course you need to
have an account with the right user rights, but is there some specific
service that needs to be running on the remote server in order to
browse it with Server Explorer?

My ISP tech support didn't seem to know much about it, but they said
that people who did ASP.Net hosting with them were able to browse the
tables hosted on the server using "MS Enterprise Manager" (did he mean
SQL Enterprise Manager?). Is the type of access required to browse
remotely with Enterprise Manager, the same as the type of access
required to browse remotely with Server Explorer -- so if other
customers are able to use Enterprise Manager, then I'll probably be
able to use Server Explorer?
Jul 19 '05 #1
1 2351

Hi Bennett, If you have Public access to a SQL Server Database then you can
add a "Database Connection" in Server Explorer to this database. You can
use SQL or NT authentication to configure your connection. The
functionality provided thru this Database connection is similar to that of
SQL Enterprise Manager and thus requires the same permissions for Database
objects. For e.g. you will be able to list tables for which you have SELECT
rights. Also the Servers node in Server Explorer does not required any
particular service on machines but you will get access to different
features based on your rights. Specifically for Databases you can just make
data connections if you have access to the Database and not to the actual
Server. Thanks.

--------------------
From: be*****@peacefire.org (Bennett Haselton)
Newsgroups: microsoft.public.dotnet.general
Subject: what level of server access is required in order to view tables with Server Explorer?Date: 14 Jul 2003 17:02:49 -0700
Organization: http://groups.google.com/
Lines: 17
Message-ID: <e6**************************@posting.google.com >
NNTP-Posting-Host: 4.41.85.142
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1058227370 6835 127.0.0.1 (15 Jul 2003 00:02:50 GMT)X-Complaints-To: gr**********@google.com
NNTP-Posting-Date: 15 Jul 2003 00:02:50 GMT
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed 00.sul.t-online.de!t-onlin
e.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-03!sn-xit-01!sn-
xit-09!supernews.com!postnews1.google.com!not-for-mailXref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.general:101144
X-Tomcat-NG: microsoft.public.dotnet.general

I want to get an ASP.Net hosting account with my ISP, and I'm trying
to find out what level of access to the server is requried in order
for me to view the server in Server Explorer in Visual Studio .Net,
where you can see the available database, expand it to get a list of
tables, etc. What level of access is required? Of course you need to
have an account with the right user rights, but is there some specific
service that needs to be running on the remote server in order to
browse it with Server Explorer?

My ISP tech support didn't seem to know much about it, but they said
that people who did ASP.Net hosting with them were able to browse the
tables hosted on the server using "MS Enterprise Manager" (did he mean
SQL Enterprise Manager?). Is the type of access required to browse
remotely with Enterprise Manager, the same as the type of access
required to browse remotely with Server Explorer -- so if other
customers are able to use Enterprise Manager, then I'll probably be
able to use Server Explorer?


-Abhishek
VS .Net Data Tools, Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Elham.Ghoddousi | last post: by
47 posts views Thread by Neal | last post: by
121 posts views Thread by typingcat | last post: by
26 posts views Thread by Lasse Edsvik | last post: by
7 posts views Thread by Zach | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.