SSIS and BIDS development admin rights

  • I've start a new job as a contractor for a company for a new project.

    I'm setting up my development PC and everything here requires you to request software you want to install.

    If it's not listed I need to put a request in for it.

    The only thing available is SSMS. SQL Server is not on the list of installable software.

    The problem is this project requires me to develop items using SSIS

    I've put the request in to be allowed to install SQL Server 2008 so I can select SSIS and BIDS to be installed on my development PC.

    But I still won't have local administrator access on my development PC.

    Will this be a problem? Do I need to request to be a local administrator on my development PC?

    From what I've been told it's not very easy or from what I heard, even possible to get admin rights.

    Will this hinder my daily duties to perform and development SSIS packages?

  • It shouldn't, and I know if doesn't for people in my company doing the same.

    They tend to develop SSIS packages etc in BIDS but deploy and test against development SQL servers they have the necessary rights on.

    They don't have local installs of the SQL Server services on there own machines.

    MCITP SQL 2005, MCSA SQL 2012

  • Did they install BIDS on their dev systems?

  • No as we have a standard image for machines that will be used by the DB Engineering team that comes with all they will need such as BIDS, SSMS, powershell libraries, python etc etc.

    Everytime someone new starts or they get an updated machine they get a machine with the fresh image on it.

    MCITP SQL 2005, MCSA SQL 2012

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply