I recently created an ADP project as a front end that connects to a new MSDE
2000 backend. Both files are installed on the same machine. MSDE 2000 and
Access XP are both installed. The project is using NT Authentication
(Trusted Connection). My login authenticates to an Active Directory domain.
I don't know whether this detail is relevant.

Now I'm trying to connect to the back end from the project file (both on
local machine), but I'm having the below problems:

1) The tables and database diagram no longer display in the database
window.

2) The title bar at the top of the database window indicates that the
project is *disconnected* from the back end.

3) When I run the "Connection" option from the File menu and click on the
"Test Connection" button at the bottom of the "Data Link Properties" dialog
box, I get the following error:

"Test connection failed because of an error in initializing provider. Login
failed for user '[myDomain\MyUserName]'"

4) If I just click on the OK button in the "Data Link Properties" dialog
box, I get the following error:

"Microsoft Access could not log on to the server. Verify that the log on
information is correct."

Normally, I would assume the fact that I was able to successfully log on to
my machine is sufficient proof that my login info is correct. For some
reason, my new database does not appear to be trusting(?) my Windows 2000
authentication. My password has *not* changed recently.

I have also verified that SQL Server is running on my machine and that my
machine name has been selected as the SQL Server Name in the "Data Link
Properties" dialog box. "Use Windows NT Integrated security" is also
selected. The database is also selected.

I have re-started my machine and logged in again, but I still cannot connect
to the MSDE database from the project file.

What am I missing?


P.S. I'm Xposting in Microsoft.Public.Access.Security and
Microsoft.Public.Access.ADP.SQLServer.

The fact that you are able to successfully log on to your machine is not
necessarily sufficient to get access to the MSDE or SQL-Server.

By default, you must have administrator rights to have access to the server
(with a default installation) and even these accounts can be kicked off the
sql-server.

Have you been able to log on successfully before?

S. L.

"MikeC" <(E-Mail Removed)> wrote in message
news:8Vtnd.23388$(E-Mail Removed)...
>I recently created an ADP project as a front end that connects to a new
>MSDE 2000 backend. Both files are installed on the same machine. MSDE
>2000 and Access XP are both installed. The project is using NT
>Authentication (Trusted Connection). My login authenticates to an Active
>Directory domain. I don't know whether this detail is relevant.
>
> Now I'm trying to connect to the back end from the project file (both on
> local machine), but I'm having the below problems:
>
> 1) The tables and database diagram no longer display in the database
> window.
>
> 2) The title bar at the top of the database window indicates that the
> project is *disconnected* from the back end.
>
> 3) When I run the "Connection" option from the File menu and click on the
> "Test Connection" button at the bottom of the "Data Link Properties"
> dialog box, I get the following error:
>
> "Test connection failed because of an error in initializing provider.
> Login failed for user '[myDomain\MyUserName]'"
>
> 4) If I just click on the OK button in the "Data Link Properties" dialog
> box, I get the following error:
>
> "Microsoft Access could not log on to the server. Verify that the log on
> information is correct."
>
> Normally, I would assume the fact that I was able to successfully log on
> to my machine is sufficient proof that my login info is correct. For some
> reason, my new database does not appear to be trusting(?) my Windows 2000
> authentication. My password has *not* changed recently.
>
> I have also verified that SQL Server is running on my machine and that my
> machine name has been selected as the SQL Server Name in the "Data Link
> Properties" dialog box. "Use Windows NT Integrated security" is also
> selected. The database is also selected.
>
> I have re-started my machine and logged in again, but I still cannot
> connect to the MSDE database from the project file.
>
> What am I missing?
>
>
> P.S. I'm Xposting in Microsoft.Public.Access.Security and
> Microsoft.Public.Access.ADP.SQLServer.
>

I must have a default installation.

Yes, I successfully connected to the database the day that I created it. I
created the tables, relationships and was beginning to enforce referential
integrity. Now I'm trying to connect, and it won't trust my login even
though that's what I told it to do when I originally created the database.

I do have administrator rights on my local machine, but these rights are
external to SQL Server. I don't know what specific rights I have within SQL
Server. However, as I mentioned above, I did manage to create the tables
and begin enforcing referential integrity. Usually, only someone with
administrator permissions can do these things. At the time, I just assumed
that I was automatically granted administrator rights when I created the
database. If this is not the case, then I'm puzzled as to why I was allowed
to create the database, tables, etc. in the first place. Maybe SQL Server
was just teasing me. :-)


