Problem in installing SQL Server 2005 (Beta version is not getting uninstalled)

Hi All,

I had installed a beta version of SQL Server (SQL Server 2005 CTP) and now I want to install a full version of SQL Server 2005 Developer Edition on my machine. I have properly uninstalled all the CTP componenets from Add-Remove programs and even deleted the registry data of that installation. I have also removed the related folders from the hard drive.

When I run the setup of the full version it says that setup has detected the beta versions of either .Net Framework, Visual Studio or SQl Server. Remove the beta components using Add-Remove programs and try again. Can anyone help me out of this problem?

Regards,

Sachin

hope this will help u.

http://geekswithblogs.net/mattrobertsblog/archive/2005/11/06/59246.aspx

Madhu

Problem in installing SQL express

If you know how to fix my problem , pls let me know. I am trying to install SQL express version with XP SP2 . iIt stops at the screen of "Detecting Installed IIS" . I have tried the same installation in server 2003. It is ok.

I too have the exact same problem. I've got a case logged into MS support and I'll post back whenever they get around to returning my call.
|||OK - I resolved the problem on two identicial clean machines, but we were not sure what exactly resolved the problem. First off, I have two, out-of-the-box Dell 9150s and both came with a Norton Internet Security installed with 'Personnal Firwewall' turned ON. I turned the firewall off and also installed the service packs listed below and I was able to install SQL Express without issue on both machines.

I hope this helps.
Security Update for Windows XP (KB890859)

- Update for Windows XP (KB894391)

- Security Update for Windows XP (KB896428)

- Security Update for Windows XP (KB905749)

- Security Update for Windows XP (KB904706)

- Security Update for Microsoft .NET Framework, Version 1.1 Service Pack 1 (KB886903)

- Critical Update for Windows XP (KB886185)

- Security Update for Windows XP (KB900725)

- Security Update for Windows XP (KB888302)

- Security Update for Windows XP (KB905414)

- Security Update for Windows XP (KB899589)

- Security Update for Windows XP (KB893066)

- Cumulative Security Update for Internet Explorer for Windows XP (KB896688)

- Security Update for Windows XP (KB890046)

- Security Update for Windows XP (KB902400)

- Security Update for Microsoft Windows (KB898458)

- Security Update for Windows XP (KB896358)

- Update for Windows XP (KB887742)

- Security Update for Windows XP (KB896423)

- Security Update for Windows XP (KB893756)

- Security Update for Windows XP (KB896424)

|||

I was having the same problem with the install haning up at the IIS detection on my laptop. I didn't have any problem installing it on my desktop. Both machines are running XP Home. The difference is the desktop has ZoneAlarms as a firewall, while the laptop is running the Norton firewall.

I couldn't install on the laptop either from the download or from a SQL Server Standard Edition CD. They both stopped at the IIS detection.

I turned off the Norton firewall, downloaded the install to my desktop, ran it from there and it installed very quickly.

Problem in Crystl Report Viewer.CloseView Method

Hello K.Babu

My Self Sanjeev. i want to ask about crystal report viewer control. i am using crystal report 8.5 version. i using crviewer to view the report. by crviewer.viewreport() i view the reoprt now i want to close the view, so i use crviewer.closeview(index) method but it gives error. index parameter not accepting string data type. and also not 1,-1,0 to close the view. i use activeindex of crviewer but not woking. so please help me to solve this problem. i needed it veru much

SanjeevLooks like something is wrong with dealing with viewObject. Did u use AddView method to add ViewerObject. It's not picking the index properly.

THanks|||hello,

i have not used addview method to add view for the viewobject. how to use it? can u please explain it.

Thankx

Sanjeev|||So far in my application I haven't used view.. it's not clear yet whether I need to use view or not ?

I see this particular function :

closeCurrentView
If the canCloseCurrentView property is True, closes the current view. Equivalent to the Close button in the toolbar. A viewClosed and a viewActivated event are fired. The currentViewName property is changed.

Syntax
void closeCurrentView ()

check whether this server our purpose.

Thanks|||Sorry sir,

this will not solve the problem. i have know that whether the canCloseCurrentView() is method of what? 'coz both the ceviewer and crystalreport is not having property,method,function like this.

and i want to close the view.

sanjeev.|||Do u really need view in your application ? What if you don't close the view ?|||Hello Sir,

