473,320 Members | 2,054 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

VS Authentication (mixed mode)

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
Nov 19 '05 #1
4 1774
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

Nov 19 '05 #2
Thanks for the reply Patrick. Well upon further investigation, I do not have
Enterprise Manager installed. I tried searching for it through google but I
came up with third party sites trying to sell it. I did download the MSDE
SQL Server Web Data Administrator from Microsoft but it had a web interface
and locked up. BTW I am running MSDE, if that changes anything. Again thanks
for your help. Hopefully you or someone can point me in the

right direction form here as to how I can obtain a reliable manager.

"tripwater" <ts****@sonador.com> wrote in message
news:%2******************@TK2MSFTNGP12.phx.gbl...
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

Nov 19 '05 #3
The book I have that walks me through setting up sqlserver does not show me
how to setup mixed mode. It starts off running the install then says to run
: setup instancename="netsdk" sapwd="sa" in a command window.

Then run: net start mssql$netsdk to start it.

Can you please tell me at what stage do I make a change and what info I need
to enter please? I do not know what I am doing so I am following this book.
Now the book is covering web forms and it had me setup windows
authentication in the install!

Thanks

"tripwater" <ts****@sonador.com> wrote in message
news:%2******************@TK2MSFTNGP12.phx.gbl...
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

Nov 19 '05 #4
Hi tripwater,

using the MSDE makes it just a bit harder, not unpossible.

I found this on my way through the www:
C:\...MSDE\>Setup.exe DISABLENETWORKPROTOCOLS=0
SAPWD="password " INSTANCENAME="myinstance" SECURITYMODE=SQL

The important option is "SECURITYMODE=SQL" this will allow access using the
userinformations defined in your MSDE. However I'm afraid, you need to
reinstall the MSDE; I'm not sure...

You can find the complete article here:
http://www.codeproject.com/database/...p?print=true#5

regards
patrick

"tripwater" wrote:
The book I have that walks me through setting up sqlserver does not show me
how to setup mixed mode. It starts off running the install then says to run
: setup instancename="netsdk" sapwd="sa" in a command window.

Then run: net start mssql$netsdk to start it.

Can you please tell me at what stage do I make a change and what info I need
to enter please? I do not know what I am doing so I am following this book.
Now the book is covering web forms and it had me setup windows
authentication in the install!

Thanks

"tripwater" <ts****@sonador.com> wrote in message
news:%2******************@TK2MSFTNGP12.phx.gbl...
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


Nov 19 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Mike Kamzyuk | last post by:
Hello all. Basically, I need to call a mixed-mode dll's function (which uses managed code) from a native or mixed-mode dll function (which does not use managed code). I'm wondering if this could...
0
by: Edward Diener | last post by:
I have some questions about the instructions for creating a mixed mode DLL in the MSDN topic "Converting Managed Extensions for C++ Projects from Pure Intermediate Language to Mixed Mode" in the...
9
by: Edward Diener | last post by:
I received no answers about this the first time I posted, so I will try again. My inability to decipher an MSDN topic may find others who have the same inability and someone who can decipher and...
8
by: Bern McCarty | last post by:
Is it at all possible to leverage mixed-mode assemblies from AppDomains other than the default AppDomain? Is there any means at all of doing this? Mixed-mode is incredibly convenient, but if I...
8
by: Nadav | last post by:
Hi, I am writing a performence critical application, this require me to stick to unmanaged C++ as performance is much better using unmanaged C++ ( about 33% better ), Still, I am trying to avoid...
0
by: tripwater | last post by:
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...
2
by: Doug Belkofer | last post by:
We have created a fairly complex mixed-mode DLL that we want to use from VB.NET. The mixed-mode DLL is written in C++, and does use the standard C runtime libraries. An unusual thing is happening...
8
by: Edward Diener | last post by:
By reuse, I mean a function in an assembly which is called in another assembly. By a mixed-mode function I mean a function whose signature has one or more CLR types and one or more non-CLR...
0
by: emu | last post by:
Hi All, I have an unmanaged C++ application that references a mixed mode image DLL (mixed managed and unmanaged). Under .NET 1.1 we could trust the dll (the mixed mode dll) by running the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.