"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:%(E-Mail Removed)...
> The fact that you are able to successfully log on to your machine is not
> necessarily sufficient to get access to the MSDE or SQL-Server.
>
> By default, you must have administrator rights to have access to the
> server (with a default installation) and even these accounts can be kicked
> off the sql-server.
>
> Have you been able to log on successfully before?
>
> S. L.
>
> "MikeC" <(E-Mail Removed)> wrote in message
> news:8Vtnd.23388$(E-Mail Removed)...
>>I recently created an ADP project as a front end that connects to a new
>>MSDE 2000 backend. Both files are installed on the same machine. MSDE
>>2000 and Access XP are both installed. The project is using NT
>>Authentication (Trusted Connection). My login authenticates to an Active
>>Directory domain. I don't know whether this detail is relevant.
>>
>> Now I'm trying to connect to the back end from the project file (both on
>> local machine), but I'm having the below problems:
>>
>> 1) The tables and database diagram no longer display in the database
>> window.
>>
>> 2) The title bar at the top of the database window indicates that the
>> project is *disconnected* from the back end.
>>
>> 3) When I run the "Connection" option from the File menu and click on
>> the "Test Connection" button at the bottom of the "Data Link Properties"
>> dialog box, I get the following error:
>>
>> "Test connection failed because of an error in initializing provider.
>> Login failed for user '[myDomain\MyUserName]'"
>>
>> 4) If I just click on the OK button in the "Data Link Properties" dialog
>> box, I get the following error:
>>
>> "Microsoft Access could not log on to the server. Verify that the log on
>> information is correct."
>>
>> Normally, I would assume the fact that I was able to successfully log on
>> to my machine is sufficient proof that my login info is correct. For
>> some reason, my new database does not appear to be trusting(?) my Windows
>> 2000 authentication. My password has *not* changed recently.
>>
>> I have also verified that SQL Server is running on my machine and that my
>> machine name has been selected as the SQL Server Name in the "Data Link
>> Properties" dialog box. "Use Windows NT Integrated security" is also
>> selected. The database is also selected.
>>
>> I have re-started my machine and logged in again, but I still cannot
>> connect to the MSDE database from the project file.
>>
>> What am I missing?
>>
>>
>> P.S. I'm Xposting in Microsoft.Public.Access.Security and
>> Microsoft.Public.Access.ADP.SQLServer.
>>
>
>

Obviously, if you were able to connect to the MSDE engine and now you can't,
something must have happened.

Have you tried another kind of client, like Enterprise Manager ou VS.NET, to
connect to the MSDE database and what is the name of the server that you are
using? (for example: the name of the machine, (local), localhost,
127.0.0.1, etc.)

S. L.

"MikeC" <(E-Mail Removed)> wrote in message
news:58vnd.19918$(E-Mail Removed)...
>I must have a default installation.
>
> Yes, I successfully connected to the database the day that I created it.
> I created the tables, relationships and was beginning to enforce
> referential integrity. Now I'm trying to connect, and it won't trust my
> login even though that's what I told it to do when I originally created
> the database.
>
> I do have administrator rights on my local machine, but these rights are
> external to SQL Server. I don't know what specific rights I have within
> SQL Server. However, as I mentioned above, I did manage to create the
> tables and begin enforcing referential integrity. Usually, only someone
> with administrator permissions can do these things. At the time, I just
> assumed that I was automatically granted administrator rights when I
> created the database. If this is not the case, then I'm puzzled as to why
> I was allowed to create the database, tables, etc. in the first place.
> Maybe SQL Server was just teasing me. :-)
>
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> wrote in message news:%(E-Mail Removed)...
>> The fact that you are able to successfully log on to your machine is not
>> necessarily sufficient to get access to the MSDE or SQL-Server.
>>
>> By default, you must have administrator rights to have access to the
>> server (with a default installation) and even these accounts can be
>> kicked off the sql-server.
>>
>> Have you been able to log on successfully before?
>>
>> S. L.
>>
>> "MikeC" <(E-Mail Removed)> wrote in message
>> news:8Vtnd.23388$(E-Mail Removed)...
>>>I recently created an ADP project as a front end that connects to a new
>>>MSDE 2000 backend. Both files are installed on the same machine. MSDE
>>>2000 and Access XP are both installed. The project is using NT
>>>Authentication (Trusted Connection). My login authenticates to an Active
>>>Directory domain. I don't know whether this detail is relevant.
>>>
>>> Now I'm trying to connect to the back end from the project file (both on
>>> local machine), but I'm having the below problems:
>>>
>>> 1) The tables and database diagram no longer display in the database
>>> window.
>>>
>>> 2) The title bar at the top of the database window indicates that the
>>> project is *disconnected* from the back end.
>>>
>>> 3) When I run the "Connection" option from the File menu and click on
>>> the "Test Connection" button at the bottom of the "Data Link Properties"
>>> dialog box, I get the following error:
>>>
>>> "Test connection failed because of an error in initializing provider.
>>> Login failed for user '[myDomain\MyUserName]'"
>>>
>>> 4) If I just click on the OK button in the "Data Link Properties"
>>> dialog box, I get the following error:
>>>
>>> "Microsoft Access could not log on to the server. Verify that the log
>>> on information is correct."
>>>
>>> Normally, I would assume the fact that I was able to successfully log on
>>> to my machine is sufficient proof that my login info is correct. For
>>> some reason, my new database does not appear to be trusting(?) my
>>> Windows 2000 authentication. My password has *not* changed recently.
>>>
>>> I have also verified that SQL Server is running on my machine and that
>>> my machine name has been selected as the SQL Server Name in the "Data
>>> Link Properties" dialog box. "Use Windows NT Integrated security" is
>>> also selected. The database is also selected.
>>>
>>> I have re-started my machine and logged in again, but I still cannot
>>> connect to the MSDE database from the project file.
>>>
>>> What am I missing?
>>>
>>>
>>> P.S. I'm Xposting in Microsoft.Public.Access.Security and
>>> Microsoft.Public.Access.ADP.SQLServer.
>>>
>>
>>
>
>

