Re: Trying to get a VB.net sample working with SQL Server.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Blair (john_blair_at_hotmail.com)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 18:03:37 GMT

Greg,

Thanks very much for taking time to reply....SQL Server logon approach is
much clearer thanks!

FYI " Trusted_Connection=yes" was taken directly from the online sample
(url below) and works on my win XP PC:

http://samples.gotdotnet.com/quickstart/util/srcview.aspx?path=%2fquickstart%2faspplus%2fsamples%2fcache%2fdatacache1.src

"Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
news:OQS3RHr5EHA.1404@TK2MSFTNGP11.phx.gbl...
> 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
>>>
>>>
>>>
>>
>>
>
>

Relevant Pages

  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using Access 2007 to connect to SQL
    ... MDB database file format, ODBC linked tables, passthrough queries ... probably the easiest way of retrieving data from a SQL-Server ... I'm a total newbie w MS SQL Server. ...
    (microsoft.public.access.adp.sqlserver)