1

Re: Permissions on SQL Express 2005

I've had R6 running for sometime and been using it myself but it would not let other users logon. There was and Eole Exception: Can't access NBNData message.

Well on reviewing it I had found that through learning curve necessity I had bypassed suggested security and made myself a user directly rather than using a group. I had set up the groups but newbie status and the documentation being based on SQL Server 2003 meant some bits were hard to see a way through.

I went back to the documentation [thanks by the way] and made sure I had done all that could be based on what I could see and the difference on my 2005 Express system. Still I had the problem. I disabled my SQL logon and that just complained that it was disabled. I deleted it and got the same errors as my colleagues. A few adjustments to membership and check on roles and it all seems to work.

I now have an Admin group and a User group. I'm already forgetting what it was I did of course which seems to be the case with so many choices and boxes to tick as well as the interrelationships.

I just thought I'd pass on a note some success where once there was a minefield.;)

Data Manger
Somerset Environmental Records Centre