Facing problem while connecting to SSMS server from Azure data factory

Harsh Gupta 1

@sql-server Team,

We are facing a problem while connecting to SSMS Server from Azure Data factory pipeline activity/dataset.
We are not sure to put exact format of - server_name, database_name , user_name, and authentication_type.

Can you please help us to frame the proper inputs for above mentioned 4 fields?

Nandan Hegde 32,026 Reputation points MVP

2022-09-15T16:13:20.837+00:00

Hey,Is it SQL server or Azure SQL database that you are trying to access to?
Bhargava-MSFT 30,891 Reputation points Microsoft Employee

2022-09-15T20:36:14.437+00:00

Hello @Harsh Gupta ,

Welcome to the MS Q&A platform.

Please correct me if my understanding is wrong. It seems like you are looking for help on the SQL server/Azure SQL-linked server connection.

If this is your requirement, please work with your DBA to get the SQL server name, Database name and authentication type for the new linked server connection.

]1
Harsh Gupta 1 Reputation point

2022-09-16T05:39:42.997+00:00

Hi @Nandan Hegde , We are trying to access SQL Server.

1 answer

Nandan Hegde 32,026 Reputation points MVP

2022-09-16T05:58:38.387+00:00

Hey,

There are 2 Auths for SQL server: SQL and Windows

SQL Auth :

Windows Auth :

Always prefer Windows Auth as it is more secure

And you would need a self hosted IR
Please sign in to rate this answer.

1 person found this answer helpful.
Bhargava-MSFT 30,891 Reputation points Microsoft Employee

2022-09-16T22:07:12.077+00:00

Thank you @Nandan Hegde .

Hello @Harsh Gupta ,
I am just checking in to see if you need any further help here.

Harsh Gupta 1 Reputation point

2022-09-18T13:41:20.107+00:00

@Nandan Hegde @Bhargava-MSFT Thank you for looking into this.

Actually I have not received the proper server_name from the concerned DBA(Domain name was missing). But now I got the correct format from few sources available on internet (Correct format that worked for me was -> abcdxxx01 .go.<org_name>.com ) Actually I have been missing the bold part. Also, I was using SQL authentication, but what actually worked for me was Windows Authentication.

Thank you.

Bhargava-MSFT 30,891 Reputation points Microsoft Employee

2022-09-19T17:35:35.677+00:00

Hello @Harsh Gupta ,
Thank you for the update. Are you seeing any error messages if you use SQL authentication?
When you use the on-prem SQL make sure to enable SQL auth.

Please let us know if you still need any further assistance here.

Bhargava-MSFT 30,891 Reputation points Microsoft Employee

2022-09-20T17:32:27.357+00:00

Hello @Harsh Gupta ,
I am just checking in to see if you have any further questions here.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Facing problem while connecting to SSMS server from Azure data factory

1 answer

Your answer