Enterprise Manager and VS.NET are not installed on my machine.

The SQL Server name is set to the name of the machine. Should I change it
to Local? I hadn't tried that, but in hind sight that makes sense. I'll
give it a try and post again if the problem persists. Thanks for your help.


"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:%(E-Mail Removed)...
> Obviously, if you were able to connect to the MSDE engine and now you
> can't, something must have happened.
>
> Have you tried another kind of client, like Enterprise Manager ou VS.NET,
> to connect to the MSDE database and what is the name of the server that
> you are using? (for example: the name of the machine, (local), localhost,
> 127.0.0.1, etc.)
>
> S. L.
>
> "MikeC" <(E-Mail Removed)> wrote in message
> news:58vnd.19918$(E-Mail Removed)...
>>I must have a default installation.
>>
>> Yes, I successfully connected to the database the day that I created it.
>> I created the tables, relationships and was beginning to enforce
>> referential integrity. Now I'm trying to connect, and it won't trust my
>> login even though that's what I told it to do when I originally created
>> the database.
>>
>> I do have administrator rights on my local machine, but these rights are
>> external to SQL Server. I don't know what specific rights I have within
>> SQL Server. However, as I mentioned above, I did manage to create the
>> tables and begin enforcing referential integrity. Usually, only someone
>> with administrator permissions can do these things. At the time, I just
>> assumed that I was automatically granted administrator rights when I
>> created the database. If this is not the case, then I'm puzzled as to
>> why I was allowed to create the database, tables, etc. in the first
>> place. Maybe SQL Server was just teasing me. :-)
>>
>>
>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>> wrote in message news:%(E-Mail Removed)...
>>> The fact that you are able to successfully log on to your machine is not
>>> necessarily sufficient to get access to the MSDE or SQL-Server.
>>>
>>> By default, you must have administrator rights to have access to the
>>> server (with a default installation) and even these accounts can be
>>> kicked off the sql-server.
>>>
>>> Have you been able to log on successfully before?
>>>
>>> S. L.
>>>
>>> "MikeC" <(E-Mail Removed)> wrote in message
>>> news:8Vtnd.23388$(E-Mail Removed)...
>>>>I recently created an ADP project as a front end that connects to a new
>>>>MSDE 2000 backend. Both files are installed on the same machine. MSDE
>>>>2000 and Access XP are both installed. The project is using NT
>>>>Authentication (Trusted Connection). My login authenticates to an
>>>>Active Directory domain. I don't know whether this detail is relevant.
>>>>
>>>> Now I'm trying to connect to the back end from the project file (both
>>>> on local machine), but I'm having the below problems:
>>>>
>>>> 1) The tables and database diagram no longer display in the database
>>>> window.
>>>>
>>>> 2) The title bar at the top of the database window indicates that the
>>>> project is *disconnected* from the back end.
>>>>
>>>> 3) When I run the "Connection" option from the File menu and click on
>>>> the "Test Connection" button at the bottom of the "Data Link
>>>> Properties" dialog box, I get the following error:
>>>>
>>>> "Test connection failed because of an error in initializing provider.
>>>> Login failed for user '[myDomain\MyUserName]'"
>>>>
>>>> 4) If I just click on the OK button in the "Data Link Properties"
>>>> dialog box, I get the following error:
>>>>
>>>> "Microsoft Access could not log on to the server. Verify that the log
>>>> on information is correct."
>>>>
>>>> Normally, I would assume the fact that I was able to successfully log
>>>> on to my machine is sufficient proof that my login info is correct.
>>>> For some reason, my new database does not appear to be trusting(?) my
>>>> Windows 2000 authentication. My password has *not* changed recently.
>>>>
>>>> I have also verified that SQL Server is running on my machine and that
>>>> my machine name has been selected as the SQL Server Name in the "Data
>>>> Link Properties" dialog box. "Use Windows NT Integrated security" is
>>>> also selected. The database is also selected.
>>>>
>>>> I have re-started my machine and logged in again, but I still cannot
>>>> connect to the MSDE database from the project file.
>>>>
>>>> What am I missing?
>>>>
>>>>
>>>> P.S. I'm Xposting in Microsoft.Public.Access.Security and
>>>> Microsoft.Public.Access.ADP.SQLServer.
>>>>
>>>
>>>
>>
>>
>
>

(local), with the parenthesis, not Local. You can also try 127.0.0.1 or
127.0.0.1,1433.

If you have ODBC installed (quite probably), you can try creating a DSN by
using the Data Sources tool in the Administrative Tools section under the
control panel.

Finally, what provider are you trying to use in the connection window?

S. L.

