SQL Server 2005 and any authenticated user access / guest account

What is the proper way to give any authenticated user access to a View
in SQL Server 2005?
I have a View that I would like to give any valid network
authenticated user access to so they can refresh a connected
PivotTable in Excel 2007.

I have given the guest account REFERENCES and SELECT rights to the
View and precursors (other views and 2 tables). I have also enabled
the [guest] account for this particular database. What am I missing?
Do I then have to do something to map a set of users to the [guest]
account?
Via Excel I get the error message:

Connection Failed:
SQL State: 42000
SQL Server Error: 18456
Login Failed for user 'SOMENET\SOMEUSER'

Thanks,
Kelly Greer
kellygreer1@xxxxxxxxxx
change nospam to yahoo





.

Relevant Pages

  • Re: SQL Server 2005 and any authenticated user access / guest account
    ... authenticated user access to so they can refresh a connected ... Do I then have to do something to map a set of users to the [guest] ... SQL Server Error: 18456 ... You can add the login for the user with the CREATE LOGIN command: ...
    (microsoft.public.sqlserver.security)
  • Re: public role???
    ... account existed for all these DBs. ... these users from viewing the master and tempdb DBs as well? ... then that's the way SQL Server ... >see if you have the "guest" account enabled in the other ...
    (microsoft.public.sqlserver.security)
  • Re: Cant Start Local Instance
    ... Thats ok unless your SQL Server will need Acces to your network or services ... -the service account to start SQL Server under (see above, ... > "guest" as the DefaultLogin? ... > I am confused regarding the login settings. ...
    (microsoft.public.sqlserver.setup)
  • Re: Cant Start Local Instance
    ... > changing the LogOn setting to "Local System ... > -the service account to start SQL Server under (see above, ... > database with the user guest. ...
    (microsoft.public.sqlserver.setup)
  • Re: Guest Account
    ... > I am trying to delete the guest account from the database: ... > tempdb and master, in SQL server. ... Is there a way to get rid of that account? ... You cannot delete 'Guest', ...
    (microsoft.public.sqlserver.security)
Quantcast