a DB connection Problem

Hello, I am developping a web application in which I have used SQL Server 2005 (installed in the same comuter ). Now my objective is to migrate the solution to other computer. So I have moved the project to the new Post.. By this way, the connection between the solution and the DB become distant . For this reason when I run this solution the error below is raising

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Login failed for user ''. The user is not associated with a trusted SQL Server connection.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734963 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

I understand from this that the connection with SQL Server 2005 was failed. I know also that I must change something in the connection String But I don' know it . So how doing this?

Thanks in advance

What's your connection string? I guess you're using Windows Authentication to connect to SQL. Make sure the there is a login for the account used in your connection string in the SQL Server. To manage SQL logins, connect to the SQL Server in Management Studio->go to Security->Logins|||

Hello , My connection strin is as below

<

addname="LocalSqlServer"connectionString="Data Source=IBM7;Initial Catalog=Reclamation;Integrated Security=True"providerName="System.Data.SqlClient" />

According to the message Error I have created a new login named IBM7/ASPNET and a new schema named IBM7/ASPNET owned by the new login IBM7/ASPNET . The error message become as follow:

Server Error in '/Rec_Web' Application.

---

Procédure stockée 'dbo.aspnet_CheckSchemaVersion' introuvable.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Procédure stockée 'dbo.aspnet_CheckSchemaVersion' introuvable.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Procédure stockée 'dbo.aspnet_CheckSchemaVersion' introuvable.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857338 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734950 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135 System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) +367 System.Web.Security.SqlMembershipProvider.CheckSchemaVersion(SqlConnection connection) +85 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

So what should I do ? Thanks in advance

|||

Sorry I can't understand the error message very well. I guess it indicates a permission issue on the'dbo.aspnet_CheckSchemaVersion' .So please make sure you're connecting to the right database which contains the'dbo.aspnet_CheckSchemaVersion', and the IBM7/ASPNET account has proper permission to the database objects. Suppose for the login IBM7/ASPNET, you map it to amyuser user in the database:

grant execute on dbo.aspnet_CheckSchemaVersion tomyuser

Consider the IBM7/ASPNET account may use other database objects, you can add it to the db_owner database role in the database.

|||

Thanks for this indication, I think that I understand the problem : The database to which I want connect is imported from another DB who use the ASP membership feature... but it seems during the DB copy the stored procedures related to the membership weren't copied. For this reason, this procedure wasn't founded. My question now , Is there a manner to copy only the non system stored procedures ?

Thanks in advance

A baffeling problem between a text box and database table.

I have a web form with a text box that when submited gets put in a field in a table in an SQL database. Only 50 characters were being passed to the table. I gave the text box a max size of 200 characters and also found that the field in my table was set at 50 char. I had my SA set the field to 200 char. I rebuilt the solution and yet I am still only getting 50 charecters in the table. Any ideas?Show how you are setting the field in SQL Server.|||This is what I am doing to update my database.
'comments' is the field in question.
_______________________________________

Private Sub Update_Dataset()
Dim dr As DataRow = DataSet11.Tables("Results").NewRow()
dr("Area") = Area.SelectedItem
dr("Q1") = Q1.SelectedIndex + 1
dr("Q2") = Q2.SelectedIndex + 1
dr("Q3") = Q3.SelectedIndex + 1
dr("Q4") = Q4.SelectedIndex + 1
dr("Q5") = Q5.SelectedIndex + 1
dr("Q6") = Q6.SelectedIndex + 1
dr("Q7") = Q7.SelectedIndex + 1
dr("Q8") = Q8.SelectedIndex + 1
dr("Q9") = Q9.SelectedIndex + 1
dr("Comments") = Comments.Text
dr("ID") = 0
DataSet11.Tables("Results").Rows.Add(dr)
OleDbDataAdapter1.Update(DataSet11, "Results")

End Sub

__________________________________________________________

A bad error!

hi friends!
i have a web service in .NET 2003 that contain below error and I cant handle it...
...

Anunhandled exception of type 'System.Web.Services.Protocols.SoapException'occurred in system.web.services.dll

Additionalinformation: System.Web.Services.Protocols.SoapException: Server was unable toprocess request. --> System.Data.SqlClient.SqlException: Login failed foruser 'MICROGOD3\ASPNET'.

atSystem.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,Boolean breakConnection)

atSystem.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehaviorrunBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

atSystem.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

atSystem.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnectionowningObject, SqlConnectionString connectionOptions, String newPassword,Boolean redirectedUserInstance)

atSystem.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionString connectionOptions, Object providerInfo, StringnewPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

atSystem.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptionsoptions, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnectionowning Connection)

atSystem.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionowning Connection, DbConnectionPool pool, DbConnectionOptions options)

atSystem.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionowningObject)

atSystem.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionowningObject)

atSystem.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnectionowningObject)

atSystem.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

atSystem.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnectionouterConnection, DbConnectionFactory connectionFactory)

at System.Data.SqlClient.SqlConnection.Open()

atSystem.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[]datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommandcommand, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSetdataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommandcommand, CommandBehavior behavior)

atSystem.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

at LeitnerWebService.Service1.GetData() inc:\inetpub\wwwroot\leitnerwebservice\service1.asmx.cs:line 68

-- End of inner exception stack trace --

