Skip to Content
0
Former Member
Mar 27, 2009 at 06:56 AM

MSSQL 2005 Issue

14 Views

Hello,

I'm using MSSQL 2005 for SAP B1

with login name: "sa"

Now I've created another user in SQL named "sap" who has given the permission to manipulate the SAP databases.Now SAP users will work by userscode: "sap" instead of "sa".

And now my question is=>

Is it possible that users other than "sa" could not restart the server from MSSQL Server Management Studio?

There are few semi computer literate people in company who knows to connect to the database & creates problems in absense of admin.

So, plz let me know how to control the permission level such that no one other than "sa" could stop MSSQL 2005 service from Management Studio.

Thanks.

Subrata