RE: VS Authentication (mixed mode)

Hi!

The "mixed mode" has nothing to do with VS. You can specify this option
during the installation process of your sql-server. You can setup "mixed
mode" with your Enterprise Manager on an existing installation of SQL-Server.

Open Enterprise Manager, right-click on the server you want to setup and
choose settings. Open the tab "Security" and choose "SQL Server and Windows"
under Authentication.

You now can setup any user for the database (e.g. sa) with a password to use
this information in future for a database connection.

cu patrick

"tripwater" wrote:

> Hello, I am currently trying to learn VS, using C#. I have a book called
> Beginning C# Databases. I am using sqlserver and the first half of the book
> deals with windows apps. So it uses the windows authentication. Well now it
> is at the web form section and I can not connect this way now because it is
> no longer getting authentication from me as a user on this PC. The book
> explains a (mixed mode) where you can do both types of projects and get the
> benefit of both types of authentication.
>
> So far what the book does not show is how to set up sqlserver or VS for
> mixed mode authentication. This is where I need help. If someone could
> please walk me through setting this up it would be appreciated. Remember I
> am new to all of this so please keep that in mind when you explain it.
>
> Thanks
>
>
>
.

Relevant Pages

  • Re: VS Authentication (mixed mode)
    ... The book I have that walks me through setting up sqlserver does not show me ... It starts off running the install then says to run ... So it uses the windows authentication. ... > explains a (mixed mode) where you can do both types of projects and get ...
    (microsoft.public.dotnet.framework.aspnet)
  • Client Status
    ... I have SCCM 2007 setup in a test envrionment and have extended the AD schema. ... Setup in Mixed Mode ... Now if I go to one of the clients, in the control panel, the "Site mode" is Unknown and when I click on autodiscover site number, it comes back saying that it cant find a site number. ...
    (microsoft.public.sms.setup)
  • Re: Migrating from NT to Win2k in native mode
    ... from mixed mode authentication to Windows only authentication? ... What are the effects of switching SQL Server from 'Mixed mode' to 'Windows ...
    (microsoft.public.sqlserver.security)
  • Customising SQL Server in .Net deployment
    ... I have been trying to customise the installation of SQL Server Express ... I want to change the authentication to ... change the login mode to 2 for mixed mode) then the application works ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Cannot open database requested in login
    ... Ive just checked that and it is set to mixed mode. ... > you sql server is in windows authentication mode, ... > you should see security tab, change authentication to "SQL ...
    (microsoft.public.sqlserver.security)