Hello,
I am doing some development for a client who has an IIS server running
webmail on the same box as the SQL server 2000 sp3 install. I am trying to connect to
this box but do not know how to set it up to connect. The IIS for SQL server
tool lets me add a virtual directory just fine but will not connect. This
problem is not firewall based, as the 1433 port is open, and the database is
running just fine, as those in the LAN can connect ok. My problem is with
the 'external' face and my concern that the running IIS process is
preventing web-based connection. How do I modify/change the IIS for SQL
virtual directory to respond?
If you need more information, please let me know.
Thanks,
Donald Wheeler
What error do you get when you attempt to connect?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I get the standard server not found or access denied error - both via ASP calls and the SQL Server Query analyzer. I don't think that it's an authentication problem because I've tried using both valid and invalid passwords, as well as trying to the connec
t to the Northwind database, and received the same error
Donald
|||Just to clarify, I am trying to enable web access to a SQL Server 2k sp3 database on a machine that already has a set of active IIS directories for webmail. I think the firewall is ok but the connections are getting 'swallowed' by the active IIS and not h
itting the SQL server - does this make sense and if so, how may I remedy it?
Thanks,
Donald Wheeler
sql
Showing posts with label iis. Show all posts
Showing posts with label iis. Show all posts
Friday, March 30, 2012
Problems installing/accessing SQL server via web
Hello,
I am doing some development for a client who has an IIS server running
webmail on the same box as the SQL server 2000 sp3 install. I am trying to c
onnect to
this box but do not know how to set it up to connect. The IIS for SQL server
tool lets me add a virtual directory just fine but will not connect. This
problem is not firewall based, as the 1433 port is open, and the database is
running just fine, as those in the LAN can connect ok. My problem is with
the 'external' face and my concern that the running IIS process is
preventing web-based connection. How do I modify/change the IIS for SQL
virtual directory to respond?
If you need more information, please let me know.
Thanks,
Donald WheelerWhat error do you get when you attempt to connect?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I get the standard server not found or access denied error - both via ASP ca
lls and the SQL Server Query analyzer. I don't think that it's an authentica
tion problem because I've tried using both valid and invalid passwords, as w
ell as trying to the connec
t to the Northwind database, and received the same error
Donald|||Just to clarify, I am trying to enable web access to a SQL Server 2k sp3 dat
abase on a machine that already has a set of active IIS directories for webm
ail. I think the firewall is ok but the connections are getting 'swallowed'
by the active IIS and not h
itting the SQL server - does this make sense and if so, how may I remedy it?
Thanks,
Donald Wheeler
I am doing some development for a client who has an IIS server running
webmail on the same box as the SQL server 2000 sp3 install. I am trying to c
onnect to
this box but do not know how to set it up to connect. The IIS for SQL server
tool lets me add a virtual directory just fine but will not connect. This
problem is not firewall based, as the 1433 port is open, and the database is
running just fine, as those in the LAN can connect ok. My problem is with
the 'external' face and my concern that the running IIS process is
preventing web-based connection. How do I modify/change the IIS for SQL
virtual directory to respond?
If you need more information, please let me know.
Thanks,
Donald WheelerWhat error do you get when you attempt to connect?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I get the standard server not found or access denied error - both via ASP ca
lls and the SQL Server Query analyzer. I don't think that it's an authentica
tion problem because I've tried using both valid and invalid passwords, as w
ell as trying to the connec
t to the Northwind database, and received the same error
Donald|||Just to clarify, I am trying to enable web access to a SQL Server 2k sp3 dat
abase on a machine that already has a set of active IIS directories for webm
ail. I think the firewall is ok but the connections are getting 'swallowed'
by the active IIS and not h
itting the SQL server - does this make sense and if so, how may I remedy it?
Thanks,
Donald Wheeler
Problems installing SRS
I'm trying to install Reporting Services on a new XP Pro SP2 IIS 6
development box. The local database is SQL Server 2000 sp3.
At the end of the installation I get an error message indicating that
the 'Setup could not initialize the report server' and that I'll have
to manually initialize the Report Server.
After running rsactive I got the message indicating that the "Report
Server Web Service has not generated a public key".
Looking in the log files is less-than-helpful (hundreds of lines
indicating that some -unknown- file is missing):
===============================================================================
aspnet_wp!library!a4!12/01/2004-10:15:58:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --
a
===============================================================================
When I navigate to the http://localhost/ReportServer I get the
following error message:
An internal error occurred on the report server. (again not very
helpful).
IIS is listening on port 80 (and there are no other apps on the port).
SO... I'm running out of things to try and patience. Is there anyone
out there who can help me get over this problem? I really need to
get this installed ASAP and there doesn't seem to be any documentation
anywhere that explains what is going wrong!!!
Any help appreciated.
GlennAfter much trail-and-error and finally a call to Microsoft I was able to
install the SRS and get everything working. I'm posting this in hopes that my
solution will help someone in a similar situation.
Ultimately the problem was solved by:
1) accessing the machine.config file
2) find the user name in the process model section (by default it's set
to 'machine')
3) change this to 'system' (temporarily)
4) using EnterpriseManager open the Keys table of the ReportServer
database (three are probably 2 keys)
5) delete the NON-ZERO key (don't delete the ZERO key)
6) browse to http:/localhost/ReportServer (should no longer produce any
errors!!!)
7) browse to http:/localhost/Reposrts
Hope this helps...
Glenn
"Glenn" wrote:
> I'm trying to install Reporting Services on a new XP Pro SP2 IIS 6
> development box. The local database is SQL Server 2000 sp3.
> At the end of the installation I get an error message indicating that
> the 'Setup could not initialize the report server' and that I'll have
> to manually initialize the Report Server.
> After running rsactive I got the message indicating that the "Report
> Server Web Service has not generated a public key".
> Looking in the log files is less-than-helpful (hundreds of lines
> indicating that some -unknown- file is missing):
> ===============================================================================> aspnet_wp!library!a4!12/01/2004-10:15:58:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., ;
> Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot
> find the file specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --
> a
> ===============================================================================> When I navigate to the http://localhost/ReportServer I get the
> following error message:
> An internal error occurred on the report server. (again not very
> helpful).
> IIS is listening on port 80 (and there are no other apps on the port).
>
> SO... I'm running out of things to try and patience. Is there anyone
> out there who can help me get over this problem? I really need to
> get this installed ASAP and there doesn't seem to be any documentation
> anywhere that explains what is going wrong!!!
> Any help appreciated.
> Glenn
>
development box. The local database is SQL Server 2000 sp3.
At the end of the installation I get an error message indicating that
the 'Setup could not initialize the report server' and that I'll have
to manually initialize the Report Server.
After running rsactive I got the message indicating that the "Report
Server Web Service has not generated a public key".
Looking in the log files is less-than-helpful (hundreds of lines
indicating that some -unknown- file is missing):
===============================================================================
aspnet_wp!library!a4!12/01/2004-10:15:58:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --
a
===============================================================================
When I navigate to the http://localhost/ReportServer I get the
following error message:
An internal error occurred on the report server. (again not very
helpful).
IIS is listening on port 80 (and there are no other apps on the port).
SO... I'm running out of things to try and patience. Is there anyone
out there who can help me get over this problem? I really need to
get this installed ASAP and there doesn't seem to be any documentation
anywhere that explains what is going wrong!!!
Any help appreciated.
GlennAfter much trail-and-error and finally a call to Microsoft I was able to
install the SRS and get everything working. I'm posting this in hopes that my
solution will help someone in a similar situation.
Ultimately the problem was solved by:
1) accessing the machine.config file
2) find the user name in the process model section (by default it's set
to 'machine')
3) change this to 'system' (temporarily)
4) using EnterpriseManager open the Keys table of the ReportServer
database (three are probably 2 keys)
5) delete the NON-ZERO key (don't delete the ZERO key)
6) browse to http:/localhost/ReportServer (should no longer produce any
errors!!!)
7) browse to http:/localhost/Reposrts
Hope this helps...
Glenn
"Glenn" wrote:
> I'm trying to install Reporting Services on a new XP Pro SP2 IIS 6
> development box. The local database is SQL Server 2000 sp3.
> At the end of the installation I get an error message indicating that
> the 'Setup could not initialize the report server' and that I'll have
> to manually initialize the Report Server.
> After running rsactive I got the message indicating that the "Report
> Server Web Service has not generated a public key".
> Looking in the log files is less-than-helpful (hundreds of lines
> indicating that some -unknown- file is missing):
> ===============================================================================> aspnet_wp!library!a4!12/01/2004-10:15:58:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., ;
> Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot
> find the file specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --
> a
> ===============================================================================> When I navigate to the http://localhost/ReportServer I get the
> following error message:
> An internal error occurred on the report server. (again not very
> helpful).
> IIS is listening on port 80 (and there are no other apps on the port).
>
> SO... I'm running out of things to try and patience. Is there anyone
> out there who can help me get over this problem? I really need to
> get this installed ASAP and there doesn't seem to be any documentation
> anywhere that explains what is going wrong!!!
> Any help appreciated.
> Glenn
>
Problems installing SQL Reporting Services
I verified that the prerequisites MDAC, ASP, IIS 5 and MSDTC were all
installed, but I'm getting an error duing the install that says:
"IIS is either not installed or not configured for server component
installation"
Any ideas?
Carlton.
I just solved the same issue. Go to Administrative Tools, IIS Manager and
make sure the Default Web site is not stopped. If it is, then Start it and
then the Reporting Services install will not give you this error.
"Cwhitmore" wrote:
> I verified that the prerequisites MDAC, ASP, IIS 5 and MSDTC were all
> installed, but I'm getting an error duing the install that says:
> "IIS is either not installed or not configured for server component
> installation"
> Any ideas?
> Carlton.
>
|||Sunil,
The default website was running. I have serveral virtual directories that
run fine.
Any other ideas?
Carlton.
"Sunil Gulati" wrote:
[vbcol=seagreen]
> I just solved the same issue. Go to Administrative Tools, IIS Manager and
> make sure the Default Web site is not stopped. If it is, then Start it and
> then the Reporting Services install will not give you this error.
> "Cwhitmore" wrote:
installed, but I'm getting an error duing the install that says:
"IIS is either not installed or not configured for server component
installation"
Any ideas?
Carlton.
I just solved the same issue. Go to Administrative Tools, IIS Manager and
make sure the Default Web site is not stopped. If it is, then Start it and
then the Reporting Services install will not give you this error.
"Cwhitmore" wrote:
> I verified that the prerequisites MDAC, ASP, IIS 5 and MSDTC were all
> installed, but I'm getting an error duing the install that says:
> "IIS is either not installed or not configured for server component
> installation"
> Any ideas?
> Carlton.
>
|||Sunil,
The default website was running. I have serveral virtual directories that
run fine.
Any other ideas?
Carlton.
"Sunil Gulati" wrote:
[vbcol=seagreen]
> I just solved the same issue. Go to Administrative Tools, IIS Manager and
> make sure the Default Web site is not stopped. If it is, then Start it and
> then the Reporting Services install will not give you this error.
> "Cwhitmore" wrote:
Problems instaling IIS & Notification Service
I am trying to install SQL server 2005 Developer Edition on a stand alone PC running XP (service pack 2). I have the below error messages preventing me installing Notification Services and Intergration Services ( looks like the same problem for both ). I followed the advice to check the 'Distributed TransactionCoordinator' in services, all setting were correct. I stopped amd restarted the service and selected "retry' to no avail. Any ideas anyone?
Messages:
TITLE: Microsoft SQL Server 2005 Setup
Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29549&EvtType=sqlca%5csqlassembly.cpp%40Do_sqlAssemblyRegSvcs%40Do_sqlAssemblyRegSvcs%40x80070002
BUTTONS:
&Abort
&Retry
&Ignore
TITLE: Microsoft SQL Server 2005 Setup
Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29549&EvtType=sqlca%5csqlassembly.cpp%40Do_sqlAssemblyRegSvcs%40Do_sqlAssemblyRegSvcs%40x80070002
BUTTONS:
&Abort
&Retry
&Ignore
Thanks in advance
ADG
can you try to reinstall .NET Framework 2.0 and then try the setup again?
You can find x86 vesrion of .NET 2.0 redistributable at: http://www.microsoft.com/downloads/details.aspx?FamilyID=0856EACB-4362-4B0D-8EDD-AAB15C5E04F5&displaylang=en
The page also contains links to x64 and ia64 versions at the bottom.
|||Many thanks Jin
I downloaded .net 2.0 as suggested, and selected repair. Service loaded fine afterwards
Monday, March 26, 2012
Problems deploying website
My ASP.NET application runs fine within the VS2005 IDE; but, when I deploy to my local machine to try to run it under IIS and calling it up in a browser, I'm getting the following exception:
Exception Details: System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: 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 '(null)'. Reason: Not associated with a trusted SQL Server connection.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734979
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.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +92
System.Web.UI.WebControls.ListControl.PerformSelect() +31
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +26
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
I'm a novice at this and really need some help. What stupid newbie mistake am I making here? Thanks in advance for any guidance/assistance rendered.
When you deplyed the app you left the same SQL trusted connection, and most probably there is no local SQL server running in the same machine. Make sure to change the SQL string to the IP, username and password of the database and will work really well
Al
|||I remember I got this problem too when I did my first try. It seems that your are using trusted connection, you need assign the domain user in your database with appropriate access right. Or you can create a database user in the database to use standard User/password connection method in your database is in mixed mode..
You can easily find the syntax for the connection string. As to create user in database, you need to create a login account under Security on the Server, in the database, you assign this user for access under database security tab.
Limno
Monday, March 12, 2012
problem: user account access (always uses the same account)
I've configured the IIS with only windows authentication, when i connect to
Reporting Server or Reporting Administrator uses the windows account, but
the security rules work different:
I have configured rules for two accounts: my windows account and
IUSR_machine.
When i try to connect to servers i put my windows account and goes ok, but
the security rules works with the rules assigned to the iusr_machine. Any
rule assigned to my user doesn't have effect, and all the changes makes in
the IUSR_machine's rules have effect.
I've configured restrict access to the iusr_machine and grant permission for
my windows account. When i connect with my windows account and i try to do
any task that iusr_machine haven't permission, the server response me that
the iusr_machine haven't permmission to do it.
Any idea?
thank you.
Oliver
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> escribió en el
mensaje news:OT0ifxqZEHA.212@.TK2MSFTNGP12.phx.gbl...
> Usually this is because anonymous is set on the IIS web site settings.
>
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "oli" <oli1350@.hotmail.com> wrote in message
> news:eHPoJtZZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> > I'm having problem with the authentication in reports. When a user
sign
> > in to Report Administrator or Report Server validates with the IIS'
> > configuration. Onces inside always use the same user with the rules
> > security: IWAM_machine.
> > I need the account used inside of Reporting Server/Reporting
> > Administration
> > should be the same that the account used to validates with IIS.
> >
> > It's possible'
> >
> > Thank you in advanced.
> >
> > Oliver
> >
> >
>
>You have to disable anonymous access for both Reports and Reportserver
virtual directories.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"oli" <oli1350@.hotmail.com> wrote in message
news:#YUfIwBaEHA.212@.TK2MSFTNGP12.phx.gbl...
> I've configured the IIS with only windows authentication, when i connect
to
> Reporting Server or Reporting Administrator uses the windows account, but
> the security rules work different:
> I have configured rules for two accounts: my windows account and
> IUSR_machine.
> When i try to connect to servers i put my windows account and goes ok, but
> the security rules works with the rules assigned to the iusr_machine. Any
> rule assigned to my user doesn't have effect, and all the changes makes in
> the IUSR_machine's rules have effect.
> I've configured restrict access to the iusr_machine and grant permission
for
> my windows account. When i connect with my windows account and i try to do
> any task that iusr_machine haven't permission, the server response me
that
> the iusr_machine haven't permmission to do it.
> Any idea?
> thank you.
> Oliver
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> escribió en el
> mensaje news:OT0ifxqZEHA.212@.TK2MSFTNGP12.phx.gbl...
> > Usually this is because anonymous is set on the IIS web site settings.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "oli" <oli1350@.hotmail.com> wrote in message
> > news:eHPoJtZZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> > > Hi,
> > > I'm having problem with the authentication in reports. When a user
> sign
> > > in to Report Administrator or Report Server validates with the IIS'
> > > configuration. Onces inside always use the same user with the rules
> > > security: IWAM_machine.
> > > I need the account used inside of Reporting Server/Reporting
> > > Administration
> > > should be the same that the account used to validates with IIS.
> > >
> > > It's possible'
> > >
> > > Thank you in advanced.
> > >
> > > Oliver
> > >
> > >
> >
> >
>|||I uses the windows integrated authentication in both, but with the same
result: the rules works like if i authenticates with iwam_machine.
"Tudor Trufinescu (MSFT)" <tudortr@.ms.com> escribió en el mensaje
news:utWbctEaEHA.2792@.TK2MSFTNGP09.phx.gbl...
> You have to disable anonymous access for both Reports and Reportserver
> virtual directories.
> --
> Tudor Trufinescu
> Dev Lead
> Sql Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "oli" <oli1350@.hotmail.com> wrote in message
> news:#YUfIwBaEHA.212@.TK2MSFTNGP12.phx.gbl...
> > I've configured the IIS with only windows authentication, when i connect
> to
> > Reporting Server or Reporting Administrator uses the windows account,
but
> > the security rules work different:
> > I have configured rules for two accounts: my windows account and
> > IUSR_machine.
> >
> > When i try to connect to servers i put my windows account and goes ok,
but
> > the security rules works with the rules assigned to the iusr_machine.
Any
> > rule assigned to my user doesn't have effect, and all the changes makes
in
> > the IUSR_machine's rules have effect.
> >
> > I've configured restrict access to the iusr_machine and grant permission
> for
> > my windows account. When i connect with my windows account and i try to
do
> > any task that iusr_machine haven't permission, the server response me
> that
> > the iusr_machine haven't permmission to do it.
> >
> > Any idea?
> >
> > thank you.
> >
> > Oliver
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> escribió en el
> > mensaje news:OT0ifxqZEHA.212@.TK2MSFTNGP12.phx.gbl...
> > > Usually this is because anonymous is set on the IIS web site settings.
> > >
> > > --
> > > Brian Welcker
> > > Group Program Manager
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "oli" <oli1350@.hotmail.com> wrote in message
> > > news:eHPoJtZZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> > > > Hi,
> > > > I'm having problem with the authentication in reports. When a
user
> > sign
> > > > in to Report Administrator or Report Server validates with the IIS'
> > > > configuration. Onces inside always use the same user with the rules
> > > > security: IWAM_machine.
> > > > I need the account used inside of Reporting Server/Reporting
> > > > Administration
> > > > should be the same that the account used to validates with IIS.
> > > >
> > > > It's possible'
> > > >
> > > > Thank you in advanced.
> > > >
> > > > Oliver
> > > >
> > > >
> > >
> > >
> >
> >
>|||sorry,
i wanted to say i uses only windows integrated authentication in both(not
uses anonymous access)
"oli" <oli1350@.hotmail.com> escribió en el mensaje
news:ub%23HEVLaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> I uses the windows integrated authentication in both, but with the same
> result: the rules works like if i authenticates with iwam_machine.
>
> "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> escribió en el mensaje
> news:utWbctEaEHA.2792@.TK2MSFTNGP09.phx.gbl...
> > You have to disable anonymous access for both Reports and Reportserver
> > virtual directories.
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "oli" <oli1350@.hotmail.com> wrote in message
> > news:#YUfIwBaEHA.212@.TK2MSFTNGP12.phx.gbl...
> > > I've configured the IIS with only windows authentication, when i
connect
> > to
> > > Reporting Server or Reporting Administrator uses the windows account,
> but
> > > the security rules work different:
> > > I have configured rules for two accounts: my windows account and
> > > IUSR_machine.
> > >
> > > When i try to connect to servers i put my windows account and goes ok,
> but
> > > the security rules works with the rules assigned to the iusr_machine.
> Any
> > > rule assigned to my user doesn't have effect, and all the changes
makes
> in
> > > the IUSR_machine's rules have effect.
> > >
> > > I've configured restrict access to the iusr_machine and grant
permission
> > for
> > > my windows account. When i connect with my windows account and i try
to
> do
> > > any task that iusr_machine haven't permission, the server response me
> > that
> > > the iusr_machine haven't permmission to do it.
> > >
> > > Any idea?
> > >
> > > thank you.
> > >
> > > Oliver
> > >
> > > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> escribió en el
> > > mensaje news:OT0ifxqZEHA.212@.TK2MSFTNGP12.phx.gbl...
> > > > Usually this is because anonymous is set on the IIS web site
settings.
> > > >
> > > > --
> > > > Brian Welcker
> > > > Group Program Manager
> > > > SQL Server Reporting Services
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > > "oli" <oli1350@.hotmail.com> wrote in message
> > > > news:eHPoJtZZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> > > > > Hi,
> > > > > I'm having problem with the authentication in reports. When a
> user
> > > sign
> > > > > in to Report Administrator or Report Server validates with the
IIS'
> > > > > configuration. Onces inside always use the same user with the
rules
> > > > > security: IWAM_machine.
> > > > > I need the account used inside of Reporting Server/Reporting
> > > > > Administration
> > > > > should be the same that the account used to validates with IIS.
> > > > >
> > > > > It's possible'
> > > > >
> > > > > Thank you in advanced.
> > > > >
> > > > > Oliver
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
Reporting Server or Reporting Administrator uses the windows account, but
the security rules work different:
I have configured rules for two accounts: my windows account and
IUSR_machine.
When i try to connect to servers i put my windows account and goes ok, but
the security rules works with the rules assigned to the iusr_machine. Any
rule assigned to my user doesn't have effect, and all the changes makes in
the IUSR_machine's rules have effect.
I've configured restrict access to the iusr_machine and grant permission for
my windows account. When i connect with my windows account and i try to do
any task that iusr_machine haven't permission, the server response me that
the iusr_machine haven't permmission to do it.
Any idea?
thank you.
Oliver
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> escribió en el
mensaje news:OT0ifxqZEHA.212@.TK2MSFTNGP12.phx.gbl...
> Usually this is because anonymous is set on the IIS web site settings.
>
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "oli" <oli1350@.hotmail.com> wrote in message
> news:eHPoJtZZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> > I'm having problem with the authentication in reports. When a user
sign
> > in to Report Administrator or Report Server validates with the IIS'
> > configuration. Onces inside always use the same user with the rules
> > security: IWAM_machine.
> > I need the account used inside of Reporting Server/Reporting
> > Administration
> > should be the same that the account used to validates with IIS.
> >
> > It's possible'
> >
> > Thank you in advanced.
> >
> > Oliver
> >
> >
>
>You have to disable anonymous access for both Reports and Reportserver
virtual directories.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"oli" <oli1350@.hotmail.com> wrote in message
news:#YUfIwBaEHA.212@.TK2MSFTNGP12.phx.gbl...
> I've configured the IIS with only windows authentication, when i connect
to
> Reporting Server or Reporting Administrator uses the windows account, but
> the security rules work different:
> I have configured rules for two accounts: my windows account and
> IUSR_machine.
> When i try to connect to servers i put my windows account and goes ok, but
> the security rules works with the rules assigned to the iusr_machine. Any
> rule assigned to my user doesn't have effect, and all the changes makes in
> the IUSR_machine's rules have effect.
> I've configured restrict access to the iusr_machine and grant permission
for
> my windows account. When i connect with my windows account and i try to do
> any task that iusr_machine haven't permission, the server response me
that
> the iusr_machine haven't permmission to do it.
> Any idea?
> thank you.
> Oliver
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> escribió en el
> mensaje news:OT0ifxqZEHA.212@.TK2MSFTNGP12.phx.gbl...
> > Usually this is because anonymous is set on the IIS web site settings.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "oli" <oli1350@.hotmail.com> wrote in message
> > news:eHPoJtZZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> > > Hi,
> > > I'm having problem with the authentication in reports. When a user
> sign
> > > in to Report Administrator or Report Server validates with the IIS'
> > > configuration. Onces inside always use the same user with the rules
> > > security: IWAM_machine.
> > > I need the account used inside of Reporting Server/Reporting
> > > Administration
> > > should be the same that the account used to validates with IIS.
> > >
> > > It's possible'
> > >
> > > Thank you in advanced.
> > >
> > > Oliver
> > >
> > >
> >
> >
>|||I uses the windows integrated authentication in both, but with the same
result: the rules works like if i authenticates with iwam_machine.
"Tudor Trufinescu (MSFT)" <tudortr@.ms.com> escribió en el mensaje
news:utWbctEaEHA.2792@.TK2MSFTNGP09.phx.gbl...
> You have to disable anonymous access for both Reports and Reportserver
> virtual directories.
> --
> Tudor Trufinescu
> Dev Lead
> Sql Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "oli" <oli1350@.hotmail.com> wrote in message
> news:#YUfIwBaEHA.212@.TK2MSFTNGP12.phx.gbl...
> > I've configured the IIS with only windows authentication, when i connect
> to
> > Reporting Server or Reporting Administrator uses the windows account,
but
> > the security rules work different:
> > I have configured rules for two accounts: my windows account and
> > IUSR_machine.
> >
> > When i try to connect to servers i put my windows account and goes ok,
but
> > the security rules works with the rules assigned to the iusr_machine.
Any
> > rule assigned to my user doesn't have effect, and all the changes makes
in
> > the IUSR_machine's rules have effect.
> >
> > I've configured restrict access to the iusr_machine and grant permission
> for
> > my windows account. When i connect with my windows account and i try to
do
> > any task that iusr_machine haven't permission, the server response me
> that
> > the iusr_machine haven't permmission to do it.
> >
> > Any idea?
> >
> > thank you.
> >
> > Oliver
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> escribió en el
> > mensaje news:OT0ifxqZEHA.212@.TK2MSFTNGP12.phx.gbl...
> > > Usually this is because anonymous is set on the IIS web site settings.
> > >
> > > --
> > > Brian Welcker
> > > Group Program Manager
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "oli" <oli1350@.hotmail.com> wrote in message
> > > news:eHPoJtZZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> > > > Hi,
> > > > I'm having problem with the authentication in reports. When a
user
> > sign
> > > > in to Report Administrator or Report Server validates with the IIS'
> > > > configuration. Onces inside always use the same user with the rules
> > > > security: IWAM_machine.
> > > > I need the account used inside of Reporting Server/Reporting
> > > > Administration
> > > > should be the same that the account used to validates with IIS.
> > > >
> > > > It's possible'
> > > >
> > > > Thank you in advanced.
> > > >
> > > > Oliver
> > > >
> > > >
> > >
> > >
> >
> >
>|||sorry,
i wanted to say i uses only windows integrated authentication in both(not
uses anonymous access)
"oli" <oli1350@.hotmail.com> escribió en el mensaje
news:ub%23HEVLaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> I uses the windows integrated authentication in both, but with the same
> result: the rules works like if i authenticates with iwam_machine.
>
> "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> escribió en el mensaje
> news:utWbctEaEHA.2792@.TK2MSFTNGP09.phx.gbl...
> > You have to disable anonymous access for both Reports and Reportserver
> > virtual directories.
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "oli" <oli1350@.hotmail.com> wrote in message
> > news:#YUfIwBaEHA.212@.TK2MSFTNGP12.phx.gbl...
> > > I've configured the IIS with only windows authentication, when i
connect
> > to
> > > Reporting Server or Reporting Administrator uses the windows account,
> but
> > > the security rules work different:
> > > I have configured rules for two accounts: my windows account and
> > > IUSR_machine.
> > >
> > > When i try to connect to servers i put my windows account and goes ok,
> but
> > > the security rules works with the rules assigned to the iusr_machine.
> Any
> > > rule assigned to my user doesn't have effect, and all the changes
makes
> in
> > > the IUSR_machine's rules have effect.
> > >
> > > I've configured restrict access to the iusr_machine and grant
permission
> > for
> > > my windows account. When i connect with my windows account and i try
to
> do
> > > any task that iusr_machine haven't permission, the server response me
> > that
> > > the iusr_machine haven't permmission to do it.
> > >
> > > Any idea?
> > >
> > > thank you.
> > >
> > > Oliver
> > >
> > > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> escribió en el
> > > mensaje news:OT0ifxqZEHA.212@.TK2MSFTNGP12.phx.gbl...
> > > > Usually this is because anonymous is set on the IIS web site
settings.
> > > >
> > > > --
> > > > Brian Welcker
> > > > Group Program Manager
> > > > SQL Server Reporting Services
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > > "oli" <oli1350@.hotmail.com> wrote in message
> > > > news:eHPoJtZZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> > > > > Hi,
> > > > > I'm having problem with the authentication in reports. When a
> user
> > > sign
> > > > > in to Report Administrator or Report Server validates with the
IIS'
> > > > > configuration. Onces inside always use the same user with the
rules
> > > > > security: IWAM_machine.
> > > > > I need the account used inside of Reporting Server/Reporting
> > > > > Administration
> > > > > should be the same that the account used to validates with IIS.
> > > > >
> > > > > It's possible'
> > > > >
> > > > > Thank you in advanced.
> > > > >
> > > > > Oliver
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
Friday, March 9, 2012
Problem: Sending SQL mail from SQL Server 2000 and outlook 2003
Hi there.
In our server, the following has been set up.
- SMTP server using IIS.
- SQL Server 2000 SP4
- Outlook 2003
My goal is to send SQLMAil with the above configuration. I have
followed this article to set up the MAPI profile.
http://support.microsoft.com/default...263556&sd=tech
I've made sure that I used the SQL-Server service account to set up the
MAPI profile. I can send email through the outlook 2003 via this MAPI
profile without any problem.
According to the following article, I need to run keep outlook 2003
runing at the server.
http://support.microsoft.com/default...;en-us;Q315886
This is the point that I don't understand. If I have SQL Server 2000
service running, I can't start Outlook 2003 because it complains
"Unable to open your default e-amil folders. The file
"[path-to-my-pst-file]" is in use and could not be accessed". In order
for me to start outlook 2003, I have to stop SQL Server service first.
After I start Outlook 2003, I can then restart SQL Server service
again. That's fine. The problem occurs when I run xp_sendmail to send
an email. It returns the following message.
SQL Mail session started.
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x8004011d
On the other hand, if I run SQL Server 2000 service without outlook
2003 running, I can use xp_sendmail to send email without the above
error message. It returns "Mail sent". The problem is that the email
never arrives.
Do you have any idea how I can solve this problem?
Thanks
Dominic
Hi
If possible I would try and install an Outlook 2000 client or use XP_SMTP
http://www.sqldev.net/xp/xpsmtp.htm.
John
"domtam@.hotmail.com" wrote:
> Hi there.
> In our server, the following has been set up.
> - SMTP server using IIS.
> - SQL Server 2000 SP4
> - Outlook 2003
> My goal is to send SQLMAil with the above configuration. I have
> followed this article to set up the MAPI profile.
> http://support.microsoft.com/default...263556&sd=tech
> I've made sure that I used the SQL-Server service account to set up the
> MAPI profile. I can send email through the outlook 2003 via this MAPI
> profile without any problem.
> According to the following article, I need to run keep outlook 2003
> runing at the server.
> http://support.microsoft.com/default...;en-us;Q315886
> This is the point that I don't understand. If I have SQL Server 2000
> service running, I can't start Outlook 2003 because it complains
> "Unable to open your default e-amil folders. The file
> "[path-to-my-pst-file]" is in use and could not be accessed". In order
> for me to start outlook 2003, I have to stop SQL Server service first.
> After I start Outlook 2003, I can then restart SQL Server service
> again. That's fine. The problem occurs when I run xp_sendmail to send
> an email. It returns the following message.
> SQL Mail session started.
> Server: Msg 18025, Level 16, State 1, Line 0
> xp_sendmail: failed with mail error 0x8004011d
>
> On the other hand, if I run SQL Server 2000 service without outlook
> 2003 running, I can use xp_sendmail to send email without the above
> error message. It returns "Mail sent". The problem is that the email
> never arrives.
> Do you have any idea how I can solve this problem?
> Thanks
> Dominic
>
|||I am using Outlook 2000, so I don't know if this helps.
Usually when I get "xp_sendmail: failed with mail error 0x8004011d"
it's because the pst file is locked by Outlook.
To make changes to the outlook configuration, I stop SQL Server, Open
Outlook and make the changes in there. Afterwards, I close outlook and
open restart SQLServer. If I forget to close outlook, I get this error.
|||Thanks. After "downgrading" to outlook 2000, it works as expected.
|||I have same problem .
as when I was sent mail through sql, it gives error:
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x8004011d
url:http://ureader.com/msg/11605151.aspx
In our server, the following has been set up.
- SMTP server using IIS.
- SQL Server 2000 SP4
- Outlook 2003
My goal is to send SQLMAil with the above configuration. I have
followed this article to set up the MAPI profile.
http://support.microsoft.com/default...263556&sd=tech
I've made sure that I used the SQL-Server service account to set up the
MAPI profile. I can send email through the outlook 2003 via this MAPI
profile without any problem.
According to the following article, I need to run keep outlook 2003
runing at the server.
http://support.microsoft.com/default...;en-us;Q315886
This is the point that I don't understand. If I have SQL Server 2000
service running, I can't start Outlook 2003 because it complains
"Unable to open your default e-amil folders. The file
"[path-to-my-pst-file]" is in use and could not be accessed". In order
for me to start outlook 2003, I have to stop SQL Server service first.
After I start Outlook 2003, I can then restart SQL Server service
again. That's fine. The problem occurs when I run xp_sendmail to send
an email. It returns the following message.
SQL Mail session started.
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x8004011d
On the other hand, if I run SQL Server 2000 service without outlook
2003 running, I can use xp_sendmail to send email without the above
error message. It returns "Mail sent". The problem is that the email
never arrives.
Do you have any idea how I can solve this problem?
Thanks
Dominic
Hi
If possible I would try and install an Outlook 2000 client or use XP_SMTP
http://www.sqldev.net/xp/xpsmtp.htm.
John
"domtam@.hotmail.com" wrote:
> Hi there.
> In our server, the following has been set up.
> - SMTP server using IIS.
> - SQL Server 2000 SP4
> - Outlook 2003
> My goal is to send SQLMAil with the above configuration. I have
> followed this article to set up the MAPI profile.
> http://support.microsoft.com/default...263556&sd=tech
> I've made sure that I used the SQL-Server service account to set up the
> MAPI profile. I can send email through the outlook 2003 via this MAPI
> profile without any problem.
> According to the following article, I need to run keep outlook 2003
> runing at the server.
> http://support.microsoft.com/default...;en-us;Q315886
> This is the point that I don't understand. If I have SQL Server 2000
> service running, I can't start Outlook 2003 because it complains
> "Unable to open your default e-amil folders. The file
> "[path-to-my-pst-file]" is in use and could not be accessed". In order
> for me to start outlook 2003, I have to stop SQL Server service first.
> After I start Outlook 2003, I can then restart SQL Server service
> again. That's fine. The problem occurs when I run xp_sendmail to send
> an email. It returns the following message.
> SQL Mail session started.
> Server: Msg 18025, Level 16, State 1, Line 0
> xp_sendmail: failed with mail error 0x8004011d
>
> On the other hand, if I run SQL Server 2000 service without outlook
> 2003 running, I can use xp_sendmail to send email without the above
> error message. It returns "Mail sent". The problem is that the email
> never arrives.
> Do you have any idea how I can solve this problem?
> Thanks
> Dominic
>
|||I am using Outlook 2000, so I don't know if this helps.
Usually when I get "xp_sendmail: failed with mail error 0x8004011d"
it's because the pst file is locked by Outlook.
To make changes to the outlook configuration, I stop SQL Server, Open
Outlook and make the changes in there. Afterwards, I close outlook and
open restart SQLServer. If I forget to close outlook, I get this error.
|||Thanks. After "downgrading" to outlook 2000, it works as expected.
|||I have same problem .
as when I was sent mail through sql, it gives error:
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x8004011d
url:http://ureader.com/msg/11605151.aspx
Problem: Sending SQL mail from SQL Server 2000 and outlook 2003
Hi there.
In our server, the following has been set up.
- SMTP server using IIS.
- SQL Server 2000 SP4
- Outlook 2003
My goal is to send SQLMAil with the above configuration. I have
followed this article to set up the MAPI profile.
http://support.microsoft.com/defaul...;263556&sd=tech
I've made sure that I used the SQL-Server service account to set up the
MAPI profile. I can send email through the outlook 2003 via this MAPI
profile without any problem.
According to the following article, I need to run keep outlook 2003
runing at the server.
http://support.microsoft.com/defaul...b;en-us;Q315886
This is the point that I don't understand. If I have SQL Server 2000
service running, I can't start Outlook 2003 because it complains
"Unable to open your default e-amil folders. The file
"[path-to-my-pst-file]" is in use and could not be accessed". In order
for me to start outlook 2003, I have to stop SQL Server service first.
After I start Outlook 2003, I can then restart SQL Server service
again. That's fine. The problem occurs when I run xp_sendmail to send
an email. It returns the following message.
SQL Mail session started.
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x8004011d
On the other hand, if I run SQL Server 2000 service without outlook
2003 running, I can use xp_sendmail to send email without the above
error message. It returns "Mail sent". The problem is that the email
never arrives.
Do you have any idea how I can solve this problem?
Thanks
DominicHi
If possible I would try and install an Outlook 2000 client or use XP_SMTP
http://www.sqldev.net/xp/xpsmtp.htm.
John
"domtam@.hotmail.com" wrote:
> Hi there.
> In our server, the following has been set up.
> - SMTP server using IIS.
> - SQL Server 2000 SP4
> - Outlook 2003
> My goal is to send SQLMAil with the above configuration. I have
> followed this article to set up the MAPI profile.
> http://support.microsoft.com/defaul...;263556&sd=tech
> I've made sure that I used the SQL-Server service account to set up the
> MAPI profile. I can send email through the outlook 2003 via this MAPI
> profile without any problem.
> According to the following article, I need to run keep outlook 2003
> runing at the server.
> http://support.microsoft.com/defaul...b;en-us;Q315886
> This is the point that I don't understand. If I have SQL Server 2000
> service running, I can't start Outlook 2003 because it complains
> "Unable to open your default e-amil folders. The file
> "[path-to-my-pst-file]" is in use and could not be accessed". In orde
r
> for me to start outlook 2003, I have to stop SQL Server service first.
> After I start Outlook 2003, I can then restart SQL Server service
> again. That's fine. The problem occurs when I run xp_sendmail to send
> an email. It returns the following message.
> SQL Mail session started.
> Server: Msg 18025, Level 16, State 1, Line 0
> xp_sendmail: failed with mail error 0x8004011d
>
> On the other hand, if I run SQL Server 2000 service without outlook
> 2003 running, I can use xp_sendmail to send email without the above
> error message. It returns "Mail sent". The problem is that the email
> never arrives.
> Do you have any idea how I can solve this problem?
> Thanks
> Dominic
>|||I am using Outlook 2000, so I don't know if this helps.
Usually when I get "xp_sendmail: failed with mail error 0x8004011d"
it's because the pst file is locked by Outlook.
To make changes to the outlook configuration, I stop SQL Server, Open
Outlook and make the changes in there. Afterwards, I close outlook and
open restart SQLServer. If I forget to close outlook, I get this error.|||Thanks. After "downgrading" to outlook 2000, it works as expected.|||I have same problem .
as when I was sent mail through sql, it gives error:
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x8004011d
url:http://ureader.com/msg/11605151.aspx
In our server, the following has been set up.
- SMTP server using IIS.
- SQL Server 2000 SP4
- Outlook 2003
My goal is to send SQLMAil with the above configuration. I have
followed this article to set up the MAPI profile.
http://support.microsoft.com/defaul...;263556&sd=tech
I've made sure that I used the SQL-Server service account to set up the
MAPI profile. I can send email through the outlook 2003 via this MAPI
profile without any problem.
According to the following article, I need to run keep outlook 2003
runing at the server.
http://support.microsoft.com/defaul...b;en-us;Q315886
This is the point that I don't understand. If I have SQL Server 2000
service running, I can't start Outlook 2003 because it complains
"Unable to open your default e-amil folders. The file
"[path-to-my-pst-file]" is in use and could not be accessed". In order
for me to start outlook 2003, I have to stop SQL Server service first.
After I start Outlook 2003, I can then restart SQL Server service
again. That's fine. The problem occurs when I run xp_sendmail to send
an email. It returns the following message.
SQL Mail session started.
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x8004011d
On the other hand, if I run SQL Server 2000 service without outlook
2003 running, I can use xp_sendmail to send email without the above
error message. It returns "Mail sent". The problem is that the email
never arrives.
Do you have any idea how I can solve this problem?
Thanks
DominicHi
If possible I would try and install an Outlook 2000 client or use XP_SMTP
http://www.sqldev.net/xp/xpsmtp.htm.
John
"domtam@.hotmail.com" wrote:
> Hi there.
> In our server, the following has been set up.
> - SMTP server using IIS.
> - SQL Server 2000 SP4
> - Outlook 2003
> My goal is to send SQLMAil with the above configuration. I have
> followed this article to set up the MAPI profile.
> http://support.microsoft.com/defaul...;263556&sd=tech
> I've made sure that I used the SQL-Server service account to set up the
> MAPI profile. I can send email through the outlook 2003 via this MAPI
> profile without any problem.
> According to the following article, I need to run keep outlook 2003
> runing at the server.
> http://support.microsoft.com/defaul...b;en-us;Q315886
> This is the point that I don't understand. If I have SQL Server 2000
> service running, I can't start Outlook 2003 because it complains
> "Unable to open your default e-amil folders. The file
> "[path-to-my-pst-file]" is in use and could not be accessed". In orde
r
> for me to start outlook 2003, I have to stop SQL Server service first.
> After I start Outlook 2003, I can then restart SQL Server service
> again. That's fine. The problem occurs when I run xp_sendmail to send
> an email. It returns the following message.
> SQL Mail session started.
> Server: Msg 18025, Level 16, State 1, Line 0
> xp_sendmail: failed with mail error 0x8004011d
>
> On the other hand, if I run SQL Server 2000 service without outlook
> 2003 running, I can use xp_sendmail to send email without the above
> error message. It returns "Mail sent". The problem is that the email
> never arrives.
> Do you have any idea how I can solve this problem?
> Thanks
> Dominic
>|||I am using Outlook 2000, so I don't know if this helps.
Usually when I get "xp_sendmail: failed with mail error 0x8004011d"
it's because the pst file is locked by Outlook.
To make changes to the outlook configuration, I stop SQL Server, Open
Outlook and make the changes in there. Afterwards, I close outlook and
open restart SQLServer. If I forget to close outlook, I get this error.|||Thanks. After "downgrading" to outlook 2000, it works as expected.|||I have same problem .
as when I was sent mail through sql, it gives error:
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x8004011d
url:http://ureader.com/msg/11605151.aspx
Problem: Sending SQL mail from SQL Server 2000 and outlook 2003
Hi there.
In our server, the following has been set up.
- SMTP server using IIS.
- SQL Server 2000 SP4
- Outlook 2003
My goal is to send SQLMAil with the above configuration. I have
followed this article to set up the MAPI profile.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556&sd=tech
I've made sure that I used the SQL-Server service account to set up the
MAPI profile. I can send email through the outlook 2003 via this MAPI
profile without any problem.
According to the following article, I need to run keep outlook 2003
runing at the server.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886
This is the point that I don't understand. If I have SQL Server 2000
service running, I can't start Outlook 2003 because it complains
"Unable to open your default e-amil folders. The file
"[path-to-my-pst-file]" is in use and could not be accessed". In order
for me to start outlook 2003, I have to stop SQL Server service first.
After I start Outlook 2003, I can then restart SQL Server service
again. That's fine. The problem occurs when I run xp_sendmail to send
an email. It returns the following message.
SQL Mail session started.
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x8004011d
On the other hand, if I run SQL Server 2000 service without outlook
2003 running, I can use xp_sendmail to send email without the above
error message. It returns "Mail sent". The problem is that the email
never arrives.
Do you have any idea how I can solve this problem?
Thanks
DominicHi
If possible I would try and install an Outlook 2000 client or use XP_SMTP
http://www.sqldev.net/xp/xpsmtp.htm.
John
"domtam@.hotmail.com" wrote:
> Hi there.
> In our server, the following has been set up.
> - SMTP server using IIS.
> - SQL Server 2000 SP4
> - Outlook 2003
> My goal is to send SQLMAil with the above configuration. I have
> followed this article to set up the MAPI profile.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;263556&sd=tech
> I've made sure that I used the SQL-Server service account to set up the
> MAPI profile. I can send email through the outlook 2003 via this MAPI
> profile without any problem.
> According to the following article, I need to run keep outlook 2003
> runing at the server.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886
> This is the point that I don't understand. If I have SQL Server 2000
> service running, I can't start Outlook 2003 because it complains
> "Unable to open your default e-amil folders. The file
> "[path-to-my-pst-file]" is in use and could not be accessed". In order
> for me to start outlook 2003, I have to stop SQL Server service first.
> After I start Outlook 2003, I can then restart SQL Server service
> again. That's fine. The problem occurs when I run xp_sendmail to send
> an email. It returns the following message.
> SQL Mail session started.
> Server: Msg 18025, Level 16, State 1, Line 0
> xp_sendmail: failed with mail error 0x8004011d
>
> On the other hand, if I run SQL Server 2000 service without outlook
> 2003 running, I can use xp_sendmail to send email without the above
> error message. It returns "Mail sent". The problem is that the email
> never arrives.
> Do you have any idea how I can solve this problem?
> Thanks
> Dominic
>|||I am using Outlook 2000, so I don't know if this helps.
Usually when I get "xp_sendmail: failed with mail error 0x8004011d"
it's because the pst file is locked by Outlook.
To make changes to the outlook configuration, I stop SQL Server, Open
Outlook and make the changes in there. Afterwards, I close outlook and
open restart SQLServer. If I forget to close outlook, I get this error.|||Thanks. After "downgrading" to outlook 2000, it works as expected.
In our server, the following has been set up.
- SMTP server using IIS.
- SQL Server 2000 SP4
- Outlook 2003
My goal is to send SQLMAil with the above configuration. I have
followed this article to set up the MAPI profile.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556&sd=tech
I've made sure that I used the SQL-Server service account to set up the
MAPI profile. I can send email through the outlook 2003 via this MAPI
profile without any problem.
According to the following article, I need to run keep outlook 2003
runing at the server.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886
This is the point that I don't understand. If I have SQL Server 2000
service running, I can't start Outlook 2003 because it complains
"Unable to open your default e-amil folders. The file
"[path-to-my-pst-file]" is in use and could not be accessed". In order
for me to start outlook 2003, I have to stop SQL Server service first.
After I start Outlook 2003, I can then restart SQL Server service
again. That's fine. The problem occurs when I run xp_sendmail to send
an email. It returns the following message.
SQL Mail session started.
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x8004011d
On the other hand, if I run SQL Server 2000 service without outlook
2003 running, I can use xp_sendmail to send email without the above
error message. It returns "Mail sent". The problem is that the email
never arrives.
Do you have any idea how I can solve this problem?
Thanks
DominicHi
If possible I would try and install an Outlook 2000 client or use XP_SMTP
http://www.sqldev.net/xp/xpsmtp.htm.
John
"domtam@.hotmail.com" wrote:
> Hi there.
> In our server, the following has been set up.
> - SMTP server using IIS.
> - SQL Server 2000 SP4
> - Outlook 2003
> My goal is to send SQLMAil with the above configuration. I have
> followed this article to set up the MAPI profile.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;263556&sd=tech
> I've made sure that I used the SQL-Server service account to set up the
> MAPI profile. I can send email through the outlook 2003 via this MAPI
> profile without any problem.
> According to the following article, I need to run keep outlook 2003
> runing at the server.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886
> This is the point that I don't understand. If I have SQL Server 2000
> service running, I can't start Outlook 2003 because it complains
> "Unable to open your default e-amil folders. The file
> "[path-to-my-pst-file]" is in use and could not be accessed". In order
> for me to start outlook 2003, I have to stop SQL Server service first.
> After I start Outlook 2003, I can then restart SQL Server service
> again. That's fine. The problem occurs when I run xp_sendmail to send
> an email. It returns the following message.
> SQL Mail session started.
> Server: Msg 18025, Level 16, State 1, Line 0
> xp_sendmail: failed with mail error 0x8004011d
>
> On the other hand, if I run SQL Server 2000 service without outlook
> 2003 running, I can use xp_sendmail to send email without the above
> error message. It returns "Mail sent". The problem is that the email
> never arrives.
> Do you have any idea how I can solve this problem?
> Thanks
> Dominic
>|||I am using Outlook 2000, so I don't know if this helps.
Usually when I get "xp_sendmail: failed with mail error 0x8004011d"
it's because the pst file is locked by Outlook.
To make changes to the outlook configuration, I stop SQL Server, Open
Outlook and make the changes in there. Afterwards, I close outlook and
open restart SQLServer. If I forget to close outlook, I get this error.|||Thanks. After "downgrading" to outlook 2000, it works as expected.
Monday, February 20, 2012
problem with url in microsoft server 2005
Hi,
I have a problem:
I have a problem:
When i enter in the iis i have two virtual directory:
Reportsr$sqlexpress
ReportServer$sqlexpress
I try to run the report by browsing home.aspx and going to my
report.The url that i got is:
http://localhost/Reports$SQLExpress/Pages/Report.aspx?ItemPath=%2fReportInventory%2fReportTotalCounting
Now, i enter the parameter wanted and click on export to pdf file
it works fine :it opens the report in a pdf file ,i got a url like
this:
http://localhost/Reports$SQLExpress/Reserved.ReportViewerWebControl.axd?ReportSession=a52f1o55wy00wq454pq0jp45&ControlID=f8672382-3d09-430f-a308-9bf42b850184&Culture=1037&UICulture=9&ReportStack=1&OpType=Export&FileName=ReportTotalCounting&ContentDisposition=OnlyHtmlInline&Format=PDF
but the probem is that i think the url is encrript because i don't see the parameters i entered in that url!
what i would like to have is an url like this:
http://localhost/Reports$SQLExpress?%2fReportInventory%2fReportTotalCounting&Parameter_WarehouseID=12&rs%3aCommand=Render&rs%3AFormat=PDF
but this url doesn't work it return me to the url:
http://localhost/Reports$SQLExpress/Pages/Folder.aspx
how can i have a url that work fine so i can pass the paramerter(a url not encript)?
is there somewere where i have to set if the url is encript or not?
help me please why the url does'nt work?
thanks in advance
The Report Manager virtual directory does not have a URL access interface. If you wish to pass parameters and other directives via URL, you must use the Report Server virtual directory:
http://localhost/ReportServer$SQLExpress/Pages/ReportViewer.aspx?%2fReport1&rs%3aCommand=Render
|||You can pass the parameter in url by accessing the report server. Try http://localhost/ReportServer$sqlexpress/... instead.
http://msdn2.microsoft.com/en-us/library/aa256630(SQL.80).aspx
Subscribe to:
Posts (Atom)