Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MGouders
Starting Member
30 Posts |
 Posted - 2009-09-09 : 14:50:12
|
| Hi,Scenario: Writing SSIS Logging to Text Logging Provider -> Text file destination: Server A -> SSIS Package executed through SQL Job on Server B -> Server Information at Hand: UNC Path such as defgh4997 Constraint: Access to file destination deniedQuestion: How can the domain the server belongs to be determined???Thanks for any hint |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-09 : 16:30:41
|
| If you can access/RDP the server, check the properties of the computer. The domain will be shown there.Or from the command prompt on your machine, try ping -a [server ip address] This will resolve the hostname. |
 |
|
|
MGouders
Starting Member
30 Posts |
Posted - 2009-09-09 : 17:28:55
|
| Thanks,The ping command worked fine |
|
|
|
MGouders
Starting Member
30 Posts |
Posted - 2009-09-10 : 11:23:23
|
| Just want to share the following solution, posted as a reply from another forum.[Quote Start]Why can't we try this?Execute xp_regread 'HKEY_LOCAL_MACHINE','SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\','Domain'perhaps, the path changes from OS to OS. But the above should work on windows XP, 2000,2003.[Quote End]Submitted by Vishal Singh on SQL Server Central |
|
|
|
|
|
|
How can the domain of a SQL Server be determined