|
Home > Archive > MS Access project with SQL Server > June 2005 > Re: data provider could not be initialized
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: data provider could not be initialized
|
|
| Kevin3NF 2005-06-10, 11:24 am |
| Are the Domain users added as SQL Server logins? Its recognizing them, but
telling them to go away...
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Aubrey" <miscuates@online.nospam> wrote in message
news:995F10F1-C51F-4820-8E77- 450573B7CC56@microso
ft.com...
> Help needed to connect ADE. There are several posts directly addressing
> this
> issue when I do an MSDN Search, but NO answers, yet. Try "data provider
> could not be initialized" ...
>
> Deploying Runtime ADE via MOD 2002 Packaging Wizard against (local)
> MSDERelA
> Anonymous Merge Pull Subscription on Windows XP Pro Notebooks using
> Windows
> Authentication. ...\Setup SAPWD="<averystrongpassword>"
>
> Added Module modCopyConnect (adapted from Northwind/KB) to Establish
> Connection:
> Public Function fStartUp(strDBName As String, strMDFName As String, _
> Optional strUN As String, Optional strPW As String)
>
> Works GREAT, for Administrators.
> Does NOT connect Users.
>
> Errors:
>
> -2147024891: [SQL-DMO][Service Control Error: Access is denied.
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> '<domain>\<user>'.
>
> -2147217843: Login failed for user '<domain>\<user>'.
>
> OR (non-verbose error handler)
>
> Data provider could not be initialized.
>
>
> I have tried all sorts of NTFS Security settings on the Laptops, including
> adding Everyone to MSSQL\Data folder
>
>
> --
> Aubrey Kelley
| |
| Aubrey 2005-06-10, 11:24 am |
| That would be counter-productive. Why explicitly massage MSDE when I am using
Windows Authentication throughout?
--
Aubrey Kelley
"Kevin3NF" wrote:
> Are the Domain users added as SQL Server logins? Its recognizing them, but
> telling them to go away...
>
> --
> Kevin Hill
> President
> 3NF Consulting
>
> www.3nf-inc.com/NewsGroups.htm
>
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
>
> "Aubrey" <miscuates@online.nospam> wrote in message
> news:995F10F1-C51F-4820-8E77- 450573B7CC56@microso
ft.com...
>
>
>
| |
| Kevin3NF 2005-06-10, 1:24 pm |
| Because Domain\Aubrey cannot get to SQL Server (or MSDE) unless
Domain\Aubrey has been granted the rghts to do so. Ideally, you would be
creating a group in AD that you add as a SQL login and grant the appropriate
permissions to the database
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Aubrey" <miscuates@online.nospam> wrote in message
news:CA8397B5-DA1E-497D-947E- 49BD90BBBFDC@microso
ft.com...[color=darkred]
> That would be counter-productive. Why explicitly massage MSDE when I am
> using
> Windows Authentication throughout?
> --
> Aubrey Kelley
>
>
> "Kevin3NF" wrote:
>
| |
| Aubrey 2005-06-10, 8:25 pm |
| Thanks, Kevin-
So, AD is hosted on SBS2K3 Premium ...
How are stored Administrator and User Profiles different, such that
occasionally connected notebook WORKS for Admin, but NOT User? I did not see
anything in the GPO's that looks related.
--
Aubrey Kelley
"Kevin3NF" wrote:
> Because Domain\Aubrey cannot get to SQL Server (or MSDE) unless
> Domain\Aubrey has been granted the rghts to do so. Ideally, you would be
> creating a group in AD that you add as a SQL login and grant the appropriate
> permissions to the database
>
> --
> Kevin Hill
> President
> 3NF Consulting
>
> www.3nf-inc.com/NewsGroups.htm
>
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
>
> "Aubrey" <miscuates@online.nospam> wrote in message
> news:CA8397B5-DA1E-497D-947E- 49BD90BBBFDC@microso
ft.com...
>
>
>
|
|
|
|
|