Wrox Programmer Forums
|
BOOK: Beginning VB.NET Databases
This is the forum to discuss the Wrox book Beginning VB.NET Databases by Thearon Willis; ISBN: 9780764568008
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning VB.NET Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 8th, 2005, 11:19 PM
Registered User
 
Join Date: Jul 2005
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Another Login failure

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?

 
Old July 9th, 2005, 06:37 AM
Thearon's Avatar
Wrox Author
 
Join Date: Dec 2003
Posts: 396
Thanks: 0
Thanked 8 Times in 8 Posts
Default

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
 
Old July 9th, 2005, 05:09 PM
Registered User
 
Join Date: Jul 2005
Posts: 4
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via AIM to GivenRandy
Default

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

The Following User Says Thank You to GivenRandy For This Useful Post:
owolabi (March 22nd, 2012)
 
Old July 9th, 2005, 10:08 PM
Registered User
 
Join Date: Jul 2005
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
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.

Thearon
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.
 
Old July 9th, 2005, 10:13 PM
Registered User
 
Join Date: Jul 2005
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by GivenRandy
 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

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.
 
Old July 10th, 2005, 12:32 AM
Registered User
 
Join Date: Jul 2005
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
 
Old July 10th, 2005, 04:02 AM
Thearon's Avatar
Wrox Author
 
Join Date: Dec 2003
Posts: 396
Thanks: 0
Thanked 8 Times in 8 Posts
Default

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

Thearon





Similar Threads
Thread Thread Starter Forum Replies Last Post
Photo login failure pchee373 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 5 June 29th, 2007 02:25 PM
login failure yasminnnnn BOOK: ASP.NET Website Programming Problem-Design-Solution 2 February 27th, 2007 04:16 AM
How to determine login success or failure? kscase VB Databases Basics 1 January 22nd, 2007 02:31 PM
Login Failure Basia BOOK: ASP.NET Website Programming Problem-Design-Solution 6 November 1st, 2005 08:33 PM
Chapter 15 Forum Login Failure Indigo11 BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 2 November 30th, 2004 12:22 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.