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 |
|
greaseman
Starting Member
30 Posts |
 Posted - 2006-06-23 : 12:21:41
|
| I connect to a compute 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!*********************************************************************This forum is best viewed with a computer. Questions asked freely. Confusion happily shared. |
|
|
greaseman
Starting Member
30 Posts |
Posted - 2006-06-23 : 16:53:02
|
| Anyone???? Please??*********************************************************************This forum is best viewed with a computer. Questions asked freely. Confusion happily shared. |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-06-23 : 17:27:20
|
| The login you use for sql server is probably member of the sysadmin fixed server role.What does"select suser_sname()"show?rockmoose |
|
|
|
greaseman
Starting Member
30 Posts |
Posted - 2006-06-26 : 09:16:42
|
| The command "select suser_sname()" gave me an 'invalid column' error message. As stated in my initial plea, ..."when I use the query, "SELECT user_name as ()". What I see instead is "DBO". What do you mean by "probably member of the sysadmin fixed server role?"Thank you for replying.......*********************************************************************This forum is best viewed with a computer. Questions asked freely. Confusion happily shared. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-06-26 : 09:25:36
|
| "SELECT user_name as ()" is not a valid syntax. "SELECT user_name()" is. Also "SELECT suser_sname()" is a valid syntax.Which version of MS SQL Server are you using? SQL Server 2003 does not exist. Maybe you are referring to MS Windows 2003?Peter LarssonHelsingborg, Sweden |
|
|
|
greaseman
Starting Member
30 Posts |
Posted - 2006-06-26 : 13:18:07
|
| Peso,Right. This time, "SELECT suser_sname()" gave a valid reply. I most likely entered a typo.I'm running SQL Server 8.0 on a Windows 2003 Server machine. I think I'm onto a good track, now that I've been made aware of the "SELECT suser_sname()" command, which I can put into my VB code. I was going nuts when all I could see was the "DBO" user name.Thanks to all of you who responded. I appreciate your help greatly.*********************************************************************This forum is best viewed with a computer. Questions asked freely. Confusion happily shared. |
|
|
|
|
|
|
|
|
NT Authentication - Remote Desktop