Hi,
 i am working on asp.net. i am using sql server 2000 as backend. in sqlserver i created a user 'all' for the windows user 'operator'. my machine name is 'samar' so the user name in sql server, for login name 'all', appears as 'samar\operator'. now the problem is that if i transfer my database to a different system (with different machine name, say 'comp'). the username does not appear as 'comp\operator'. even if i have a windows user 'operator' in 'comp' i could not find a way to create user with same user-name and login-name for sql server. can anyone help?

:samar

Use SQL authentication not windows authentication. That's really the easiest solution.

u can set ur Server name as . inseat of server name if u always use it in ur Local Server. I mean if its always ur local Server.
HTH.

Always:),
Hovik Melkomian.

Hi,
Thanks for ur attention to the message, but in my case it is not the local server only. I've to upload a website database of which need to be uploaded on webserver. For all other objects, e.g. database, tables, etc., I've generated sql script, but for winodws authenticated, sql server users, I can't generate an sql script untill I know the machine name of the server. The main point is that it is necessary to user windows authentication due to NTFS permissions facility for files.
  Can u please help me in this case. Is there any way, in sql server 2000 or asp.net, to find out the machine name of server?
Thanks,
Samar

:samar

if ur problem is just server name, save ur server names u use somewhere & use it whenever u want & need! u can also use it as a Dynamic Property.
planoie told the last & the best way indeed. why do u wanna use servers in diffrent instalation, I wonder why do u use diffrent instalation?!

Always:),
Hovik Melkomian.

  I am developing a website on a system in my office. windows authentication is necessary bcoz i m using 'impersonation' in asp.net and i want a particular windows user to get the database permissions automatically, as soon as it logs in.
  one of the windows user is dbo. since i created users in my system manually, it caused no problems. but when this website will be uploaded on webserver, the database needs 'windows authenticated users' so that to match the settings on my system. this website is on its final stage and it'll be very difficult to use sql authentication and rewrite the bulk of the code.
  u adviced that i should save my server name, but that is the question: how would i know the name of webserver (through programming tools).

:samar

Sorry I have no idea! but its question for me that, why u should use diffrent instalation for ur SERVERS?!

Bye the way, I dont know any way to get Server names but since there are not many at most 5 or 10 u can set them manually urself.

Always:),
Hovik Melkomian.