I want to create 1 DLL file which includs several reports in it. and i will add reference of that file to my VB Project. So i used Crystal 8.5 and Vb 6.0. i create 1 dll but with ne VB form which have the crystal report viewer control shows the Report which i passed through VB. now when i close the Form of viewer. Dll component does not get closed. i.e. the instance of the object is not closed and project goes into HangUp position. if so i want to close the view first so i can set the object to nothing.

So please help me to di it.

Sanjeev

Problem getting SQL Server Express Service to Start

I have had SQL Server 2005 (Full Version) installed along with SQL Server Express and suddenly SQL Express quit starting and will not start manually. I have reinstalled VS 2005 (Team Edition for Software Dev) and tried to reinstall SQL Express but the installation fails when it tries to start the service. Any suggestions?

Keith

If it had been working for a while but stopped, and it logs on with an account other than local I would check to see if the account's password has expired. If that isn't the case, when you try to start it are there any messages in the Event Logs?|||

You should also check the SQL Error logs in addition to the Event logs. Let us know what they say.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

|||

I get the following in the SQL Server Express Log:

SQL Trace ID 1 was started by login "sa".

2006-04-17 16:16:32.77 spid5s Starting up database 'mssqlsystemresource'.

2006-04-17 16:16:33.14 spid5s Error: 15209, Severity: 16, State: 1.

2006-04-17 16:16:33.14 spid5s An error occurred during encryption.

2006-04-17 16:16:33.16 spid5s SQL Trace was stopped due to server shutdown.

Any thoughts?

|||

Thanks Keith,

Just to be clear, are you getting this error while installing or just when trying to start the server?

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

|||

When the server quit starting and repairing visual studio didn't help, I removed the following registry entries:

Under the key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL, the string named SQLEXPRESS with data MSSQL.1 and

the key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1

so that sql express would install under the same instance name. I then reinstalled sqlexpress and during the installation it was unable to start the service and reported the encryption error in the sql server log.

|||

Do not delete registry entries. Use the setup program to uninstall/reinstall the SQL Server Express product.

Normally, SQL Server setup creates the following key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Security

If the Security key is not present, the creation of the service master key will fail with the error that you've encountered. The key was probably not created because you partially deleted the registry entries for this product.

