Can I install both version of SQL server 2000 & 2005 on my Computer ?

I now know only I can install both .Net 1.1 and 2.0 on one computer

but I don't know, Can I do it on SQL Server ?

Please advise me...

You cannot have SQL 2000 and SQL 2005 running in the same computer.

Cheers

Al

|||Yes you can. SQL Servers run under their own process, and different instances maintain their own memory space. You're fine to run both on one server, though I dont recomend it for a production enviroment.|||

When you try, there is an error from the installer! How do you get around that?

Cheers

Al

|||

albertpascual:

When you try, there is an error from the installer! How do you get around that?

Cheers

Al

EDIT

You can if you install 2000 before 2005, companies run different versions on the network as of last year you can still download 6.5 from MSDN. And yes I have run both in one box during the SQL Server 2005 roll out.

|||Hi Albert, I have a machine which first has SQL2005 installed and then I added SQL2000 to it, without any problem. Do you remember what's the error you got from the installer?|||

Yes, something like you cannot install SQL 2005 when another instance is already installed.

The other instance was SQL 2000, and that happend to me at the SQL 2005 CTP version. I have never tried with the release version. Are you telling me that now is all possible?

|||

albertpascual:

Yes, something like you cannot install SQL 2005 when another instance is already installed.

The other instance was SQL 2000, and that happend to me at the SQL 2005 CTP version. I have never tried with the release version. Are you telling me that now is all possible?

The CTPs were bad one CTP between beta 2 and 3 cost me a hard drive and the OS that came with it, back then it takes a while to find the Management Studios all that changed with the final product, you can even get a child to install it but I have not tried it. it is very easy now. But 2000 remains ignore Windows questions just answer those relevant to you.

|||

You are correct, took me a long time to finish the installation of SQL 2005 CTP, the release version was fast and easy on a clean computer. I already removed all my SQL 2000 from any computer, I only use SQL 2005, love the speed!

I am glad that people can install both in the same machine now. Some day I may try that instead of just upgrading it.

Cheers

Al

Can I install a Enterprise version analysis service on a Standard version of SQL 2005 server?

Hi all,

Since some analysis services features are only available in Enterprise version , I have to upgrade my SQL 2005 server from standard edition to enterpise edition.

So I uninstall originial standard version of analysis service and install a Enterprise version. However, the analysis service is still a standard version after installation.

Is it possible to keep data engine as standard version and install a enterprise version of analysis service?

Thank you very much

Tony

Yes. This is supported as in SQL Server 2005, Standardard SKU and Enterprise SKU can be installed side by side successfully. Of course, their instancenames must be distinct.

Can I install a Enterprise version analysis service on a Standard version of SQL 2005 server

Hi all,

Since some analysis services features are only available in Enterprise version , I have to upgrade my SQL 2005 server from standard edition to enterpise edition.

So I uninstall originial standard version of analysis service and install a Enterprise version. However, the analysis service is still a standard version after installation.

Is it possible to keep data engine as standard version and install a enterprise version of analysis service?

Thank you very much

Tony

Yes. This is supported as in SQL Server 2005, Standardard SKU and Enterprise SKU can be installed side by side successfully. Of course, their instancenames must be distinct.

Can I get an English version of electron book

