Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Can I Access SQL Login Users In ASP.Net Application


Hello All,


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
How To Use Login-Less Users The Alternate To Application Roles?
SQL Server 2005 introduces a new type of database user, one that is created using the €œWITHOUT LOGIN€? clause. This user is not mapped to a login, and is being touted as an alternate to Application Roles because no password is needed.. What I do not understand is how to use this type of user. I know how to use sp_setapprole with Application Roles, what are the equivalent steps needed to use login-less users?
 
Thank you in advance.
Terry Duffy

View Replies !   View Related
Login Failure For Access - SQLServer Application.
Hi,
I am using a Access and Microsoft SQLServer as a client server application.
But one of my users is getting an error message when trying to open the access database called faculty

Connection Failed:
SQLState: ‘28000’
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]login failed for user ‘PTRICHARDS’.

But it works fine for me as i am an Administrator. Even my user
can open another database called student which asks for SQLSERVER authentication.

But only cannot open this database which does not ask for SQLServer
authentication.

Both the databases reside in the same SQL Server.
IT worked fine till yesterday.

Any suggestions will help,

Thanking you,
Ran.

View Replies !   View Related
Secure .NET 1.1 Application From Users
Hi all.

I am developing an distributed VB.NET 1.1 application with a TripleDES capable socket layer for communication with my server app.

I need to secure the distributed app from the users within the organization I am developing it for (a franchise).

I do not wish to store any encryption keys in the source code as these would be obvious to any seasoned hacker through decompilation of my binaries (even with obfuscation). I have decided to use the windows DPAPI (under machine storage mode) to secure manually entered (at installation) encryption layer keys in the registry. The salt values for this DPAPI mode also need to be secured, as a disgruntled franchise owner may be the hacker (and hence would have admin privilege on the machine the software is installed on). Not as far fetched as you think !