PLEASE HELP ME!The Windows user, the web service runs under on the server, user being MICROGOD3\ASPNET based on the error message, does not have permissions to log into the SQL Server you use. It should have a login in SQL Server and the login should be granted permissions to access the database in question.

80004005 ODBC SQL Server Driver shared memory or TCP/IP sockets er

Hi all,
I have been getting these errors on simple ASP code on my web site:
|80004005|[Microsoft][ODBC_SQL_Server_Driver][TCP/IP_Sockets]ConnectionWrite_(send()).
|80004005|[Microsoft][ODBC_SQL_Server_Driver]Timeout_expired
|80004005|[Microsoft][ODBC_SQL_Server_Driver][Shared_Memory]SQL_Server_does_not_exist_or_access_denied.
|80004005|[Microsoft][ODBC_SQL_Server_Driver][TCP/IP_Sockets]SQL_Server_does_not_exist_or_access_denied.
|80004005|[Microsoft][ODBC_SQL_Server_Driver]Timeout_expired
The SQL 2000 is Standard Edition, SP3 and OS is Windows 2003 Standard edition.
Previously I never faced this problem before. These errors come
intermittently, at no specific time. It appears randomly at any time.
The only thing I have to do is reboot the server to solve this issue.
please tell me if there's anything to solve this issue.
reboot?
"tapman" wrote:

> Hi all,
> I have been getting these errors on simple ASP code on my web site:
> |80004005|[Microsoft][ODBC_SQL_Server_Driver][TCP/IP_Sockets]ConnectionWrite_(send()).
> |80004005|[Microsoft][ODBC_SQL_Server_Driver]Timeout_expired
> |80004005|[Microsoft][ODBC_SQL_Server_Driver][Shared_Memory]SQL_Server_does_not_exist_or_access_denied.
>
> |80004005|[Microsoft][ODBC_SQL_Server_Driver][TCP/IP_Sockets]SQL_Server_does_not_exist_or_access_denied.
> |80004005|[Microsoft][ODBC_SQL_Server_Driver]Timeout_expired
> The SQL 2000 is Standard Edition, SP3 and OS is Windows 2003 Standard edition.
> Previously I never faced this problem before. These errors come
> intermittently, at no specific time. It appears randomly at any time.
> The only thing I have to do is reboot the server to solve this issue.
> please tell me if there's anything to solve this issue.
>

64 Bit and 32 Bit Reporting Servers in same web farm

Can I mix 64 Bit and 32 Bit Reporting Servers in same web farm? I currently have a distributed environment with 2 32 Bit Web Servers and a 32 Bit Reporting Services Database server. I would like to add 64 Bit web servers to this configuration. Are there any issues with this?

This wasn't really a tested scenario, but I think in theory it should work. I mean I don't see anything in the RS product code that prevents you from doing so. It's always interesting when a theory is put to test though :).

If you decide to go down this route, let us know any problems you find.

501 when connect to Endpoint

I Created SP and endpoint that exposes SP as web service :

CREATE PROCEDURE TimeServer.ResponseTime2
(
@.TimeType int,
)
AS
IF (@.TimeType = 0 )
SELECT @.Result AS CZAS
ELSE
SELECT @.Result AS CZAS
GO
CREATE ENDPOINT MyWebService
STATE = STARTED
AS HTTP
(
PATH = '/AdventureWorks/MyWebService',
AUTHENTICATION = (INTEGRATED ),
PORTS = ( CLEAR ),
SITE = 'localhost'
)
FOR SOAP
(
WEBMETHOD 'GetTime' (Name = 'AdventureWorks.TimeServer.ResponseTime2', FORMAT = ROWSETS_ONLY),
DATABASE = 'AdventureWorks'
)

GO

