SQL Authenication problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Harry Mace (anonymous_at_discussions.microsoft.com)
Date: 05/18/04 

Date: Mon, 17 May 2004 22:06:54 -0700

Our users use a third party app that connects to a SQL
database on a windows 2003 member server. The app
works if the user has a windows 2003 user account local
on the server.

1. All of our user accounts are in a Novell Netware
Domain.

2. We have purchased a processor license for the SQL
server, so we have unlimited connections to SQL.

3. The user accounts that need access to the SQL Server
do not have windows 2003 local server accounts.

>From our testing, it appears to be an authentication
problem.

We have tried to create only SQL user accounts, but that
also fails to authenticate.

Is there a way for our user to use the third party app
without having windows 2003 local user account or just
have only SQL user accounts to authenticate to the
database?

Relevant Pages

  • Re: Sql Server 2005 Dev. Ed. on Windows Server 2003
    ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
    (microsoft.public.sqlserver.setup)
  • SQL Login problem
    ... Our users use a third party app that connects to a SQL ... database on a windows 2003 member server. ... The user accounts that need access to the SQL Server ...
    (microsoft.public.sqlserver.clients)
  • Re: New Windows Infrastructure
    ... vendor's application runs on windows with an SQL database and I will also need a web server for a separate module which will allow our customers to access account data online. ... I would think that if the app runs on windows, I do not need the citrix server. ... It makes sense to have separate DCs though, because let's say you want to upgrade your Active Directory in two weeks time, with separate DCs it's easy, but if you've got a bunch of apps installed it could be a nightmare. ...
    (microsoft.public.win2000.setup_deployment)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.sharepoint.portalserver.development)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.office.developer.web.components)