Activity overview
Latest activity by esumanti
Hi Eddie,
we have never use roaming profile, always static profile.
Anyway I asked my sysadmin to add me to local admin (temporary) of terminal service just to proof a point, and SQL Compare works fine, but unfortunately this is not allowable.
Can you let me know what minimum priv should I have?
Thanks
Elly / comments
Hi Eddie,
we have never use roaming profile, always static profile.
Anyway I asked my sysadmin to add me to local admin (temporary) of terminal service just to proof a point, and SQL Compare works ...
Hi,
SQL compare was installed in the terminal service by my sys admin (who obviously has local admin priv). However my OS ac does not have local admin because that's our site policy.
Can you confirm if I am not localadmin I can't use SQL Compare even though I have "sa" credential for database I am working with?
What is the minimum priv should my OS ac has?
Thanks
Elly / comments
Hi,
SQL compare was installed in the terminal service by my sys admin (who obviously has local admin priv). However my OS ac does not have local admin because that's our site policy.
Can you confir...
Hi,
I am using sa to connect to the database. I am referring to OS user privilege required to run sqlcompare.
Thanks
Elly / comments
Hi,
I am using sa to connect to the database. I am referring to OS user privilege required to run sqlcompare.
Thanks
Elly
Hi,
I was just wondering whether anyone has chance to update this??
thanks
Elly / comments
Hi,
I was just wondering whether anyone has chance to update this??
thanks
Elly
Eddie,
I tried this with/out "tcp:" with both hostname and it hung.
However if I logon to terminal service with an account with local admin password connection is fine.
should this connectivity tool dump log/trace file somewhere?
Can you confirm if admin right is prerequisite?
Thanks
Elly / comments
Eddie,
I tried this with/out "tcp:" with both hostname and it hung.
However if I logon to terminal service with an account with local admin password connection is fine.
should this connectivity too...
HI Andras,
I can confirmed no firewall between my terminal service and remote SQL service, I also noted that when I used local a/c (of terminal service) with admin priv, sqlcompare works fine. I am puzzled now, does it have to be admin on where the tool is installed?
Thanks
ELly / comments
HI Andras,
I can confirmed no firewall between my terminal service and remote SQL service, I also noted that when I used local a/c (of terminal service) with admin priv, sqlcompare works fine. I am...
Andras,
Thank you for your reply.
I tried both tcp: or np: followed by ip of remote Sql server but it hung.
I then created a window local admin account, tcp: and np: works. Which is really strange, I don't think the window logon (to the terminal server) needed to be admin at all (but maybe you can confirm this).
I was using SQL authentication.
I am not sure about firewall, I have to checked with my security people tomorrow morning.
Can I turn "debug" on connection so I have more concrete evidence?
Rgds,
Elly / comments
Andras,
Thank you for your reply.
I tried both tcp: or np: followed by ip of remote Sql server but it hung.
I then created a window local admin account, tcp: and np: works. Which is really strange...
Apology for posting this in the wrong forum, I am running v5.3. / comments
Apology for posting this in the wrong forum, I am running v5.3.
SQL Compare Connection problem
Hi,
I have just installed sql compare on my terminal service and trying to create a database snapshot from a remote SQL server.
I can register and connect to this server using SQL Enterprise manage...
Hi,
I did send email to sales@red-gate.com, support@red-gate.com also Peter Peart last thursday, I have not got any reply, and almost giving up this forum was my last hope.
Let say I purchase upgrade to professional ed. do I uninstall my current standard edition or do I install on top?
Thank you / comments
Hi,
I did send email to sales@red-gate.com, support@red-gate.com also Peter Peart last thursday, I have not got any reply, and almost giving up this forum was my last hope.
Let say I purchase upgra...