Users limited access by IP

[a1istair]

Hiya - this might be a bit of a simple question but please bear with me! I have looked reasonably hard for this but can not find an answer:

I have an MSSQL 2000 server running on PC-A and would like to limit certain users (e.g. admin) to be only able to logon when using the actual PC-A machine.

I am aware that you can acheive this in MySQL with the "insert into user (host, user, password) values (localhost, username, password);" command. Is there an equivalent way to do this in MSSQL?

Thanks for your help,

Alistair.

[davef]

Hiya - this might be a bit of a simple question but please bear with me! I have looked reasonably hard for this but can not find an answer:

I have an MSSQL 2000 server running on PC-A and would like to limit certain users (e.g. admin) to be only able to logon when using the actual PC-A machine.

I am aware that you can acheive this in MySQL with the "insert into user (host, user, password) values (localhost, username, password);" command. Is there an equivalent way to do this in MSSQL?

Thanks for your help,

Alistair.

Do you mean log on to the SQL Server Management Console or to the database via your custom application?

[a1istair]

Do you mean log on to the SQL Server Management Console or to the database via your custom application?

The database using a 3rd party application

[davef]

The database using a 3rd party application

Try the host_name() function. It returns the workstation name from which a logon attempt is made. Hope this helps.