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.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  SQL7 Server: Domain prefix not required?

Author  Topic  SQLGreg Starting Member 1 Post Posted - 2004-06-28 : 11:41:39 Hi folks, First posting here, so please be gentle with me! We migrated a number of SQL7 databases from one server to another over the weekend. The server they were migrated to is in DomainC, lets say. The users who access it are in two NT4 domains, DomainA and DomainB. The SQL server is in a trusting NT4 resource domain, by the way. Users in domainA can access the server and application no problem, but the DomainB users cannot. A table has been created to capture information when users log in. For some strange reason SUSER_NAME for DomainB users appears as "USERNAME" whereas users from other domains accessing appear as "DOMAINA\USERNAME", for example. This behaviour would occur (surely) if the SQL server was in the same domain as the users, which is most certainly is not. Has anyone seen this behaviour before? Microsoft tell me that as the SQL server is running 7, I should be using the function SUSER_SNAME, which is fine, but will require an amount of application recoding. The strange thing is it was working perfectly on the old server (in another NT4 domain). Thanks for reading. Regards, Greg