January 4, 2011 at 5:15 am
I am trying to log into SSMS using my service domain account, to test it and make sure it can connect to the server. I'm trying to use the instructions provided in this link, but when I create the shortcut, it added "%windir%\system32\" to the front of the short cut. Then when I double click the shortcut, it blinks as if it's about to start something, and nothing happens.
I've tried removing the added path, but then my OS adds "C:\WINNT\system32\" right before the runas.
I'm using a local path to get to the SSMS GUI, but I want to log into a remote server. The shortcut isn't prompting me for a password, and I can only think it's because the service account in question isn't on my local box. Obviously I'm missing something in the above linked instructions. Any thoughts?
Or, conversely, does anyone know an easier way to achieve what I'm attempting to do?
January 4, 2011 at 5:25 am
Brandie
What I do is right-click on the unmodified SSMS shortcut, choose Run as, and then enter the credentials of the account I want to connect as.
John
January 4, 2011 at 5:29 am
I didn't even try that... Are you using a name in the drop down list?
I overwrote the list with the account (because it's not on my box), but I'm getting an error:
C:\program files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe
The Directory Name is invalid.
January 4, 2011 at 7:00 am
Bah. Giving up on the shortcut and logging directly into the server (Remote Desktop) with the account. I'll see how that works.
EDIT: Okay. That worked. Wanted to do it from my desktop, but I've wasted enough time trying to test this silly thing. So, lesson learned. Log into server directly with account in question, then log into SSMS using Windows Auth to test.
January 4, 2011 at 7:07 am
Brandie Tarvin (1/4/2011)
I didn't even try that... Are you using a name in the drop down list?I overwrote the list with the account (because it's not on my box), but I'm getting an error:
C:\program files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe
The Directory Name is invalid.
This error is usually associated with the permissions of the user. btw I was able to "Run as" for the service account which was part of the Administrators group on the OS.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
January 4, 2011 at 7:09 am
Brandie
You can select the name from the list if it's remembered in there, but that isn't always the case. I think it's to do whether the account in question is local admin on the computer. I've never had that issue that you describe - could it be to do with permissions to the SSMS installation folder?
John
January 4, 2011 at 7:25 am
The account in question had no perms on my local box, so I added it as a regular user and tried that. Failed with the same error. I didn't try adding it as an admin, since it was only a Domain Service account for a remote server, which I didn't want to have admin access on my local box.
Maybe that was the issue. I'll test it in a bit and see.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply