Authentication An Application Using Windows Integrated Authentication

May 12, 2006

Hi all,

My work is using a shared application
which accesses a MSSQL 2000 database. To access the application, the
folder on the Windows 2003 Server is shared and users can access the
folder through a shared drive.

For the application to access the
database, it uses an ODBC connection to the MSSQL server which
originally used the SA password.

We have recently switched to using
Windows Integrated Authentication because we believe it offers a
higher level of security. However the only way in which we have been
able to enable this is to add the windows users to the SQL server.

The problem with this is that the
application sets permissions for individual users on what records
they can see within the database. We have found that by adding the
windows users to the SQL Server, they can bypass the permissions the
set by the application by simply using any application that can use
an ODBC connection, such as Enterprise Manager, and see all the

One way around this would be to set up
domains of users with access privileges to the tables which reflect
the permissions set by the application, and configuring a view of the
data so they may only see the records that they have permissions to.
However to do this would require a high administrative cost to ensure
that changes made in the application are reflected in the privileges
of the SQL server.

Instead, is there a way the SQL server
can authenticate that the ODBC connection is coming from the correct
application using Windows Integrated Authentication?

This would allow the applcation to
determine security, and stop users from connecting to the SQL server
using other applications.

Alternatively, can the SQL server,
using Windows Integrated Authentication, also ask the application to
supply a username and password?

Any help with this matter would be
greatly appreciated.


View 4 Replies


Using SQL Authentication And Windows Integrated Authentication Concurrently

May 15, 2006

Hi all,

I've got two applications which both have a database on my MS SQL 2000 server. The problem is, one application must use Windows Integrated Authentication (which it is currently using and cannot be changed) whilst the other application which I'm trying to configure must use a SQL password.

Since the server has already been configured to use Windows Integrated Authentication for the existing database and application, how do I configure the other database to use the SQL password?


View 1 Replies View Related

Windows Integrated Authentication - Domain Controller

Feb 24, 2007

If my SQL Server authentication is windows integrated authentication, whenever my application makes a connection to SQL server does it contact the windows active directory domain controller to authenticate the windows user account? How does windows integrated authentication work in the background?

View 9 Replies View Related

SSRS And ASP.Net And Windows Integrated Authentication Failure In Internet Explorer

Jun 1, 2006

I have a very confusing problem that I'm going to attempt to relay concisely:

I have a LAN on which I'm running an Intranet web site built in ASP.Net 2.0 and using SSRS / Sql Server 2005 on the same server.

The name of the box is "warehouse" or "" When I ping "warehouse," I get a response from, as I should. Likewise, I get a response from when I ping "" If I do a "ping -a" on, it correctly resolves to "" Based on the facts presented in this paragraph, I believe that my DNS is working as expected.

Using IE (6.0.2900.2180.xpsp_sp2_gdr.050301-1519) with "low" security settings, I navigate to (Lex is the name of the app) and it authenticates me to the index page (which calls the SSRS web service to get and display a list of available reports), except that I get the login prompt three times. If I hit F5 (refresh), I get three more login prompts and then I get a 401.1 error. From this point, no matter what I do, I can not see the index page again without closing and restarting IE.

