Being an IT consultant, I have to visit a number of customers having applications running on SQL Servers that implement trusted connection security model. In addition, all of these companies have their own DOMAIN settings, and security implementation.
How can I access to databases without changing the DOMAIN settings of MY notebook? I do not want them to switch to SQL security model, and I do not want to create any security hole in those companies.
What shall I want from the system administrator so that I can login into their domain without changing my domain settings?
Thanks,
EIO.
Hi,
you can store user network crednetials for your account on the notebook which will be used if connecting to a remote server.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
May I ask: How?
I understand that:
1. I have to ask all the administrators in those separate companies to create a user account for me, in their local domains, that has access to the SQL Server databases. That is easy.
2. I have to register those separate domain accounts in my notebook (how?)
3. After I connect to the company network and login to my notebook with my own username, those registrations will make me be acquainted with the company network.
Is this correct? And how can I complete Step 2?
Thanks in advance,
EIO.
|||Yes you can ask those companies to create a standard account with your name and you can access the SQL Server using Enterprise manager by regsitering those instances. I have done this previously without any problem, where the account name (username) should match for authentication.
On Step2 even though it says cannot connect to server you can still register on your EM lists.
No comments:
Post a Comment