When I try to connect to webservice (localhost/AdventureWorks/MyWebServic
I get 501 error - Not implemented or not supported.

Any ideas why ?

I don't know if this answers your question. However, we support HTTP GET requests ONLY for requesting WSDL. In this case if you submitted the following request

http://localhost/AdventureWorks/MyWebService?wsdl

it should return WSDL describing the endpoint.

The rest of the SOAP requests have to be submitted via HTTP POST.

Thanks
Srik

|||

I was also getting this at one point. Try going into IE browser->Tools->Internet Options->Advanced and enable "Use HTTP 1.1 through proxy connections" if this is not set (may be related to proxy settings associated wih IE Browser->Connections->LAN Settings)

501 when connect to Endpoint

I Created SP and endpoint that exposes SP as web service :

CREATE PROCEDURE TimeServer.ResponseTime2
(
@.TimeType int,
)
AS
IF (@.TimeType = 0 )
SELECT @.Result AS CZAS
ELSE
SELECT @.Result AS CZAS
GO
CREATE ENDPOINT MyWebService
STATE = STARTED
AS HTTP
(
PATH = '/AdventureWorks/MyWebService',
AUTHENTICATION = (INTEGRATED ),
PORTS = ( CLEAR ),
SITE = 'localhost'
)
FOR SOAP
(
WEBMETHOD 'GetTime' (Name = 'AdventureWorks.TimeServer.ResponseTime2', FORMAT = ROWSETS_ONLY),
DATABASE = 'AdventureWorks'
)

GO

When I try to connect to webservice (localhost/AdventureWorks/MyWebServic
I get 501 error - Not implemented or not supported.

Any ideas why ?

I don't know if this answers your question. However, we support HTTP GET requests ONLY for requesting WSDL. In this case if you submitted the following request

http://localhost/AdventureWorks/MyWebService?wsdl

it should return WSDL describing the endpoint.

The rest of the SOAP requests have to be submitted via HTTP POST.

Thanks
Srik

|||

I was also getting this at one point. Try going into IE browser->Tools->Internet Options->Advanced and enable "Use HTTP 1.1 through proxy connections" if this is not set (may be related to proxy settings associated wih IE Browser->Connections->LAN Settings)

48folderopen.jpg

A couple of days ago, I asked about changing the Reporting Services web page.
I asked about changing the "SQL Server Reporting Services" text, and
including a company logo where the folder icon now resides. I got a response
that I could change the text by clicking the Site Settings in the upper right
corner, and to look for the css under Program Files\Microsoft SQL Server.
Great start.
It turns out the name of the folder graphic is 48folderopen.jpg. I searched
inside every file on my hard drive, but could not find a reference to that
file name. I did find 48folderopen.jpg in a Microsoft SQL Server subdirectory
(images subdirectory). I renamed my logo.jpg to 48folderopen.jpg. I do see my
logo on the Reporting Services web page, but the sizing is all wrong and it
looks terrible.
Any pointers on where to find the sizing dimensions of 48folderopen.jpg so I
can resize to my logo size? It would also be nice to use my own file name
instead of 48folderopen.jpg, but that's not ciritical.
Thanks,
--
RandyIt is in Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\images
--
"Everyone knows something you don't know"
"randy1200" wrote:
> A couple of days ago, I asked about changing the Reporting Services web page.
> I asked about changing the "SQL Server Reporting Services" text, and
> including a company logo where the folder icon now resides. I got a response
> that I could change the text by clicking the Site Settings in the upper right
> corner, and to look for the css under Program Files\Microsoft SQL Server.
> Great start.
> It turns out the name of the folder graphic is 48folderopen.jpg. I searched
> inside every file on my hard drive, but could not find a reference to that
> file name. I did find 48folderopen.jpg in a Microsoft SQL Server subdirectory
> (images subdirectory). I renamed my logo.jpg to 48folderopen.jpg. I do see my
> logo on the Reporting Services web page, but the sizing is all wrong and it
> looks terrible.
> Any pointers on where to find the sizing dimensions of 48folderopen.jpg so I
> can resize to my logo size? It would also be nice to use my own file name
> instead of 48folderopen.jpg, but that's not ciritical.
> Thanks,
> --
> Randy|||Your logo needs to be 48x48 pixels... :)
Unless you update the CSS sheet to size it correctly.
=-Chris
"randy1200" <randy1200@.newsgroups.nospam> wrote in message
news:39551613-4AA2-4D50-9AFA-00C9346C0487@.microsoft.com...
>A couple of days ago, I asked about changing the Reporting Services web
>page.
> I asked about changing the "SQL Server Reporting Services" text, and
> including a company logo where the folder icon now resides. I got a
> response
> that I could change the text by clicking the Site Settings in the upper
> right
> corner, and to look for the css under Program Files\Microsoft SQL Server.
> Great start.
> It turns out the name of the folder graphic is 48folderopen.jpg. I
> searched
> inside every file on my hard drive, but could not find a reference to that
> file name. I did find 48folderopen.jpg in a Microsoft SQL Server
> subdirectory
> (images subdirectory). I renamed my logo.jpg to 48folderopen.jpg. I do see
> my
> logo on the Reporting Services web page, but the sizing is all wrong and
> it
> looks terrible.
> Any pointers on where to find the sizing dimensions of 48folderopen.jpg so
> I
> can resize to my logo size? It would also be nice to use my own file name
> instead of 48folderopen.jpg, but that's not ciritical.
> Thanks,
> --
> Randy|||I see nothing in the ReportingServices.css that relates to an image size. Any
pointers here?
I was hoping to find something that said 48x48, and change it to 151x60,
which would work perfectly for me.
--
Randy
"Chris Conner" wrote:
> Your logo needs to be 48x48 pixels... :)
> Unless you update the CSS sheet to size it correctly.
> =-Chris
> "randy1200" <randy1200@.newsgroups.nospam> wrote in message
> news:39551613-4AA2-4D50-9AFA-00C9346C0487@.microsoft.com...
> >A couple of days ago, I asked about changing the Reporting Services web
> >page.
> > I asked about changing the "SQL Server Reporting Services" text, and
> > including a company logo where the folder icon now resides. I got a
> > response
> > that I could change the text by clicking the Site Settings in the upper
> > right
> > corner, and to look for the css under Program Files\Microsoft SQL Server.
> > Great start.
> >
> > It turns out the name of the folder graphic is 48folderopen.jpg. I
> > searched
> > inside every file on my hard drive, but could not find a reference to that
> > file name. I did find 48folderopen.jpg in a Microsoft SQL Server
> > subdirectory
> > (images subdirectory). I renamed my logo.jpg to 48folderopen.jpg. I do see
> > my
> > logo on the Reporting Services web page, but the sizing is all wrong and
> > it
> > looks terrible.
> >
> > Any pointers on where to find the sizing dimensions of 48folderopen.jpg so
> > I
> > can resize to my logo size? It would also be nice to use my own file name
> > instead of 48folderopen.jpg, but that's not ciritical.
> >
> > Thanks,
> > --
> > Randy
>
>|||Hello Randy,
Unfortunately, the picture size is hard-coded in the Report Manager, you
could not change it directly.
I looked inside the report manager code and found that it create a HTML
image and hard code the size to be 48 pixel.
You may send the feedback to the product team:
http://connect.microsoft.com/sqlserver.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
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.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community 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.

