quote:Originally posted by Thearon
Here's something to check. First when you created the login account in the Security folder, all you did was create the login and set the default database or specify which databases the login could access.
You also need to go to the actual database and click on the User folder and add the user there and specify what permissions they should have in the database.
Hi, thanks for your quick response. I'm still having trouble. When i go to the database i click on Users and and that brings up a form with:
Login name: bo
User name: bo permissions
"and then there is the statement database role membership:"
in the box below it are a lot of choices and i have PUBLIC and db_Owner checked."
When i go to Permissions if i click on every option i get an error like this:
ERROR4606: Granted or Revoked privilege REFERENCES is not compatible with object
The permissions box looks like this:
GroupProjects dbo (checked) (checked) etc..
i just check the boxes in this instance and it saves it but the owner is dbo not bo????
I keep getting the same error over and over again :
"Login failed for user 'bo'. Reason: Not associated with a trusted SQL Server connection."
I have SQL server 2000 and when i installed it for the first time i think i set the password for sa to something but i forget what. I'm not sure about this. When you look at GivenRandy's post he seems to have had the same problem but i'm not running MSDE.
Is there some way to use the command prompt to check to see if i have the correct password for "sa".
When i open the command prompt and then type
osql -U sa
it brings up:
i then type the password for sa and then i get the same error
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection."
But i can use SQL server just fine. The SQL wizard example worked fine (but i wasn't inserting, updating, etc.. data.) I can run stored procedures in enterprise manager, insert data into databases, create new databases, create new logins, etc... i can stop and start the sql server using "sql server service manager".
In Sql server service manager i have two combo boxes:
In the first one Server: (the name of my computer)
and the second i have services and the Sql server running and i've tried the DB migration example with the other two services "sql server agent" & "Distributed Transaction coordinator" running and not running in combinations thereabouts.
Maybe i'm not creating a new login properly. I seem to have all the administrator functions so i should be able to create a login with a username and password that would work in the DBm.utility.
I see you've mentioned running in mixed mode but how do i do that in SQL server 2000. When i go to the link that G.Randy has given me it asks to change the "LoginMode" to a value of 2 but when i go into regedt32 i do not have that subkey in any part of the registry.
Do you have any thoughts about what could be wrong? The only last resort i have is to go to school on Monday and just download i guess it would be SQL server 2003 and just install that and try with that, but other than that i don't know what to do.