Having trouble deploying a report

I've installed SQL Server 2005 express SP2 with SQL Server Reporting
Services, along with the Business Intelligence Development Studio from
the SQL Server Express Toolkit SP2. I've created a reports project
and a simple report that I'm trying to deploy. When I try to deploy,
I get prompted for a username and password. I've tried all the
username and password for this computer combinations I can think of,
but it doesn't recognize any of them. I have the virtual directory for
the SQL Reports set to 'integrated windows'. Any ideas about what I'm
missing?
-MichaelOn Jan 19, 7:07 pm, michael.sle...@.gmail.com wrote:
> I've installed SQL Server 2005 express SP2 with SQL Server Reporting
> Services, along with the Business Intelligence Development Studio from
> the SQL Server Express Toolkit SP2. I've created a reports project
> and a simple report that I'm trying to deploy. When I try to deploy,
> I get prompted for a username and password. I've tried all the
> username and password for this computer combinations I can think of,
> but it doesn't recognize any of them. I have the virtual directory for
> the SQL Reports set to 'integrated windows'. Any ideas about what I'm
> missing?
> -Michael
Have you created at least one user account in the Report Manager? If
you haven't, you will want to create a user account with at least
Browser privileges in the Report Manager, preferably set to your
current windows domain account (i.e., DOMAIN_NAME\UserName). Also, if
you are using Firefox or some other non-IE browser, the authentication
window always pops up. If this doesn't help, you may need to evaluate
the security on the Reports and ReportServer virtual directories in
IIS. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Why not uploading the report using report manager?
http://localhost/reportS
Then "Upload Report"
See if you get an error message there, possibly more specific and post this
here.
Regards
Ralf Stofer
"EMartinez" wrote:
> On Jan 19, 7:07 pm, michael.sle...@.gmail.com wrote:
> > I've installed SQL Server 2005 express SP2 with SQL Server Reporting
> > Services, along with the Business Intelligence Development Studio from
> > the SQL Server Express Toolkit SP2. I've created a reports project
> > and a simple report that I'm trying to deploy. When I try to deploy,
> > I get prompted for a username and password. I've tried all the
> > username and password for this computer combinations I can think of,
> > but it doesn't recognize any of them. I have the virtual directory for
> > the SQL Reports set to 'integrated windows'. Any ideas about what I'm
> > missing?
> >
> > -Michael
>
> Have you created at least one user account in the Report Manager? If
> you haven't, you will want to create a user account with at least
> Browser privileges in the Report Manager, preferably set to your
> current windows domain account (i.e., DOMAIN_NAME\UserName). Also, if
> you are using Firefox or some other non-IE browser, the authentication
> window always pops up. If this doesn't help, you may need to evaluate
> the security on the Reports and ReportServer virtual directories in
> IIS. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jan 21, 2:35 pm, Ralf Stofer <RalfSto...@.discussions.microsoft.com>
wrote:
> Why not uploading the report using report manager?http://localhost/reportS
> Then "Upload Report"
> See if you get an error message there, possibly more specific and post this
> here.
> Regards
> Ralf Stofer
> "EMartinez" wrote:
> > On Jan 19, 7:07 pm, michael.sle...@.gmail.com wrote:
> > > I've installed SQL Server 2005 express SP2 with SQL Server Reporting
> > > Services, along with the Business Intelligence Development Studio from
> > > the SQL Server Express Toolkit SP2. I've created a reports project
> > > and a simple report that I'm trying to deploy. When I try to deploy,
> > > I get prompted for a username and password. I've tried all the
> > > username and password for this computer combinations I can think of,
> > > but it doesn't recognize any of them. I have the virtual directory for
> > > the SQL Reports set to 'integrated windows'. Any ideas about what I'm
> > > missing?
> > > -Michael
> > Have you created at least one user account in the Report Manager? If
> > you haven't, you will want to create a user account with at least
> > Browser privileges in the Report Manager, preferably set to your
> > current windows domain account (i.e., DOMAIN_NAME\UserName). Also, if
> > you are using Firefox or some other non-IE browser, the authentication
> > window always pops up. If this doesn't help, you may need to evaluate
> > the security on the Reports and ReportServer virtual directories in
> > IIS. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
In order to upload a report via the Report Manager, the items I
mentioned above need to be in place beforehand.
Regards,
Enrique Martinez
Sr. Software Consultant

Having problem with my server

I just currently installed Microsoft studio express which includes SQL server and i get this error Server Error in '/WebSite1' Application. it also states "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" I am wondering do i have to have IIS on to run SQL server 2005 express adition.

I am also having problem with SQL Express installation. After installing it, and configuring with SQL surface area for also remote access via tcp or pipe I still get the message:

>sqlcmd

HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

|||Make sure you have followed all of the steps at http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx in order to enable remote connectivity.

Having difficulty creating a stored procedure

I am trying to create stored procedure i Query analyzer in visual studio 2005. I am having
difficulty though. Whenever I press the execute button, here is the error message I get:

Msg 102, Level 15, State 1, Procedure MarketCreate, Line 21
Incorrect syntax near 'MarketName'.

Here is the stored procedure. Note that the very first column in named "MarketId" but I did not
include it in the stored procedure since it should be auto generated.