404 error when using Web Service

I'm building a client application that uses the SSRS Web Service. My problem
is that when I use the servername the web service works just fine. ie
http://RServer/ReportServer/reportservice.asmx
If I try to use the full DNS name of the server any call I make to the web
service returns a 404 error.
ie if I use http://RServer.sdm.dm.com/ReportServer/reportservice.asmx which
points to the same server gives me a 404 error..I've looked at the config
files for ReportServer and can't figure out what's going wrong...
Any help would be greatly appreciated..
Thanks
JasonHello Jason,
To use the FQDN name of the report server, please check the ReportServerUrl
element in the RSWebApplication.config file.
You need to specify the FQDN name for this element. Please refer this
article:
RSWebApplication Configuration File
http://msdn2.microsoft.com/en-us/library/ms155878.aspx
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community 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.

403 trying to access RS web service

Just installed SRS on a remote server. Tried to access the web service at
http://<IP>/reportserver/reportservice.asmx and get 403 - Forbidden.
When the system is installed, anonymous is turned off. When I turn it on I
still get 403 - Forbidden.
Thoughts?
TIA.Damned I.S. guys had IIS configured to disallow all clients except local.
Rrrrrrr..
Prob solved.
"Mark Peters" <mcpdoc@.hotmail.com> wrote in message
news:%23jGrjsJiFHA.708@.TK2MSFTNGP09.phx.gbl...
> Just installed SRS on a remote server. Tried to access the web service at
> http://<IP>/reportserver/reportservice.asmx and get 403 - Forbidden.
> When the system is installed, anonymous is turned off. When I turn it on
> I still get 403 - Forbidden.
> Thoughts?
> TIA.
>

401: Unauthorized.

Dear all,
I have 2 server, Server_A is IIS, Server_B is Reporting Server(SQL2005).
I create a web project under Server_A and drop a reportviewer on the
default.aspx.
I then enter the Server URL and Report path. And build the project.
I can then browse the report without any problem if URL is typing
localhost/web_project/default.aspx
But problem comes up if change into Server_A/webproject/default.aspx.
The message is
The request failed with HTTP status 401: Unauthorized.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Net.WebException: The request failed with HTTP
status 401: Unauthorized.
Regards,
Ken Linhai
this ragu
u have iis server security problem u verify ur admin
i have the same problem occur i verify my admin
i sent the coading
private void button1_Click_1(object sender, EventArgs e)
{
RunRemote();
}
private void RunRemote()
{
try
{
// this.Cursor = Cursors.WaitCursor;
reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer1.ServerReport.ReportServerUrl = new Uri(Settings.Default.ReportServerEndPoint);
reportViewer1.ServerReport.ReportPath = "/Report Project3/TestReortForFunds";
reportViewer1.RefreshReport();
}
catch (Exception ex)
{
throw ex;
}
finally
{
//this.Cursor = Cursors.Default;
}
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com|||use this code easily retrive your report
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportPath = "/Report Project3/TestReortForFunds";
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
Microsoft.Reporting.WebForms.ReportParameter [1]=new Microsoft.Reporting.WebForms.ReportParameter (0);
}
}
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com|||No, I can sucess to view the report from the IE in Web Server.
But when I go to toher computers, got the 401 error.
Regards,
Ken Lin
<ragu> wrote in message news:2006122114446ragu1100@.yahoo.com...
> use this code easily retrive your report
>
> protected void Page_Load(object sender, EventArgs e)
> {
>
> if (!Page.IsPostBack)
> {
> ReportViewer1.ProcessingMode => Microsoft.Reporting.WebForms.ProcessingMode.Remote;
> ReportViewer1.ServerReport.ReportPath = "/Report
> Project3/TestReortForFunds";
> ReportViewer1.ServerReport.ReportServerUrl = new
> Uri(ConfigurationManager.AppSettings["ReportServerEndPoint"]);
> Microsoft.Reporting.WebForms.ReportParameter [1]=new
> Microsoft.Reporting.WebForms.ReportParameter (0);
>
> }
> }
> EggHeadCafe.com - .NET Developer Portal of Choice
> http://www.eggheadcafe.com

401 Web Service Access

