I am a local admin on the SQL server machine but do not have access to create a database and to browse other databases on the server. I have access to few databases but not all.
Which SQL rights or role do i need to have a full access to the SQL server? Besides above, i should also have rights to create a jobs in SQL. I told my client to give me a sysadmin role but he think this granted the full access to the server and might not be necessary? Is there any other access or rights or suggestion that will help me to do all I have mentioned above.
Create database, Create jobs, Access databases on the server.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!