USE [StockWatch]
GO
/****** Object: StoredProcedure [dbo].[MarketCreate] Script Date: 08/28/2007 15:49:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[MarketCreate]

(
@.MarketCode nvarchar(20),
@.MarketName nvarchar(100),
@.LastUpdateDate nvarchar(2),
@.MarketDescription nvarchar(100)
)

AS
INSERT INTO Market
(
MarketCode
MarketName
LastUpdateDate
MarketDescription
)
VALUES
(
@.MarketCode
@.MarketName
@.LastUpdateUser
@.MarketDescription
)

You need to use comma's to separate the column names.

USE[StockWatch]

GO

/****** Object: StoredProcedure [dbo].[MarketCreate] Script Date: 08/28/2007 15:49:26 ******/

SET ANSI_NULLSON

GO

SET QUOTED_IDENTIFIERON

GO

CREATEPROCEDURE [dbo].[MarketCreate]

(

@.MarketCodenvarchar(20),

@.MarketNamenvarchar(100),

@.LastUpdateDatenvarchar(2),

@.MarketDescriptionnvarchar(100)

)

AS

INSERTINTO Market

(

MarketCode,

MarketName,

LastUpdateDate,

MarketDescription

)

VALUES

(

@.MarketCode,

@.MarketName,

@.LastUpdateUser,

@.MarketDescription

)

|||

Thanks !

have SQL Server Mgmt Studio save alter table script when change table?

Is there a way to have SQL Server Management Studio save the script for
everything necessary to alter a table when changing the design of a table?
The older Visual Studio interfaces would allow this - maybe I can discover w
here
to turn that on in Visual Studio 2005?
--
Thanks in advance, Les CaudleHello Les,
If I understand the issue correctly, you'd like to save the script for
alterring a table when you change the design of the table in Managment
Studio.
You could use the following method to see if it meets your requirement:
1. Right click a table->Design to open the table in design view.
2. Do the change you want for the table.
3. Right click the blank area of the design view->Genegrate Change Script.
Also, If you have any feedback or wishes on SQL Server, I encourage you
submit via the link below and our product team would like to hear your
voice:
http://lab.msdn.microsoft.com/produ...ck/default.aspx
Please let's know if you have any further qusetions. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Les,
I'm still interested in this issue. If you have any comments or questions,
please feel free to let's know. We look forward to hearing from you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

have SQL Server Mgmt Studio save alter table script when change table?

Is there a way to have SQL Server Management Studio save the script for
everything necessary to alter a table when changing the design of a table?
The older Visual Studio interfaces would allow this - maybe I can discover where
to turn that on in Visual Studio 2005?
Thanks in advance, Les Caudle
Hello Les,
If I understand the issue correctly, you'd like to save the script for
alterring a table when you change the design of the table in Managment
Studio.
You could use the following method to see if it meets your requirement:
1. Right click a table->Design to open the table in design view.
2. Do the change you want for the table.
3. Right click the blank area of the design view->Genegrate Change Script.
Also, If you have any feedback or wishes on SQL Server, I encourage you
submit via the link below and our product team would like to hear your
voice:
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Please let's know if you have any further qusetions. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hello Les,
I'm still interested in this issue. If you have any comments or questions,
please feel free to let's know. We look forward to hearing from you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
sql

have SQL Server Mgmt Studio save alter table script when change table?

Is there a way to have SQL Server Management Studio save the script for
everything necessary to alter a table when changing the design of a table?
The older Visual Studio interfaces would allow this - maybe I can discover where
to turn that on in Visual Studio 2005?
--
Thanks in advance, Les CaudleHello Les,
If I understand the issue correctly, you'd like to save the script for
alterring a table when you change the design of the table in Managment
Studio.
You could use the following method to see if it meets your requirement:
1. Right click a table->Design to open the table in design view.
2. Do the change you want for the table.
3. Right click the blank area of the design view->Genegrate Change Script.
Also, If you have any feedback or wishes on SQL Server, I encourage you
submit via the link below and our product team would like to hear your
voice:
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Please let's know if you have any further qusetions. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Les,
I'm still interested in this issue. If you have any comments or questions,
please feel free to let's know. We look forward to hearing from you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hang while trying to browse thr cube

I am working on the Analysis Services

When I am in Business Intelligence Studio and I right-click on the

cube and I choose browse to open the cube-browser, the Cube-Browser

HANGS FOREVER. it never finishes opening. I always end up using the

taskmgr to kill off Business Intelligent Studio. How is this HANGING

problem fixed?

Please make sure whether cube was processed sucesfully before you are browsing it. and also you have sificient permissions to browse the cube.

Thanks

|||Hello,

I have the same problems.
We have a central MSSQL 2005 (OS: Windows 2000) instance and several clients without a local MSSQL Installation. The people create cubes and there exist 2 problems:
- When the user wants to create/deploy the cube on the central instance he needs administrator rights on the base directory of the mssql installation. (I gave the user that right but it is not the way i want to fix the problem)
- It is not possible that a user can browse a cube. I tested the same process on a machine without any firewall (cleint side) and it works. This machine was not in the same network like the other clients. I tested it again and turned off the windows firewall on the clients in the same network, but nothing changed.

Could anybody help me?

Tim