Basic question

I've instaled M Visual Web Developer studio 2005 ee and SQL 2005.
Service is working, but i can't connect my project with serwer. ASP configuration tool(security) can't connect. Error message doesn't show any reason.
Server menager can connect normally.
Please help
what is the error message?sql

Basic question

I've instaled M Visual Web Developer studio 2005 ee and SQL 2005.
Service is working, but i can't connect my project with serwer. ASP configuration tool(security) can't connect. Error message doesn't show any reason.
Server menager can connect normally.
Please help
what is the error message?

basic authentication with olap failing

Hi,
I've got a situation where I am trying to connect from my local PC to
a windows 2003 server that is running SQL Server2k EE with Analysis
Services and IIS.
I have followed a number of Microsoft articles for configuring http
access to the Analysis Services, and my msolap.asp file is located
correctly and I have tested that I can access it with both anonymous
and basic authentication enabled on the site. The connection string I
am using is pointing to the correct directory for my msolap.asp file.
I can type the url to my msolap.asp file into my browser and do not
get any errors, both on anonymous or basic authentication access (I
need to have basic authentication).
The problem lies in the fact that when I try and access my web site
pages that contain the OWC components, if I turn on basic
authentication on msolap.asp I get unspecified errors and cannot load
data. If I leave the msolap.asp file as anonymous access and my web
site virtual directory with basic authentication, I am promted to
login and the data displays correctly. However, if I refresh the
page, I am prompted to login again - which should not be happening.
The frustrating thing is, if I remove the dynamic OWC component from
my page but leave the static OWC component, then I do not get prompted
to log in multiple times and it behaves as it should.
I know I've outlined a few problems in this post, but I'm pretty new
to OLAP and I'm just trying to get it running on a server.
Thanks in advanceTo clear up a few items, it appears there is no impact of the OWC
component being dynamic or static, as either one of them results in
multiple login prompts. If I disable basic authentication on
msolap.asp, then the strange behaviour I notice is that when I have the
site marked as "Trusted" in my browser, I am prompted to login on first
page access (which is correct), but then prompted to login again on any
hyperlink click on the page or on a page refresh. If I remove the
"Trusted" status, then I am only prompted to login on first access to
the site and on any subsequent refresh of the page in the browser.
Is this the correct behaviour for OWC/OLAP components?
Thankssql

Bad Login/Password...how to correct it?

How do I change the login/password Reporting Services uses to connect to
SQL Server?
How do I reconfigure the options I chose when I installed SQL Server
Reporting Services in the first place?
Help!?!?rsconfig.exe -c
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JC Ford" <johncford@.hotmail.com> wrote in message
news:eSa0kGvfEHA.592@.TK2MSFTNGP11.phx.gbl...
> How do I change the login/password Reporting Services uses to connect to
> SQL Server?
> How do I reconfigure the options I chose when I installed SQL Server
> Reporting Services in the first place?
> Help!?!?|||Thanks!
Tudor Trufinescu (MSFT) wrote:
> rsconfig.exe -c
>

Bad Connection

I am getting the following error when I attempt to connect to SqlServer with the following connection string from my Web.config file:

<add name="LeanPathConnection" connectionString="Data Source=(local);Initial Catalog=VWOA1.DB;User Id=LeanPath;Password=jesus" />

I have made LeanPath a user at the Security level of the server. His default database is VWOA1.DB. I have given him db_owner rights. The following contains the exception detail I get. I don't see how he could NOT have a trusted SQL Server connection!!!!!!

System.Data.SqlClient.SqlException was unhandled by user code
Message="Login failed for user 'LeanPath'. The user is not associated with a trusted SQL Server connection."
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
Class=14
LineNumber=65536
Number=18452
Procedure=""
Server="localhost"
State=1
StackTrace:
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at DbConnection.Open() in c:\Documents and Settings\sarogers\My Documents\Visual Studio 2005\Projects\VWOA\LRS\App_Code\DbConnection.cs:line 21
at MyBase.Execute() in c:\Documents and Settings\sarogers\My Documents\Visual Studio 2005\Projects\VWOA\LRS\App_Code\DbStoredProc.cs:line 63
at MyReturn.RetValParamInt(String ParamName) in c:\Documents and Settings\sarogers\My Documents\Visual Studio 2005\Projects\VWOA\LRS\App_Code\DbStoredProc.cs:line 328
at DbStoredProc.PER_Validate(String LoginName, String Password) in c:\Documents and Settings\sarogers\My Documents\Visual Studio 2005\Projects\VWOA\LRS\App_Code\DbStoredProc.cs:line 1215
at Login.btnLogin_Click(Object sender, EventArgs e) in c:\Documents and Settings\sarogers\My Documents\Visual Studio 2005\Projects\VWOA\LRS\Login.aspx.cs:line 43
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Hi,

you only have Windows Authentication enabled at your server, therefore the SQL Server tries to logon the user with WIndows Authentication. I guess that the LeanUser is a SQL Server User right ? Therefore you will have to use and enable SQL Server authentication first. See my Screencast on my site for more information how to switch from Windows Auth. to Mixed Auth. (SQL Server & Windows Auth).

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de