Hi,
We are getting a 401 unauthorized error when trying to create subscriptions
via a web service from our .Net. The server is Windows Server 2003 with SP1
and Reporting Services with SP2.
The frustration is that one of our servers is fine with this setup and the
other one is giving the 401 error! I have tried adding the DWORD registry
entry as commonly suggested, but have had no luck (the server that works
doesn't have this entry either).
Would anyone therefore be ale to offer any solutions?
Thanks
DaveUPDATE:
We have found that this problem only occurs if we have the reporting server
on a different server to the application server which is calling the web
service. If they are both hosted on the same machine, everything is fine.
I am guessing that this is because the user information isn't being passed
correctly?

401 Unauthorized When Access Application Remotely

Hello,
I have developed a web application which has a ReportViewer control
embedded in the page and connects to a remote Reporting Services
server. Everything works fine locally in my development environment.
However, when I deploy to the test server, the ReportViewer control
throws a Report Error: 401: Unauthorized exception. I am using
Windows Authentication and Impersonation (the application is on the
local intranet). If I log onto the web server locally and try to
access the web site through localhost, everything works fine. I have
found several articles on implementing the IReportServerCredentials
interface to set the permissions via code, but have not seen anything
on using Windows authentication and impersonation.
Any suggestions would be appreciated...
Thanks!
David.You are most likely experiencing what is called the "double hop" issue.
This happens all the time, thanks to the security set up by default on
your servers. When you log in to your server through the web it will
trust you, but strip your credentials from you. You will be an
anonymous user. Then when you try to request the data in a report from
another data source, it will pass your anonymous credentials to the
other server, and therefore you being denied access is a good thing.
The reason it works when you log in directly to the sever is because it
retains your credentials then. The solution to this is delegation,
which can be set up by the domain controller. This should be enough to
get you started I hope!
Lance M.
Cyke wrote:
> Hello,
> I have developed a web application which has a ReportViewer control
> embedded in the page and connects to a remote Reporting Services
> server. Everything works fine locally in my development environment.
> However, when I deploy to the test server, the ReportViewer control
> throws a Report Error: 401: Unauthorized exception. I am using
> Windows Authentication and Impersonation (the application is on the
> local intranet). If I log onto the web server locally and try to
> access the web site through localhost, everything works fine. I have
> found several articles on implementing the IReportServerCredentials
> interface to set the permissions via code, but have not seen anything
> on using Windows authentication and impersonation.
> Any suggestions would be appreciated...
> Thanks!
> David.

401 authorization denied error for web service proxy

all-
When I have a SQLXML 3.0 virtual directory set up on the same web server as the one that my application is in on my local machine, I can run the application. When I move the web reference (and the web service) to a different server, I can access the
application on my machine with http://localhost but not http://<machinename>.
I have tried setting various properties from the System.Web.Services library in addition to credentials. Here are the the things I have tried:
proxy.UnsafeAuthenticatedConnectionSharing = true;
proxy.Credentials = CredentialCache.DefaultCredentials;
proxy.PreAuthenticate = true;
Maybe the problem is with IIS, but the username does seem to be passed in correctly when it is localhost.
to recap
SAME BOX LOCAL WEB, REMOTE SQLXML BOTH REMOTE
http://localhost YES YES NO
http://<machinename> YES NO NO
After further troubleshooting I can say with some confidence that this is a problem with server-to-server communication.
I have found KB articles on ServerXMLHTTP and how to pass default credentials from server to server, but no examples in .NET.
I also tried every syntax of proxycfg that I could think of, all the way down to
proxycfg -d
Now all requests bypass the proxy server and I still can't pass default credentials.
Any help would be greatly appreciated.

401 2 and repeat request errors

I have sort of asked this elsewhere, but with new information the questions
has changed slightly, so apologies for the broken thread.
I have a web service sending messages through to a SQL server.
I have integrated security on (no anonymous). For one application, when I
run the application i get an unauthorized error and the logs hold these
lines:
2006-02-21 10:32:58 173.1.1.1 GET
/ApplicationWebservice/DocumentContent.asmx - 80 - 172.25.1.1 - 401 2
2148074254
2006-02-21 10:32:58 173.1.1.1 GET
/ApplicationWebservice/DocumentContent.asmx - 80 LONDON\ShamS00 172.25.1.1 -
200 0 0
2006-02-21 10:32:59 173.1.1.1 GET /ApplicationWebservice/Blank.html - 80 -
172.25.1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.N ET+CLR+1.1.4322)
401 2 2148074254
2006-02-21 10:32:59 173.1.1.1 GET /ApplicationWebservice/Blank.html - 80
LONDON\ShamS00 172.25.1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.N ET+CLR+1.1.4322)
200 0 0
2006-02-21 10:32:59 173.1.1.1 POST
/applicationwebservice/documentcontent.asmx - 80 - 172.25.1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+ Protocol+1.1.4322.2032)
401 2 2148074254
2006-02-21 10:32:59 173.1.1.1 POST
/applicationwebservice/documentcontent.asmx - 80 - 172.25.1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+ Protocol+1.1.4322.2032)
401 2 2148074254
What I am confused about is why are there two entries for each request (one
with authentication and one without), and then the next question would be
why does the last 'request' have two entries, both without authentiacation.
perhaps this is an impossible question to answer, but i thought i'd see if
anyone out there had an idea.
I still seem to have my delegation problem, another application seems to be
sending through commands properly, bt not getting an answer from the web
service, but i've decided to take a break from that one.
Any help/thoughts would be apprecitaed.
Thanks
Saira
Where is your web service running? Are you using the http endpoint in SQL
Server 2005? If not, I'm not sure where SQL Server fits into this picture.
The double messages through authentication are normal. The client will try
without authentication and then try with authentication once it find out
what the server needs.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Saira" <Saira@.Bayonet.com> wrote in message
news:uWb%23ZftNGHA.2300@.TK2MSFTNGP15.phx.gbl...
>I have sort of asked this elsewhere, but with new information the questions
>has changed slightly, so apologies for the broken thread.
> I have a web service sending messages through to a SQL server.
> I have integrated security on (no anonymous). For one application, when I
> run the application i get an unauthorized error and the logs hold these
> lines:
> 2006-02-21 10:32:58 173.1.1.1 GET
> /ApplicationWebservice/DocumentContent.asmx - 80 - 172.25.1.1 - 401 2
> 2148074254
> 2006-02-21 10:32:58 173.1.1.1 GET
> /ApplicationWebservice/DocumentContent.asmx - 80 LONDON\ShamS00
> 172.25.1.1 - 200 0 0
> 2006-02-21 10:32:59 173.1.1.1 GET /ApplicationWebservice/Blank.html - 80 -
> 172.25.1.1
> Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.N ET+CLR+1.1.4322)
> 401 2 2148074254
> 2006-02-21 10:32:59 173.1.1.1 GET /ApplicationWebservice/Blank.html - 80
> LONDON\ShamS00 172.25.1.1
> Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.N ET+CLR+1.1.4322)
> 200 0 0
> 2006-02-21 10:32:59 173.1.1.1 POST
> /applicationwebservice/documentcontent.asmx - 80 - 172.25.1.1
> Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+ Protocol+1.1.4322.2032)
> 401 2 2148074254
> 2006-02-21 10:32:59 173.1.1.1 POST
> /applicationwebservice/documentcontent.asmx - 80 - 172.25.1.1
> Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+ Protocol+1.1.4322.2032)
> 401 2 2148074254
> What I am confused about is why are there two entries for each request
> (one with authentication and one without), and then the next question
> would be why does the last 'request' have two entries, both without
> authentiacation. perhaps this is an impossible question to answer, but i
> thought i'd see if anyone out there had an idea.
> I still seem to have my delegation problem, another application seems to
> be sending through commands properly, bt not getting an answer from the
> web service, but i've decided to take a break from that one.
> Any help/thoughts would be apprecitaed.
> Thanks
> Saira
>
|||Thanks, on the authentication, i sort of figured that, but was not positive.
I am not taking advantage of any of the new SQL 2005 features yet.
My setup is a recently installed SQL Server 2005 box, hosting an upgraded
SQL 2000 database.
The client (XP SP2) talks to the web server (IIS 6, in a seperate IP
segment), and the web server requests the data from the database. I had
assumed that I would not need to make massive changes for the upgrade to
2005, is this not the case?
Saira
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:u3wS5gvNGHA.2884@.TK2MSFTNGP12.phx.gbl...
> Where is your web service running? Are you using the http endpoint in SQL
> Server 2005? If not, I'm not sure where SQL Server fits into this
> picture. The double messages through authentication are normal. The
> client will try without authentication and then try with authentication
> once it find out what the server needs.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Saira" <Saira@.Bayonet.com> wrote in message
> news:uWb%23ZftNGHA.2300@.TK2MSFTNGP15.phx.gbl...
>
|||None that I can think of.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Saira" <Saira@.Bayonet.com> wrote in message
news:erGMpHwNGHA.428@.tk2msftngp13.phx.gbl...
> Thanks, on the authentication, i sort of figured that, but was not
> positive.
> I am not taking advantage of any of the new SQL 2005 features yet.
> My setup is a recently installed SQL Server 2005 box, hosting an upgraded
> SQL 2000 database.
> The client (XP SP2) talks to the web server (IIS 6, in a seperate IP
> segment), and the web server requests the data from the database. I had
> assumed that I would not need to make massive changes for the upgrade to
> 2005, is this not the case?
> Saira
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:u3wS5gvNGHA.2884@.TK2MSFTNGP12.phx.gbl...
>