You can attempt to create the key manually (don't create anything under it), to see if this will allow the installation to complete. If it works, I suggest to backup your databases, then uninstall and reinstall SQL Server Express again, because the correct installation will create this key and it will also apply the proper access restrictions on it.

Thanks
Laurentiu

|||The Add/Remove Programs utility in the control panel will not let me uninstall SQLEXPRESS. It says that the product has already been uninstalled. When I try to add SQLEXPRESS it states the the instance name is already in use and won't install. This lead me to make the registry changes mentioned earlier. I have repaired the registry. Is there any way to delete the entry for the SQLEXPRESS instance from the list of installed instances in the the Add/Remove programs list that appears when I select "Change" under Microsoft SQL Server 2005?|||

Try posting this question on the Setup forum: SQL Server Setup & Upgrade.

Thanks
Laurentiu

problem copying database with Microsoft SQl Server Management Studio

I am trying to copy a database from the server on my web host(crystaltech) to my new local install of MS SQL Server 2005 Enterprise (trial version).

I go to Tasks>Copy Database which opens the wizard. When I get to the select database screen I get this error:

Server user 'username' is not a valid user in database '123foo'

(123foo is the first database of all those on the server)

I need have it look only at my database which I have permissions for to copy it. How do I do this?

I tried copying the tables the other way(import data) but it dropped all my identities and primary keys which is a pain to recreate. Is there a way to copy tables from one server to another without losing primary keys and identity fields?

Thanks for any help!

I think you can use the import export option and specify them with primary keys and identities also other option is you can try scripting the tables and run the script in SSMS........

|||

Thats is some sort of Bug in SSMS. You will have to assign a valid database owner top the database as the existing database owner is no server principal on your computer, this can be either based on the fact that you deleted the server principal or as the most common reason, you restored a database backup which is from another computer or a certain point in time where the current database owner did not exist on the computer. To fix that use sp_changedbowner (described int he BOL) to change the db_owner.

Jens K. Suessmeyer

http://www.sqlserver2005.de

problem copying database with Microsoft SQl Server Management Studio

I am trying to copy a database from the server on my web host(crystaltech) to my new local install of MS SQL Server 2005 Enterprise (trial version).

I go to Tasks>Copy Database which opens the wizard. When I get to the select database screen I get this error:

Server user 'username' is not a valid user in database '123foo'

(123foo is the first database of all those on the server)

I need have it look only at my database which I have permissions for to copy it. How do I do this?

I tried copying the tables the other way(import data) but it dropped all my identities and primary keys which is a pain to recreate. Is there a way to copy tables from one server to another without losing primary keys and identity fields?

Thanks for any help!

I think you can use the import export option and specify them with primary keys and identities also other option is you can try scripting the tables and run the script in SSMS........

|||

Thats is some sort of Bug in SSMS. You will have to assign a valid database owner top the database as the existing database owner is no server principal on your computer, this can be either based on the fact that you deleted the server principal or as the most common reason, you restored a database backup which is from another computer or a certain point in time where the current database owner did not exist on the computer. To fix that use sp_changedbowner (described int he BOL) to change the db_owner.

Jens K. Suessmeyer

http://www.sqlserver2005.de

Problem converting Crystal Report to RS2005

I've run into a problem while converting an old Crystal report into a
RS2005 version. The report in question gets a dataset from a SQL
stored procedure. The stored procedure passes details on paper
production by day, machine and grade. The report groups the data by
grade and then by machine. In the grade group footer, I perform a
calculation on the data that is as follows:
=sum(GradePeriod.value)*avg(SBK.value). This works the same as in the
crystal report. However, in the crystal report, they declare a global
variable, that basically creates a running sum of this calculation.
So in the Machine footer, it is a sum of all of the
sum(GradePeriod.value)*avg(SBK.value). Now if I try in RS to sum the
values in the footer by using
=sum(sum(GradePeriod.value)*avg(SBK.value)) I get an error that says
you cannot use an aggregate of an aggregate. So my question is, how
do I replicate what is going on in the Crystal Report in RS?In RS you need to give some thing like this in the header or footer you cant
give directly. Try this. (you should use "reportitems")
=Sum(ReportItems!Gradeperiod.Value)
Amarnath, MCTS
"dachrist" wrote:
> I've run into a problem while converting an old Crystal report into a
> RS2005 version. The report in question gets a dataset from a SQL
> stored procedure. The stored procedure passes details on paper
> production by day, machine and grade. The report groups the data by
> grade and then by machine. In the grade group footer, I perform a
> calculation on the data that is as follows:
> =sum(GradePeriod.value)*avg(SBK.value). This works the same as in the
> crystal report. However, in the crystal report, they declare a global
> variable, that basically creates a running sum of this calculation.
> So in the Machine footer, it is a sum of all of the
> sum(GradePeriod.value)*avg(SBK.value). Now if I try in RS to sum the
> values in the footer by using
> =sum(sum(GradePeriod.value)*avg(SBK.value)) I get an error that says
> you cannot use an aggregate of an aggregate. So my question is, how
> do I replicate what is going on in the Crystal Report in RS?
>|||It wants me to put the sum(ReportItems!GradePeriod.value) in the Page
Footer. I need to have these sums at each group footer, because I
cannot have one paper machine per page.
Dave
On Mar 15, 2:33 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> In RS you need to give some thing like this in the header or footer you cant
> give directly. Try this. (you should use "reportitems")
> =Sum(ReportItems!Gradeperiod.Value)
> Amarnath, MCTS
>
> "dachrist" wrote:
> > I've run into a problem while converting an old Crystal report into a
> > RS2005 version. The report in question gets a dataset from a SQL
> > stored procedure. The stored procedure passes details on paper
> > production by day, machine and grade. The report groups the data by
> > grade and then by machine. In the grade group footer, I perform a
> > calculation on the data that is as follows:
> > =sum(GradePeriod.value)*avg(SBK.value). This works the same as in the
> > crystal report. However, in the crystal report, they declare a global
> > variable, that basically creates a running sum of this calculation.
> > So in the Machine footer, it is a sum of all of the
> > sum(GradePeriod.value)*avg(SBK.value). Now if I try in RS to sum the
> > values in the footer by using
> > =sum(sum(GradePeriod.value)*avg(SBK.value)) I get an error that says
> > you cannot use an aggregate of an aggregate. So my question is, how
> > do I replicate what is going on in the Crystal Report in RS... Hide quoted text -
> - Show quoted text -