Forum Discussion
Passing credentials to SQL connection string
Hello. I am new to PowerShell and would really appreciate some help! I have a working script (Example A) which allows me to connect to SQL servers in my current domain using windows authenticatio...
Hi
I am not a SQL expert but let me tell you what I think
It's not a the PowerShell use the logged-in cred to auth, its the connection string and what parameter support
You cannot pass the username and password through a connection string as Windows Auth. it wont work
The other way is to enable SQL Auth on the remote server and connect using SQL Auth
One way I think you can do it is to invoke Enter-PSSession and execute the SQL query on the remote server, But still not sure if it will work like this. Its just an idea.
Good to know, thanks for the info!