401 2 and repeat request errors

I have sort of asked this elsewhere, but with new information the questions
has changed slightly, so apologies for the broken thread.
I have a web service sending messages through to a SQL server.
I have integrated security on (no anonymous). For one application, when I
run the application i get an unauthorized error and the logs hold these
lines:
2006-02-21 10:32:58 173.1.1.1 GET
/ApplicationWebservice/DocumentContent.asmx - 80 - 172.25.1.1 - 401 2
2148074254
2006-02-21 10:32:58 173.1.1.1 GET
/ApplicationWebservice/DocumentContent.asmx - 80 LONDON\ShamS00 172.25.1.1 -
200 0 0
2006-02-21 10:32:59 173.1.1.1 GET /ApplicationWebservice/Blank.html - 80 -
172.25.1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
401 2 2148074254
2006-02-21 10:32:59 173.1.1.1 GET /ApplicationWebservice/Blank.html - 80
LONDON\ShamS00 172.25.1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
200 0 0
2006-02-21 10:32:59 173.1.1.1 POST
/applicationwebservice/documentcontent.asmx - 80 - 172.25.1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.
2032)
401 2 2148074254
2006-02-21 10:32:59 173.1.1.1 POST
/applicationwebservice/documentcontent.asmx - 80 - 172.25.1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.
2032)
401 2 2148074254
What I am confused about is why are there two entries for each request (one
with authentication and one without), and then the next question would be
why does the last 'request' have two entries, both without authentiacation.
perhaps this is an impossible question to answer, but i thought i'd see if
anyone out there had an idea.
I still seem to have my delegation problem, another application seems to be
sending through commands properly, bt not getting an answer from the web
service, but i've decided to take a break from that one.
Any help/thoughts would be apprecitaed.
Thanks
SairaWhere is your web service running? Are you using the http endpoint in SQL
Server 2005? If not, I'm not sure where SQL Server fits into this picture.
The double messages through authentication are normal. The client will try
without authentication and then try with authentication once it find out
what the server needs.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Saira" <Saira@.Bayonet.com> wrote in message
news:uWb%23ZftNGHA.2300@.TK2MSFTNGP15.phx.gbl...
>I have sort of asked this elsewhere, but with new information the questions
>has changed slightly, so apologies for the broken thread.
> I have a web service sending messages through to a SQL server.
> I have integrated security on (no anonymous). For one application, when I
> run the application i get an unauthorized error and the logs hold these
> lines:
> 2006-02-21 10:32:58 173.1.1.1 GET
> /ApplicationWebservice/DocumentContent.asmx - 80 - 172.25.1.1 - 401 2
> 2148074254
> 2006-02-21 10:32:58 173.1.1.1 GET
> /ApplicationWebservice/DocumentContent.asmx - 80 LONDON\ShamS00
> 172.25.1.1 - 200 0 0
> 2006-02-21 10:32:59 173.1.1.1 GET /ApplicationWebservice/Blank.html - 80 -
> 172.25.1.1
> Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
> 401 2 2148074254
> 2006-02-21 10:32:59 173.1.1.1 GET /ApplicationWebservice/Blank.html - 80
> LONDON\ShamS00 172.25.1.1
> Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
> 200 0 0
> 2006-02-21 10:32:59 173.1.1.1 POST
> /applicationwebservice/documentcontent.asmx - 80 - 172.25.1.1
> Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.432
2.2032)
> 401 2 2148074254
> 2006-02-21 10:32:59 173.1.1.1 POST
> /applicationwebservice/documentcontent.asmx - 80 - 172.25.1.1
> Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.432
2.2032)
> 401 2 2148074254
> What I am confused about is why are there two entries for each request
> (one with authentication and one without), and then the next question
> would be why does the last 'request' have two entries, both without
> authentiacation. perhaps this is an impossible question to answer, but i
> thought i'd see if anyone out there had an idea.
> I still seem to have my delegation problem, another application seems to
> be sending through commands properly, bt not getting an answer from the
> web service, but i've decided to take a break from that one.
> Any help/thoughts would be apprecitaed.
> Thanks
> Saira
>|||Thanks, on the authentication, i sort of figured that, but was not positive.
I am not taking advantage of any of the new SQL 2005 features yet.
My setup is a recently installed SQL Server 2005 box, hosting an upgraded
SQL 2000 database.
The client (XP SP2) talks to the web server (IIS 6, in a seperate IP
segment), and the web server requests the data from the database. I had
assumed that I would not need to make massive changes for the upgrade to
2005, is this not the case?
Saira
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:u3wS5gvNGHA.2884@.TK2MSFTNGP12.phx.gbl...
> Where is your web service running? Are you using the http endpoint in SQL
> Server 2005? If not, I'm not sure where SQL Server fits into this
> picture. The double messages through authentication are normal. The
> client will try without authentication and then try with authentication
> once it find out what the server needs.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Saira" <Saira@.Bayonet.com> wrote in message
> news:uWb%23ZftNGHA.2300@.TK2MSFTNGP15.phx.gbl...
>|||None that I can think of.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Saira" <Saira@.Bayonet.com> wrote in message
news:erGMpHwNGHA.428@.tk2msftngp13.phx.gbl...
> Thanks, on the authentication, i sort of figured that, but was not
> positive.
> I am not taking advantage of any of the new SQL 2005 features yet.
> My setup is a recently installed SQL Server 2005 box, hosting an upgraded
> SQL 2000 database.
> The client (XP SP2) talks to the web server (IIS 6, in a seperate IP
> segment), and the web server requests the data from the database. I had
> assumed that I would not need to make massive changes for the upgrade to
> 2005, is this not the case?
> Saira
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:u3wS5gvNGHA.2884@.TK2MSFTNGP12.phx.gbl...
>

