Cant Log In!

A

Andrew

I've done a fresh install running off a SQL Server 2000
database, on a local (non-ssl) server; however I can't log
in due to the following error:

"Your account does not have permissions to log on. You
need to change the account in your profile or contact your
server administrator to give your account permissions to
log on to this server. (5016)"

I feel like I've tried everything, but no matter what I do
I can't log in. PLEASE HELP!

Does anyone know how to fix this? I have full admin
rights, not running any add-ons (sharepoint etc), and have
tried the following:

Log in to the SQL Server using the admin account (works
fine).
Used SQL Server authentication only - doesn't work
Used Windows Authentication - doesn't work
 
G

Guest

Hey, I've thought about it and I'm getting the impression
that I need to set up an IIS account in SQL server so it
is authorised. Is this correct and can somone tell me the
settings?
 
Top