I know that IE only passes credentials to certain sites, so I add my domain ( to the Local Intranet list ( Tools->Internet Options->Security->Local Intranet->Advanced) and then I can refresh and see my index page once, but I still get 3 login attempts and then the same thing happens -- I refresh and go through 3 logins and then get a 401.1.

If I now change my address bar to read, I get a single login and it works like a champ. This makes me think that there's a DNS problem, so I open up Mozilla Firefox and wouldn't you know it -- Firefox works like a champ all around -- one single sign-in, it keep credentials between Lex and SSRS, and it appears to use the DNS correctly. However, I can't use Firefox because I can't get any of the SSRS reports to look like they're supposed to in Mozilla-based browsers.


I have set my IE securtiy settings to "Low." I have added the primary domain to the Local Intranet list and also to the Trusted Sites list (but you can't do both at the same time). I have even added the internal IP to my "hosts" file.

Does anyone know anything that might be a help to me in getting this figured out?

Other notes of interest:

My machine is an XP machine, but is not on the domain, but I do have a valid domain login that I use and it works in Firefox without problem.

View 6 Replies View Related

Switching From SQL Authentication To Integrated Authentication?

Aug 25, 2006

Hi,I'm using SQL Server 2005. My Connection String looks like that at the moment: <add name="LocalSqlServer" connectionString="Data Source=xx;Initial Catalog=xx;Persist Security Info=True;User ID=xx;Password=xx" providerName="System.Data.SqlClient"/>    Now I'd like to change this kind of authentication to Integrated Windows AuthenticationI added the WorkerProcess IIS_WPG to the permitted Users but it didn't help.Changed the Connection String to this:connectionString="Server=xx;Database=xx;Trusted_Connection=True;"All I'm getting is that my NetworkService is not permitted to access DB when I try to connect to the DB in ASP.NET.How can I properly configure that? Thanks!

View 4 Replies View Related

How To Give Authentication For Send Mail Task Component? [not Default Windows Authentication]

May 11, 2007

How to give authentication for Send Mail Task component?

View 4 Replies View Related

Switching SQL 2005 Authentication Mode From Windows To SQL Authentication

Apr 18, 2007

Hi there,I have installed MS SQL Server 2005 on my machine with windows authentication. But now I want to switch the authentication mode to SQL Authentication. I am unable to switch, I can’t find the proper way to do so here in 2005.Could any one help me in doing this?Thank you,-Ahsan

View 1 Replies View Related

Sql Authentication = Fast./ Windows Authentication = V.slow!

Mar 25, 2004


(Using win2k, sqlserver2k, framework 1.1)
I have an fairly data-heavy application that uses Windows authentication (Trusted connection/aspnet account) to connect to Sql Server. The site uses IIS basic authentication.

On the dev server everything works fine but when I move to the live server things get strange and it starts to crawl along. (Pages load OK but then it just crawls as it loads the datagrids etc. Sometimes it brings back incomplete/incorrect data )

BUT When I use Sql Authentication to connect to Sql Server and there is no problem at all!

Ok, there is something obviously wrong with the live server (which is identical setup to dev)but I dont know where to start.

Any ideas??

View 2 Replies View Related

SQL Database In My Application With Windows Authentication Rejects Accessing After Deploying And Remote Access

Dec 13, 2007

SQL Database in my application with windows authentication rejects accessing after deploying and remote access
1- My web applications databese access is windows authentication
2- In developing area there is no problem for accessing database
3- After deploying to another server there is problem accessing database:
Cannot open user default database. Login failed.Login failed for user 'BRCK231ASPNET'.
 How can I solve this problem?

View 1 Replies View Related

Difference Between Sql Authentication And Windows Authentication

May 8, 2003


Can anyone tell me what is the difference between sql authentication and windows authentication.

Examples of each would be very useful

Many thanks in advance


View 2 Replies View Related

SQL Server Authentication Vs Windows Authentication

Oct 16, 2006

Would anyone please help me out here. which of the 2 modes of authentication is better and why??

View 3 Replies View Related

Using Windows Authentication V/s Mixed Authentication

Dec 18, 2006


Say, I have configured my SQL to use Mixed Authentication. Now, I have a applicaiton which uses my SQL Server. The application just creates a database in SQL Server and uses the database to store its information.

This application also has a SYSTEM DSN under ODBC through which it accesses the database. For the application to access this database, should I only use SA (as my SQL instance is configured to use Mixed Authentication) or can I use Windows Authentcation too...

If I should only use SA, do we have a documentation which talks about this.


View 1 Replies View Related

Windows Authentication Vs SQL Server Authentication

Mar 12, 2008

For using different services of SQL SERVER 2005 which is better...
Windows Authentication or SQL Server Authentication?
what are the advantages and disadvantages of both?

View 5 Replies View Related

Report Manager With Forms Authentication. Report Server With Windows Authentication.

Feb 1, 2008


I wonder if it is possible to set forms authentication for report manager but leave report server "as it is". I need to authenticate users from external LDAP and can't use windows authentication for report manager, but I would also like to leave report server open for anonymous users. In that way authenticated administrators could create reports which anonymous users could read.

I tested the Security Extension Sample and got it working when I rewrote the authentication part with my own LDAP authentication.

If I have understood correctly, the report manager is just application inside report server so is it possible to use forms authentication with one application but still leave the report server with Windows authentication?

View 1 Replies View Related

Integrated Authentication

Aug 20, 2007


I am writing project in asp .net with sql server 2005. But I need support him by some applications like deamon in linux systems.(but it will be in windows) So i write it in java. I download jdbc driver and install it. I wrote simple project:

package MainW;
//import javax.mail.*;
//import javax.mail.internet.*;
//import com.sun.mail.smtp.*;
//import javax.swing.*;
//import java.awt.*;
//import java.awt.event.*;
import java.sql.*;
//import java.text.DateFormat;
//import java.text.SimpleDateFormat;
//import java.util.*;
//import java.util.Date;

class Main
public static void main(String[] args)
String connectionUrl = "jdbc:" + "sqlserver://localhost;databaseName=ASPNETDB.MDF;IntegratedSecurity=True";
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
con = DriverManager.getConnection(connectionUrl);
String SQL = "SELECT * FROM aspnet_Users";
stmt = con.createStatement();
rs = stmt.executeQuery(SQL);
// Iterate through the data in the result set and display it.
while (
System.out.println(rs.getString(4) + " " + rs.getString(6));
catch (Exception e)
if (rs != null) try { rs.close(); } catch(Exception e) {}
if (stmt != null) try { stmt.close(); } catch(Exception e) {}
if (con != null) try { con.close(); } catch(Exception e) {}


But i have error:
2007-08-20 15:20:59 SNISecGenClientContext
WARNING: Initialize context failed
2007-08-20 15:20:59 SSPIData
WARNING: ConnectionID:1 TransactionID:0x0000000000000000 Authentication failed code-2146893052 This driver is not configured for integrated authentication.
at Source)
at Source)
at Source)
at Source)
at$000(Unknown Source)
at$LogonCommand.doExecute(Unknown Source)
at Source)
at Source)
at Source)
at Source)
at Source)
at Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at MainW.Main.main(

I am googling about this error second day but i cannot find solve.
Please help.

View 1 Replies View Related

This Driver Is Not Configured For Integrated Authentication

Oct 26, 2007

My OS is Windows Vista and I'm running SQL Server 2005 with SP2 and I have installed JDBC driver sqljdbc1.2 on my laptop.

I tried to connect it to the database Employee on Database Enginee Server
Here is the code:

import java.sql.*;

public class MSsqlConnect{
public static void main(String[] args) {
System.out.println("Microsoft SQL Server 2005 Connect Example.");
Connection conn = null;
String url ="jdbcqlserver://localhost:1433;integratedSecurity=true";
String dbName = "Employee";
String driver = "";
String userName = "Gurumurthy";
String password = "pa55word";
try {
conn = DriverManager.getConnection(url);
System.out.println("Connected to the database");
System.out.println("Disconnected from database");
} catch (Exception e) {

When i run the program i got the msg:

C:UsersGurumurthyDesktop>java MSsqlConnect
Microsoft SQL Server 2005 Connect Example.
26 Oct, 2007 10:05:09 AM <clinit>
WARNING: Failed to load the sqljdbc_auth.dll This driver is not configured for integra
ted authentication.
at Sou
at Source)
at Source)
at$000(Unknown Source)
at Source)
at Source)

