RE: Trouble connecting user with MS Access adp to SQL Server 2000

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 01/26/04 

Date: Mon, 26 Jan 2004 19:54:58 GMT

It sounds like JT or the group "Power users" was never added as a SQL
Server login;

Execute this statement as a stored proc for SQL.

Exec sp_grantlogin [BUILTIN\power users]

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Relevant Pages

  • Re: full-text contains * issue
    ... You may also want to consider using a stored proc for this situation as it ... EXEC usp_FTSearchPubsInfo '' ... > no data but was concatenation of the fields I wanted to index. ... > This is the SQL ...
    (microsoft.public.sqlserver.fulltext)
  • Re: dt_verstampxxx
    ... EXEC sp_helptext 'dt_verstamp007' ... SQL Server MVP ... > What is this stored proc used for? ... > public permissions. ...
    (microsoft.public.sqlserver.server)
  • Re: Full text catalog just not populating
    ... exec sp_defaultdb N'NT Authority\System', N'master' ... means either the network guys in my company who don't know SQL but are admins ... > needs this login to log into SQL Server and you can either add back this ... >> fetching U ...
    (microsoft.public.sqlserver.fulltext)
  • RE: Inserting/deleting data in table in multiuser environment
    ... Add a field to the table in the SQL DB? ... Capture the value to a variable before you send it to the stored proc, ... I did create a table in a front-end to just copy data from that table on SQL ... the stored procedure will be running each time with report generation anyway. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Indexing delay for one row.
    ... script and WAITFOR and varying the delay from 1 to 18 seconds. ... could you confirm your exact version of SQL Server that you are seeing ... It is possible that a change was made to the pooling frequence under SP3 to ... exec sp_fulltext_table 'FTSTable','create','FTSCatalog','FTSTable_IDX' ...
    (microsoft.public.sqlserver.fulltext)