ADE: data provider could not be initialized

A

Aubrey

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
 
A

Aubrey

That would be counter-productive. Why explicitly massage MSDE when I am using
Windows Authentication throughout?
--
Aubrey Kelley


Kevin3NF said:
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 said:
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
Click to expand...
Click to expand...
 
K

Kevin3NF

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 said:
That would be counter-productive. Why explicitly massage MSDE when I am
using
Windows Authentication throughout?
--
Aubrey Kelley


Kevin3NF said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
A

Aubrey

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 said:
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 said:
That would be counter-productive. Why explicitly massage MSDE when I am
using
Windows Authentication throughout?
--
Aubrey Kelley


Kevin3NF said:
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


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
Click to expand...
Click to expand...
Click to expand...
 
V

Vadim Rapp

Hello Aubrey,

A> I have tried all sorts of NTFS Security settings on the Laptops,
A> including adding Everyone to MSSQL\Data folder

That's not how security of sql server works. Users don't work directly with
the database files. You need to learn what is database server, how it works,
and how security is set up in it. Read Books Online that are installed with
sql server.

Vadim
 
A

Aubrey

You are so right, about SQL permissions being intrinsic, not extrinsic.

Still, how to apply and what credentials are needed in the Notebook
described: MSDERelA with ADE Front End? Are they applied to the SQL Server
instance, or to the Subscription Database?
 
K

Kevin3NF

SQL Server security is two-layered:

You create a login..this gets your user access to the SQL Server.

Step two is to give that user access to the database(s) you want with the
privilege level you want. Typically this is done by assigning them to a
database role that has already been granted permissions.

--
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
 
A

Aubrey

So, it is a Windows Authentication issue?
How/Where do I add the necessary permissions to all Users?
Can that be GPO'd?

"You create a login.." ... almost there? Thanks for the pointers

I created a "Test.UDL" on the target Desktop, moved it to ...All Users with
Everyone Permissions. It finds and connects to MSDERelA with both Windows and
Sql authentication when logged on as Administrator, but NOT as User.
Error: cannot connect invalid login

TEST.UDL
[oledb]
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;User ID=user;Initial Catalog=CareSQL50207;Data Source=ABITKG7R
 
K

Kevin3NF

The reason it works as admin is likely that the SQL Server (MSDE) likely has
a group called Builtin\Administrators which your admin account is part of.

The regular user you are failing with is not defined in the SQL Server as
allowed to access. You need to add them using something like sp_addlogin.
See books online for the details. If you only have MSDE, you may have to
use the osql utility to run this procedure.

--
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data provider could not be initialized 1
Data provider could not be initialized 0
Data Provider Could not be initialized 3
Data Provider Could Not Be Initialized 2
Data provider could not be initialized 0
Error - Could not generate SSPI context 2
automatically connect to the default database while opening adp file. 2
"Data provider could not be initialized"? 1

Top