error handling flow: login

Showing posts with label login. Show all posts

Thursday, March 22, 2012

Error in user permission

Hi,
I have a user 'AAA' who has NT Login to a database db1 on a test machine
running SQL Server 2000. I recently restored a database db2 from Production
machine to the test machine and I will call this db2_test. The production
machine didn't have the login 'AAA" set up.
Now after the restoration of db2_test I still see user 'AAA' in the list of
users and I am not able to drop it so that I can give permissions to 'AAA'
login for this restored database under the Security tab in Enterprise Manager.
I have tried running the Stored Procedure sp_change_users_login but it
didn't help.
sharman,
I don't think I understand your description. Could you do the following
please and share the results:
use master
exec sp_helplogins 'AAA'
use db1
exec sp_helpuser 'AAA'
use db2_test
exec sp_helpuser 'AAA'
Do the SIDs all match? Do the sp_helpuser LoginNames match each other? Etc.
RLF
sql

Error in user permission

Hi,
I have a user 'AAA' who has NT Login to a database db1 on a test machine
running SQL Server 2000. I recently restored a database db2 from Production
machine to the test machine and I will call this db2_test. The production
machine didn't have the login 'AAA" set up.
Now after the restoration of db2_test I still see user 'AAA' in the list of
users and I am not able to drop it so that I can give permissions to 'AAA'
login for this restored database under the Security tab in Enterprise Manager.
I have tried running the Stored Procedure sp_change_users_login but it
didn't help.sharman,
I don't think I understand your description. Could you do the following
please and share the results:
use master
exec sp_helplogins 'AAA'
use db1
exec sp_helpuser 'AAA'
use db2_test
exec sp_helpuser 'AAA'
Do the SIDs all match? Do the sp_helpuser LoginNames match each other? Etc.
RLF

Error in the login process when establishing connection

Hello,
I am trying to connect to a database through a web service. I am being able to connect to the databse through the server explorer in Visual Studio 2005, but when I try to do it with code in my application this is the message I get:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
My code looks like this:

SqlConnection thisConnection = new SqlConnection(@."Data Source=vse1092;Initial Catalog=CurrituckDB;Integrated Security=True;"); //User id=;Password=;");
thisConnection.Open();
I also tried putting my user id and password... but same message appears.
Any help will be greatly appreciated.
Thanks,
David
Do you have the upto date SQL server express, the one that corresponds with the version of Visual Studio
|||Try with VS.NET 2003|||Also, you can try looking in the server error log (by default at "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG") for an error message that might be more informative. Look for messages that correspond in time to the failed login attempts when you run the client application.

Hope this helps,
Vaughn|||Hi,
I faced a similar issue few days back. The issue was solved when I removed the Windows 2003 Service pack1 from my system. Try removing the service pack. If U have it installed or try removing security updates that U've recently installed.

By the way, are U able to connect to the database using the management studio ot enterprise manageer?|||In addition, please check out the SQL Protocols Blog (http://blogs.msdn.com/sql_protocols/) which contains a troubleshooting connectivity series.|||Hmmm... The best way to figure this out is by looking through the error log (as Vaughn suggested). If we had a bit more information about your configuration we could probably conjecture a bit more here.
One place we've seen this happen before is when the client stacks (in your case SQLClient) and the server are mismatched intermediate versions - for example, .Net Framework 2.0 beta 2 running against SQL Server 2005 beta 2. If you have mismatched intermediate releases, you'd see something like this.

There are other reasons you might see this. There's a swath of blogs up on http://blogs.msdn.com/sql_protocols that might have the answer your looking for.

Thanks.sql

Error in the login process when establishing connection

Hello,
I am trying to connect to a database through a web service. I am being able to connect to the databse through the server explorer in Visual Studio 2005, but when I try to do it with code in my application this is the message I get:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
My code looks like this:

SqlConnection thisConnection = new SqlConnection(@."Data Source=vse1092;Initial Catalog=CurrituckDB;Integrated Security=True;"); //User id=;Password=;");
thisConnection.Open();
I also tried putting my user id and password... but same message appears.
Any help will be greatly appreciated.
Thanks,
David
Do you have the upto date SQL server express, the one that corresponds with the version of Visual Studio|||Try with VS.NET 2003|||Also, you can try looking in the server error log (by default at "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG") for an error message that might be more informative. Look for messages that correspond in time to the failed login attempts when you run the client application.

There are other reasons you might see this. There's a swath of blogs up on http://blogs.msdn.com/sql_protocols that might have the answer your looking for.

Thanks.

Wednesday, March 21, 2012

Error in SQL startup

Hi guys,

I have an SQL Server 2000 installed on a Windows server 2003. Yesterday, i restart my server and before login to the server the following message poped-up:

"Your SQL Server installation is either corrupt or has been tampered with (unable to load SQLBOOT.DLL). Please uninstall, then re-run setup to correct this problem"

Any ideas what this error is or why occurred?
Any help will be appreciated.

have u checked the sqllog and application log.. post the error from Log. its looks like the REGISTRY/system drive got corrupted/ or master file corrupted... what all are the backup u have. Do u have system dbs backups ?...

Madhu

|||

There are no errors in the event viewer regarding the error i tild you above. There is only the 19012 error which has to do something with the TCP port.

Any other ideas what this error should be?

|||Please post the sql log here. It would help us help you pinpoint the problem. The sqlboot error simply means the service doesn't get all the resources it needs to start up. A re-install typically will fix this.|||

generally this might be the log file path. C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG . Open the ERRORLOG file and paste the contents here

Madhu

Monday, March 19, 2012

Error in Report Server Registration

TITLE: New Server Registration

Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.

The request failed with the error message:

<html>

<head>

<title>

SQL Server Reporting Services

</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />

at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)

