CODEWITHSUNDEEP
sql
stoic
stoic

Reputation: 4830

SQL pass Windows Auth details using Server Authentication

We have a MSSQL2005 Database on our domain, We can only connect to the database using Windows Authentication. When i am on the domain it connects perfectly, but when i am not on the domain i am unable to pass through my domain credentials to connect to the database.

I tried using Server Authentication and passing domain credentials but i haven't been successful

Thanx

Upvotes: 2

Views: 83

Answers (2)

vukashin
vukashin

Reputation: 86

Are you sure this is even possible? You want to connect to database using domain account when your windows machine is not on a domain.

Try using local windows account.

Upvotes: 1

Andrew
Andrew

Reputation: 46

Have a look at this tutorial he gives a nice explanation including screenshots

Upvotes: 1

Related Questions