Server Info: Windows Server 2008, SQL Server Standard 2008 (64-bit)
I recently upgraded to SQL 2008 and was interested in trying out T-SQL Debugging. Initally encountered some firewall issues, but after disabling my workstation's Windows Firewall and having TCP port 135 and UDP 4500/500 opened up by the IT group I got a little further.
Now I get the error message:
Unable to start T-SQL Debugging. Could not connect to computer 'servername'. Logon failure: unknown user name or bad password.
My workstation and server are on different domains and I use Windows authentication to connect to the machine. My account is sysadmin and connects to the server fine in SSMS. The SQL Server service is running as a different service-level account.
Thoughts?