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

[Bennett Haselton]

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 Lal]

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: (e-mail address removed) (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: <[email protected]>
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: (e-mail address removed)
NNTP-Posting-Date: 15 Jul 2003 00:02:50 GMT
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.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-mail
Xref: 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.