sqlclient data provider .net provider connection

Question

sqlclient data provider .net provider connection

jaango123

SSC Veteran

Points: 271
More actions
October 11, 2024 at 3:35 pm

#4467713

I have a task to check the connection managers as part of ssis integration project, now the package should be running on a different server.
I see a connection manager with .net providers/sqlclient data provider, server as "CCSQL", sql server authentication and service account as "SA".
The server name is CCSQL and in the new server it doesnt work obviously as it is not resolved to a host. Could this be a custom sql connection alias which has to be created? Any hints on this connection manager server?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246960 More actions · Answer 1

Can you provide a screen shot, as I'm not sure exactly what you mean?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

jaango123 SSC Veteran Points: 271 More actions · Answer 2

Hi Phil,

Please find the screenshot. What could CCSQL mean in a server name?

Screenshot 2024-10-14 at 19.21.23

Phil Parkin SSC Guru Points: 246960 More actions · Answer 3

If you do not have a server called CCSQL, I think it may be an alias to a server.

Read more about aliases here:

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/create-or-delete-a-server-alias-for-use-by-a-client?view=sql-server-ver16

If you don't need or want to use an alias here, simply overtype it with the new server's name (which may need to be qualified, depending on your network config).

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

jaango123 SSC Veteran Points: 271 More actions · Answer 4

Thanks Phil. I will check this.

One more query related to this. In the screenshot you can see that "save my password" is checked for the user "SA". How can i check or view this password. I have the solution file with me of the project.

Phil Parkin SSC Guru Points: 246960 More actions · Answer 5

jaango123 wrote:

Thanks Phil. I will check this.
One more query related to this. In the screenshot you can see that "save my password" is checked for the user "SA". How can i check or view this password. I have the solution file with me of the project.

That is probably not possible, for obvious reasons of security.

Has your existing solution been deployed to SSISDB? Are you using SSISDB environments to configure things like connection strings in different environments? Those environment variables (if they exist) may give you some useful clues.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin