adp connection to msde and exclusive rights

I am attempting to create a View from MS Access 2000 SR-1 to an MSDE 2000
(SQL Server 2000 Desktop Engine) database . I accessed with exclusive rights
but I get the following error when trying to create a view:
"You do not have exclusive access to the database at this time. Your design
changes will not be saved."
how can I get ability to create views ?
I'd recommend not using Access as a development tool for SQL Server
objects. Use the Query Analyzer or Enterprise Manager instead. The
error message you're getting is an Access error, not a SQL Server
error.
--Mary
On Thu, 24 Jun 2004 01:08:50 -0700, "TJS" <nospam@.here.com> wrote:

>I am attempting to create a View from MS Access 2000 SR-1 to an MSDE 2000
>(SQL Server 2000 Desktop Engine) database . I accessed with exclusive rights
>but I get the following error when trying to create a view:
>"You do not have exclusive access to the database at this time. Your design
>changes will not be saved."
>how can I get ability to create views ?
>
|||Hi Mary:
Thanks for replying (I have your book, Developer's guide to SQL Server).
Unfortunately, I don't have the Query Analyzer or Enterprise Manager , so I
was hoping to use access as a front end.
is there any way access can be a front end to msde ?
"Mary Chipman" <mchip@.online.microsoft.com> wrote in message
news:n74md01glum1t5l2c79ak6sjmj11sct03m@.4ax.com... [vbcol=seagreen]
> I'd recommend not using Access as a development tool for SQL Server
> objects. Use the Query Analyzer or Enterprise Manager instead. The
> error message you're getting is an Access error, not a SQL Server
> error.
> --Mary
> On Thu, 24 Jun 2004 01:08:50 -0700, "TJS" <nospam@.here.com> wrote:
rights[vbcol=seagreen]
design
>
|||MSDE is not a development platform, it's a deployment platform. I would
suggest that you spend the <$50 required to purchase SQL Server Developer
Edition. It contains everything you'll need to develop for the SQL Server
and MSDE platforms (really the same thing).
I'll even go out on a limb and predict that Mary will say the same thing.
:-)
Yes, you can use Access as a front end to MSDE, but you'll likely find the
tools she mentioned easier to use to create and manage your database.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"TJS" <nospam@.here.com> wrote in message
news:10dm523btum1rd5@.corp.supernews.com...
> Hi Mary:
> Thanks for replying (I have your book, Developer's guide to SQL Server).
> Unfortunately, I don't have the Query Analyzer or Enterprise Manager , so
I[vbcol=seagreen]
> was hoping to use access as a front end.
> is there any way access can be a front end to msde ?
>
>
> "Mary Chipman" <mchip@.online.microsoft.com> wrote in message
> news:n74md01glum1t5l2c79ak6sjmj11sct03m@.4ax.com...
2000
> rights
> design
>
|||I just want to create a view...
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:OBa0OViWEHA.2844@.TK2MSFTNGP11.phx.gbl...
> MSDE is not a development platform, it's a deployment platform. I would
> suggest that you spend the <$50 required to purchase SQL Server Developer
> Edition. It contains everything you'll need to develop for the SQL Server
> and MSDE platforms (really the same thing).
> I'll even go out on a limb and predict that Mary will say the same thing.
> :-)
> Yes, you can use Access as a front end to MSDE, but you'll likely find the
> tools she mentioned easier to use to create and manage your database.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "TJS" <nospam@.here.com> wrote in message
> news:10dm523btum1rd5@.corp.supernews.com...
so
> I
> 2000
>

Administrators

I would like that local administrators or domain administrators dont have
administrative rights on some databases running with MSDE.
I've learned about to enable the user "sa" and to give a personal password
to this user, but apparently administrators continue having full access to
all databases.
Thanks.
Regards.
Jose Nuez
Montevideo - Uruguay
hi Jose,
"Jose Nuez" <josenunez70@.hotmail.com> ha scritto nel messaggio
news:OOeUxFovEHA.164@.TK2MSFTNGP10.phx.gbl
> I would like that local administrators or domain administrators dont
> have administrative rights on some databases running with MSDE.
> I've learned about to enable the user "sa" and to give a personal
> password to this user, but apparently administrators continue having
> full access to all databases.
> Thanks.
> Regards.
> Jose Nuez
> Montevideo - Uruguay
Hari already answered you in june.. http://tinyurl.com/4638l and gave you
additional pointers to troubles you could experience..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

administrator rights

This doesn't seem to have anything to do with SQL Server Reporting Services, but to answer your question you are probably a limited user.

Go to control panel and click User Accounts. Click on your user account from the list of users. Then click "change the account type". Next, select Computer Administrator.

Admin rights to Report Manager disappeared...?

Hi,
Out of the blue I have lost administration rights to RS Report Manager. I
can no longer access several reports (others do work). When I connect to the
Report Manager the GUI is displayed, but I can't access all of the usual tabs
(ie. under the properties tab I can only see the 'General' and 'Security'
options, nothing else.)
I've tried accessing Report Manager via a client with domain admin rights
and via the RS server with local admin rights still the same problem...
Can anybody get me started on troubleshooting?
Kind Regards,
Casey.Casey,
I had this same problem...everything worked fine and then out of the
blue I couldn't update reports, deploy new reports, log into Report
Manager. I discovered that in Computer Management console when I Right
clicked on Default Web Site and went into Properties, then Directory
Security, then clicked on Anonymous Access and Authentication control,
and clicked the Edit button, that I did have Anonymous Access set.
When I tried to remote into that web server and perform changes I was
getting logged in as the anonymous user account with the limited rights
I gave that account. After hours when I'm working on the web server
now, I turn the anonymous option off, Restart IIS and do my
work...finally with the proper rights.
I hope this helps...
Jeff