4 Layered Web Application for Inserting data into a database using sql server as the back

4 Layered Web Application for Inserting data into a database using sql server as the back end and a web form as the front end using C# .

Can someone provide with code as I am new to this architecture and framework.

Better send email.

Thanks In Advance,

A New Bie

I suggest taking a look at the Time Tracker Starter Kit (v1.x or x2.0)or the Issue Tracker Starter Kit (v1.x). Full source code isavailable. Click on theDownloads tab above to find them. These are not exactly what you are looking for, but perhaps they will help you get started.

3-tier deployment

I'm trying to deploy reporting services in an architecture that has an IIS
server outside of the firewall, a middle tier server running web services and
a backend sql server. I understand I need to have the reporting services on
my sql server and I also understand I need to have the reporting client (iis
portion) installed somewhere.
How do I do this and keep my 3 tier architecture. I cannot install software
on the IIS server that talks directly to my sql server (2 tier).
I am not using the portal to view reports. I'm rendering the reports by
creating a hyperlink to the rdl files. Do I use virtual folders mapped to the
middle tier? Will the report clients get installed on both boxes? Front only?You misunderstand the architecture. SQL Server database is an object store.
You can report off of any database for the data for the report but the
object store must be SQL Server database. Reporting Services is an asp.net
application. It is not the client it is the application. That means that you
have to have IIS installed where you have RS installed. You can integrate
with either URL integration or with SOAP. SOAP is more complicated but it
gives you the most control. RS uses the object store which can reside on
another machine. RS does the queries to the data to report off of it.
By my understanding of 3 tier you have the user (using a browser it one
tier), your app is the second tier and SQL Server is the 3rd tier. Having RS
go against SQL Server data does not make it 2 tier. RS is a middle tier app.
You want to do 4 tiers which makes it more complicated, doable but
complicated.
Here is a great link to understand how this all works:
http://www.microsoft.com/sql/reporting/techinfo/techoverview.asp
Also, you might want to investigate the controls that come with Widbey beta
(a new winform and webform control). They will make this sort of integration
easier.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Leneise44" <Leneise44@.discussions.microsoft.com> wrote in message
news:15A3BF25-1B83-498F-AE11-CC647E3FF058@.microsoft.com...
> I'm trying to deploy reporting services in an architecture that has an IIS
> server outside of the firewall, a middle tier server running web services
and
> a backend sql server. I understand I need to have the reporting services
on
> my sql server and I also understand I need to have the reporting client
(iis
> portion) installed somewhere.
> How do I do this and keep my 3 tier architecture. I cannot install
software
> on the IIS server that talks directly to my sql server (2 tier).
> I am not using the portal to view reports. I'm rendering the reports by
> creating a hyperlink to the rdl files. Do I use virtual folders mapped to
the
> middle tier? Will the report clients get installed on both boxes? Front
only?|||Perhaps I can help with a few general statements. First, you can absolutely
deploy on 3 servers if that is what you want. Doing so requires that you do
some programming to embed reports on your web page.
Next, Reporting Services is implemented with web services, not straight
DLL's. You have to have IIS installed on the server that renders the
reports. Having said that, you can put RS on the SQL Server box or on a
separate server. Also, you can either let users access the server that has
the rendering web services, or you can hide this server from users.
Note that the Reporting Services databases need to be in SQL Server, but
your reports can access data from a different SQL Server, or any other
source. I will omit any further details about this since this thread seems
to be about business logic on a separate server.
Putting this together, the simplest 3-server implementation involves a
public web server with IIS, a middle tier server with IIS running the RS web
services, and a database server with both the Reporting Services databases
and the report data.
As I said in the beginning, this public web site needs programming to either
embed web pages served up from the middle tier using URL access, or to embed
raw HTML, PDF, JPEG, etc. data from the web service. As Bruse said, the 2005
version will ship new controls that will make this embedding process a lot
easier.
Hope this helps,
Ted
"Leneise44" wrote:
> I'm trying to deploy reporting services in an architecture that has an IIS
> server outside of the firewall, a middle tier server running web services and
> a backend sql server. I understand I need to have the reporting services on
> my sql server and I also understand I need to have the reporting client (iis
> portion) installed somewhere.
> How do I do this and keep my 3 tier architecture. I cannot install software
> on the IIS server that talks directly to my sql server (2 tier).
> I am not using the portal to view reports. I'm rendering the reports by
> creating a hyperlink to the rdl files. Do I use virtual folders mapped to the
> middle tier? Will the report clients get installed on both boxes? Front only?|||Having a WebService as Datasources may help you to have the 3-tiers
WebServices Data Processing Extension
http://www.rdlcomponents.com/DTE/default.aspx
Thanks
Jerry
"Ted K" wrote:
> Perhaps I can help with a few general statements. First, you can absolutely
> deploy on 3 servers if that is what you want. Doing so requires that you do
> some programming to embed reports on your web page.
> Next, Reporting Services is implemented with web services, not straight
> DLL's. You have to have IIS installed on the server that renders the
> reports. Having said that, you can put RS on the SQL Server box or on a
> separate server. Also, you can either let users access the server that has
> the rendering web services, or you can hide this server from users.
> Note that the Reporting Services databases need to be in SQL Server, but
> your reports can access data from a different SQL Server, or any other
> source. I will omit any further details about this since this thread seems
> to be about business logic on a separate server.
> Putting this together, the simplest 3-server implementation involves a
> public web server with IIS, a middle tier server with IIS running the RS web
> services, and a database server with both the Reporting Services databases
> and the report data.
> As I said in the beginning, this public web site needs programming to either
> embed web pages served up from the middle tier using URL access, or to embed
> raw HTML, PDF, JPEG, etc. data from the web service. As Bruse said, the 2005
> version will ship new controls that will make this embedding process a lot
> easier.
> Hope this helps,
> Ted
>
> "Leneise44" wrote:
> > I'm trying to deploy reporting services in an architecture that has an IIS
> > server outside of the firewall, a middle tier server running web services and
> > a backend sql server. I understand I need to have the reporting services on
> > my sql server and I also understand I need to have the reporting client (iis
> > portion) installed somewhere.
> >
> > How do I do this and keep my 3 tier architecture. I cannot install software
> > on the IIS server that talks directly to my sql server (2 tier).
> >
> > I am not using the portal to view reports. I'm rendering the reports by
> > creating a hyperlink to the rdl files. Do I use virtual folders mapped to the
> > middle tier? Will the report clients get installed on both boxes? Front only?