I used Chinese edition of Windows.
When I download Reporting service trial version.
I always get a Chinese version thought I have choosen an English version.
The translation of electron book is not good, so I want to read in English.
How can I get a English version of electron book of Reporting Service?When you install reporting services, we include all languages in a single
distribution. We derive the language for the install from the OS language
settings. You can change this by setting the language for non-Unicode
programs to English. To get the english version:
Start
-->Control Panel
-->Regional and Language Options
-->Advanced tab
--> Language for non-Unicode programs - set this to English (United States)
Also, if you can provide examples of where the translation is poor, we would
love to know these so we can make the localization for our documentation
better.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:%23z6PrKGaEHA.3996@.TK2MSFTNGP12.phx.gbl...
>I used Chinese edition of Windows.
> When I download Reporting service trial version.
> I always get a Chinese version thought I have choosen an English version.
> The translation of electron book is not good, so I want to read in
> English.
> How can I get a English version of electron book of Reporting Service?
>|||Thank,
After I set the language of Control Panel, the electron book is still in
Chinese,
and the character in my Outlook in mess up.
Can I only set the electron book to English, not the whole Windows?
"Lukasz Pawlowski [MSFT]" <lukaszp@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:#1QG6yGaEHA.3888@.TK2MSFTNGP10.phx.gbl...
> When you install reporting services, we include all languages in a single
> distribution. We derive the language for the install from the OS language
> settings. You can change this by setting the language for non-Unicode
> programs to English. To get the english version:
> Start
> -->Control Panel
> -->Regional and Language Options
> -->Advanced tab
> --> Language for non-Unicode programs - set this to English (United
States)
> Also, if you can provide examples of where the translation is poor, we
would
> love to know these so we can make the localization for our documentation
> better.
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:%23z6PrKGaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> >I used Chinese edition of Windows.
> > When I download Reporting service trial version.
> > I always get a Chinese version thought I have choosen an English
version.
> > The translation of electron book is not good, so I want to read in
> > English.
> > How can I get a English version of electron book of Reporting Service?
> >
> >
>|||This is only required during installation. You can set it back whenever you
like after the install is complete. Note that the behavior of updates to
books online (there's on available thorugh msdn) will only install based on
the setting you had during setup.
-Lukasz
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:eeKiaRNaEHA.712@.TK2MSFTNGP11.phx.gbl...
> Thank,
> After I set the language of Control Panel, the electron book is still in
> Chinese,
> and the character in my Outlook in mess up.
> Can I only set the electron book to English, not the whole Windows?
>
> "Lukasz Pawlowski [MSFT]" <lukaszp@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
> :#1QG6yGaEHA.3888@.TK2MSFTNGP10.phx.gbl...
>> When you install reporting services, we include all languages in a single
>> distribution. We derive the language for the install from the OS
>> language
>> settings. You can change this by setting the language for non-Unicode
>> programs to English. To get the english version:
>> Start
>> -->Control Panel
>> -->Regional and Language Options
>> -->Advanced tab
>> --> Language for non-Unicode programs - set this to English (United
> States)
>> Also, if you can provide examples of where the translation is poor, we
> would
>> love to know these so we can make the localization for our documentation
>> better.
>> -Lukasz
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>>
>> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
>> news:%23z6PrKGaEHA.3996@.TK2MSFTNGP12.phx.gbl...
>> >I used Chinese edition of Windows.
>> > When I download Reporting service trial version.
>> > I always get a Chinese version thought I have choosen an English
> version.
>> > The translation of electron book is not good, so I want to read in
>> > English.
>> > How can I get a English version of electron book of Reporting Service?
>> >
>> >
>>
>|||Thank!
But the character of Outlook is mess up after set the Control Pannel's
language to English.
Are there any method just change the electron book's language to English,
not the whole Windows system.
"Lukasz Pawlowski [MSFT]" <lukaszp@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:#1QG6yGaEHA.3888@.TK2MSFTNGP10.phx.gbl...
> When you install reporting services, we include all languages in a single
> distribution. We derive the language for the install from the OS language
> settings. You can change this by setting the language for non-Unicode
> programs to English. To get the english version:
> Start
> -->Control Panel
> -->Regional and Language Options
> -->Advanced tab
> --> Language for non-Unicode programs - set this to English (United
States)
> Also, if you can provide examples of where the translation is poor, we
would
> love to know these so we can make the localization for our documentation
> better.
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:%23z6PrKGaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> >I used Chinese edition of Windows.
> > When I download Reporting service trial version.
> > I always get a Chinese version thought I have choosen an English
version.
> > The translation of electron book is not good, so I want to read in
> > English.
> > How can I get a English version of electron book of Reporting Service?
> >
> >
>|||Thank for your answer.
It solve my problem.
"ad" <ad@.wfes.tcc.edu.tw> ¼¶¼g©ó¶l¥ó·s»D
:OstyUtSaEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Thank!
> But the character of Outlook is mess up after set the Control Pannel's
> language to English.
> Are there any method just change the electron book's language to English,
> not the whole Windows system.
>
>
> "Lukasz Pawlowski [MSFT]" <lukaszp@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
> :#1QG6yGaEHA.3888@.TK2MSFTNGP10.phx.gbl...
> > When you install reporting services, we include all languages in a
single
> > distribution. We derive the language for the install from the OS
language
> > settings. You can change this by setting the language for non-Unicode
> > programs to English. To get the english version:
> >
> > Start
> > -->Control Panel
> > -->Regional and Language Options
> > -->Advanced tab
> > --> Language for non-Unicode programs - set this to English (United
> States)
> >
> > Also, if you can provide examples of where the translation is poor, we
> would
> > love to know these so we can make the localization for our documentation
> > better.
> >
> > -Lukasz
> >
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> >
> >
> > "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> > news:%23z6PrKGaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > >I used Chinese edition of Windows.
> > > When I download Reporting service trial version.
> > > I always get a Chinese version thought I have choosen an English
> version.
> > > The translation of electron book is not good, so I want to read in
> > > English.
> > > How can I get a English version of electron book of Reporting
Service?
> > >
> > >
> >
> >
>

Can i developmy db in SQL Server MSDE then upload to SQL Server 20

I want to develop a web application using the MSDE version of SQL server -
will i then be able to upload it to a web host running SQL Server 2000?
Thanks
Yes.
"JoeConnor79" <JoeConnor79@.discussions.microsoft.com> wrote in message
news:8F42A758-7C69-4A04-94A7-5A7F1A0A709A@.microsoft.com...
> I want to develop a web application using the MSDE version of SQL server -
> will i then be able to upload it to a web host running SQL Server 2000?
> Thanks

Can I deploy a runtime version

Is is possible to deploy MSDE with a database in such a way that an end user
can only access that database via a custom application? In other words, I
don't want the end user to be able to use osql (or any other tool) to get
into the database, and I don't want them to be able to detach that database
and attach it to a full blown SQL Server.
Thanks.
No, it is not possible. If the user has full right (Admin right) to his
computer, he can do anything to SQL Server/MSDE on this computer:
attaching/detaching it, peeking into the database structure. The most you
can do is to encrypt the data content, if you can find a reliable tool to do
that.
"Tom Iarusso" <TomIarusso@.discussions.microsoft.com> wrote in message
news:E2A8F5F9-A707-4985-8E00-C419353C82D9@.microsoft.com...
> Is is possible to deploy MSDE with a database in such a way that an end
> user
> can only access that database via a custom application? In other words, I
> don't want the end user to be able to use osql (or any other tool) to get
> into the database, and I don't want them to be able to detach that
> database
> and attach it to a full blown SQL Server.
> Thanks.

Can I attach to my 2005 Express DB using the 2005 Mgt Studio (NOT EXPRESS) client?

I have a 2005 Express DB I wish to attach to using the 2005 Mgt Studio Client (Not the express version, but the full blown 2005 Mgt Studio Client from the SQL 2005 Standard Edition Install disk). Can this be done, or can I only use the 2005 Mgt Studio Express Edition Client?

Thanks in advance.
M. Scott Blalock

You can use either one.

Buck Woody

Can I apply this hot fix to solve SqlBulkCopy issue?

Hi,
Our production SQL databaseâ' located on SQL Server 2005 (SP2) with 3161
version. When we use the SqlBulkCopy, the following error occurs:
System.Data.SqlClient.SqlException: The incoming tabular data stream (TDS)
protocol stream is incorrect. The TDS headers contained errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
We searched on web site and found this
http://support.microsoft.com/kb/913177/en-us article.
Now, I want know this hot fix version is higher than 3161 or lower because
we are currently on 3161 version.
Regards,
ChenI don't think this fix affects SQL Server versioning, and doesn't seem to
have anything to do with specific SQL Server hotfixes. So, it is probably
worth a try.
There are also later builds available for SQL Server... you may want to
check cumulative updates 1 - 7 for any mention of the issue you are seeing.
The best part is, you no longer have to call CSS to get one of these
updates.
http://sqlblog.com/blogs/aaron_bertrand/archive/2008/04/25/don-t-want-to-call-css-pss-to-get-a-cumjulative-update-you-don-t-have-to.aspx
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:34AB0521-F9E8-4249-B77C-341FDA1DA921@.microsoft.com...
> Hi,
> Our production SQL databaseâ' located on SQL Server 2005 (SP2) with 3161
> version. When we use the SqlBulkCopy, the following error occurs:
> System.Data.SqlClient.SqlException: The incoming tabular data stream (TDS)
> protocol stream is incorrect. The TDS headers contained errors.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection)
> We searched on web site and found this
> http://support.microsoft.com/kb/913177/en-us article.
> Now, I want know this hot fix version is higher than 3161 or lower because
> we are currently on 3161 version.
> Regards,
> Chen|||Thank you very much!
"Aaron Bertrand [SQL Server MVP]" wrote:
> I don't think this fix affects SQL Server versioning, and doesn't seem to
> have anything to do with specific SQL Server hotfixes. So, it is probably
> worth a try.
> There are also later builds available for SQL Server... you may want to
> check cumulative updates 1 - 7 for any mention of the issue you are seeing.
> The best part is, you no longer have to call CSS to get one of these
> updates.
> http://sqlblog.com/blogs/aaron_bertrand/archive/2008/04/25/don-t-want-to-call-css-pss-to-get-a-cumjulative-update-you-don-t-have-to.aspx
>
>
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:34AB0521-F9E8-4249-B77C-341FDA1DA921@.microsoft.com...
> > Hi,
> > Our production SQL databaseâ' located on SQL Server 2005 (SP2) with 3161
> > version. When we use the SqlBulkCopy, the following error occurs:
> >
> > System.Data.SqlClient.SqlException: The incoming tabular data stream (TDS)
> > protocol stream is incorrect. The TDS headers contained errors.
> > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> > Boolean breakConnection)
> >
> > We searched on web site and found this
> > http://support.microsoft.com/kb/913177/en-us article.
> >
> > Now, I want know this hot fix version is higher than 3161 or lower because
> > we are currently on 3161 version.
> >
> > Regards,
> > Chen
>