Im sure there is an SQL Server guru out there who will be able to go...oh you nub, you just need to execute this script. And if there is, please tell me what it is, cause I am really stuck on this one.
We are running a small dedicated workstation here (XP 64) which we would like to host our MS Business Contact Manager database on. I have set up SQL Express 2005, and used the MS BCM tool to create the Database, I can log into it fine, but I am also the database owner. Other members on the network are having no success, and I have tried giving them all as many access privledges as I can possibly see, all to no avail.
what privledges to I "have" to give them to connect and modify this database, in both the SQL server setup, and the database setup.
Many Thanks in advance