Re: Newbie questions about 'trusted connections'

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 10/05/04 

Date: Mon, 04 Oct 2004 19:43:55 -0600

Is your VB app actually logging into the server and
executing a query in each database? You may want to log into
SQL Server with SQL Authentication and joe as the user.
using Query Analyzer. Any of the databases where Joe can
really get into, you can check for the guest account being
enabled. You may also want to double check that Joe is not a
member of any of the server roles which would allow him
access to the other databases.

-Sue

On Mon, 4 Oct 2004 17:25:03 -0700, "B. Chernick"
<BChernick@discussions.microsoft.com> wrote:

>(Live and learn. I do normally use the default server with Windows
>Authenication.)
>
>If you don't mind, I now have a problem of a different kind. I've created
>the 'Joe' user according to the instructions in Lesson 3 practice but it
>doesn't seem to be confined to the SSEMDB database. In fact to doublecheck,
>I wrote a quick VB program that logs in using SQL Server authentication under
>the Joe Id and I can still get into any database on the server. (I'm
>wondering if I've setup this server correctly.)
>
>"Sue Hoegemeier" wrote:
>
>> No not really a bug. If you were using local and localhost then you
>> were connecting to the default instance. It sounds like you have a
>> default instance that is set to Windows Authentication only and a
>> named instance that you are using to practice 228 questions.
>> The drop downs don't necessarily show every available server - they
>> display the servers you have connected to. Once you type in a server
>> and connect to it, it is saved to the registry and then it displays in
>> the drop down. You have only connected to the default instance with
>> Query Analyzer that's why it's the only one that showed.
>>
>> -Sue
>>
>> On Mon, 4 Oct 2004 08:05:03 -0700, "B. Chernick"
>> <BChernick@discussions.microsoft.com> wrote:
>>
>> >Hold everything! I found the problem but I'm still a little confused.
>> >
>> >My server settings are fine. The problem was the point in the exercise
>> >where you're told to go to the Query Analyzer and do a Connect.
>> >
>> >When my 'Connect to SQL Server' window pops up, it displayed two options in
>> >the dropdown - (local) and localhost. Neither would work. Hitting the ...
>> >button (the elipsis?) produced a blank list. Then I realized I could type in
>> >the full name of my server and that worked. (And apparently now that I've
>> >done that, the name is also available in the dropdown.)
>> >
>> >Please feel free to elaborate on what just happened. Is this a user
>> >interface bug?
>> >
>> >"Sue Hoegemeier" wrote:
>> >
>> >> A trusted connection uses Windows Authentication. So the
>> >> user is authenticated based on their network login. When
>> >> using Windows authentication, you don't pass in a user name
>> >> and password. You just tell the connection to use Windows
>> >> Authentication or a trusted connection and you are validated
>> >> against the network. With a SQL login, you specify a user
>> >> name and password and then you are validated against the
>> >> login information for the SQL login by SQL Server.
>> >> If you are creating SQL logins (vs Windows logins) and you
>> >> are trying to login using one of these logins, your server
>> >> needs to be configured for Mixed Mode security to allow both
>> >> Windows logins as well as SQL logins.
>> >>
>> >> -Sue
>> >>
>> >> On Sun, 3 Oct 2004 11:29:01 -0700, "B. Chernick"
>> >> <BChernick@discussions.microsoft.com> wrote:
>> >>
>> >> >I'm trying to do chapter 10 in the 70-228 book and I'm totally confused. I'm
>> >> >on Lesson 3, Chapter 10, Creating a login, and I keep getting msg 18452 (Not
>> >> >associated with a trusted SQL Server connection) at step 19. I've looked at
>> >> >every reference I have and this is just not making sense to me. First of
>> >> >all, could someone please explain to me in their own words what a trusted
>> >> >connection is and how do I create it?
>> >> >
>> >> >(I should mention that I've installed SQL Server 2000 Developer over a
>> >> >pre-existing MSDE2000 installation. This is all on one laptop, no network
>> >> >currently connected. The original MSDE server is in Windows Authentication
>> >> >mode. The new server, on which I'm trying to do the exercise, is in mixed
>> >> >mode. I did stop and restart the server before trying to login as 'Joe'.)
>> >>
>> >>
>>
>>

Quantcast