This is the beginning of a vicious cycle. How do I secure and where do I store this salt value safely ? With it a hacker with admin privilige can easily decrypt my keys if they know I am using machine mode DPAPI. Can I use ACLs to protect the keys with an account I set up manually on the machine ? If so then I would need to be able to switch account identities in my code (which I haven't researched as yet) and then would need to store the password to that somewhere.

If anyone could offer any insight or direction it would be much appreciated.

View Replies !   View Related
Users' Access Linked Table From ACCESS To SQL 7.0 By ODBC
Hi Everyone,

I have set up a link from ACCESS to a SQL 7.0 database using ODBC (File DSN saved on a shared DRIVE). The link works well only from the workstation where the link was created. But How can I create a link so a group of users can view the linked table in ACCESS without type a password? Any suggestion is appreciated.

Lunjun

View Replies !   View Related
Can An Authorized User Like SA Create A Table Which The Owner Is Any Users Who Use The Application?
Hi,
 
autorized user: sa
any user : nuran
temporary table:  birtablo
 
I need a stored procedure will execute by sa and it will create some required temporary tables for each users. For example table name is birtablo. I mean sa will create table  for nuran, and when I checked the owner of the table (birtablo) I want to see nuran not dbo.
sa will execute following command:
 
create table nuran.birtablo (...........)
 
Is it possible to cerate a table by sa on behalf of  any user?  If it is, could you please explain?

 
 
Thanks
 
Nuran

View Replies !   View Related
See Application Users (View Server State) Within A Stored Procedure
Hello, i have a problem regarding stored procedures and view server state.
 
I have an application with a lot of stored procedures, one of them checks data of the connected users.
In SQL 2000 i had no problem getting this information, but in SQL server 2005 i do.
 
my stored procedure looks like this:
 

ALTER PROCEDURE [dba].[applsp_GetConnectionInfo]

(

@DBName varchar(100)

)

WITH EXECUTE AS OWNER AS

BEGIN

SET NOCOUNT ON



DECLARE @sCollationMaster VARCHAR(128);

DECLARE @sSqlString VARCHAR(900);



-- Determine collation from master database because collation from master and ultimo database may differ

SELECT @sCollationMaster = CAST(databasepropertyex('master', 'Collation') AS VARCHAR);



SET @sSqlString =

'SELECT max(status) AS Status, max(isnull(SCISUSENAME, ''ULTIMOLOGIN'')) AS Login

, MAX(Rtrim(Rtrim(convert(varchar(255), nt_domain)) + nt_username)) AS NTUser

, max(Rtrim(hostname)) AS Host, MAX(Rtrim(program_name)) AS Program

FROM master.dbo.sysprocesses JOIN dba.SCONNECTIONINFO on SCISPID = CAST(spid AS VARCHAR)

AND ( SCISUSENAME = ISNULL(loginame, '''') COLLATE ' + @sCollationMaster + ' OR ISNULL(loginame, '''') = ''ULTIMOLOGIN'')

WHERE ...... AND DB_NAME(dbid) = ''' + @DBName + '''

GROUP BY hostprocess

ORDER BY Login

';



EXEC(@sSqlString);

END
 
I've granted view server state permissions to my user 'dba' which is the db_owner.
When i execute the query in the stored procedure seperatly as dba i get all the info i need, but when i execute the stored procedure i don't see anything.
 
I seem to have the same problem with sp_who2
Executing it gives me information about everyone but when i put in a stored procedure like this:

alter procedure test

with execute as owner as

begin


EXEC sp_who2

end
I just see information about myself

 
 

View Replies !   View Related
Users And Login Restoration
SQL Server 7 or 2000.

I restore a database on a different server from a device file. This database has a user defined for it. In this case, 'privuser' is the name. No login has been defined.

I can add the privuser login but cannot grant db access because privuser already exists in the db. I cannot drop 'privuser' because the user owns all the user objects in the db.

How can I make the privuser login I create access the db using the privuser username in the db? Would having the login created before restoring the db as a new db work?

View Replies !   View Related
Multi Users On One Sql Login
can there be multiple users on one single sql login?

I keep getting errors from my users randomly about the server timing out and i am wondering if they are trying to submit append queries at the same time.

View Replies !   View Related
Unable To Map Users To The Login
I am new to this, so, I will be greatful to anyone who can clarify the following:
 
qn 1: 
In login properties under Logins of Security, what does creating mapping to the different databases mean ?
 
For a given login, I notice that I can login / execute DDL statements alike for the databases which are checked and also for the ones that are not checked.
 
Then, what does
Security -> Logins - > Login Properties -> User mapping -> Users mapped to this login -> checking the database - accomplish?
 
qn 2:
For a perticular login, say 'Bob' which has server admin rights, I wish to include two more databases. For this I 'checked' the databases, which I wish to include, in the

 
Security -> Logins - > Login Properties -> User mapping -> Users mapped to this login
 
When I clicked 'OK', I get the following error and the two databases are left unchecked. 
 
User, group, or role 'SQL1AGENT' already exists in the current database. (.Net SqlClient Data Provider)
 
How can I include the databases ?

View Replies !   View Related
Does MS Access Installation Is Required For Running Application That Uses Access Mdb File
Hi,

I am developing an application that uses Access database (mdb file) to store the user data. The user of this application is not interested in the database file (to view in MS Access Environment). Does the user machine requires MS Access installation to run my application or just some couple of dlls (OleDB driver, Access DB Engine,..) should be enough to run my application?

 

Thanks,

Rao

View Replies !   View Related
Users & Login After Restore Of DB--URGENT!!
I made a backup of a production database and copied that backup over to a development server and restored the database. Now I have users saying that the application is failing on development. I have users that have NT authentication and some with SQL authentication.

What is the best way to get everything to sync up again?????

View Replies !   View Related
Restoring DB (users/login Problems)
Hi,

I have a few db's that I am backing up from an old sql2000 system and moving them to the new sql2005 server. The first db's restored without any problems but now I am getting some problems with users and logins.

I am restoring in the following order

1.) Creating empty db "123"
2.) Restoring database from file to database "123"
3.) Creating Login to this database (error happens when linking it to the database, "user exists")

When connecting thru QA I get "Cannot open user default database login failed"

I only have 1 login per database and I don't mind manually deleting and recreating them all but it doesnt seem to be working :S



Any suggestions much appreciated!! :)

Thanks!
mike123

View Replies !   View Related
Force RS To Use Database Login For Users
I am in a situation where I would like to use a SQL login instead of adding individuals windows login to the server. Is there a way to force a login instead of having the report server not give rights at all??
 
I hope that makes sense...
 
Thanks

