473,714 Members | 2,552 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2629

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*****@peacefi re.org (Bennett Haselton)
Newsgroups: microsoft.publi c.dotnet.genera l
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**********@go ogle.com
NNTP-Posting-Date: 15 Jul 2003 00:02:50 GMT
Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!new sfeed00.sul.t-online.de!t-onlin
e.de!news-spur1.maxwell.s yr.edu!news.max well.syr.edu!sn-xit-03!sn-xit-01!sn-
xit-09!supernews.co m!postnews1.goo gle.com!not-for-mailXref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.genera l:101144
X-Tomcat-NG: microsoft.publi c.dotnet.genera l

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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2308
by: Elham.Ghoddousi | last post by:
How can I implement "Row Level Security" in SQL Server 2000? Thanks alot.
47
9145
by: Neal | last post by:
Patrick Griffiths weighs in on the CSS vs table layout debate in his blog entry "Tables my ass" - http://www.htmldog.com/ptg/archives/000049.php . A quite good article.
121
10107
by: typingcat | last post by:
First of all, I'm an Asian and I need to input Japanese, Korean and so on. I've tried many PHP IDEs today, but almost non of them supported Unicode (UTF-8) file. I've found that the only Unicode support IDEs are DreamWeaver 8 and Zend PHP Studio. DreamWeaver provides full support for Unicode. However, DreamWeaver is a web editor rather than a PHP IDE. It only supports basic IntelliSense (or code completion) and doesn't have anything...
1
292
by: Bennett Haselton | last post by:
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...
3
3302
by: Br | last post by:
I'm going to go into a fair bit of detail as I'm hoping my methods may be of assistance to anyone else wanting to implement something similar (or totally confusing:) One of systems I've developed has three levels of security. Admins - can see all records Manager - can only see records based on an organisation structure held in a table (simple tree structure) Employee - can only see own records
26
4474
by: Lasse Edsvik | last post by:
Hello I'm trying to build a simple COM+ app in vs.net using C# and i cant register it in component manager..... what more is needed than this: using System; using System.EnterpriseServices;
7
1442
by: Zach | last post by:
The formatting system of my HD is NTFS. When I right click on a file in Windows Explorer, I get a Properties Window with only two tabs: "General" and "Summary". I don't get a Security Tab, allowing me to set access permission. Given that the formatting system is NTFS, why am I not seeing the required tab, and why am I not seeing the appropriate Properties form? Please assist.
1
2668
by: Friends | last post by:
Hi I need to set security for row level but not based on Database user's login. It should be based on the user table login. For the particular user I need to allow only the particular records to access insert, update delete and select. Let me explain clearly For example think we are using asp/asp.net website
4
29167
by: Jer | last post by:
I am using Access 2003 as a front-end to a SQL Server 2005 database. I make design changes using SQL Server Management Studio. I have a table that includes a datetime column. I create a view and sort by the datetime field. When I initially look at the result it is sorted correctly. Then I save the view and re-open it and it is not sorted. I've simplified the view so it only contains the date field and it still does not sort. Here is...
0
8801
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8707
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9174
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9015
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7953
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5947
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4464
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
2520
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2110
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.