Results 1 to 3 of 3

Thread: nt user name in a remote connection

  1. Jun 23rd, 2006, 12:04 PM #1
    greaseman
    greaseman is offline

    Thread Starter
    Hyperactive Member greaseman's Avatar
    Join Date
    Jul 2005
    Location
    Somewhere, out there...
    Posts
    295

    nt user name in a remote connection

    I connect to a computer via Remote Desktop Connection that is running SQL Server 2003. That part works. However, once I'm connected, and running SQL Server, I cannot see my user name in SQL, when I use the query, "SELECT user_name as ()". What I see instead is "DBO". Nor does it show me as being in a particlar group. I also cannot see my Windows Authentication remote computer name.

    I think it has something to do with using my PC to do the Remote Desktop Connection and then from there, running SQL Server 2003, but am lost on this one.

    Can anyone help? I sure would appreciate it! Thanks in advance!
    Reply With Quote Reply With Quote
  2. Jun 23rd, 2006, 03:54 PM #2
    greaseman
    greaseman is offline

    Thread Starter
    Hyperactive Member greaseman's Avatar
    Join Date
    Jul 2005
    Location
    Somewhere, out there...
    Posts
    295

    Re: nt user name in a remote connection

    Anyone?? Please ????
    Reply With Quote Reply With Quote
  3. Jun 27th, 2006, 09:21 AM #3
    greaseman
    greaseman is offline

    Thread Starter
    Hyperactive Member greaseman's Avatar
    Join Date
    Jul 2005
    Location
    Somewhere, out there...
    Posts
    295

    Re: nt user name in a remote connection

    Oh, well.....

    I got it figured out and am processing the way I needed to.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width