View Replies !   View Related
Parameter Selected By Users Login
I'm trying to set up my reports with parameters, to select the paramater by the users login. For example, if someone from the Northwest Region accesses Report mangers and then a report. Instead of them clicking the drop down, for the report parameter. The report automatically generates from the login that gave them access to report manager. So it diplays the information for the Northwest Region.
 
I know how to do this for  Data Driven subscriptions.Such as creating a table , with Region, login, email, and all the information relevant. But how do i do this for users accessing the site theirselves? Is this possible?

View Replies !   View Related
Login To SQL Server For Web Application
Hello everyone,I am currently developing a web application that retrieves and updates contact information in a database.  I am coding the application with VB.Net and ASP.Net with a little bit of javascript.  It is accessing a SQL Server Database.Everything is working fine when I run the web application from within the VS.Net environment.  However after publishing the website to our local Intranet (where the app will be stored) I get the following error:Server Error in '/ollodev1/RIC' Application.

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Description: An
unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the
error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Source Error:





An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below. I assume that this message appears because I am not retrieving setting the proper access rights from the DB but I don't know how to go about doing this.  Could someone provide me with a link to a few examples to help resolve my issue?Thanks,Eric 

View Replies !   View Related
Application Login SQL Error
I created a ASP.net 2.0 application using C# on VS2005 The application access several database on a remote SQL Server 2005I recently added Login functionalties  to the application, this created a MDF in the app_data folder.Everything works fine on my local desk top... I can access my remote SQL Server 2005 and the local MDF file works fine, I can create account, login and all that fun stuffSo I Published the site to my target server:Which is the same server running the SQL Server 2005 The parts of the application that does not require login works fine, I can access the SQL server 2005 with ease..see data, update, everythingHowever when ever I try to login or create an account from the application(MDF file) I get this:An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)I can only assume that the problem is with the MDF file. Can anyone point me in the right direction?Thank you Andre

View Replies !   View Related
Login/Users Out Of Sync When Restoring To Backup Database
We have a backup/standby server which is restored every night from the daily dump on the main server. Everything seems to work fine, except that the logins/users become out of sync. The logins seem to be fine, but the user names which belong to the different logins do not restore properly which causes problems when using the backup server.

Does anyone know why this happens? Is there a workaround for this?

View Replies !   View Related
Application Login Failure After SQL 6.5 To 6.5 Migration
Over the weekend, I attempted to move six databases from an older server to a newer one. I have installed SQL 6.5 on both with identical configurations. After migrating the data, bringing down the old server, renaming the new server and configuring the ip address, I ran into a problem. Two applications that access databases on the server were unable to login using any id other than the system administrator id. Each of these applications have been tested on a test server with the same configuration as the new and old production servers. Each installation is on an NT server with SP6 and each SQL install is using SP4. One of the applications gives an OLE DB error. Any suggestions would be appreciated. Thanks in advance.

View Replies !   View Related
Application Login And Integrated Security
Hello,
 
We're having a bit of a problem getting Integrated Security to work with a .Net 2.0 application and SQL 2005. While we're tweaking permissions on the SQL-side, we came across an account "Application Login" and wondered what its role is. First, our problem:
 
Currently, the users in the AD group get a connection error. This group is defined as follows at the instance level:

role: public
user mapping: to the database without any default schema
securables: none
status: grant and enabled
 
At the database security level:

general: none
securables: execute on all (100+) stored procedures
 
And we gave them "Execute" on the database itself.
 
A little background: we had detached and copied this database from one server to another. So we suspect that the Application Login may have been modified/corrupted, even though it appears to be identical between the original and the copied databases. So we redefined it on the copied DB to match the original.
Another group, which is defined as dbo on the database, has no problem at all connecting and running the application.
 
The Application Login has Execute permissions on all stored procedures and Delete, Insert, Select, Update, and View Definition on the ChangeLog table. It also has db_DataReader, db_DataWriter, and db_ddlAdmin roles associated with it.
 
Is there another SQL login required for initial connection to the database even though Integrated Security=SSPI is used in the connection string?
 
Does anyone see where we may be missing a security setting for the non-dbo user group to connect to the database?
 
Thanks very much for any suggestions, ideas ....
Cheers,
Tess

View Replies !   View Related
How To Authenticate Users Using User Login And Password Stored In SQL Database?
Hi. I have a DetailsView with Bound Fields "Login" and "Password". This informations are stored in SQL database. How to solve such authorization? How to compare password stored in database against passowrd typed by user? Is this a good idea to use CustomValidator control to write some checking procedure?. Regards. Pawel.

View Replies !   View Related
Generate Script For Current Sql Server Login And Database Users
Hello Everyone
How do you generate a script for all the current sql server logins and generate a script for database users for each database.? You can script operaoers, tables, databases, and a lot of other objects by using the “All Tasks” shortcut menu option, but I haven’t figured out to script logins and database users. Any help would be greatly appreciated.

I’m using sql server 2000 and Enterprise Manager.

Thanks
GEM

View Replies !   View Related
Diffrence Between Roles, Accounts, Login, Users Permissions And Groups?
I have jsut started using SQL server 7 and am having problems with accounts permissions, users,roles, groups, owners etc what are the differences?

View Replies !   View Related
How To: Determine If Current Windows User Has Login Access, Database Access And If They Are A Member Of A Specific DB Role.
 
I need to determine the following about the current authenticated Windows domain user who is trying to access a SQL Server via a trusted connection.
 
1 Has the current user been granted login access to the trusted SQL Server?
 
2 Has the current user been granted access to a specific database?
 
3 Is the current user a member of a specific database role such as (DB_ROLE_ADMINISTRATORS)?
 
Thanks,
Sean

View Replies !   View Related
Problem Login Failed With Installed Application
 

I have an application that uses an MDF file as a database. Debug mode of application on developing machine works fine.
I synchronize my project to my home computer so that I can work home too. (I use AllwaySync for synchronisation, it copies newer file from the old location overwriting the old ones).
 
I also have a setup project in my solution for that app.
 
When I create and install the application on my local computer everything works fine. But when I install it one a different computer and then run it, it cannot connect to database. The error occures while conencting to database saying:
 



Code Snippet
Unable to open the physical file "C:Program Files........VBDB.mdf". Operating system error 5: "5error not found)".
Unable to open the physical file "C:Program Files........VBDB_log.ldf". Operating system error 5: "5error not found)".
Cannot open user default database. Login  failed.
Login failed for user 'EKAROMAEka''.
File activation failure. The physical file name "C:Program Files........VBDB_log.ldf" may be incorrect.
 

 
 

the second time I try run my application I get the following error (and all following tried where resulted in this error):



Code Snippet
Cannot open user default database. Login failed.
Login failed for user 'EKAROMAEka'.
 
 


These exceptions are caught by "try catch" when feeding data into DataGridView om my main form.
 
I have the sam username and password on my Home and Work computers.
 
I'm not very good at MSSQL security. I don't know how to solve this problem. I can't even understand wheather this is a security that's built in an MDF file or some kind of a Database server issue.
 
the connection string that I use for connecting to SQL Server is this:
 



Code Snippet
Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|VBDB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=False
 
 



 
 
Thanks in advance.

View Replies !   View Related
Login Failed For 'user' (Application Role)
I've created a database in SQL Express and I have a Windows form attempting to connect to it through SQL Authentication. Connection string:

private string connString = @"Data Source=.sqlexpress;Initial Catalog=SQLTestDatabase;User ID=SearchAppRole; Password=password;";

The role I have added to the database is an Application Role. It has been added to the Database permissions with Grant checked for "Select" and "Authenticate".

If I test this with query analyzer, it returns expected results (if I remove Grant from 'Select', it fails)

sp_setapprole 'SearchAppRole', 'password'

select * from recipe

If I edit my connection string (for testing purposes) to use the sa account, the application can connect and run the Select statement:

private string connString = @"Data Source=.sqlexpress;Initial Catalog=SQLTestDatabase;User ID=sa; Password=sa_password;";

However, I cannot get the application to successfully logon and run the select statement when using the user id and password of the Application Role. I get error:

System.Data.SqlClient.SqlException: Login failed for user 'SearchAppRole'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj


I can't find much information on Application Role...I just want one basic permission for the application as a whole. Any help is appreciated. Thanks.

View Replies !   View Related
Sql Server To Access An Application In MS Access
Hi,
Can anyone tell me how i can access an application or open tables in MS sql server that are in MS Access. Its urgent and any help will be appriaciated.

View Replies !   View Related
Users' Access Through ADO
Hi,
I'm writing a program to access a SQL server and my problem is that if I use a user that isn't an administrator the login is failed.

