IVR Software Connection Problem

Graneter 1 Reputation point
2021-09-13T09:25:14.657+00:00

Hello. I have a windows server 2003 and on it, I have an IVR Software. keep in mind that this software is old and does not work on newer OS. Due to security concerns I had to disjoin the server from the main domain. With all of its SQL data and Authentication properties. Now I can't authenticate on the software for some reason and I don't know what to do. I need to be able to use my IP, Username and Password to connect to the software from a domain PC. I don't think there should be a problem with this. So if anybody know what the problem can be, please help me. Also I have tried disabling antivirus and firewall and I know that I can ping the Server 2003 which is now a workgroup system.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,761 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,174 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,901 Reputation points
    2021-09-13T09:38:20.25+00:00

    Which error message do you get when the logon fails? Do you see any hints in SQL Server ErrorLog?

    0 comments
  2. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2021-09-14T02:58:34.037+00:00

    Hi @Graneter ,

    What is your SQL server version? How did you connect it? What is the error message that you got when SQL connection failed? You can also get the error message from SQL server error log. By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files. (‘n’ is the SQL version, such as SQL 2019 is 15)

    Is it a local SQL connection or remote connection? Which authentication that you want to use? Windows authentication or SQL server authentication?

    Or could you share us a screenshot about SQL connection failed UI? This will make us better understood your issue.

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.

    0 comments
  3. Limitless Technology 39,376 Reputation points
    2021-09-14T13:48:17.403+00:00

    Hello,

    Thank you for your question.

    I would like to suggest you to check below Troubleshooting steps.

    1, Please open SQL Management Studio and check what is user name is used in your application ,
    2. Please check in your Application which SQL authentication mechanism have used its Windows or Mixed mode.
    3. Please check if you have created any DSN in Control panel -> ODBC.
    4. Please check if you are able to resolve using Hostname of SQL from Client software.
    5. Please check if there is any config file from which you can see SQL Hostname or IP address and User information.

    If the reply was helpful, please don’t forget to upvote or accept as answer.

    0 comments
  4. Limitless Technology 39,376 Reputation points
    2021-09-14T17:29:08.727+00:00

    Hello again @Graneter

    The issue is basically that your authentication was bound to the domain architecture (DOMAIN\Username) and since the machine is not anymore a member of the domain the authentication can't be validated. You could workaround this issue by authenticating with a different local account (like a sysadmin account). If you don't have this type of account, please follow the next step by step process to create a new login locally:

    https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/connect-to-sql-server-when-system-administrators-are-locked-out?redirectedfrom=MSDN&view=sql-server-ver15#step-by-step-instructions

    Hope this resolves your query,
    Best regards,

    0 comments