question

Graneter-0271 avatar image
0 Votes"
Graneter-0271 asked LimitlessTechnology-2700 answered

IVR Software Connection Problem

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-generalwindows-server
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @Graneter-0271,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered

Hello again @Graneter-0271

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://docs.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,

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.