Skip to Content
author's profile photo Former Member
Former Member

windows authentication for SQL 2005 DB connect

Hi all,

I'm trying to create a DB connect

in the connection parameters when I mention a user name and password who is created as a SQL authentication then it is working fine.

but in my connection parameters if I mention a user name password who have a Windows authentication in the SQL 2005 which we are trying to connect then it gives an error. It is not connecting .

Can you please tell me how can we connect using a windows authentication.

Mey

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 13, 2007 at 01:43 AM

    Solution to solve the actual issue :

    For the SAP system to use standard default NT authentication

    Please refer to this link: http://help.sap.com/saphelp_nw04s/helpdata/en/9c/d736b880c34f76b507bac7751a0474/content.htm

    1. Database login:

    SQL Server login with System Administrator privileges, that is this login should be member of the sysadmin fixed server role on the target SQL Server. If such a login does not exist, you have to create it on the target SQL Server. The SAP multi-connect mechanism allows both integrated security logins and the use of SQL Server authentication. For security reasons, we highly recommend to use integrated security (Windows authentication). If you use Windows security, leave this field empty.

    2.  Password / Re-enter password :

    If you have decided to use integrated security, leave these fields empty. Otherwise enter the password of the SQL Server login.

    The above pointer was used to solve the login issue but we still had issues in getting the schema visible in SAP BW. As the user ID was left blank we were not able to get the schema view for the <blank> user.

    Note to be applied to solve the Schema issue :

    note 1091929 : &#61664; Link

    so now you can enter the schema to be used in DS creaton screen.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.