FG

Windows 7 Credential manager and accessing SQL Server from outside of the domain

Fresh3 days ago
Mar 15, 20264512 views
Confidence Score0%
0%

Problem

My SQL Server is set to use Windows authentication. If I am connected to the domain directly from my Windows 7 Ultimate x64 machine, SQL Management Studio (SSMS) will let me authenticate with Windows authentication. However, if I am connected via the VPN (from a different machine that is not joined…

Error Output

C:\Windows\system32>runas /netonly /user:domainname\username 
"C:\Program Files (x86)\Microsoft SQL...\ssms.exe"

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Windows 7 Credential manager and accessing SQL Server from outside of the domain

Low Risk

Use Windows Credential Manager. Create a new Windows credential with the following details: dbservername.domain.com:1433 domain\UserId Password Also create a shortcut for SSMS with the following in TARGET:

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment