new instance question

  • Hi all,

    I had SQL server 2005 installed on my machine by my company. They install stuff via ZEN so the install was scripted and I was not presented with any dialogs along the way. Also, it did not create an instance for me to work with. Can I create a new instance from within the management studio or on the command line? Should I ask the ZEN team to change the installation so that it creates a default instance?

    Thanks for your help.

  • Are you a local admin on your machine? If not then they probably need to add you to the sysadmin role on the SQL Server instance. Can you see if the service is running? They may have installed a named instance - if so you can still work with it, but you would connect to it via computername\instancename

  • Hi Toby,

    I am a local admin on my machine. Also, it looks like the services were not installed on my machine.

  • You will need to run through the setup process again to create an instance, if you have access to the SQL server install disks then run through these again.

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

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