I do not have the option to create an Integration Service project in Business Management Studio

Hi,

I have installed the advanced toolkit for Microsoft Sql server 2005, with the SQL server Business Intelligence Development Studio but I don't have the option the create a Integration Service project. I only have the Report Server project option available.

Do I have to download something else to get it?

I do not have a SQL server instance installed on the machine I installed the toolkit on.

Thank you

What version of SQL Server do you have installed? You need Standard, Developer, or Enterprise.|||

Oh I see, I have the express edition.

I guess I'll get to play with that if we buy one of those editions some day

Thank you

|||Developer edition is $50, but cannot be used in a production environment.

I cant seem to install reporting and business intelligence services, is this disabled for expres

Setup gives me the option, I choose these services, it tells me they are already installed, but they are not?

does it then also give you the option to 'upgrade' them after you hit next?

if not, try going to add/remove programs and hit the change button for sql, it should prompt you for what items to remove, see if you can remove RS.

|||

What makes you think it is not installed?

Mike

I can't get SQL Server 2005 Enterprise Edition working

Hi all,

I can't get SQL Server 2005 Enterprise Edition working on my notebook with Windows Vista Business Edition. I installed SQL Server 2005 Enterprise Edition and then i ran SP2 for SQL Server EE.

But now when i a am trying to connect to any server from SQL SERVER MANAGEMENT STUDIO i can't see any Server in Server Name list. When I click on Browse for more, I don't see any server. I am able to get Network servers.

While installing the SQL SERVER all the features were disabled as it is, then i went to advanced and selected all the options.

Any suggestions are apperiacted in advance.

Regards,

Syed Abbas Naqvi

Sr. Software Developer.

Enterprise Edition (EE) requires a server operation system.

http://www.microsoft.com/sql/editions/enterprise/sysreqs.mspx

Make sure that you installed SQL Server Express (sucessfully) by checking the Services running on the machine. Look for services name "SQL Server*"

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Thanks fo your reply.

But the question is that I want to install Microsoft SQL Server 2005 Enterprise Edition on My notebook which has

Microsoft Windows Vista Business.

I tried installing Microsoft SQL 2000 Server on my machine and it works fine while it is specified on Microsoft Website

that Microsoft SQL 2000 Server is not supported on Microsoft Windows Vista ( Of Any Edition ).

I installed SQL 2000 Server on my notebook when I got frustrated installing SQL Server 2005 Enterprise Edition on my

notebook.

I am really frustrated, i should have not gone for windows vista, let the Windows Vista features go to hell.

I am not able configue .NET 1.1 or .NET 2.0 on my notebook.

I wish there was some magic which can fix all these issues.

Hope to read you soon...

Regards,

Syed Abbas Naqvi

Sr. Software Developer.

|||

Once again, SQL Server EE will need a server OS to run and to be installed. if you have problems installing SQL Server on a vista system (non SQL-EE version) you might have a look here [1] to see what you will have to tweak to make it happen.

[1] http://blogs.msdn.com/sqlexpress/

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||I think you have something wrong!
According to the document at:
http://msdn2.microsoft.com/en-us/library/ms143506.aspx
It says that I can install SQL Server 2005 - Enterprise Edition in Windows Vista (Ultimate - 32 Bit). But the note "Requires SQL Server 2005 SP2 on Windows Vista" makes me difficult to understand "how can I have SS2005 SP2". I had tried to install SS2005-Developer Edition, and upgraded it to SP2, after that, I tried to install SS2005-EE with hope to upgrade my DE into EE but nothing happened...
Please help me!
|||

I think folks are missing the point here...SQL Server Enterprise Edition can not be installed on Vista, period. Vista is a client operating system and we don't support installing Enterprise Edition on client operating systems. I'm pretty sure this is actually blocked in the installer. You will need to install a different edition if you want to install on Vista.

Mike

sql

i can't deploy a report from SQL Server Business Intellegience Development Studio

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

The request failed with HTTP status 405: Method not allowed. (Microsoft.ReportingServices.Designer)

BUTTONS:

OK

I have installed:

* SQL Server 2005 Express Edition SP1

* SQL Management Studio Express

* SQL Server 2005 Express Edition with Advanced Services SP1

* SQL Server 2005 Express Edition Toolkit SP1

I'm trying to create a simple report, that display only a list of names. "Select * From Table"

Any ideas?

Hi,

switch the logging mode of SQL Server Reporting Services to Verbose and try it again, post the specific log snippets of the log according the error to the forum.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hey, Jens

I uninstalled SQL Server Express and all its components, and reinstalled the SQL Express SP1 Edition, i'm no longer going to use the reporting services anymore, as long as i know that SQL Server Express can create reports and deploy it to, other computers. I'm ok, and Thanks for the reply to my Message.

Lloyd Arcales

i can't deploy a report from SQL Server Business Intellegience Development Studio

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

The request failed with HTTP status 405: Method not allowed. (Microsoft.ReportingServices.Designer)

BUTTONS:

OK

I have installed:

* SQL Server 2005 Express Edition SP1

* SQL Management Studio Express

* SQL Server 2005 Express Edition with Advanced Services SP1

* SQL Server 2005 Express Edition Toolkit SP1

I'm trying to create a simple report, that display only a list of names. "Select * From Table"

Any ideas?

Hi,

switch the logging mode of SQL Server Reporting Services to Verbose and try it again, post the specific log snippets of the log according the error to the forum.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hey, Jens

I uninstalled SQL Server Express and all its components, and reinstalled the SQL Express SP1 Edition, i'm no longer going to use the reporting services anymore, as long as i know that SQL Server Express can create reports and deploy it to, other computers. I'm ok, and Thanks for the reply to my Message.

Lloyd Arcales