Sql Server Error 18456 (1 Viewer)

[dubmunkey]

Hi all,

i have an access database which is linked to a sql server table.

Up until yesterday everything worked fine and anyone one of my 20 users could log in.

Today they are getting these error messages:

warning unsafe expressions

and then

sql state: 28000
sql server error: 18456
login failed for..........

Nothing has been changed in the database or on the server (security wise) and im at a loss as to why or what is happening, can anybody help?

greg

 

[SQL_Hell]

Hi there

Can you login via Query analyser / enterprise manager?

Are you using sql server logins or windows logins?

 

[rsbutterfly16]

hi did you solve this problem.???.. i am having the same one and can't solve it....