"MikeC" <(E-Mail Removed)> wrote in message
news:P9xnd.19938$(E-Mail Removed)...
> Enterprise Manager and VS.NET are not installed on my machine.
>
> The SQL Server name is set to the name of the machine. Should I change it
> to Local? I hadn't tried that, but in hind sight that makes sense. I'll
> give it a try and post again if the problem persists. Thanks for your
> help.
>
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> wrote in message news:%(E-Mail Removed)...
>> Obviously, if you were able to connect to the MSDE engine and now you
>> can't, something must have happened.
>>
>> Have you tried another kind of client, like Enterprise Manager ou VS.NET,
>> to connect to the MSDE database and what is the name of the server that
>> you are using? (for example: the name of the machine, (local),
>> localhost, 127.0.0.1, etc.)
>>
>> S. L.
>>
>> "MikeC" <(E-Mail Removed)> wrote in message
>> news:58vnd.19918$(E-Mail Removed)...
>>>I must have a default installation.
>>>
>>> Yes, I successfully connected to the database the day that I created it.
>>> I created the tables, relationships and was beginning to enforce
>>> referential integrity. Now I'm trying to connect, and it won't trust my
>>> login even though that's what I told it to do when I originally created
>>> the database.
>>>
>>> I do have administrator rights on my local machine, but these rights are
>>> external to SQL Server. I don't know what specific rights I have within
>>> SQL Server. However, as I mentioned above, I did manage to create the
>>> tables and begin enforcing referential integrity. Usually, only someone
>>> with administrator permissions can do these things. At the time, I just
>>> assumed that I was automatically granted administrator rights when I
>>> created the database. If this is not the case, then I'm puzzled as to
>>> why I was allowed to create the database, tables, etc. in the first
>>> place. Maybe SQL Server was just teasing me. :-)
>>>
>>>
>>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>>> wrote in message news:%(E-Mail Removed)...
>>>> The fact that you are able to successfully log on to your machine is
>>>> not necessarily sufficient to get access to the MSDE or SQL-Server.
>>>>
>>>> By default, you must have administrator rights to have access to the
>>>> server (with a default installation) and even these accounts can be
>>>> kicked off the sql-server.
>>>>
>>>> Have you been able to log on successfully before?
>>>>
>>>> S. L.
>>>>
>>>> "MikeC" <(E-Mail Removed)> wrote in message
>>>> news:8Vtnd.23388$(E-Mail Removed)...
>>>>>I recently created an ADP project as a front end that connects to a new
>>>>>MSDE 2000 backend. Both files are installed on the same machine. MSDE
>>>>>2000 and Access XP are both installed. The project is using NT
>>>>>Authentication (Trusted Connection). My login authenticates to an
>>>>>Active Directory domain. I don't know whether this detail is relevant.
>>>>>
>>>>> Now I'm trying to connect to the back end from the project file (both
>>>>> on local machine), but I'm having the below problems:
>>>>>
>>>>> 1) The tables and database diagram no longer display in the database
>>>>> window.
>>>>>
>>>>> 2) The title bar at the top of the database window indicates that the
>>>>> project is *disconnected* from the back end.
>>>>>
>>>>> 3) When I run the "Connection" option from the File menu and click on
>>>>> the "Test Connection" button at the bottom of the "Data Link
>>>>> Properties" dialog box, I get the following error:
>>>>>
>>>>> "Test connection failed because of an error in initializing provider.
>>>>> Login failed for user '[myDomain\MyUserName]'"
>>>>>
>>>>> 4) If I just click on the OK button in the "Data Link Properties"
>>>>> dialog box, I get the following error:
>>>>>
>>>>> "Microsoft Access could not log on to the server. Verify that the log
>>>>> on information is correct."
>>>>>
>>>>> Normally, I would assume the fact that I was able to successfully log
>>>>> on to my machine is sufficient proof that my login info is correct.
>>>>> For some reason, my new database does not appear to be trusting(?) my
>>>>> Windows 2000 authentication. My password has *not* changed recently.
>>>>>
>>>>> I have also verified that SQL Server is running on my machine and that
>>>>> my machine name has been selected as the SQL Server Name in the "Data
>>>>> Link Properties" dialog box. "Use Windows NT Integrated security" is
>>>>> also selected. The database is also selected.
>>>>>
>>>>> I have re-started my machine and logged in again, but I still cannot
>>>>> connect to the MSDE database from the project file.
>>>>>
>>>>> What am I missing?
>>>>>
>>>>>
>>>>> P.S. I'm Xposting in Microsoft.Public.Access.Security and
>>>>> Microsoft.Public.Access.ADP.SQLServer.
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

I am unable to find the provider in the "Data Link Properties" dialog box.
This is the dialog box that displays when I select Connection... from the
File menu. Should I be looking somewhere else?

I also tried to change the server to "(local)", but I'm continuing to
receive the same error.

I'll try creating a DSN and see if that makes any difference.

I also noticed that I can no longer stop SQL Server on my machine. I get
the below:

"An error 5 - (Access is denied.) occured while performing this service
operation on the MSSQLServer service."

I am assuming this error is part of the same permissions-related problem. I
discovered this problem because I had tried to change SQL Server from
Windows Authentication mode to Mixed mode in the system registry as
explained in a KB article I found. However, I do not believe I can change
this setting in the registry until I can shut down SQL Server!!!


"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:(E-Mail Removed)...
> (local), with the parenthesis, not Local. You can also try 127.0.0.1 or
> 127.0.0.1,1433.
>
> If you have ODBC installed (quite probably), you can try creating a DSN by
> using the Data Sources tool in the Administrative Tools section under the
> control panel.
>
> Finally, what provider are you trying to use in the connection window?
>
> S. L.
>
> "MikeC" <(E-Mail Removed)> wrote in message
> news:P9xnd.19938$(E-Mail Removed)...
>> Enterprise Manager and VS.NET are not installed on my machine.
>>
>> The SQL Server name is set to the name of the machine. Should I change
>> it to Local? I hadn't tried that, but in hind sight that makes sense.
>> I'll give it a try and post again if the problem persists. Thanks for
>> your help.
>>
>>
>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>> wrote in message news:%(E-Mail Removed)...
>>> Obviously, if you were able to connect to the MSDE engine and now you
>>> can't, something must have happened.
>>>
>>> Have you tried another kind of client, like Enterprise Manager ou
>>> VS.NET, to connect to the MSDE database and what is the name of the
>>> server that you are using? (for example: the name of the machine,
>>> (local), localhost, 127.0.0.1, etc.)
>>>
>>> S. L.
>>>
>>> "MikeC" <(E-Mail Removed)> wrote in message
>>> news:58vnd.19918$(E-Mail Removed)...
>>>>I must have a default installation.
>>>>
>>>> Yes, I successfully connected to the database the day that I created
>>>> it. I created the tables, relationships and was beginning to enforce
>>>> referential integrity. Now I'm trying to connect, and it won't trust
>>>> my login even though that's what I told it to do when I originally
>>>> created the database.
>>>>
>>>> I do have administrator rights on my local machine, but these rights
>>>> are external to SQL Server. I don't know what specific rights I have
>>>> within SQL Server. However, as I mentioned above, I did manage to
>>>> create the tables and begin enforcing referential integrity. Usually,
>>>> only someone with administrator permissions can do these things. At
>>>> the time, I just assumed that I was automatically granted administrator
>>>> rights when I created the database. If this is not the case, then I'm
>>>> puzzled as to why I was allowed to create the database, tables, etc. in
>>>> the first place. Maybe SQL Server was just teasing me. :-)
>>>>
>>>>
>>>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>>>> wrote in message news:%(E-Mail Removed)...
>>>>> The fact that you are able to successfully log on to your machine is
>>>>> not necessarily sufficient to get access to the MSDE or SQL-Server.
>>>>>
>>>>> By default, you must have administrator rights to have access to the
>>>>> server (with a default installation) and even these accounts can be
>>>>> kicked off the sql-server.
>>>>>
>>>>> Have you been able to log on successfully before?
>>>>>
>>>>> S. L.
>>>>>
>>>>> "MikeC" <(E-Mail Removed)> wrote in message
>>>>> news:8Vtnd.23388$(E-Mail Removed)...
>>>>>>I recently created an ADP project as a front end that connects to a
>>>>>>new MSDE 2000 backend. Both files are installed on the same machine.
>>>>>>MSDE 2000 and Access XP are both installed. The project is using NT
>>>>>>Authentication (Trusted Connection). My login authenticates to an
>>>>>>Active Directory domain. I don't know whether this detail is relevant.
>>>>>>
>>>>>> Now I'm trying to connect to the back end from the project file (both
>>>>>> on local machine), but I'm having the below problems:
>>>>>>
>>>>>> 1) The tables and database diagram no longer display in the database
>>>>>> window.
>>>>>>
>>>>>> 2) The title bar at the top of the database window indicates that
>>>>>> the project is *disconnected* from the back end.
>>>>>>
>>>>>> 3) When I run the "Connection" option from the File menu and click
>>>>>> on the "Test Connection" button at the bottom of the "Data Link
>>>>>> Properties" dialog box, I get the following error:
>>>>>>
>>>>>> "Test connection failed because of an error in initializing provider.
>>>>>> Login failed for user '[myDomain\MyUserName]'"
>>>>>>
>>>>>> 4) If I just click on the OK button in the "Data Link Properties"
>>>>>> dialog box, I get the following error:
>>>>>>
>>>>>> "Microsoft Access could not log on to the server. Verify that the
>>>>>> log on information is correct."
>>>>>>
>>>>>> Normally, I would assume the fact that I was able to successfully log
>>>>>> on to my machine is sufficient proof that my login info is correct.
>>>>>> For some reason, my new database does not appear to be trusting(?) my
>>>>>> Windows 2000 authentication. My password has *not* changed recently.
>>>>>>
>>>>>> I have also verified that SQL Server is running on my machine and
>>>>>> that my machine name has been selected as the SQL Server Name in the
>>>>>> "Data Link Properties" dialog box. "Use Windows NT Integrated
>>>>>> security" is also selected. The database is also selected.
>>>>>>
>>>>>> I have re-started my machine and logged in again, but I still cannot
>>>>>> connect to the MSDE database from the project file.
>>>>>>
>>>>>> What am I missing?
>>>>>>
>>>>>>
>>>>>> P.S. I'm Xposting in Microsoft.Public.Access.Security and
>>>>>> Microsoft.Public.Access.ADP.SQLServer.
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Sorry, for the provider, it's my error. After verification, I see that the
dialog box for ADP project only permits the SQL-Server OLEDB Provider. It's
hard to follow all these different dialog boxes these days. Forget about
the DSN.

For the registry setting, try to change the setting and reboot your
computer. Go into safe mode if necessary to change the setting. Look into
the services window to see if they are nothing unusual about the SQL-Server
service.

If I were you, I would stop the SQL-Server (by going into safe mode if
necessary); make a copy of the database files and desinstalls/reinstalls the
whole thing.

