By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,144 Members | 872 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,144 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a

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.