Missing SQL Server Project template

I have VS2005 Beta 2 (build 8.0.50215.44) and the June CTP of SQL Server 2005 Developer Edition installed.

Within VS2005, when I go to File -> New Project, I don't have the "Database" project type under either VB or C#. Which also means that the "SQL Server Project" template is not being offered.

Is there a manual way of adding the template, or some other workaround/solution?

Which SKU of Visual Studio are you using? Visual Studio Express does not have SQL Server project support.

Thanks,
-Vineet.

|||It's the full version of Visual Studio 2005, Beta 2, that was released in mid April.|||Actually database projects are not availble in VS Express and VS Standard editions. It sounds like that is what you have. Can you confirm?|||Which editions of VS.Net 2005 do have the "SQL Server" project templates? Or can they be downloaded from somewhere? (I have not been able to find such a place...)
Many thanks.
|||Nevermind. I have VS.Net 2005 Beta2 and didn't notice that if I expanded the Visual C# under the project types tree, there was a database node which contained the "SQL Server" project template.
Take care.

Missing Integration Service Template - fixed now

I have installed SQL Server 180 day evaluation as well as SQL Server Express but I cannot add a new SSIS project because the template is not there (- in the non-express instance - only Reporting Services). When I try and redo the SSIS part of setup(Add/Remove programs) the report tells me that it is already installed correctly. I have searched for others having this problem to no avail...

What do I need to do to fix it?

This may be a silly question but just wanted to make sure. Did you check the bottom option in the installation wizard for Workstation components and documentation? Also, when you look at the services, do you see the SSIS service installed?

-- Brian Knight

|||

Not a silly question but I had checked already and the SSIS service was installed and running and I had checked everything to install.

I tried to install the parts of sql that I could to D: rather than the default of C: and I installed SQL Express before the SQL 2005 EVAL (which I the realized that I needed for SSIS)

Then I posted the question and the decided to un and re-install.

I have now installed just the EVAL and it now works ok :-)

(In fact I see that there is also an Analysis Service Template there as well)

So the problem may have been with the order or the location?

I will be adding the SQL Express later so if it fails I will let you know...

Thanks anyway for the reply

|||

Not a silly question but I had checked already and the SSIS service was installed and running and I had checked everything to install.

I tried to install the parts of sql that I could to D: rather than the default of C: and I installed SQL Express before the SQL 2005 EVAL (which I the realized that I needed for SSIS)

Then I posted the question and the decided to un and re-install

I have now installed just the EVAL and it now works ok :-)

(In fact I see that there is also an Analysis Service Template there as well)

So the problem may have been with the order or the location?

I will be adding the SQL Express later so if it fails I will let you know...

Thanks anyway for the reply

|||

Your configuration should work fantastically. Not sure what gremlin reaked havok in your install but glad everything is fine now! I have your exact config and everything works well.

-- Brian Knight

Missing Integration Service Template

I have installed SQL Server 180 day evaluation as well as SQL Server Express but I cannot add a new SSIS project because the template is not there (- in the non-express instance - only Reporting Services). When I try and redo the SSIS part of setup(Add/Remove programs) the report tells me that it is already installed correctly. I have searched for others having this problem to no avail...

What do I need to do to fix it?

This may be a silly question but just wanted to make sure. Did you check the bottom option in the installation wizard for Workstation components and documentation? Also, when you look at the services, do you see the SSIS service installed?

-- Brian Knight

|||

Not a silly question but I had checked already and the SSIS service was installed and running and I had checked everything to install.

I tried to install the parts of sql that I could to D: rather than the default of C: and I installed SQL Express before the SQL 2005 EVAL (which I the realized that I needed for SSIS)

Then I posted the question and the decided to un and re-install.

I have now installed just the EVAL and it now works ok :-)

(In fact I see that there is also an Analysis Service Template there as well)

So the problem may have been with the order or the location?

I will be adding the SQL Express later so if it fails I will let you know...

Thanks anyway for the reply

|||

Not a silly question but I had checked already and the SSIS service was installed and running and I had checked everything to install.

I tried to install the parts of sql that I could to D: rather than the default of C: and I installed SQL Express before the SQL 2005 EVAL (which I the realized that I needed for SSIS)

Then I posted the question and the decided to un and re-install

I have now installed just the EVAL and it now works ok :-)

(In fact I see that there is also an Analysis Service Template there as well)

So the problem may have been with the order or the location?

I will be adding the SQL Express later so if it fails I will let you know...

Thanks anyway for the reply

|||

Your configuration should work fantastically. Not sure what gremlin reaked havok in your install but glad everything is fine now! I have your exact config and everything works well.

-- Brian Knight