How can i connect to SQL without passing credentials in connection string using powershell

Question

I want to make connection to SQL server configured on On prem using Powershell. But I don't want to pass any credential in connection string as shown below

#making a db connection string
$connString = "Data Source=$SqlServer;Database=$Database;User ID=$SqlAuthLogin;Password=$SqlAuthPw"
        
#Create a SQL connection object
$conn = New-Object System.Data.SqlClient.SqlConnection $connString
        
#Attempt to open the connection
$conn.Open()

Is there any other way from which i can pass credential.

Any help will be thankfull.

Which dbms are you using? (This isn't really related to the SQL language.) — jarlh
– jarlh, Commented Oct 10, 2022 at 8:06
@Roshan, thanks for reply, for windows authentication also we have to pass credential as ConnectionString 'Server=$server;Database=$databaseName;UID=$DOMAIN\USER;PWD=$password;Integrated Security=true;' as given in following link stackoverflow.com/questions/38177582/… — Shubh kumar
– Shubh kumar, Commented Oct 10, 2022 at 8:49

Roshan · Accepted Answer · 2022-10-10 09:08:06Z

0

You can use windows Authentication with Integrated Security.

# more secure windows authentication with current account

Invoke-Sqlcmd  -ConnectionString "Data Source=$SqlServer;Initial Catalog=$Database; Integrated Security=True;" -Query "$Query" | Format-Table

answered Oct 10, 2022 at 9:08

Roshan

1,0751 gold badge14 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shubh kumar Over a year ago

Thanks for reply but I can't use windows authentication because most of users don't have access to database. So have to go with SQL username and Password , but not to pass password in connection string . Is it possible by any way

Collectives™ on Stack Overflow

How can i connect to SQL without passing credentials in connection string using powershell

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related