Also, I'm not sure but it's quite possible that loging as Administrator and
not with another account with administrator rights can change things. Maybe
there is something wrong with the account that you are using presently.

S. L.

"MikeC" <(E-Mail Removed)> wrote in message
news:M5sod.21136$(E-Mail Removed)...
>I am unable to find the provider in the "Data Link Properties" dialog box.
>This is the dialog box that displays when I select Connection... from the
>File menu. Should I be looking somewhere else?
>
> I also tried to change the server to "(local)", but I'm continuing to
> receive the same error.
>
> I'll try creating a DSN and see if that makes any difference.
>
> I also noticed that I can no longer stop SQL Server on my machine. I get
> the below:
>
> "An error 5 - (Access is denied.) occured while performing this service
> operation on the MSSQLServer service."
>
> I am assuming this error is part of the same permissions-related problem.
> I discovered this problem because I had tried to change SQL Server from
> Windows Authentication mode to Mixed mode in the system registry as
> explained in a KB article I found. However, I do not believe I can change
> this setting in the registry until I can shut down SQL Server!!!
>
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> wrote in message news:(E-Mail Removed)...
>> (local), with the parenthesis, not Local. You can also try 127.0.0.1 or
>> 127.0.0.1,1433.
>>
>> If you have ODBC installed (quite probably), you can try creating a DSN
>> by
>> using the Data Sources tool in the Administrative Tools section under the
>> control panel.
>>
>> Finally, what provider are you trying to use in the connection window?
>>
>> S. L.
>>
>> "MikeC" <(E-Mail Removed)> wrote in message
>> news:P9xnd.19938$(E-Mail Removed)...
>>> Enterprise Manager and VS.NET are not installed on my machine.
>>>
>>> The SQL Server name is set to the name of the machine. Should I change
>>> it to Local? I hadn't tried that, but in hind sight that makes sense.
>>> I'll give it a try and post again if the problem persists. Thanks for
>>> your help.
>>>
>>>
>>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>>> wrote in message news:%(E-Mail Removed)...
>>>> Obviously, if you were able to connect to the MSDE engine and now you
>>>> can't, something must have happened.
>>>>
>>>> Have you tried another kind of client, like Enterprise Manager ou
>>>> VS.NET, to connect to the MSDE database and what is the name of the
>>>> server that you are using? (for example: the name of the machine,
>>>> (local), localhost, 127.0.0.1, etc.)
>>>>
>>>> S. L.
>>>>
>>>> "MikeC" <(E-Mail Removed)> wrote in message
>>>> news:58vnd.19918$(E-Mail Removed)...
>>>>>I must have a default installation.
>>>>>
>>>>> Yes, I successfully connected to the database the day that I created
>>>>> it. I created the tables, relationships and was beginning to enforce
>>>>> referential integrity. Now I'm trying to connect, and it won't trust
>>>>> my login even though that's what I told it to do when I originally
>>>>> created the database.
>>>>>
>>>>> I do have administrator rights on my local machine, but these rights
>>>>> are external to SQL Server. I don't know what specific rights I have
>>>>> within SQL Server. However, as I mentioned above, I did manage to
>>>>> create the tables and begin enforcing referential integrity. Usually,
>>>>> only someone with administrator permissions can do these things. At
>>>>> the time, I just assumed that I was automatically granted
>>>>> administrator
>>>>> rights when I created the database. If this is not the case, then I'm
>>>>> puzzled as to why I was allowed to create the database, tables, etc.
>>>>> in
>>>>> the first place. Maybe SQL Server was just teasing me. :-)
>>>>>
>>>>>
>>>>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam
>>>>> please)>
>>>>> wrote in message news:%(E-Mail Removed)...
>>>>>> The fact that you are able to successfully log on to your machine is
>>>>>> not necessarily sufficient to get access to the MSDE or SQL-Server.
>>>>>>
>>>>>> By default, you must have administrator rights to have access to the
>>>>>> server (with a default installation) and even these accounts can be
>>>>>> kicked off the sql-server.
>>>>>>
>>>>>> Have you been able to log on successfully before?
>>>>>>
>>>>>> S. L.
>>>>>>
>>>>>> "MikeC" <(E-Mail Removed)> wrote in message
>>>>>> news:8Vtnd.23388$(E-Mail Removed)...
>>>>>>>I recently created an ADP project as a front end that connects to a
>>>>>>>new MSDE 2000 backend. Both files are installed on the same machine.
>>>>>>>MSDE 2000 and Access XP are both installed. The project is using NT
>>>>>>>Authentication (Trusted Connection). My login authenticates to an
>>>>>>>Active Directory domain. I don't know whether this detail is
>>>>>>>relevant.
>>>>>>>
>>>>>>> Now I'm trying to connect to the back end from the project file
>>>>>>> (both
>>>>>>> on local machine), but I'm having the below problems:
>>>>>>>
>>>>>>> 1) The tables and database diagram no longer display in the
>>>>>>> database
>>>>>>> window.
>>>>>>>
>>>>>>> 2) The title bar at the top of the database window indicates that
>>>>>>> the project is *disconnected* from the back end.
>>>>>>>
>>>>>>> 3) When I run the "Connection" option from the File menu and click
>>>>>>> on the "Test Connection" button at the bottom of the "Data Link
>>>>>>> Properties" dialog box, I get the following error:
>>>>>>>
>>>>>>> "Test connection failed because of an error in initializing
>>>>>>> provider.
>>>>>>> Login failed for user '[myDomain\MyUserName]'"
>>>>>>>
>>>>>>> 4) If I just click on the OK button in the "Data Link Properties"
>>>>>>> dialog box, I get the following error:
>>>>>>>
>>>>>>> "Microsoft Access could not log on to the server. Verify that the
>>>>>>> log on information is correct."
>>>>>>>
>>>>>>> Normally, I would assume the fact that I was able to successfully
>>>>>>> log
>>>>>>> on to my machine is sufficient proof that my login info is correct.
>>>>>>> For some reason, my new database does not appear to be trusting(?)
>>>>>>> my
>>>>>>> Windows 2000 authentication. My password has *not* changed
>>>>>>> recently.
>>>>>>>
>>>>>>> I have also verified that SQL Server is running on my machine and
>>>>>>> that my machine name has been selected as the SQL Server Name in the
>>>>>>> "Data Link Properties" dialog box. "Use Windows NT Integrated
>>>>>>> security" is also selected. The database is also selected.
>>>>>>>
>>>>>>> I have re-started my machine and logged in again, but I still cannot
>>>>>>> connect to the MSDE database from the project file.
>>>>>>>
>>>>>>> What am I missing?
>>>>>>>
>>>>>>>
>>>>>>> P.S. I'm Xposting in Microsoft.Public.Access.Security and
>>>>>>> Microsoft.Public.Access.ADP.SQLServer.
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
>

Sylvain,

You are absolutely correct. The problem was related to my account!

After some further troubleshooting, I discovered that my account had been
*removed* from the Administrator group on my local machine!!!

After some special effort from my local desktop support people, they managed
to add my account back to the group. Now I can connect to the database
without any problems.

Now that I have admin permissions again, I can also start and stop SQL
Server, so this allowed me to change my authentication mode to Mixed in the
registry. I'll set up a SQL Server account for myself just in case this
problem happens again in the future. Thanks for your help.


"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:(E-Mail Removed)...
> Sorry, for the provider, it's my error. After verification, I see that
the
> dialog box for ADP project only permits the SQL-Server OLEDB Provider.
It's
> hard to follow all these different dialog boxes these days. Forget about
> the DSN.
>
> For the registry setting, try to change the setting and reboot your
> computer. Go into safe mode if necessary to change the setting. Look
into
> the services window to see if they are nothing unusual about the
SQL-Server
> service.
>
> If I were you, I would stop the SQL-Server (by going into safe mode if
> necessary); make a copy of the database files and desinstalls/reinstalls
the
> whole thing.
>
> Also, I'm not sure but it's quite possible that loging as Administrator
and
> not with another account with administrator rights can change things.
Maybe
> there is something wrong with the account that you are using presently.
>
> S. L.
>
> "MikeC" <(E-Mail Removed)> wrote in message
> news:M5sod.21136$(E-Mail Removed)...
> >I am unable to find the provider in the "Data Link Properties" dialog
box.
> >This is the dialog box that displays when I select Connection... from the
> >File menu. Should I be looking somewhere else?
> >
> > I also tried to change the server to "(local)", but I'm continuing to
> > receive the same error.
> >
> > I'll try creating a DSN and see if that makes any difference.
> >
> > I also noticed that I can no longer stop SQL Server on my machine. I
get
> > the below:
> >
> > "An error 5 - (Access is denied.) occured while performing this service
> > operation on the MSSQLServer service."
> >
> > I am assuming this error is part of the same permissions-related
problem.
> > I discovered this problem because I had tried to change SQL Server from
> > Windows Authentication mode to Mixed mode in the system registry as
> > explained in a KB article I found. However, I do not believe I can
change
> > this setting in the registry until I can shut down SQL Server!!!
> >
> >
> > "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> > wrote in message news:(E-Mail Removed)...
> >> (local), with the parenthesis, not Local. You can also try 127.0.0.1
or
> >> 127.0.0.1,1433.
> >>
> >> If you have ODBC installed (quite probably), you can try creating a DSN
> >> by
> >> using the Data Sources tool in the Administrative Tools section under
the
> >> control panel.
> >>
> >> Finally, what provider are you trying to use in the connection window?
> >>
> >> S. L.
> >>
> >> "MikeC" <(E-Mail Removed)> wrote in message
> >> news:P9xnd.19938$(E-Mail Removed)...
> >>> Enterprise Manager and VS.NET are not installed on my machine.
> >>>
> >>> The SQL Server name is set to the name of the machine. Should I
change
> >>> it to Local? I hadn't tried that, but in hind sight that makes sense.
> >>> I'll give it a try and post again if the problem persists. Thanks for
> >>> your help.
> >>>
> >>>
> >>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam
please)>
> >>> wrote in message news:%(E-Mail Removed)...
> >>>> Obviously, if you were able to connect to the MSDE engine and now you
> >>>> can't, something must have happened.
> >>>>
> >>>> Have you tried another kind of client, like Enterprise Manager ou
> >>>> VS.NET, to connect to the MSDE database and what is the name of the
> >>>> server that you are using? (for example: the name of the machine,
> >>>> (local), localhost, 127.0.0.1, etc.)
> >>>>
> >>>> S. L.
> >>>>
> >>>> "MikeC" <(E-Mail Removed)> wrote in message
> >>>> news:58vnd.19918$(E-Mail Removed)...
> >>>>>I must have a default installation.
> >>>>>
> >>>>> Yes, I successfully connected to the database the day that I created
> >>>>> it. I created the tables, relationships and was beginning to enforce
> >>>>> referential integrity. Now I'm trying to connect, and it won't
trust
> >>>>> my login even though that's what I told it to do when I originally
> >>>>> created the database.
> >>>>>
> >>>>> I do have administrator rights on my local machine, but these rights
> >>>>> are external to SQL Server. I don't know what specific rights I
have
> >>>>> within SQL Server. However, as I mentioned above, I did manage to
> >>>>> create the tables and begin enforcing referential integrity.
Usually,
> >>>>> only someone with administrator permissions can do these things. At
> >>>>> the time, I just assumed that I was automatically granted
> >>>>> administrator
> >>>>> rights when I created the database. If this is not the case, then
I'm
> >>>>> puzzled as to why I was allowed to create the database, tables, etc.
> >>>>> in
> >>>>> the first place. Maybe SQL Server was just teasing me. :-)
> >>>>>
> >>>>>
> >>>>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam
> >>>>> please)>
> >>>>> wrote in message news:%(E-Mail Removed)...
> >>>>>> The fact that you are able to successfully log on to your machine
is
> >>>>>> not necessarily sufficient to get access to the MSDE or SQL-Server.
> >>>>>>
> >>>>>> By default, you must have administrator rights to have access to
the
> >>>>>> server (with a default installation) and even these accounts can be
> >>>>>> kicked off the sql-server.
> >>>>>>
> >>>>>> Have you been able to log on successfully before?
> >>>>>>
> >>>>>> S. L.
> >>>>>>
> >>>>>> "MikeC" <(E-Mail Removed)> wrote in message
> >>>>>> news:8Vtnd.23388$(E-Mail Removed)...
> >>>>>>>I recently created an ADP project as a front end that connects to a
> >>>>>>>new MSDE 2000 backend. Both files are installed on the same
machine.
> >>>>>>>MSDE 2000 and Access XP are both installed. The project is using
NT
> >>>>>>>Authentication (Trusted Connection). My login authenticates to an
> >>>>>>>Active Directory domain. I don't know whether this detail is
> >>>>>>>relevant.
> >>>>>>>
> >>>>>>> Now I'm trying to connect to the back end from the project file
> >>>>>>> (both
> >>>>>>> on local machine), but I'm having the below problems:
> >>>>>>>
> >>>>>>> 1) The tables and database diagram no longer display in the
> >>>>>>> database
> >>>>>>> window.
> >>>>>>>
> >>>>>>> 2) The title bar at the top of the database window indicates that
> >>>>>>> the project is *disconnected* from the back end.
> >>>>>>>
> >>>>>>> 3) When I run the "Connection" option from the File menu and
click
> >>>>>>> on the "Test Connection" button at the bottom of the "Data Link
> >>>>>>> Properties" dialog box, I get the following error:
> >>>>>>>
> >>>>>>> "Test connection failed because of an error in initializing
> >>>>>>> provider.
> >>>>>>> Login failed for user '[myDomain\MyUserName]'"
> >>>>>>>
> >>>>>>> 4) If I just click on the OK button in the "Data Link Properties"
> >>>>>>> dialog box, I get the following error:
> >>>>>>>
> >>>>>>> "Microsoft Access could not log on to the server. Verify that the
> >>>>>>> log on information is correct."
> >>>>>>>
> >>>>>>> Normally, I would assume the fact that I was able to successfully
> >>>>>>> log
> >>>>>>> on to my machine is sufficient proof that my login info is
correct.
> >>>>>>> For some reason, my new database does not appear to be trusting(?)
> >>>>>>> my
> >>>>>>> Windows 2000 authentication. My password has *not* changed
> >>>>>>> recently.
> >>>>>>>
> >>>>>>> I have also verified that SQL Server is running on my machine and
> >>>>>>> that my machine name has been selected as the SQL Server Name in
the
> >>>>>>> "Data Link Properties" dialog box. "Use Windows NT Integrated
> >>>>>>> security" is also selected. The database is also selected.
> >>>>>>>
> >>>>>>> I have re-started my machine and logged in again, but I still
cannot
> >>>>>>> connect to the MSDE database from the project file.
> >>>>>>>
> >>>>>>> What am I missing?
> >>>>>>>
> >>>>>>>
> >>>>>>> P.S. I'm Xposting in Microsoft.Public.Access.Security and
> >>>>>>> Microsoft.Public.Access.ADP.SQLServer.
> >>>>>>>
> >>>>>>
> >>>>>>
> >>>>>
> >>>>>
> >>>>
> >>>>
> >>>
> >>>
> >>
> >>
> >
> >
> >
>
>

[mazirra]

Hi

I have an MS-Access 2002 ADP application that gets deployed to a large
group of people. Most of these users are able to use a "trusted
connection" but there are a dozen or so that are situated on a
domain/setup that will not allow "trusted".
Anyway, I have VBA setting the connection string based on the domain
used to connect. I deploy the application set up for trusted
connection.
managed network services