Hi there,
I have a machine that's not connected to a domain and I want to connect to server in that particular domain and I do have proper credentials to log on.
I used runas command as follows: runas /netonly /user:domain\domain_username ssms.exe and I was able to connect to the server which otherwise I could not.
The weird thing is in the connection window the user name is still the local one: machine\machine_local_name and of course the dropdown is disabled. On the same note, after connecting in the Object Explorer window I can see in the name of the connection that I am connected as the local username servername (SQL Server 10.0.2531 - machine\machine_local_username)
And even if there has been created a Login in that server for domain\domain_username with necessary permissions, whenever I try to do anything that I was supposed to be allowed, for example create a stored procedure I get "permission denied" exception. It is like the management studio still runs under local credentials.
Another weird thing is when try browsing through the tables I cannot see any, although if I create a connection in server explorer window in a VS2008 instance that was launched using the same method (runas /netonly /user:domain\domain_username devenv.exe) I am able to see the list of tables yet still not able to create a stored procedure.
I know it sounds like a mess, but I cannot make any sense of it. Can anyone give me some hints here?
Thanks Iulian