When I first installed BI Studio everything was working fine, but I went into it today and I noticed that the FTP task seems to be missing, I can't see it in the toolbox, everything else appears to be their but not that.
Any idea how I can get this back, I really don't wont to uninstall and reinstall at the moment, and I'm not even sure if that would work.
ThanksRight-click the toolbox, Choose Items. Select the SSIS Control Flow page and have a look for any missing tasks, those not checked.
I'm doing some testing database on my computer that I've installed SQL server 2005. But the server at the company I'm working with has SQL Server 2000.
What do I need to do to convert my database file in 2005 into 2000 so that I can add it in the company's server?
TIA.
you can not "convert" SQL Server 2005 database to SQL Server 2000 database. The otherway round is possible.
Madhu
|||While you cannot 'convert' the SQL 2005 database to a SQL 2000 format, you can script out the tables, views, functions, stored procedures, etc., then after checking those scripts for compatibility, you can run the scripts on SQL 2000 and re-create the database.
|||It would be advisable to change the compatability level of the 9.0 database to 8.0.|||Thank you all for replying.One question, how to change the compatibility level?
|||
It would be nice if it were so simple as changing the compatibility level.
The physical files are different between SQL 2000 and SQL 2005, and to my knowledge, there is no current mechanism to 'downgrade' a database.
I think that you are left with my earlier suggestion about scripting out the database objects, and running those scripts in SQL 2000 to recreate a SQL 2000 database. Perhaps these links will help with scripting:
DDL -Script Database to File
http://www.wardyit.com/blog/blog/archive/2006/07/21/133.aspx
http://www.sqlteam.com/publish/scriptio
http://www.aspfaq.com/etiquette.asp?id=5006
http://www.codeproject.com/dotnet/ScriptDatabase.asp
http://www.nigelrivett.net/DMO/DMOScriptAllDatabases.html
http://rac4sql.net/qalite_main.asp
DDL –Script Data to file (Database Publishing Wizard)
http://www.microsoft.com/downloads/details.aspx?FamilyID=29B4FFD8-AC3A-4481-B352-9B185619A901
However, the last link didn't point to a website. Was it this:
http://www.microsoft.com/downloads/details.aspx?FamilyID=56e5b1c5-bf17-42e0-a410-371a838e570a&DisplayLang=en
that you want to link to?
|||
use system sp sp_dbcmptlevel
Eg: EXEC sp_dbcmptlevel 'AdventureWorks', '80';
Madhu
|||Hi all,Taken into considerations of all your suggestions, I'm compiling my step-by-step of 'downgrading' my database from version 2005 to 2000:
1) Set the compatibility of database to SQL server 2000:
EXEC sp_dbcmptlevel 'myDatabase', 80
2) Next, I will do this:
Open SQL Server Management Studio, and connect.
Right-click on myDatabase, choose 'Script Database As > CREATE To > New query editor window.
Save as .sql
Would it be advisable to script my tables one by one? But then I'll have to run the script in order of which table is created first based on relationships. Would scripting the whole database in one go takes care of the order of creating tables?
Any suggestions on what else I need to consider before/after doing this?
TIA.
|||
in this case there is no need to degrade the copatibility level. You can script all the objects into a single file and the run the script in 2000. by this step your schema will be ready. Now you need to improt the data using import/export or ssis or simple insert into statment after configuring linked server.
Madhu
|||Hello Madhu,I've tried right-click on my database and Script Database to a new query window but there are only 60-70 lines and I didn't see any CREATE TABLE anywhere. So I would assume that I need to right-click on each table and Script table to a different .sql file for each table?
Eera
|||I probably script my database the wrong way. Sorry for giving you the wrong description earlier. Now, when I right-click my database, point to Tasks and chose 'Generate Scripts' and the scripts generated looks more promising. 
Just started using SQL server this week.
|||
how many tables are there in this database ?
Madhu
|||There are (only) 8 tables in my database.I have yet to research and find out the process of importing data using the method that u mentioned.
|||
if its only 8 table then the best method will be
(a) Configure LinkedServer in 2000 for SQL Server 2005
(b) use your own script like Insert into tablename select *from <LinkedserverName>.databasename.owner.tablename
Madhu
My RS install is having a strange issue. I've installed RS on an IIS Server and pointed to a remote server database. The IIS server is secured using an internally issued SSL cert.
After some tweaking, I've been able to get RS to work (almost) properly. I'm able to deploy reports from Visual Studio and view them through the RS Web App. Of course, I have admin rights on this box.
My problem is this: The web app won't let me add a New Role Assignment for my users. The only Role Assignment is BUILTIN\Administrators. I need to add a "Browser Only" role for the users. When I click "New Role Assignment" from the project folder's security menu, it displays the New Role Assignment page. I type in the group name and click the Browser checkbox. Finally, I click the OK button, but nothing happens. Its like there isn't an event tied to the button. However, the Cancel and New Role buttons work just fine.
Why aren't my OK buttons working? This is the most bizzare issue, but it's completely halted my production. I've tried re-installing RS but am having the same issue. Please, any help will be much appreciated.
Even a quick workaround to edit folder security would be nice at this point.
Thanks!Couple things:
1. Is it possible that the web browser you are using has scripting disabled?
2. Do you see a warning icon at the bottom-left of the browser after you click OK?|||
Yes - we've seen this kind of behavior when you are using an Internet Browser that does not support scripting. In SQL Server 2005, Report Manager UI supports most operations in browsers other than Internet Explorer - but it is not perfect. Underneath the covers, we use different ways of implementing buttons so being able to click some but not others is a symptom of this problem.
If you have trouble doing this in report manager, you can use SQL Server Management Studio in SQL Server 2005 to do this as well.
Hope that helps,
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
My RS install is having a strange issue. I've installed RS on an IIS Server and pointed to a remote server database. The IIS server is secured using an internally issued SSL cert.
After some tweaking, I've been able to get RS to work (almost) properly. I'm able to deploy reports from Visual Studio and view them through the RS Web App. Of course, I have admin rights on this box.
My problem is this: The web app won't let me add a New Role Assignment for my users. The only Role Assignment is BUILTIN\Administrators. I need to add a "Browser Only" role for the users. When I click "New Role Assignment" from the project folder's security menu, it displays the New Role Assignment page. I type in the group name and click the Browser checkbox. Finally, I click the OK button, but nothing happens. Its like there isn't an event tied to the button. However, the Cancel and New Role buttons work just fine.
Why aren't my OK buttons working? This is the most bizzare issue, but it's completely halted my production. I've tried re-installing RS but am having the same issue. Please, any help will be much appreciated.
Even a quick workaround to edit folder security would be nice at this point.
Thanks!Couple things:
1. Is it possible that the web browser you are using has scripting disabled?
2. Do you see a warning icon at the bottom-left of the browser after you click OK?|||
Yes - we've seen this kind of behavior when you are using an Internet Browser that does not support scripting. In SQL Server 2005, Report Manager UI supports most operations in browsers other than Internet Explorer - but it is not perfect. Underneath the covers, we use different ways of implementing buttons so being able to click some but not others is a symptom of this problem.
If you have trouble doing this in report manager, you can use SQL Server Management Studio in SQL Server 2005 to do this as well.
Hope that helps,
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
Hello,I just installed SP2, can I freeze header at the top in this version?Thanks,Jim.can you xplain your question ?
Hi,
Can anybody help me with the following problem:
I have Vista Ultimate installed and within Vista .NET Framework 3.0 is installed as a part of the operating system so I can't remove 3.0
Now for MS SQL Server 2005 Express I need .NET Framework 2.0 and the SQL Server 2005 doesn't work with .NET Framework 3.0
Can't install 2.0, get the message that 3.0 is already installed.
Please help me!!
Ren
.NET 3.0 is actually an addon for the 2.0 framework.
Check out http://www.sqlskills.com/blogs/bobb/2007/09/19/SQLServer2008AndNETFrameworkVersions.aspx for more information.
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
|||Vista Ultimate actually comes with .NET Framework 2.0 installed by default. So it is already there.
If you check the \windows\microsoft.net\framework directory you should see v2.0.50727 and this is the .NET Framework 2.0 so SQL Server 2005 should not ask to install it.
|||Hi,
The directory is there but still SQL Server 2005 give the error-message ".NET Framework 2.0 is not installed or damaged on this computer". I run Vista Ultimate on 32-bit machine. Is there a way to re-install .NET Framework? Already installed SDK and hoped that with that installation Framework 2.0 would be re-installed but that didn't work either :-(
Tried to call Microsoft but they charge € 300 for trying to solve my problem, no garantuees..
If I was sure that a new installation of Vista would solve the problem I would do that, but can't see why a new installetion would solve the problem.. Is there a way to re-install the .NET Framework-software?
Ren
|||I would check out this post:
http://blogs.msdn.com/astebner/archive/2007/03/26/how-to-repair-the-net-framework-2-0-and-3-0-on-windows-vista.aspx
But I am not sure that there is an easier way to get this fixed. Because they are OS components, you would have to do some sort of repair.
Hi,
Can anybody help me with the following problem:
I have Vista Ultimate installed and within Vista .NET Framework 3.0 is installed as a part of the operating system so I can't remove 3.0
Now for MS SQL Server 2005 Express I need .NET Framework 2.0 and the SQL Server 2005 doesn't work with .NET Framework 3.0
Can't install 2.0, get the message that 3.0 is already installed.
Please help me!!
Ren
.NET 3.0 is actually an addon for the 2.0 framework.
Check out http://www.sqlskills.com/blogs/bobb/2007/09/19/SQLServer2008AndNETFrameworkVersions.aspx for more information.
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
|||Vista Ultimate actually comes with .NET Framework 2.0 installed by default. So it is already there.
If you check the \windows\microsoft.net\framework directory you should see v2.0.50727 and this is the .NET Framework 2.0 so SQL Server 2005 should not ask to install it.
|||Hi,
The directory is there but still SQL Server 2005 give the error-message ".NET Framework 2.0 is not installed or damaged on this computer". I run Vista Ultimate on 32-bit machine. Is there a way to re-install .NET Framework? Already installed SDK and hoped that with that installation Framework 2.0 would be re-installed but that didn't work either :-(
Tried to call Microsoft but they charge € 300 for trying to solve my problem, no garantuees..
If I was sure that a new installation of Vista would solve the problem I would do that, but can't see why a new installetion would solve the problem.. Is there a way to re-install the .NET Framework-software?
Ren
|||I would check out this post:
http://blogs.msdn.com/astebner/archive/2007/03/26/how-to-repair-the-net-framework-2-0-and-3-0-on-windows-vista.aspx
But I am not sure that there is an easier way to get this fixed. Because they are OS components, you would have to do some sort of repair.
Hi,
Can anybody help me with the following problem:
I have Vista Ultimate installed and within Vista .NET Framework 3.0 is installed as a part of the operating system so I can't remove 3.0
Now for MS SQL Server 2005 Express I need .NET Framework 2.0 and the SQL Server 2005 doesn't work with .NET Framework 3.0
Can't install 2.0, get the message that 3.0 is already installed.
Please help me!!
Ren
.NET 3.0 is actually an addon for the 2.0 framework.
Check out http://www.sqlskills.com/blogs/bobb/2007/09/19/SQLServer2008AndNETFrameworkVersions.aspx for more information.
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
|||Vista Ultimate actually comes with .NET Framework 2.0 installed by default. So it is already there.
If you check the \windows\microsoft.net\framework directory you should see v2.0.50727 and this is the .NET Framework 2.0 so SQL Server 2005 should not ask to install it.
|||Hi,
The directory is there but still SQL Server 2005 give the error-message ".NET Framework 2.0 is not installed or damaged on this computer". I run Vista Ultimate on 32-bit machine. Is there a way to re-install .NET Framework? Already installed SDK and hoped that with that installation Framework 2.0 would be re-installed but that didn't work either :-(
Tried to call Microsoft but they charge € 300 for trying to solve my problem, no garantuees..
If I was sure that a new installation of Vista would solve the problem I would do that, but can't see why a new installetion would solve the problem.. Is there a way to re-install the .NET Framework-software?
Ren
|||I would check out this post:
http://blogs.msdn.com/astebner/archive/2007/03/26/how-to-repair-the-net-framework-2-0-and-3-0-on-windows-vista.aspx
But I am not sure that there is an easier way to get this fixed. Because they are OS components, you would have to do some sort of repair.
Kind regards from
Axolotl, Mellendorf, Germany
Have you tried to reinstall / repair the management tools again. This would not take long and should re connect any links or references that were lost.
|||Hello, Glenn,
thanks a lot for your answer.
Unfortunately, I tried that several times, also with a brand new installed windows xp pro sp2.
But, must tell you, I DID find a solution:
I downloaded the sqlexpr_toolkit_ger.exe, installed it, and now this strange message has disappeared, and ssmse is working without any problems...
I think, there might be any file destroyed by updating framework 1.1 which is reinstalled by the toolkit!?
Doesn't matter, it works.
Kind regards from
Axolotl
