473,813 Members | 3,898 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Authentication issue

M K
Ok a newbie here...

i have a sql server db I got from a book to learn. I am having problems
with the 'Authentication ' mode.

I need a valid id to be authenticated with...

i have a web config file but I am not sure what goes where?

name of server
MKLAPTOP\VAIO_V EDB

connection
MKLAPTOP\Mark

i have both sql and windows authentication selected

heres the web.config
<configuratio n>

<appSettings>

<add key="constring"

value="Server=M KLAPTOP\VAIO_VE DB;UID=MKLAPTOP \Mark;PWD=IPutW indowsPWHere;Da tabase=AspNetJo bs"
/>

</appSettings>

<system.web>

<compilation debug="true"/>

<authenticati on mode="Forms" >

<forms name=".ASPNETJO BS"

loginUrl="~/site/password/login.aspx" />

</authentication>

</system.web>

</configuration>

Is there anything else i need to check/change etc.. please keep in mind I am
in learning mode so a good explination would be very helpful...

Thanks in advance,
Mark
May 9 '07 #1
1 1475
M K (sk*******@eart hlink.net) writes:
Ok a newbie here...

i have a sql server db I got from a book to learn. I am having problems
with the 'Authentication ' mode.

I need a valid id to be authenticated with...

i have a web config file but I am not sure what goes where?

name of server
MKLAPTOP\VAIO_V EDB

connection
MKLAPTOP\Mark

i have both sql and windows authentication selected
...
value="Server=M KLAPTOP\VAIO_VE DB;UID=MKLAPTOP \Mark;PWD=IPutW indowsPWHere;Da tabase=AspNetJo bs"
This won't fly. When you specify UID and PWD, those are user ids and
password for SQL logins, and they don't contain backslashes. To log in
with your Windows login, simply specify "Trusted_connec tion=Yes" or
"Integrated Security=SSPI". Or nothing at all, since Windows authentication
is the default. But you should include UID and PWD, unless you want to
use SQL authentication.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 9 '07 #2

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

Similar topics

2
3438
by: Rob Mayo | last post by:
What I'm trying to do is Create an ASP.Net app that has both Windows-authenticated users and Anonymous users. The idea is this: When authenticated users attempt to access the site, their credentials are passed to the Request, and I use the DOMAIN\USER value via the AUTH_USER server variable to access their accounts. These people would never have to log in to the app, only their machines on the network. When anonymous users attempt to...
0
4254
by: Anonieko Ramos | last post by:
ASP.NET Forms Authentication Best Practices Dr. Dobb's Journal February 2004 Protecting user information is critical By Douglas Reilly Douglas is the author of Designing Microsoft ASP.NET Applications and owner of Access Microsystems. Doug can be reached at doug@accessmicrosystems.com. --------------------------------------------------------------------------------
4
2191
by: Chris Gatto | last post by:
Hi, I'm having what should be a minor problem but has turned into a 2 day slug fest with ASP.Net. I am simply attempting to authenticate my asp.net application users against users in an AD group set up on our domain. It seems to me I am missing something very simple and obvious, but none of the MSDN articles I have read are indicating what this might be. My setup is ASP.Net running on a Windows 2003/IIS 6 server. IIS security...
2
4630
by: Maziar Aflatoun | last post by:
Hi guys, I'm using Windows authentication to connect to SQL Server 2000. On my computer the connection is fine. Now if I move it to a remote server, how to I hard code my Username/Password in my connection string (using Windows NT authentication and not SQL Server authentication)? Thank you Maz.
5
1404
by: Cesar | last post by:
Hello, I have an application that is using forms authentication and it seems to be working fine most of the time. Unfortunatelly, it sometimes just redirects me to the login screen. It seems that the session timed out. But I login again and do the same action, it redirects me AGAIN to the login page: 1. I login to the app now. 2. I hit some* "server side" link button or button (or any other object that raises a server side event). 3....
6
4613
by: eric.olstad | last post by:
I'm pullin my hair out here. I've created a login page that uses Forms Authentication. Initially, it loads the types of authentication methods from a database and asks the user to select the auth method from a drop down list. Each method corresponds to an external module (assembly) that is loaded using reflection and accessed using a common interface. The modules work, I know that. The issues come after I log in. After logging in, I...
2
1426
by: Matt | last post by:
I am getting the following Error. Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual...
18
3420
by: troywalker | last post by:
I am new to LDAP and Directory Services, and I have a project that requires me to authenticate users against a Sun Java System Directory Server in order to access the application. I have found dozens of examples of how to authenticate users against Active Directory, but AD seems to be a different animal than Sun Java System Directory Server. Could someone provide me with an example of how to authenticate a user against a Directory...
4
424
by: =?Utf-8?B?R3V1czEyMw==?= | last post by:
Hi, I created a web site on a remote server. To logon the user must enter a user id and password. The site is uses Forms Authentication. The web config file looks as follows: <configuration> <system.web> <customErrors mode="Off"/>
0
2355
by: embeddedbob | last post by:
Hi there, I appreciate any help on the following issue. I can't seem to find any other similar topic. (CS4, ActionScript 3.0, Flash 10) I have a SWF embedded within a page that is protected by digest authentication. To access this page, the browser asks for username/password. So far so good, the SWF works fine. Now, within that SWF, the script uses URLLoader to POST to another URL on the same server (but a different path than the page)....
0
9607
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10139
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9221
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7681
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6897
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5568
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5704
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4358
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3881
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.