at Source)
at S
at Source)
at Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at MSsqlConnect.main(

Could anyone pls help me out to fix it.

thanks & regards,

View 1 Replies View Related

This Driver Is Not Configured For Integrated Authentication.

Mar 26, 2007


My sqljdbc.jar is located in the following directory

C:Program FilesMicrosoft SQL Server 2005 JDBC Driversqljdbc_1.1enu

And I copied x86 directory from C:Program FilesMicrosoft SQL Server 2005 JDBC Driversqljdbc_1.1enuauth

And used following steps to establish database connection

String connectionUrl = "jdbc:sqlserver://localhost:1433;IntegratedSecurity=true;";
Connection con = DriverManager.getConnection(connectionUrl);

and getting the following error

Mar 26, 2007 12:51:50 PM <clinit>
WARNING: Failed to load the sqljdbc_auth.dll This driver is not configured for integrated authentication.
at Source)
at Source)
at Source)
at Source)
at Source)
at Source)
at Source)
at java.sql.DriverManager.getConnection(
at java.sql.DriverManager.getConnection(
at testproject.JdbcDriverTest.main(

Please help me out in fixing this issue.



View 10 Replies View Related

Sql Authentication Vs. Windows Authentication

May 31, 2007

I am in the process of rolling out a sql server 2005 enterprise install and had a question regarding authentication. We will be providing sql hosting for a number of groups on our campus, many who are not using our campus-wide active directory, though they all have an AD account.

Windows authentication via the management studio appears to use your AD authentication tokens and will not allow them to enter a username/password combo. Is there any way to configure this?

I would like to use our campus AD for obvious reasons but if there is a requirement for passing tokens this isn't going to work right? It's also going to make database mirroring more of a challenge.


View 3 Replies View Related

Reporting Services 2005 In SharePoint Integrated Mode With Forms Based Authentication

Feb 6, 2008

Well, I have SQL Server 2005 SP2 Reporting Services installed and configured in sharepoint integrated mode, so I am deploying reports in sharepoint libraries. Also I configured sharepoint to use forms authentication with builtin AspNetSqlMembership provider, but after this action I couldnot open reports through sharepoint library, instead of this, error was displayed mentioned below. I searched and found hotfix Cumulative Update 3 build 3186 for this issue, request it from microsoft support and applied it, but nothing has changed!

Error I have been experiencing is following:

An unexpected error occurred while connecting to the report server.
Verify that the report server is available and configured for
SharePoint integrated mode. --> The request failed with the error
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="/_layouts/login.aspx?ReturnUrl=

I continued to dig and find out that this hotfix should update Microsoft.ReportingServices.SharePoint.UI.WebParts.dll from version 9.0.3042.0 to new version 9.0.3180.0, but when I checked file version after applying hotfix, it remained the same as was before i.e. 9.0.3042.0. Apparently this cumulative update does not fix this issue.
anyone has any idea how to solve it? Thanks in advance.

sorry for my poor english :-)

View 2 Replies View Related

Unable To Connect To SQL SERVER 2005 Database Engine Using Windows Authentication Under Windows Vista...

Mar 26, 2008

Hallo there,

I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available.

My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs.

I enabled all the protocols and all the ports
I disabled windows firewall and antivirus (eset nod32)
I installed all service packs available
I have also installed Visual Studio 2005 without installing sqlexpress

But nothing happens!

Please i am very desperate, any information will be gratefully accepted.

This is my installation Information

Code Snippet

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.1434
Operating System 6.0.6001

Thank you in advance,

View 3 Replies View Related

SQL Sever 2005 Express Move Windowns Authentication Choice To Mixed Authentication

Aug 22, 2007

I folks.I Have installed sql server 2005 express and choosed windowsauthentication on instalation, but i make a mistake and now i needmixed authentication, how can i modify this whithout uninstall andinstall again the application?thanks for the help.

View 2 Replies View Related

Windows Authentication

Oct 24, 2006

My SQLExpress seems to be set for windows authentication and not sql server authentication ... I am not quite sure why it is set to windows authentication - I installed this with Visual Studio 2005 and it just seemed to be set that way.Am I able to change this - if I choose sql authentication when connecting I get an errorIf someone could answer this point I would be most grateful !!Patrick

View 1 Replies View Related

Using Windows NT Authentication

Sep 30, 1999


I'm trying to use Enterprise Manager in Windows 95, and attempting to
connect to SQL Server with Windows NT Authentication but get message:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server Connection.

I can connect okay using SQL Server Authentication.

How can I connect using Windows NT Authentication?

It's SQL Server 7 and protocol TCP/IP I'm using.

Any help would be appreciated.

View 3 Replies View Related

Windows Authentication

Nov 24, 2003

In an effort to eliminate the need to code accounts and passwords into the VB Com calling stored procedures, I would like to use Windows Authentication. I have setup the account that the com is running under to have access to the database. How does this change my connection string. Do I just drop the account and password parameters or do I need to let it know somehow that I want to use Windows Authentication?

Ken Nicholson

View 3 Replies View Related

Windows Authentication

Aug 23, 2006

I'm having problems with windows authentication. I'm new to using using Microsoft SQL Server. I just migrated from powerbuilder 8 to powerbuilder 10. I'm using OLE DB and can't get the windows authentication to work within the application. Can anyone help....

View 2 Replies View Related

Windows Authentication

Mar 29, 2007

I am wondering that do we need to create the separate login at SQL SERVER (server) for all the user using the application for the windows authentication?

How do the windows authentication works? I have a apllication and SQL SERVER (SERVER) running on the same machine. Any user from the same domain can access the application. Application is interacting with the DB through Windows Authentication. Now my question is whether do we need to authenticate each user from the domain at the DB level. That is to craete the login id for all the user for windows authentication.

Rahul Jha

View 1 Replies View Related

Windows Authentication.

Feb 23, 2007


How to stop user to login using Windows Authentication.



View 2 Replies View Related

Windows Authentication

Jun 7, 2007


I remove the windows authentication from enterprise manager.
and Now i want to re-assign the the windows authentication . so can i do it from query analyzer.


View 2 Replies View Related

Windows Authentication

Dec 3, 2006

Hi all,You're all stars, really helpful. Maybe one day i can be :)My question is regarding the authentication in Windows SQL Server 2005.We have setup a sa account. We purchase software from a third partythat runs on it. Before their software logs on the sql server as sa,and does its own access control, windows autentication takes over. Itslogs users on correctly i guess, using a more secure link via thedomain. However, I am probably blind, but where can we assign rights toeach domain user? I.e. stop XXY dropping tables, but allow ABC to droptables?I had a brief look through but could not find anything that stood out,in the SQL Manager.ThanksDavidP.S This is SQL Server 2005 Workgroup edition running on a 2003 windowsdomain server. Alongside a SQL 2000 server, which is running fine usingsa accounts.For those in the same timezones as me... have a good evening.

View 1 Replies View Related

Windows Authentication

Jul 20, 2005

Hi! Happy New Year!I'm having windows authetication connection problem. Although I cansee all the servers by using SQL Server authentication conncection, Ican see only some of the SQL family servers by using windowsauthentication connection. I checked the servers' properties of that Ican and can't see, but couldn't find any difference. Can someone giveme a direction that will enable me to debugg?If the servers are not in the same domain, how can I see them (windowsauthentication) from the same PC (client)?For some SQL server I even can not login via windows authentication atterminal server. Is any specific setup I should do at server?Thanks!Saiyou

View 1 Replies View Related

SA To Windows Authentication

Jul 20, 2005

Hello,We have a SQL 2000 installation (running on NT4 SP6a) with a databaseaccessed by a client application. Currently the application logs into thedatabase using a the SA account. I'd like to move the client access over toWindow Authentication. Each user has their own NT account. What steps do Ineed to take to achieve this?Any help would be greatly appreciated.James G.

View 1 Replies View Related

Windows Authentication

Oct 19, 2006

When using Windows Authentication and the Client (xp home edition) has NO PASSWORD and he accesses a server with sqlexpress...does that default him as 'guest'....

What is difference between State 8 Password Mismatch and 9 Invalad password

View 3 Replies View Related

Windows Authentication

May 4, 2007

We have an application that uses SQL Server 2005 (Express) as its database server.

We have SQL server and the application database on our server.

To setup the application we need to point it to our database from the clients and specify authentication as either SQL server or Windows Integrated Authentication. We chose Windows Integrated Authentication. This works fine for an administrator user but for a standard user with non administrator privileges , authentication fails and we cant access the database. The client is running Visa Business with UAC on. If I run the application as adminisrator and enter the administartor username and password then I can connect otherwise it is rejected.

How can I can configure SQL server to allow non administrator users to access it using Windows Integarted Authentication.

The server is running SBS 2003


View 3 Replies View Related

Copyrights 2005-15, All rights reserved