R
rsbutterfly219 via AccessMonster.com
hello, I have two Access databases and also I have the sql server client
tools (EM,query analyzer...) installed in my desktop. Everything was working
fine until I decided to change my password on Friday. I changed my password
to all the servers including my domain controller. but i keep getting this
error message when I try to connect to my EM or any of my databasess (MDB)
with the backend tables linked to my sql server. from my desktop now... ...
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
I am part of the users group, administrators group and domain users. I have
sql server 2000. I am not really sure what the problem is , It was working
fine before i changed my password. I am using windows authentication to
connect to my server. My sql server is set up for mixed authentication. I
refreshed my active directory and restarted my sql server, made sure my sql
server services and agent are running as well.
when i login directly to the server , everything is fine also, or if from my
desktop i go to run as administrator and put the credentials for
administrator then i am able to login to my em as well as query analyzer..
but the problem is when i use my local credentials eventhough i have the
administrator rights to all my servers.
Also, now when i try to run a form, etc from a database that has the backend
in sql server i get the same error message... sql server error 18452.....
login failed.... all i did was change my password in all the servers (and
used the same password) I did not change any settings at all. help please.
what else can i try?
Thanks in advance
tools (EM,query analyzer...) installed in my desktop. Everything was working
fine until I decided to change my password on Friday. I changed my password
to all the servers including my domain controller. but i keep getting this
error message when I try to connect to my EM or any of my databasess (MDB)
with the backend tables linked to my sql server. from my desktop now... ...
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
I am part of the users group, administrators group and domain users. I have
sql server 2000. I am not really sure what the problem is , It was working
fine before i changed my password. I am using windows authentication to
connect to my server. My sql server is set up for mixed authentication. I
refreshed my active directory and restarted my sql server, made sure my sql
server services and agent are running as well.
when i login directly to the server , everything is fine also, or if from my
desktop i go to run as administrator and put the credentials for
administrator then i am able to login to my em as well as query analyzer..
but the problem is when i use my local credentials eventhough i have the
administrator rights to all my servers.
Also, now when i try to run a form, etc from a database that has the backend
in sql server i get the same error message... sql server error 18452.....
login failed.... all i did was change my password in all the servers (and
used the same password) I did not change any settings at all. help please.
what else can i try?
Thanks in advance