at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)

at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)

at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()

at Microsoft.ReportingServices.WebServer.Global.StartApp()

at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />

<style>

BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}

H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}

LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}

.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}

A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}

A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}

A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}

A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

</style>

</head><body bgcolor="white">

<h1>

Reporting Services Error<hr width="100%" size="1" color="silver" />

</h1><ul>

<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>

<li>Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>

</ul>

</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>

</body>

</html>

--. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

Do you have permissions to the path listed in the error messages? And does the log file listed give any more info?

<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li>

<li>Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>

Thanks,
Sam Lester (MSFT)

|||

I added http://localhost to Trusted Sites as recommended elsewhere.

Log On As is set to NT AUTHORITY\NetworkService

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>Alaskan Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerService__09_01_2006_10_58_14.log</Path>
<SystemName>DTC0900B6FAD685</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!configmanager!4!9/1/2006-10:58:15:: w WARN: WebServiceAccount is not specified in the config file. Using default: DTC0900B6FAD685\ASPNET
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!resourceutilities!4!9/1/2006-10:58:15:: i INFO: Reporting Services starting SKU: Express
ReportingServicesService!resourceutilities!4!9/1/2006-10:58:15:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!resourceutilities!4!9/1/2006-10:58:15:: i INFO: Running on 1 physical processors, 1 logical processors
ReportingServicesService!runningjobs!4!9/1/2006-10:58:15:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
ReportingServicesService!runningjobs!4!9/1/2006-10:58:15:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!9/1/2006-10:58:15:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!9/1/2006-10:58:15:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 54104 seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!4!9/1/2006-10:58:15:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!9/1/2006-10:58:15:: i INFO: SQM timer timer enabled: Next Event: 57704 seconds. Cycle: 86400 seconds
ReportingServicesService!library!8!9/1/2006-10:58:17:: i INFO: Catalog SQL Server Edition = Express
ReportingServicesService!crypto!8!9/1/2006-10:58:18:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
ReportingServicesService!crypto!8!9/1/2006-10:58:18:: i INFO: Exporting public key
ReportingServicesService!crypto!8!9/1/2006-10:58:18:: i INFO: Performing sku validation
ReportingServicesService!crypto!8!9/1/2006-10:58:18:: i INFO: Importing existing encryption key
ReportingServicesService!configmanager!8!9/1/2006-10:58:18:: w WARN: Restricted feature: Scheduling
ReportingServicesService!configmanager!8!9/1/2006-10:58:18:: w WARN: Restricted feature: Delivery
ReportingServicesService!configmanager!8!9/1/2006-10:58:18:: w WARN: Restricted feature: Scheduling
ReportingServicesService!dbpolling!8!09/01/2006-10:58:18:: UpgradePolling polling service started
ReportingServicesService!dbpolling!a!9/1/2006-10:58:18:: Polling started

Here is the other log file:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>Alaskan Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerService__main_09_01_2006_09_56_29.log</Path>
<SystemName>DTC0900B6FAD685</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!configmanager!4!9/1/2006-09:56:35:: w WARN: WebServiceAccount is not specified in the config file. Using default: DTC0900B6FAD685\ASPNET
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!servicecontroller!9!9/1/2006-09:56:37:: Total Physical memory: 535707648
ReportingServicesService!servicecontroller!4!9/1/2006-09:56:37:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSSQL.3'

|||I had to load the express version with advanced stuff and now it is working . Thanks for your response.

Error in Report Server Registration

TITLE: New Server Registration

Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.

The request failed with the error message:

<html>

<head>

<title>

SQL Server Reporting Services

</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />

at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)

at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)

at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)

at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()

at Microsoft.ReportingServices.WebServer.Global.StartApp()

at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />

<style>

BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}

H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}

LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}

.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}

A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}

A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}

A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}

A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

</style>

</head><body bgcolor="white">

<h1>

Reporting Services Error<hr width="100%" size="1" color="silver" />

</h1><ul>

<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>

<li>Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>

</ul>

</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>

</body>

</html>

--. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

Do you have permissions to the path listed in the error messages? And does the log file listed give any more info?

<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li>

<li>Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>

Thanks,
Sam Lester (MSFT)

|||

I added http://localhost to Trusted Sites as recommended elsewhere.

Log On As is set to NT AUTHORITY\NetworkService

Here is the other log file:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>Alaskan Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerService__main_09_01_2006_09_56_29.log</Path>
<SystemName>DTC0900B6FAD685</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!configmanager!4!9/1/2006-09:56:35:: w WARN: WebServiceAccount is not specified in the config file. Using default: DTC0900B6FAD685\ASPNET
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!servicecontroller!9!9/1/2006-09:56:37:: Total Physical memory: 535707648
ReportingServicesService!servicecontroller!4!9/1/2006-09:56:37:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSSQL.3'

|||I had to load the express version with advanced stuff and now it is working . Thanks for your response.

Friday, March 9, 2012

Error in login connections during an automatic failover in a database mirroring session

We are experiencing error in login connections during an automatic failover
in a database mirroring session. Anyone who has had similar problem that can
send suggestions/ideas greatly appretiated!
Thank youHello Dev,
From your description, my understanding of this issue is: You setup a
database mirroring on SQL 2005 SP1. After a failover, the application could
not connect to the server and you get a login error. If I misunderstood
your concern, please feel free to let me know.
Based on my research, it was a by design issue in SQL Server 2005.
The main cause of this issue is because incorrect security settings on
mirror server prevents client from the connection. In this scenario new
login on mirror server should be created with the same SID as login on
primary server. Once it's done - everything should work as charm.
I would like to provide the following article to successfully transfer
Users including their SIDS
to the Mirror when setting up SQL:
918992 How to transfer the logins and the passwords between instances of
SQL Server
2005
http://support.microsoft.com/default.aspx?scid=kb;EN-US;918992
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,
Just want to say Hi, and I was wondering how everything is going. If
anything is unclear, please let me know. It is my pleasure to be of
assistance.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Wei Lu:
This is not my original thread, but I am running into the same issue. I
have the same application login on my principal and mirror servers. When
failover to the mirror occurs, the login seems to lose its credentials. I
was thinking this was something to do with the SID. I am not that familiar
with SIDs. Can you point me in the right direction on how to make sure the
login has the same SID on both servers please?
Thank you in advance.
"Wei Lu [MSFT]" wrote:
> Hi,
> Just want to say Hi, and I was wondering how everything is going. If
> anything is unclear, please let me know. It is my pleasure to be of
> assistance.
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> =====================================================> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>

Error in login connections during an automatic failover in a database mirroring session

We are experiencing error in login connections during an automatic failover
in a database mirroring session. Anyone who has had similar problem that can
send suggestions/ideas greatly appretiated!
Thank you
Hello Dev,
From your description, my understanding of this issue is: You setup a
database mirroring on SQL 2005 SP1. After a failover, the application could
not connect to the server and you get a login error. If I misunderstood
your concern, please feel free to let me know.
Based on my research, it was a by design issue in SQL Server 2005.
The main cause of this issue is because incorrect security settings on
mirror server prevents client from the connection. In this scenario new
login on mirror server should be created with the same SID as login on
primary server. Once it's done - everything should work as charm.
I would like to provide the following article to successfully transfer
Users including their SIDS
to the Mirror when setting up SQL:
918992How to transfer the logins and the passwords between instances of
SQL Server
2005
http://support.microsoft.com/default.aspx?scid=kb;EN-US;918992
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,
Just want to say Hi, and I was wondering how everything is going. If
anything is unclear, please let me know. It is my pleasure to be of
assistance.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
================================================== ===
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
================================================== ====
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Wei Lu:
This is not my original thread, but I am running into the same issue. I
have the same application login on my principal and mirror servers. When
failover to the mirror occurs, the login seems to lose its credentials. I
was thinking this was something to do with the SID. I am not that familiar
with SIDs. Can you point me in the right direction on how to make sure the
login has the same SID on both servers please?
Thank you in advance.
"Wei Lu [MSFT]" wrote:

> Hi,
> Just want to say Hi, and I was wondering how everything is going. If
> anything is unclear, please let me know. It is my pleasure to be of
> assistance.
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> ================================================== ===
> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ================================================== ====
> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== ====
>

Wednesday, February 15, 2012

Error handling in SSIS

How do I handle error login login and output using SSIS? Is there any step-by-step tutorial on this error hanlding and notification topic?

Jamie has a very good explanation in his blog, refer to this.

http://blogs.conchango.com/jamiethomson/archive/2005/08/08/1969.aspx

Thursday, March 22, 2012

Error in user permission

Error in user permission

Error in the login process when establishing connection

Error in the login process when establishing connection

Wednesday, March 21, 2012

Error in SQL startup

Monday, March 19, 2012

Error in Report Server Registration

Error in Report Server Registration

Friday, March 9, 2012

Error in login connections during an automatic failover in a database mirroring session

Error in login connections during an automatic failover in a database mirroring session

Wednesday, February 15, 2012

Error handling in SSIS

error handling flow

Blog Archive

About Me