MS SQL server setup | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

MS SQL server setup

Hi, 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 ??
THX fred
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
sp_adduser
grant ——————
Brad M. McGehee
Webmaster
SQL-Server-Performance.Com
]]>