problem with loging in

I installed a default instance of Enterprise edittion and

didn't face any error during the instalation process.

In Management Studio in the Server Name section for loging in I wrote the name of the local system.

but I couldn't log in.

in

Control Panel \ administrative tools\services

there is no SQL Server service at all.

should I install any thing extra just like Express Edition which I used to install SQL Express in Visual Studio 2005 pakage or like MSDE in SQL Server 2000?

please tell me what to do

thanks.

pooyan

Hello,

It would seem that the core dbms has not been installed correctly - did you perhaps only select client tools during the install?

Reinstall the server components (make sure you run setup from the server, not tools folder).

Cheers,

Rob

Problem with logging/System::ErrorDescription variable

Hi,

I've come up against a problem in my error handling.

I have a package-level OnError handler which is a SQL Execute task. The SQL execute task constructs a SqlStatementSource expression to insert the error details into a table. This works fine and I've tested it by introducing various errors in the package.

I have another SQL Execute task, which executes a SQL script from a file connection. This is a very long script (100s of lines) and works fine. I introduced a deliberate error into it and got the following errors:

Error: The variable System::ErrorDescription contains a string that exceeds the maximum allowed length of 4000 characters.
Error: Reading the variable "System::ErrorDescription" failed with error code 0xC0047100.
Error: The expression <expression> on property "SqlStatementSource" cannot be evaluated. Modify the expression to be valid.

The problem is obviously the length of the script, since SSIS attempts to copy all of it into the ErrorDescription, but this seems to occur before I can do anything about it. I've tried putting a SUBSTRING function around the ErrorDescription variable without success. If I introduce an error into a shorter script the error handling works fine.

Is this a bug in SSIS? Is there any sort of workround that anybody knows of?

thanks
- Jerzy

It sounds like it could be a bug. It needs validating by someone from the SSIS dev team but unfortunately they don't seem to appear on here as much as they used to.

Try logging it at the feedback center with repro steps: http://lab.msdn.microsoft.com/productfeedback/default.aspx

-Jamie

|||Thanks. I've done that. Bug ID FDBK45894

- Jerzy
|||Sounds a bit funny, but there is a known limit of 4000 characters on expressions, so for long errors you may hit this. The other issue you can hit is that the message may contain single or double quotes. Best case, it fails, worst case you have a SQL injection attack. For this reason alone I'd say just use a stored procedure, and the built in parameter support. The ErrorDescription variable should map to a procedure parameter, which should solve both the size limit (if that is your issue), and prevent injection.

Problem with Large data amounts

I have a dataset with 300,000 records and I'm getting the following error with MS Reporting Services. "An error has occurred during report processing. Exception of type System.OutOfMemoryException was thrown. any help with this would be highly appreciated.

Unfortunately, Reporting Services has some memory limitations in the current (SQL 2K and SQL 2K5). Because we support things like dataset aggregates (you can have sum(x) on the first page of your report), we materialize the entire dataset. Some things you might try:

Do you need the entire data set displayed in the report or could you do some grouping / aggregation in the query?|||

I am having a similar problem with large data amounts. My reporting server is a Dual Xeon 3GHz machine with 2.5GB RAM and still has issues.

What I find is that the reportviewer object is not releasing memory after the reports are generated, viewed and closed. It recycles the application several times if I try to do an export to excel.

Is there any way to be sure to dispose of the memory being allocated by the reportviewer? I can generate one report, close it, wait, open another, and the memory allocation just keeps growing and growing.

Any help is appreciated.

|||

I seem to be having a similar problem with a Xeon and 4Gig of memory. In my case, after the out of memory error happens, remote connections stop working stating that there is insufficient memory. In other words I can't even run a select statement in Management Studio after it hits the memory error. I have to restart the SQL Service.

HELP!!!

|||