It specifies the " DomainUserName "

Maybe it wouldn't have bothered me so if I didn't see it working on the last server I had. Unfortunatly, that one was formatted and I wasn't the one installing the SQL server on it.

Does anybody know how to make the SQL server more tolrant to users?

Thanks,
Chen.

View Replies !   View Related
Do My Users Need A Copy Of Access
I have a java program that accesses an ms access database throughodbc:jdbc.When deploying my program will the users need a full version ofmicrosoft access to be able to use it?If not, what do they need and where can i get it from.Thanks

View Replies !   View Related
Users Cant Access New Database
EMERGENCY 911 HELP PLEASE

Ok I created a database SQL is the engine and Access XP is the gui. When the users try to access the databae they get error message, it opens up but they cant open the forms for some reason. I was wondering if this had to do with me have Access XP and them having Access 2000, but I highly doubt it because when I had a user log on to my machine (which has access xp) they still were not able to access the forms. Can someone help me out PLEASE PLEASE PLEASE... this is so frustrating :(

One thing I'm noticing is that the users connection keeps dropping???

View Replies !   View Related
Allowing Users Access To Their DB Only?
Hey all.

I'm trying to set up SQL Server so that people with Enterprise Mgr can create a DB registration to their DB only (sql.yoursite.com). Are there any tutorials out there for doing this?

Thanks for the help!

View Replies !   View Related
MS Access Concurrent Users
Hi,

Does anyone know is MS Access has any limited no of users, or how many concurrent users MS Access has?

Thanks

View Replies !   View Related
Users Limited Access By IP
Hiya - this might be a bit of a simple question but please bear with me! I have looked reasonably hard for this but can not find an answer:

I have an MSSQL 2000 server running on PC-A and would like to limit certain users (e.g. admin) to be only able to logon when using the actual PC-A machine.

I am aware that you can acheive this in MySQL with the "insert into user (host, user, password) values (localhost, username, password);" command. Is there an equivalent way to do this in MSSQL?

Thanks for your help,

Alistair.

View Replies !   View Related
Schemas, Users, Logins, Database Roles, Application Roles
Hello,

I am new user of SQL Server. I have some problems with these words. I want to make my database works in my specified permissions. I will specify permissions with schemas and these schema wants an owner. I want this owner should be my user. When creating a user it needs a valid login. I am selecting my login and it occurs and error says this login has an different user. I am specifying permissions with roles. But i can't make association all of them. I hope i told my problem to you as well. If you explain these words to me and tell me how can i do my database's works with my own schemas, users and roles i'll be grateful. Thanks for advices.

Happy coding...

View Replies !   View Related
List Of Users Access By Database
Hello,

is there a master table that i could querry to buiild a report on the users who have acces to the various databases on the SQL server. I am trying to use master.dbo.syslogins but that is not generating what i need.

thak you all in advance,

Simon

View Replies !   View Related
Access For Users To SQL Server Read Only
I have SQL Server 7 database & I need to create some interface between users & database to let users see what is in the database, but not let them change or destroy data. Do I need to create some other database in-between users & the original database? Users can't program & want access to all data.management doesn't want to create a replication of the database. They want to let users have access through MS Word or Access. What could you advise me?

View Replies !   View Related
Allow Users To Access Report Server
Ive finally gotten my report server setup to run. I can access the reports via IIS from a remote computer if I login as the server administrator. Ive given certain users permissions to the /Program Files/sql server/Reporting Services/ folder, however, when I try to enter their login info, from the IIS login prompt when i visit http://servername/ReportServer/ I am unable to login. How do I grant users permission to login to report server?
 
thanks

View Replies !   View Related
Access Forbidden: Too Many Users Are Connected
I have a web application that runs on IIS on Windows XP professional. I have reached the max number of connections to the IIS website. So, I tried the approach of disabling HTTP Keep-Alives.
 

 All is fine and dandy until my Business Intelligence Studio report project attempts to set the parameters for a report using report viewer at which point I get the following error message:
 

"The request failed with http status 401: access denied."
 

 How can I fix this? I have posted this over at the asp.net forums, but I figured I would check here to see if anyone else has solved this problem.

View Replies !   View Related
How To Maintain Users Permission And Access Level
Hi guys,
We have a scenario where there are about 50 tables in our database and we want to build an intranet web application for users to with the office to access those tables.
Users ability to access tables falls into diferent category:

Some users can NOT view some tables at all
Some users can ONLY view some tables but not insert/update any field
Some users can view and also insert/update some tables (in the same time they might not have view(select) permision on some other tables)
Now, what is the right way to implement this.
I say we have to have a Role, RolePermission, User, UserPermission inside our database to implement this (something which would look like the Roles and Users inside MSSQL) and we only have one user for our Database (MachineName/ASPUSER) to access the database and all the tables within
My colleague says NO, instead of creating all these tables and implement this, we add every user of our application as a Database user inside MSSQL in the Databse Users.
All the web application I have seen so far, DNN, CommunityServer, ... the have tables to implement all these and they don't add users inside the MSSQL.
Now which way is the way to go with, and what problem might we fall into if we use SQL users, is this possible at all. How can I convince him that we have to make and use our own tables to manage this.
 Thanks for any help,Mehdi

View Replies !   View Related
Granting Users Access To SQL Server Express
I have now succefully setup SQL Server Express on an Admin PC in my office and can see it and connect to it easily from my PC using my NT logon.

My application is complete and runs a treat for me connecting to the server from my PC.

I have now deployed the application using ClickOnce and it has all gone smoothly, except for other NT users gaining access to the database?

Within MSMSE I have clicked on Security-Logins and can see my NT login details are present and as me I can administrate the server/db.

I have added a few new logins and even tried to match them to my settings but from their computers the application fails to logon to the server/database.

Within the ODBC setup the server is visible for them but they cannot connect?

If I logon to their computer it works for me?

This section is new to me so I am struggling to get it to work, can anyone throw me a bone please?

Thanks

View Replies !   View Related
Finding All SQL Users Permissions And Access On Every Server And DB?
 

Hello team, I have learned quite a bit from everyone here. I have decided to post a question for you guys and see what the best method is. Our Sr. DBA has asked me to get a list of all of our users permissions on all of our databases. We have about 20 SQL servers some of which have more databases and instances than I have fingers and toes. Can anyone recommend any solution to this problem? Perhaps there is a script I can download/write which will help me on this? Thanks in advance.

View Replies !   View Related
Can Multiple Users Access The Same Report Simultaneously?
We are currently using Crystal reports but are considering using SQL RS. We need to know if there is a restriction on simultanoeus access to the same report by multiple users? What happens when multiple users try to access the same report simultaneously? If reports can be accessed simultaneously, do the requests queue up or are they processed concurrently?

Any help on this issue is greatly appreciated.

View Replies !   View Related
SQL Server Access From ASP.Net Application.
Hello all,  We have a SQL database that uses a MS Access projectfront-end, which I am now creating an ASP.Net application for (And am completely new to so may be missing some foundation concepts).  With the Access project I added Active Directory groups to the database to use for permissions, logins, etc.  For the ASP app I have it set to use Forms authentication  with Active Directory (ActiveDirectoryMembershipProvider).  I can login to the app with the AD usernames/passwords but the connection from ASP.Net to SQL is using the ASP User.  Is there a way to provide the authentication from the ActiveDirectoryMembership through to the SQL server, so the user: bobuser would be authenticated to SQL instead of ASPNETUSER?Or do I need to have the ASP.net app handle the permissions of which SP's a user can execute?Any help or suggestions are appreciated.Thanks,Jamie.

View Replies !   View Related
Changing Access Db To Sql Db Web Application.
I am experiencing problems with databases for the web application that i am developing. The problem is that I have transferred the database from access to sql which initially seemed to work ok. I am now however struggling to solve the problems with one of my fields titled 'notes'. The trouble is that in the original database the notes field contained different notes from different dates for each record, and each note is separated by carriage returns. It is the carriage returns that are now proving to be a problem in the sql database but i am not sure what to do. Any advice would be appreciated.ThanksDan

View Replies !   View Related
Access SQL Server From Application
Hi,

I have recently transfered data from MS Access to MS SQL Server 2000 and created user interface in MS Access Project (ADP). Now I need to secure the data on server and want to access it ONLY through interface I created in MS Access. Every user has to log in the application (user id and password). Users may have the same access rights to the server (so maybe just one account or whatever I need for all of them). Can anyone advice me how to set it up? To access sql server from MS Access I am using ADO.

Thank you.
dj

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved