One credential is provided, SSMS would open with that windows account. Contractors often end up working across multiple domains as well. Dave—I use the template explorer to build a lot of custom code. This seems to have limitations when I log in as another user. Example: if I try to search for a template based on the name I get the error from ssms.
You may not have the appropriate permissions to access the item. In fact I can create new folders and templates without an issue. Do yo know of any work araound? If someone has a workaround for this please share it. I always learn something in addition to whatever problem I am trying to solve. And the articles are so clearly written. Keep up the great work and thank you very much. Hi Guys, when prompted for the password, I cannot type it in.
Any ideas? A connection was successsfully established with the server, but then an error occured during the login process. I am getting the same error as Asish on He holds a Masters of Science degree and numerous database certifications. Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. In my case I have two accounts under the same domain.
Works in Windows Worked for me on a different domain. How-to Run as other windows account user and as administrator? Show 1 more comment. Don't ask me why! Honestly, this answer should be marked up. The runas solution didn't work for me, and created a headache in that smss doesn't like to start in console, which is what happens when you invoke in smss.
And even once that stopped happening, it still didn't work. Just like he says, it'll still SHOW the local user, but it connects anyway. You may need to use sqlserver. See stackoverflow. Indeed this worked for me, seems much easier, and allows server-specific windows connections in one SSMS session. The runas method didn't work for me, but this did. I initially tried without the port information in Credential Manager, but I still couldn't log in.
When I added the port information in Credential Manager, it worked like a charm. Thank you so much for this! This might be the most elegant solution.
Works in Windows 8. Show 6 more comments. Glorfindel Dave Dave 1, 12 12 silver badges 18 18 bronze badges. This is an easy to use solution to connect from your already open ssms instance to another server with other win creds! It even allows you to save the complicated password we hope is difficult to guess Regrettably, other apps need to manage via almost odious RUNAS. Ricardo Mercado Ricardo Mercado 1 1 silver badge 2 2 bronze badges. This worked for me too, no trust relationship between domains.
Holding shift will give you an extra option "Run as different user": This will pop up a login box and you can type the credentials you would like your session to run under. If you really need to administer multiple servers across several domains, you might consider one of the following: Set up Domain Trust between your domains so that your account can access computers in the trusting domain Configure a SQL user using mixed authentication across all the servers you need to administer so that you can log in that way; obviously, this might introduce some security issues and create a maintenance nightmare if you have to change all the passwords at some point.
Hopefully this helps! Ed Altorfer Ed Altorfer 4, 1 1 gold badge 22 22 silver badges 27 27 bronze badges. The only way? I know I could login to a windows session as them, and do it that way, but that seems a tad tedious. You won't be able to log in as them if you do this, but you will be able to validate their permissions within SQL Server. For instance:. IIRC, if you map a drive to the server as the user you want to use, before doing anything else on the server, when you connect with integrated security the credentials that you have already established on that server will be used.
I used to do this when I was working from a workstation that was not trusted by the domain that the servers were in. You still only get one set of credentials, this trick won't work for two different sets of credentials.
It lets you impersonate someone, sort of like su does on linux. The documentation says that this is deprecated, but I think that it still works. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Asked 12 years, 5 months ago. Active 9 years, 1 month ago.
Viewed 11k times.
0コメント