SQL Server Performance Forum – Threads Archive
MS SQL server setupHi, I have MS SQL server 2000 installed on a nt4 machine.
I am very very confused with all the jargon used in the software, and CAN’T manage to setup a user with select, insert, update, privileges for that database. Also, The user I want to define should have access to the database through PHP. Can you help me ??
This is explained in the SQL Server Books Online fairly well. But in brief, you must first create a SQL Server Login ID, then a Database User ID, and then assign the necessary permissions. You can do this using Enterprise Manager or Transact-SQL. See these commands in the Books Online: sp_addlogin
Brad M. McGehee