First off. A human does not look at 300,000 records. Most of the time I have seen this it has been to export to Excel. When exporting to Excel export as CSV ASCII (although I don't think Excel can handle more that 64,000 records).

Note that this is with records returned, not records in the base table. I go against tables with 150 million records but I only return the data needed.

I suggest looking at design drill through reports to limit the data.

|||

Is this still a problem with Reporting Services? We are having a similar problem with .net choking on large data sets and were considering using Reporting Services as an alternative. Is Microsoft an enterprise player or not?

We are required to periodically return several hundred thousand rows from SQL Server. I'm tired of being told that is a design problem. Unfortunately when our client says he needs to print a detail report from his general ledger for his auditor we don't have the luxury of telling him Microsoft doesn't think he needs that large of a report. If he can't get the data he needs from us, he'll be happy to go down the street to get it (read Oracle).

If I can't serialize it through .net or get it out of Reporting Services, how am I supposed to extract large data sets from SQL Server?

Will 64 bit processors and multi-GB ram implementations help?

Thanks.

Problem with Large data amounts

I have a dataset with 300,000 records and I'm getting the following error with MS Reporting Services. "An error has occurred during report processing. Exception of type System.OutOfMemoryException was thrown. any help with this would be highly appreciated.

Unfortunately, Reporting Services has some memory limitations in the current (SQL 2K and SQL 2K5). Because we support things like dataset aggregates (you can have sum(x) on the first page of your report), we materialize the entire dataset. Some things you might try:

Do you need the entire data set displayed in the report or could you do some grouping / aggregation in the query?|||

I am having a similar problem with large data amounts. My reporting server is a Dual Xeon 3GHz machine with 2.5GB RAM and still has issues.

What I find is that the reportviewer object is not releasing memory after the reports are generated, viewed and closed. It recycles the application several times if I try to do an export to excel.

Is there any way to be sure to dispose of the memory being allocated by the reportviewer? I can generate one report, close it, wait, open another, and the memory allocation just keeps growing and growing.

Any help is appreciated.

|||

I seem to be having a similar problem with a Xeon and 4Gig of memory. In my case, after the out of memory error happens, remote connections stop working stating that there is insufficient memory. In other words I can't even run a select statement in Management Studio after it hits the memory error. I have to restart the SQL Service.

HELP!!!

|||

First off. A human does not look at 300,000 records. Most of the time I have seen this it has been to export to Excel. When exporting to Excel export as CSV ASCII (although I don't think Excel can handle more that 64,000 records).

Note that this is with records returned, not records in the base table. I go against tables with 150 million records but I only return the data needed.

I suggest looking at design drill through reports to limit the data.

|||

Is this still a problem with Reporting Services? We are having a similar problem with .net choking on large data sets and were considering using Reporting Services as an alternative. Is Microsoft an enterprise player or not?

We are required to periodically return several hundred thousand rows from SQL Server. I'm tired of being told that is a design problem. Unfortunately when our client says he needs to print a detail report from his general ledger for his auditor we don't have the luxury of telling him Microsoft doesn't think he needs that large of a report. If he can't get the data he needs from us, he'll be happy to go down the street to get it (read Oracle).

If I can't serialize it through .net or get it out of Reporting Services, how am I supposed to extract large data sets from SQL Server?

Will 64 bit processors and multi-GB ram implementations help?

Thanks.

sql

Problem with Large data amounts

I have a dataset with 300,000 records and I'm getting the following error with MS Reporting Services. "An error has occurred during report processing. Exception of type System.OutOfMemoryException was thrown. any help with this would be highly appreciated.

Unfortunately, Reporting Services has some memory limitations in the current (SQL 2K and SQL 2K5). Because we support things like dataset aggregates (you can have sum(x) on the first page of your report), we materialize the entire dataset. Some things you might try:

Do you need the entire data set displayed in the report or could you do some grouping / aggregation in the query?|||

I am having a similar problem with large data amounts. My reporting server is a Dual Xeon 3GHz machine with 2.5GB RAM and still has issues.

What I find is that the reportviewer object is not releasing memory after the reports are generated, viewed and closed. It recycles the application several times if I try to do an export to excel.

Is there any way to be sure to dispose of the memory being allocated by the reportviewer? I can generate one report, close it, wait, open another, and the memory allocation just keeps growing and growing.

Any help is appreciated.

|||

I seem to be having a similar problem with a Xeon and 4Gig of memory. In my case, after the out of memory error happens, remote connections stop working stating that there is insufficient memory. In other words I can't even run a select statement in Management Studio after it hits the memory error. I have to restart the SQL Service.

HELP!!!

|||

First off. A human does not look at 300,000 records. Most of the time I have seen this it has been to export to Excel. When exporting to Excel export as CSV ASCII (although I don't think Excel can handle more that 64,000 records).

Note that this is with records returned, not records in the base table. I go against tables with 150 million records but I only return the data needed.

I suggest looking at design drill through reports to limit the data.

|||

Is this still a problem with Reporting Services? We are having a similar problem with .net choking on large data sets and were considering using Reporting Services as an alternative. Is Microsoft an enterprise player or not?

We are required to periodically return several hundred thousand rows from SQL Server. I'm tired of being told that is a design problem. Unfortunately when our client says he needs to print a detail report from his general ledger for his auditor we don't have the luxury of telling him Microsoft doesn't think he needs that large of a report. If he can't get the data he needs from us, he'll be happy to go down the street to get it (read Oracle).

If I can't serialize it through .net or get it out of Reporting Services, how am I supposed to extract large data sets from SQL Server?

Will 64 bit processors and multi-GB ram implementations help?

Thanks.

Problem with Large data amounts

I have a dataset with 300,000 records and I'm getting the following error with MS Reporting Services. "An error has occurred during report processing. Exception of type System.OutOfMemoryException was thrown. any help with this would be highly appreciated.

Unfortunately, Reporting Services has some memory limitations in the current (SQL 2K and SQL 2K5). Because we support things like dataset aggregates (you can have sum(x) on the first page of your report), we materialize the entire dataset. Some things you might try:

Do you need the entire data set displayed in the report or could you do some grouping / aggregation in the query?|||

I am having a similar problem with large data amounts. My reporting server is a Dual Xeon 3GHz machine with 2.5GB RAM and still has issues.

What I find is that the reportviewer object is not releasing memory after the reports are generated, viewed and closed. It recycles the application several times if I try to do an export to excel.

Is there any way to be sure to dispose of the memory being allocated by the reportviewer? I can generate one report, close it, wait, open another, and the memory allocation just keeps growing and growing.

Any help is appreciated.

|||

I seem to be having a similar problem with a Xeon and 4Gig of memory. In my case, after the out of memory error happens, remote connections stop working stating that there is insufficient memory. In other words I can't even run a select statement in Management Studio after it hits the memory error. I have to restart the SQL Service.

HELP!!!

|||

First off. A human does not look at 300,000 records. Most of the time I have seen this it has been to export to Excel. When exporting to Excel export as CSV ASCII (although I don't think Excel can handle more that 64,000 records).

Note that this is with records returned, not records in the base table. I go against tables with 150 million records but I only return the data needed.

I suggest looking at design drill through reports to limit the data.

|||

Is this still a problem with Reporting Services? We are having a similar problem with .net choking on large data sets and were considering using Reporting Services as an alternative. Is Microsoft an enterprise player or not?

We are required to periodically return several hundred thousand rows from SQL Server. I'm tired of being told that is a design problem. Unfortunately when our client says he needs to print a detail report from his general ledger for his auditor we don't have the luxury of telling him Microsoft doesn't think he needs that large of a report. If he can't get the data he needs from us, he'll be happy to go down the street to get it (read Oracle).

If I can't serialize it through .net or get it out of Reporting Services, how am I supposed to extract large data sets from SQL Server?

Will 64 bit processors and multi-GB ram implementations help?

Thanks.

problem with key encryption

Hello,

I am using report server sql express.

The report was working until yesturday.Sudenly the report did'nt work and give an error :

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help
Bad Data.

I delete the key and change the data source.Now it works fine!

My problem is that this is not the first time that it happens!!!

I don't know what the cause of the problem and why suddenly after some times,the report give an erraur that i have to delete the key!!

i would like this not to happen anymore!!

What do i have to do to avoid this?

Please help me it's urgent

Thanks alot

Did you reset (not change, but reset) the password for the user that the Report Server windows service is running as? This would cause this message. Did you change the user that the report service is running as?|||

Hi

Thank you for your answer,when i installed reporting service, i installed the default installation so that now i have in the report server window service account this configurations:

service name: ReportServer$SQLEXPRESS

service account: NT AUTHORITY\NetworkService

built in account: network service.

Does it cause a problem that it's a built in account network service? i have a network.what configuration do i have to change so that i will never get the error that i got?

For answering your question i didn't change or reset the password i don't even know how to do that!

Help me please!

Thanks in advance

|||You should only get this error when you change the service account via the service control panel and not through the report server config tool. What you can try now is running the Report Server Configuration Manager and select the Encryption Keys tab. Then select Delete. This will mean that you will need to re-enter any data source credential information, but should at least bring your server back up.

problem with key encryption

Hello,

I am using report server sql express.

The report was working until yesturday.Sudenly the report did'nt work and give an error :

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help
Bad Data.

I delete the key and change the data source.Now it works fine!

My problem is that this is not the first time that it happens!!!

I don't know what the cause of the problem and why suddenly after some times,the report give an erraur that i have to delete the key!!

i would like this not to happen anymore!!

What do i have to do to avoid this?

Please help me it's urgent

Thanks alot

Did you reset (not change, but reset) the password for the user that the Report Server windows service is running as? This would cause this message. Did you change the user that the report service is running as?|||

Hi

Thank you for your answer,when i installed reporting service, i installed the default installation so that now i have in the report server window service account this configurations:

service name: ReportServer$SQLEXPRESS

service account: NT AUTHORITY\NetworkService

built in account: network service.

Does it cause a problem that it's a built in account network service? i have a network.what configuration do i have to change so that i will never get the error that i got?

For answering your question i didn't change or reset the password i don't even know how to do that!

Help me please!

Thanks in advance

|||You should only get this error when you change the service account via the service control panel and not through the report server config tool. What you can try now is running the Report Server Configuration Manager and select the Encryption Keys tab. Then select Delete. This will mean that you will need to re-enter any data source credential information, but should at least bring your server back up.|||Did you resolve your issue with this problem. We are having the same problem every time we reboot our servers. we have to reapply the key each time. Very troubling!

Problem with job that run ssis pckg

Hi,

i have a job that run ssis pckgs and it failed when the server is log off with this error msg:

Executed as user: xxxxx\dwhadmin. ...0.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:15:00 AM Error: 2007-07-11 09:15:01.71 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTSassword" with error 0x80070002 "The system cannot find the file specified.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2007-07-11 09:15:26.77 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "PackagePassword" with error 0x80070002 "The system cannot find the file specified.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2007-07-11 09:15:26.77 Code: 0xC0016016 Source: Description: Faile... The package execution fa... The step failed.

what can be the problem?

thanks.

Hi Steam5,

There are already answers aviled in this forums. I got it resolved in my case. There are several ways.

One way to deploy an SSIS package into a new machine where you actually created this package is to Use "Save copy of <Your SSIS Pkg> as" on the File menu in BIDS. Use EncryptAllSensitivewithPassword option with a password. Now this package can be executed on another Box using dtexec with /De option to decrypt the password.

Thanks

Subhash Subramanyam

|||

Hi Subhash,

thanks for the reply but it's not working.

:-( .

any other idea?

|||

Hi

We get slightly different errors here with SSIS, but the step succeeds.

Description: Failed to decrypt protected XML node "DTSassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error DTExec: The package execution returned DTSER_SUCCESS (0). Started: 09:55:33 Finished: 09:55:34 Elapsed: 1.15 seconds. The package executed successfully. The step succeeded.

Have you tried hardcoding the password into the connection string in the job step? Sometimes depending on the type of connection (oracle OLDBD) the password is not deployed with the package and you need to override the connection string with the one in the job, including the password.

Hope it helps, bit of a long shot.

Cheers

Matt

Problem with installing SQL Server 2005

When I'm installing SQL Server 2005 Express Edition (but not only, error was also in Enterprise Edition 2005) there is an error. Everything is fine but on the end SQL Instalation cannot start SQL Service.
Does someone know how to solve this problem?
I'm installing SQL CTp 2005 with the newest .NET 2.0
Help!!What is the error you are seeing?

Dan
http://blogs.msdn.com/dtjones/|||Something like that: "Installer cannot start SQL Service" and everything is unistalling.

Problem with installing SQL Server 2000

Help me

I am installing SQL Server 2000 on Windows 2000 and It ends up with the error showing :
"Setup failed to Configure Server. Please refer to C:\Winnt\Sqlstp.log for detail"
I checked sqlstp.log and found that
driver={sql server};server=MyServer;UID=sa;PWD=;database=....,
[Microsoft][ODBC SQL Server Driver] Connection broken

Thanks in advance.

Is that Windows 2000 server or workstation? And what edition of SQL Server are you installing?

Also - at what point in the installation is it failing?

|||

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q317328

HTH

Problem with installing SQL Server

Hi All,

I'm running into a problem when trying to install SQL Server onto my laptop that is running Windows XP. The error message that is displayed is:

"An error occurred while creating one or more registry entries. Please see
C:\Windows\sqlstp.log for details. The problem could be caused by a low
registry quota condition."

Does anyone know how to solve this?? Any help would be appreciated.

Thanks,

Pete

Seems to be a complex issue, may need sqlstp.log for trouble-shooting. For a quick check, please take a look at this link, which also mentioned an issue of installing SQL on WinXp:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=182716&SiteId=1

|||Typically this type of error (which isn't SQL Server specific) can/will happen if the account you are using can't access the registry to write/update new entries... or if there aren't enough empty 'slots' available.

Were you running/installing this as admin? (or were you trying to throw this instance on to a DC, etc?)

Try this link as well:
http://www.mcse.ms/archive82-2004-12-1281012.html

Problem with installing sp4

I can't install sp4. I got error :Error running script: replsys.sql (1)
looking in sqllog, I have this lines (at the end of file).
...
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\setup.iss returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for returned: 3, 3
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlstp.log returned: 0, 0
12:13:12 SetFileSecPerfAndLogUsers for C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\SQLCTR80.DLL returned: 1332, 1332
12:13:12 Begin ServPriv (MSSQLSERVER)
12:13:12 End ServPriv()
12:13:13 Upgrading databases
12:13:13 Upgrading databases on instance 'MSSQLSERVER'
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:13:13 Process Exit Code: (0)
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:13:13 Process Exit Code: (0)
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent
1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m
12:13:34 Process Exit Code: (0)
12:13:34 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:BOGIBATINA -b -n -d master -o
"C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out" -i
"C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.sql" -Usa -P"
12:13:34 Process Exit Code: (1)
12:14:10 Error running script: replsys.sql (1)
12:14:10 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:14:25 Process Exit Code: (0)
12:14:25 Action CleanUpInstall:
12:14:25 Installation Failed.
Have you looked in this file?
C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out
R.
"Radovan" <radovan@.servis24.hr> wrote in message
news:OWXdLAeuFHA.2072@.TK2MSFTNGP14.phx.gbl...
> I can't install sp4. I got error :Error running script: replsys.sql (1)
> looking in sqllog, I have this lines (at the end of file).
> ...
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\setup.iss returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for returned: 3, 3
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlstp.log returned: 0, 0
> 12:13:12 SetFileSecPerfAndLogUsers for C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\SQLCTR80.DLL returned: 1332, 1332
> 12:13:12 Begin ServPriv (MSSQLSERVER)
> 12:13:12 End ServPriv()
> 12:13:13 Upgrading databases
> 12:13:13 Upgrading databases on instance 'MSSQLSERVER'
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:13:13 Process Exit Code: (0)
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:13:13 Process Exit Code: (0)
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent
> 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m
> 12:13:34 Process Exit Code: (0)
> 12:13:34 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:BOGIBATINA -b -n -d master -o
> "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out" -i
> "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.sql" -Usa -P"
> 12:13:34 Process Exit Code: (1)
> 12:14:10 Error running script: replsys.sql (1)
> 12:14:10 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:14:25 Process Exit Code: (0)
> 12:14:25 Action CleanUpInstall:
> 12:14:25 Installation Failed.
>
|||Check what other processes are running on your server. I had the same
problem updating to SP4. I had to stop MOM services, Windows update
processes, and end anything else that may be using SQL. Then the SP4
install will go OK.
Mike
R wrote:[vbcol=seagreen]
> Have you looked in this file?
> C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out
> R.
> "Radovan" <radovan@.servis24.hr> wrote in message
> news:OWXdLAeuFHA.2072@.TK2MSFTNGP14.phx.gbl...
|||Thanks that helps.
Radovan
"inqbbus" <inqbbus@.gmail.com> wrote in message
news:1126820621.538655.83620@.g47g2000cwa.googlegro ups.com...
> Check what other processes are running on your server. I had the same
> problem updating to SP4. I had to stop MOM services, Windows update
> processes, and end anything else that may be using SQL. Then the SP4
> install will go OK.
> Mike
> R wrote:
>

Problem with installing sp4

I can't install sp4. I got error :Error running script: replsys.sql (1)
looking in sqllog, I have this lines (at the end of file).
...
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\setup.iss returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for returned: 3, 3
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlstp.log returned: 0, 0
12:13:12 SetFileSecPerfAndLogUsers for C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\SQLCTR80.DLL returned: 1332, 1332
12:13:12 Begin ServPriv (MSSQLSERVER)
12:13:12 End ServPriv()
12:13:13 Upgrading databases
12:13:13 Upgrading databases on instance 'MSSQLSERVER'
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlS
etup\Bin\scm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:13:13 Process Exit Code: (0)
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlS
etup\Bin\scm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:13:13 Process Exit Code: (0)
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlS
etup\Bin\scm.exe -Silent
1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m
12:13:34 Process Exit Code: (0)
12:13:34 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:BOGIBATINA -b -n -d master -o
"C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out" -i
"C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.sql" -Usa -P"
12:13:34 Process Exit Code: (1)
12:14:10 Error running script: replsys.sql (1)
12:14:10 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlS
etup\Bin\scm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:14:25 Process Exit Code: (0)
12:14:25 Action CleanUpInstall:
12:14:25 Installation Failed.Have you looked in this file?
C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out
R.
"Radovan" <radovan@.servis24.hr> wrote in message
news:OWXdLAeuFHA.2072@.TK2MSFTNGP14.phx.gbl...
> I can't install sp4. I got error :Error running script: replsys.sql (1)
> looking in sqllog, I have this lines (at the end of file).
> ...
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\setup.iss returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for returned: 3, 3
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlstp.log returned: 0, 0
> 12:13:12 SetFileSecPerfAndLogUsers for C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\SQLCTR80.DLL returned: 1332, 1332
> 12:13:12 Begin ServPriv (MSSQLSERVER)
> 12:13:12 End ServPriv()
> 12:13:13 Upgrading databases
> 12:13:13 Upgrading databases on instance 'MSSQLSERVER'
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlS
etup\Bin\scm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:13:13 Process Exit Code: (0)
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlS
etup\Bin\scm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:13:13 Process Exit Code: (0)
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlS
etup\Bin\scm.exe -Silent
> 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m
> 12:13:34 Process Exit Code: (0)
> 12:13:34 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:BOGIBATINA -b -n -d master -o
> "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out" -i
> "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.sql" -Usa -P"
> 12:13:34 Process Exit Code: (1)
> 12:14:10 Error running script: replsys.sql (1)
> 12:14:10 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlS
etup\Bin\scm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:14:25 Process Exit Code: (0)
> 12:14:25 Action CleanUpInstall:
> 12:14:25 Installation Failed.
>|||Check what other processes are running on your server. I had the same
problem updating to SP4. I had to stop MOM services, Windows update
processes, and end anything else that may be using SQL. Then the SP4
install will go OK.
Mike
R wrote:[vbcol=seagreen]
> Have you looked in this file?
> C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out
> R.
> "Radovan" <radovan@.servis24.hr> wrote in message
> news:OWXdLAeuFHA.2072@.TK2MSFTNGP14.phx.gbl...|||Thanks that helps.
Radovan
"inqbbus" <inqbbus@.gmail.com> wrote in message
news:1126820621.538655.83620@.g47g2000cwa.googlegroups.com...
> Check what other processes are running on your server. I had the same
> problem updating to SP4. I had to stop MOM services, Windows update
> processes, and end anything else that may be using SQL. Then the SP4
> install will go OK.
> Mike
> R wrote:
>sql

Problem with installing sp4

I can't install sp4. I got error :Error running script: replsys.sql (1)
looking in sqllog, I have this lines (at the end of file).
...
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\setup.iss returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for returned: 3, 3
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlstp.log returned: 0, 0
12:13:12 SetFileSecPerfAndLogUsers for C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\SQLCTR80.DLL returned: 1332, 1332
12:13:12 Begin ServPriv (MSSQLSERVER)
12:13:12 End ServPriv()
12:13:13 Upgrading databases
12:13:13 Upgrading databases on instance 'MSSQLSERVER'
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:13:13 Process Exit Code: (0)
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:13:13 Process Exit Code: (0)
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m
12:13:34 Process Exit Code: (0)
12:13:34 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:BOGIBATINA -b -n -d master -o
"C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out" -i
"C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.sql" -Usa -P"
12:13:34 Process Exit Code: (1)
12:14:10 Error running script: replsys.sql (1)
12:14:10 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:14:25 Process Exit Code: (0)
12:14:25 Action CleanUpInstall:
12:14:25 Installation Failed.Have you looked in this file?
C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out
R.
"Radovan" <radovan@.servis24.hr> wrote in message
news:OWXdLAeuFHA.2072@.TK2MSFTNGP14.phx.gbl...
> I can't install sp4. I got error :Error running script: replsys.sql (1)
> looking in sqllog, I have this lines (at the end of file).
> ...
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\setup.iss returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for returned: 3, 3
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlstp.log returned: 0, 0
> 12:13:12 SetFileSecPerfAndLogUsers for C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\SQLCTR80.DLL returned: 1332, 1332
> 12:13:12 Begin ServPriv (MSSQLSERVER)
> 12:13:12 End ServPriv()
> 12:13:13 Upgrading databases
> 12:13:13 Upgrading databases on instance 'MSSQLSERVER'
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:13:13 Process Exit Code: (0)
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:13:13 Process Exit Code: (0)
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
> 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m
> 12:13:34 Process Exit Code: (0)
> 12:13:34 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:BOGIBATINA -b -n -d master -o
> "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out" -i
> "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.sql" -Usa -P"
> 12:13:34 Process Exit Code: (1)
> 12:14:10 Error running script: replsys.sql (1)
> 12:14:10 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:14:25 Process Exit Code: (0)
> 12:14:25 Action CleanUpInstall:
> 12:14:25 Installation Failed.
>|||Check what other processes are running on your server. I had the same
problem updating to SP4. I had to stop MOM services, Windows update
processes, and end anything else that may be using SQL. Then the SP4
install will go OK.
Mike
R wrote:
> Have you looked in this file?
> C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out
> R.
> "Radovan" <radovan@.servis24.hr> wrote in message
> news:OWXdLAeuFHA.2072@.TK2MSFTNGP14.phx.gbl...
> > I can't install sp4. I got error :Error running script: replsys.sql (1)
> >
> > looking in sqllog, I have this lines (at the end of file).
> >
> > ...
> > 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\setup.iss returned: 0, 0
> > 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
> >
> > 12:13:12 SetFileSecuritySQLAndAdmin for returned: 3, 3
> >
> > 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
> >
> > 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlstp.log returned: 0, 0
> >
> > 12:13:12 SetFileSecPerfAndLogUsers for C:\Program Files\Microsoft SQL
> > Server\MSSQL\Binn\SQLCTR80.DLL returned: 1332, 1332
> >
> > 12:13:12 Begin ServPriv (MSSQLSERVER)
> >
> > 12:13:12 End ServPriv()
> >
> > 12:13:13 Upgrading databases
> >
> > 12:13:13 Upgrading databases on instance 'MSSQLSERVER'
> >
> > 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
> > 1 -Action 6 -Service MSSQLSERVER
> >
> > 12:13:13 Process Exit Code: (0)
> >
> > 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
> > 1 -Action 6 -Service MSSQLSERVER
> >
> > 12:13:13 Process Exit Code: (0)
> >
> > 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
> > 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m
> >
> > 12:13:34 Process Exit Code: (0)
> >
> > 12:13:34 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:BOGIBATINA -b -n -d master -o
> > "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out" -i
> > "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.sql" -Usa -P"
> >
> > 12:13:34 Process Exit Code: (1)
> >
> > 12:14:10 Error running script: replsys.sql (1)
> >
> > 12:14:10 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
> > 1 -Action 6 -Service MSSQLSERVER
> >
> > 12:14:25 Process Exit Code: (0)
> >
> > 12:14:25 Action CleanUpInstall:
> >
> > 12:14:25 Installation Failed.
> >
> >|||Thanks that helps.
Radovan
"inqbbus" <inqbbus@.gmail.com> wrote in message
news:1126820621.538655.83620@.g47g2000cwa.googlegroups.com...
> Check what other processes are running on your server. I had the same
> problem updating to SP4. I had to stop MOM services, Windows update
> processes, and end anything else that may be using SQL. Then the SP4
> install will go OK.
> Mike
> R wrote:
>> Have you looked in this file?
>> C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out
>> R.
>> "Radovan" <radovan@.servis24.hr> wrote in message
>> news:OWXdLAeuFHA.2072@.TK2MSFTNGP14.phx.gbl...
>> > I can't install sp4. I got error :Error running script: replsys.sql (1)
>> >
>> > looking in sqllog, I have this lines (at the end of file).
>> >
>> > ...
>> > 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\setup.iss returned: 0,
>> > 0
>> > 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0,
>> > 0
>> >
>> > 12:13:12 SetFileSecuritySQLAndAdmin for returned: 3, 3
>> >
>> > 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0,
>> > 0
>> >
>> > 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlstp.log returned:
>> > 0, 0
>> >
>> > 12:13:12 SetFileSecPerfAndLogUsers for C:\Program Files\Microsoft SQL
>> > Server\MSSQL\Binn\SQLCTR80.DLL returned: 1332, 1332
>> >
>> > 12:13:12 Begin ServPriv (MSSQLSERVER)
>> >
>> > 12:13:12 End ServPriv()
>> >
>> > 12:13:13 Upgrading databases
>> >
>> > 12:13:13 Upgrading databases on instance 'MSSQLSERVER'
>> >
>> > 12:13:13
>> > C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
>> > 1 -Action 6 -Service MSSQLSERVER
>> >
>> > 12:13:13 Process Exit Code: (0)
>> >
>> > 12:13:13
>> > C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
>> > 1 -Action 6 -Service MSSQLSERVER
>> >
>> > 12:13:13 Process Exit Code: (0)
>> >
>> > 12:13:13
>> > C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
>> > 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m
>> >
>> > 12:13:34 Process Exit Code: (0)
>> >
>> > 12:13:34 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:BOGIBATINA -b -n -d
>> > master -o
>> > "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out" -i
>> > "C:\Program Files\Microsoft SQL
>> > Server\MSSQL\install\replsys.sql" -Usa -P"
>> >
>> > 12:13:34 Process Exit Code: (1)
>> >
>> > 12:14:10 Error running script: replsys.sql (1)
>> >
>> > 12:14:10
>> > C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
>> > 1 -Action 6 -Service MSSQLSERVER
>> >
>> > 12:14:25 Process Exit Code: (0)
>> >
>> > 12:14:25 Action CleanUpInstall:
>> >
>> > 12:14:25 Installation Failed.
>> >
>> >
>

problem with installation of RDA...

Hello,

We have a server with 64bit Windows 2003 Server. I installed sqlce30setupen.msi and started to configure it. I get an error during virtual directory creating process which says "server tools must be installed first"....but I installed sqlce30setupen.msi already...Doesn't it the server tools that the error message says about?

The server tools are not supported on 64 bit Windows (for now) - sadly!|||

Hello,

Is it possible to install the server components to a pc(1) and install sql server to another pc(2) and connect to (2) via (1) using RDA method. I need this because the sql server is in 64bit windows 2003 server,so server tools can not be installed to it. I want to install server tools to another pc and access sql server via it.

How can I do that?

|||

Yes, this scenario is absolutely supported, so you must run 32 bit Windows on the web server, and can run 64 bit Windows on the DB server. See the SQL CE Books Onlie topic: Multiple Server Environment at http://msdn2.microsoft.com/en-us/library/ms172937.aspx

Problem with installation of 2005 ctp septenber

Well i installed the 2005 ctp september.
It went well but it didn't installed the RS
The error log was:
ReportingServicesService!library!8!02/10/2005-11:56:34:: i INFO: Catalog SQL
Server Edition = Developer
ReportingServicesService!library!8!02/10/2005-11:56:34:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException:
The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'C.0.6.43'. The expected
version is 'C.0.8.39'. To continue, update the version of the report server
database and verify access rights., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException:
The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'C.0.6.43'. The expected
version is 'C.0.8.39'. To continue, update the version of the report server
database and verify access rights.
ReportingServicesService!library!8!02/10/2005-11:56:34:: Exception caught
while starting service. Error:
Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException:
The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'C.0.6.43'. The expected
version is 'C.0.8.39'. To continue, update the version of the report server
database and verify access rights.
any idea what 2 do?You need to delete the existing ReportServer and ReportServerTempDB
databases. Then you can run setup or configure with the RS Configuration
Tool.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"'" <@.discussions.microsoft.com> wrote in message
news:3CC7819D-65F2-4B89-B5AD-23E070D92E11@.microsoft.com...
> Well i installed the 2005 ctp september.
> It went well but it didn't installed the RS
> The error log was:
> ReportingServicesService!library!8!02/10/2005-11:56:34:: i INFO: Catalog
> SQL
> Server Edition = Developer
> ReportingServicesService!library!8!02/10/2005-11:56:34:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException:
> The version of the report server database is either in a format that is
> not
> valid, or it cannot be read. The found version is 'C.0.6.43'. The expected
> version is 'C.0.8.39'. To continue, update the version of the report
> server
> database and verify access rights., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException:
> The version of the report server database is either in a format that is
> not
> valid, or it cannot be read. The found version is 'C.0.6.43'. The expected
> version is 'C.0.8.39'. To continue, update the version of the report
> server
> database and verify access rights.
> ReportingServicesService!library!8!02/10/2005-11:56:34:: Exception caught
> while starting service. Error:
> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException:
> The version of the report server database is either in a format that is
> not
> valid, or it cannot be read. The found version is 'C.0.6.43'. The expected
> version is 'C.0.8.39'. To continue, update the version of the report
> server
> database and verify access rights.
> any idea what 2 do?
>|||well the installation erased my sql server i don't have the old db any more!!!
"Brian Welcker [MSFT]" wrote:
> You need to delete the existing ReportServer and ReportServerTempDB
> databases. Then you can run setup or configure with the RS Configuration
> Tool.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "'" <@.discussions.microsoft.com> wrote in message
> news:3CC7819D-65F2-4B89-B5AD-23E070D92E11@.microsoft.com...
> > Well i installed the 2005 ctp september.
> >
> > It went well but it didn't installed the RS
> >
> > The error log was:
> >
> > ReportingServicesService!library!8!02/10/2005-11:56:34:: i INFO: Catalog
> > SQL
> > Server Edition = Developer
> > ReportingServicesService!library!8!02/10/2005-11:56:34:: e ERROR: Throwing
> > Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException:
> > The version of the report server database is either in a format that is
> > not
> > valid, or it cannot be read. The found version is 'C.0.6.43'. The expected
> > version is 'C.0.8.39'. To continue, update the version of the report
> > server
> > database and verify access rights., ;
> > Info:
> > Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException:
> > The version of the report server database is either in a format that is
> > not
> > valid, or it cannot be read. The found version is 'C.0.6.43'. The expected
> > version is 'C.0.8.39'. To continue, update the version of the report
> > server
> > database and verify access rights.
> > ReportingServicesService!library!8!02/10/2005-11:56:34:: Exception caught
> > while starting service. Error:
> > Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException:
> > The version of the report server database is either in a format that is
> > not
> > valid, or it cannot be read. The found version is 'C.0.6.43'. The expected
> > version is 'C.0.8.39'. To continue, update the version of the report
> > server
> > database and verify access rights.
> >
> > any idea what 2 do?
> >
>
>

Problem with instalation

I have a problem with SQL 2005 Express on Win XP, at the start of instalation, with

- Performance Monitor Counter Requirement (Error)

Messages

Performance Monitor Counter Requirement

The System Configuration Check for Performance Monitor counter registry value has failed. For details, see How to: Increment the Counter Registry Key for Setup in SQL Server 2005, in the readme file or in SQL Server Books Online

Please, send me correct values of this kezs, because I deleted them,

I'm going to move this to the Setup forum.

- Mike

|||

This can be a couple things, but typically it is the perflib registry key. Check out this article and see if it applies to your environment:

http://msdn2.microsoft.com/en-us/library/ms143215(SQL.90).aspx

One other thing to keep in mind. The registry key listed in the article HKLM\...\009 represents the English language code. If you are running a different language (or multiple languages), you will have another language code in the registry path (ex: 004 for Chinese Simplified). You will need to make the changes to both hives.

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009]

Thanks,
Samuel Lester (MSFT)

Problem with Index Tuning Wizard

When running the Index Tuning Wizard (ITW) on our SQL Server we got a
error message : 'Could not complete cursor operation because the table
schema changed after the cursor was declared'
The ITW was used only to advice new indexes. I know that it creates
hypothetical indexes in the sysindexes table, but what are the changes
in the user-tables ?
How do you use the ITW without interfering with the real
schema-definitions ?
thanks,
RobbertHi,
Before using the ITW, you should get a load of the queries
you are running. You can capture the events in profiler
and then use that load file for the ITW to use.
hth
DeeJay
>--Original Message--
>When running the Index Tuning Wizard (ITW) on our SQL
Server we got a
>error message : 'Could not complete cursor operation
because the table
>schema changed after the cursor was declared'
>The ITW was used only to advice new indexes. I know that
it creates
>hypothetical indexes in the sysindexes table, but what
are the changes
>in the user-tables ?
>How do you use the ITW without interfering with the real
>schema-definitions ?
>thanks,
>Robbert
>.
>|||My theory on this is while you were running the ITW
someone in your tream made a change to the structure a
table, which caused it to get an error.
I have run ITW a number of times using our Production
Database, with no problems.
Peter
"We are all worms. But I believe that I am a glow-worm."
Winston Churchill
>--Original Message--
>When running the Index Tuning Wizard (ITW) on our SQL
Server we got a
>error message : 'Could not complete cursor operation
because the table
>schema changed after the cursor was declared'
>The ITW was used only to advice new indexes. I know that
it creates
>hypothetical indexes in the sysindexes table, but what
are the changes
>in the user-tables ?
>How do you use the ITW without interfering with the real
>schema-definitions ?
>thanks,
>Robbert
>.
>

problem with index and duplicates

Hi
I'm trying to change structure of table 'TB_KONTAKT' to add a fiew fields -
but during that I get the following error message:
'TB_KONTAKT' table
- Unable to create index 'PK__TB_KONTAKT__04AFB25B'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE
INDEX terminated because a duplicate key was found for index ID 1. Most
significant primary key is '1190914'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint.
See previous errors.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
terminated.
That index is already build and I'm rather scared of destroying it.
How can I fix the problem?
Best Regards
Darek T.Dariusz Tomon wrote:
> Hi
> I'm trying to change structure of table 'TB_KONTAKT' to add a fiew fields -
> but during that I get the following error message:
> 'TB_KONTAKT' table
> - Unable to create index 'PK__TB_KONTAKT__04AFB25B'.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE
> INDEX terminated because a duplicate key was found for index ID 1. Most
> significant primary key is '1190914'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint.
> See previous errors.
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated.
> That index is already build and I'm rather scared of destroying it.
> How can I fix the problem?
> Best Regards
> Darek T.
>
It looks like you're attempting to define a primary key on your table.
Primary keys must be unique, and the field(s) that you're keying on have
some duplicate values.|||Dariusz Tomon,
Are you using Enterprise Manager to apply this change (add new columns)?
AMB
"Dariusz Tomon" wrote:
> Hi
> I'm trying to change structure of table 'TB_KONTAKT' to add a fiew fields -
> but during that I get the following error message:
> 'TB_KONTAKT' table
> - Unable to create index 'PK__TB_KONTAKT__04AFB25B'.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE
> INDEX terminated because a duplicate key was found for index ID 1. Most
> significant primary key is '1190914'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint.
> See previous errors.
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated.
> That index is already build and I'm rather scared of destroying it.
> How can I fix the problem?
> Best Regards
> Darek T.
>
>