Re: Trying to get a VB.net sample working with SQL Server.
From: Greg Burns (greg_burns_at_DONT_SPAM_ME_hotmail.com)
Date: 12/20/04
- Next message: Cor Ligthert: "Re: ByRef Argument - Option Strict ON"
- Previous message: Jay B. Harlow [MVP - Outlook]: "Re: Treeview"
- In reply to: John Blair: "Re: Trying to get a VB.net sample working with SQL Server."
- Next in thread: John Blair: "Re: Trying to get a VB.net sample working with SQL Server."
- Reply: John Blair: "Re: Trying to get a VB.net sample working with SQL Server."
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 20 Dec 2004 11:34:45 -0500
SQL server can have two types of logins. SQL accounts and Windows accounts.
You can setup SQL to run in mixed mode (SQL and Windows) or Windows only.
(I think MSDE is Windows only by default??)
ASPNET is a windows account.. One correct method of setting up of SQL (if
you have the GUI tools, which MSDE does not come with), is to add the
windows ASPNET user to the server (this allows it to connect to the server,
but with no access to any databases). Next step is to map that windows
account to a SQL login and give it approriate permissions to a database.
As far as your question...
When a ASP.NET page executes, it uses the ASPNET windows identity. (You can
change this in web.config with <identity impersonate="true"/>, but I
wouldn't unless you have a good reason to.). In your connection string you
told it "Trusted_Connection=yes" (Note: I've normally seen
"Trusted_Coonection=True", or "Integrated Security=SSPI", which both are
equivalent. I've NEVER seen Trusted_Connection=yes", but maybe that works
too!?!) That says to connect to the database using the identity of the
current user (which going to be the ASPNET user, since this is a web app).
No need to specify a password, because it is going to use windows
authentication, not SQL authentication.
Make any sense? I am beginning to ramble.
Greg
"John Blair" <john_blair@hotmail.com> wrote in message
news:oMCxd.1101$sQ5.52@newsfe6-gui.ntli.net...
> Very impressed Greg thanks - that worked a treat!
>
> I had the ASPNET user on my system in the "users" group but not in the
> administrators group.
>
> Could you clarify one thing for me....i normally work with oracle ...this
> is the first time with SQL Server ....i was thinking
> the database connection trying to use the ASPNET user was a DATABASE user
> and not a windows XP user account.....which database user account
> is used for the SQL Server connection and how does VB.net know the correct
> password?
>
> Thanks a lot!
>
> "Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
> news:uIZgZdq5EHA.3124@TK2MSFTNGP11.phx.gbl...
>>
>> "John Blair" <john_blair@hotmail.com> wrote in message
>> news:yGBxd.84$206.64@newsfe5-gui.ntli.net...
>>> So my question is: How do i configure the pubs database with the correct
>>> user accounts and passwords for the samples to work?
>>
>> It is pretty easy if you have SQL Enterprise Manager. If not, then not
>> so much. :^)
>>
>> Quick & dirty way: If this is purely for testing on your home box, then
>> just add the ASPNET user to the local adminsitrator group in Users &
>> Computers. That will make that user admin for all the databases on your
>> MSDE.
>>
>> If your have SQL EM that are more appropriate ways of setting this up
>> correctly. You can even do it using a command prompt and OSQL if you are
>> feeling so inclined.
>>
>> HTH,
>> Greg
>>
>>
>>
>
>
- Next message: Cor Ligthert: "Re: ByRef Argument - Option Strict ON"
- Previous message: Jay B. Harlow [MVP - Outlook]: "Re: Treeview"
- In reply to: John Blair: "Re: Trying to get a VB.net sample working with SQL Server."
- Next in thread: John Blair: "Re: Trying to get a VB.net sample working with SQL Server."
- Reply: John Blair: "Re: Trying to get a VB.net sample working with SQL Server."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
