Hi, i'm a computer science student. I bought your book even though it isn't part of my course work because i thought it would help me learn more and i'm really enjoying it.

But, i'm having a problem in chapter 8 when i run the database migration utility. I put my computers name in the "database" textbox.
I put the login name and Password and i get the error:
"Login failed for user 'bo'. Reason: Not associated with a trusted SQL Server connection."

I got SQL Server free about a year ago and i just start my computer and it's there in Programs for me to use. I created a new login by going to enterprise manager and then
 in the left folders clicking --Security
 and then clicking Logins and going to the top tab Actions and creating a new login. I gave this login "bo" all access privileges and everything.
Can you help me?

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.

Thearon

I had the same problem. Sounds like you need MSDE to be in Mixed Mode Authentication. You don't have to uninstall MSDE, you can do the registry changes listed here (after MSDE is already installed):

http://support.microsoft.com/default...n-us;325022#10

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:
(object)_______(owner)______(select)___(insert) etc....
GroupProjects dbo (checked) (checked) etc..
Groups 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:
Password:
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.

Thanks for the link. I just joined this forum and after i had registered i look at the topics and you must have just posted last night or thereabouts. Thanks for the link but i can't find the

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\ MSSqlServer

place where the LoginMode subkey resides. I don't have LoginMode. I tried the other path and no luck. I've thoroughly explored every tab and it's just not there. I'm not using MSDE but SQL Server 2000 so maybe that explains it. If you have a link that shows how to change SQL Server 2000 to mixed mode i would definitely appreciate it. I'm looking for it but i'm not having any luck.

OK i figured out how to do it. Everything is fine now. I hunted around on the MS website and found the knowledge i needed. I got it to work.:)

Thanks

ps. i concur with Randy. You have a great book!! I just like the fact that it is structured the way any normal person would learn anything. You provide the code example and then you have the "How it works" section which explains the code. Really great.

Thanks for the compliments. I'm glad you are enjoying the book and I hope you learn a lot from it.

Thearon