Am I fulfilling my pre-requisites for installation

Hi, I have set up the server as follows:

Windows Server Web Copyright 2007 Microsoft Corporation

Intel Xeon E5410 @ 2.33GHz 4GB RAM Service Pack 1

With,

Microsoft SQL Sever Express 2008.

I am using Windows Authentication on my instance of SQL Server. The user in this case is an Administrator. It is also the same user that I am when I install the Research Platform.

My problem is that I get the message 'Please ensure that the SQL Server Instance exists and that you have access to it'. I have gone through the steps up to 6c, on the Beta installation instructions and can see no way to proceed.

Can anyone help?

Many thanks.

David.

Hi David,

Is the MS SQL Express instance you mentioned on the same machine on which you're running the install?

If yes, can you please confirm that you're entering the SQL Server instance name in either of the following two formats:

1. <ComputerName\InstanceName> example: mycomputer\sqlexpress

2. .\<InstanceName> example: .\sqlexpress 

BTW, I'm not sure I understood which OS you have.

Regards,

Harsh

Hi Harsh, Thanks for replying. I have tried these combinations and have not been successful. I am using 2008 Server. I also have IIS7 set up in the roles of 'application server' and 'web server' is the instance information case sensitive? David.

Hi David, 

No, the SQL Server instance information is not case sensitive.

On Vista and Win 2008 Server the Setup.exe needs to be explicitly run as admin. Our Beta 1 installer does not support automatic elevation. So even if you've logged-in as admin you need to launch Setup.exe by right-clicking and selecting "Run as administrator". Could you please try this?

Regards,

Harsh

That doesn't seem to work. Should I have Admin setup as a log in for the SQL Server instance somewhere? David.

Yes. Could you please check the following:

1. The target SQL Server instance has Windows or Mixed Mode authentication enabled.

2. The user running the install has his login added to the target SQL Server instance.

3. The login is a member of the following roles:

  a. dbcreator

  b. securityadmin

  c. serveradmin 

If all of the above are true and you're still getting the same error even after explicitly launching Setup.exe as an admin, could you please try creating a new database through the SQL Server Management Studio?

Regards,

Harsh

Hi Harsh, I am @ home now, and don't have access to the server from here, as it is inside our institutional network. I will go through your email when I get back into the office tomorrow afternoon, which will be at around 7 am pacific time. I think that I have those boxes ticked, but will double check. Best, David.

No dice. Unfortunately. I re-installed SqlServer and Famulus, all logged in as Admin. I used Windows Authentication on the SQLServer instance. I did manage to create a new database in the new instance of the SQL Server that I created. Thanks, David.