Problem Installing BIDS Alongside With VS2003/VS2008
Apr 10, 2008
I have a problem installing BIDS. On a XP machine with Visual Studio 2003 and Visual Studio 2008 installed, i tried to install SQL Server 2005 DE with SSIS and Client Tools. All works fine, but the devenv.exe where BIDS start menu shortcut points to doesnt exist.
In SQL Server installation dialog, i tried uninstalling BIDS (168 MB disk space will get free'd...) then again installing BIDS (...needs 168 MB disk space...), a lot of harddisk activity, but all the same.
I searched for devenv.exe on drive c:, only two hits: The VS2003 and VS2008 files.
I tried uninstalling VS2008, VS2003, .net3.5, .net3.0, .net2.0 and SS2005, then installing SS2005 with BIDS, again BIDS start menu shortcut points to nowhere. No devenv.exe on drive c:
Now i used system recovery to go back to the point before uninstalling all the stuff, so i can do all my work beside BIDS/SSIS, seaching for a solution...
I thought about installing VS2005 prof., but the license is lost because i upgraded to VS2008.
Note: The VS2008 is installed without installing the SQL Server coming along with VS2008.
Any help?
alberich
View 4 Replies
ADVERTISEMENT
Feb 25, 2008
I have VS2008 installed which has installed SQLEXPRESS. But it seems not all of it.
I want to be able to create tables and generally mess about with SQLEXPRESS without VS2008, is it safe to install Sql Express from this site that will hopefully? install all the management tools? Will this action compromise the VS2008 installation? Will I need to uninstall all the SQL Server stuff that is currently installed?
I am a complete noob when it comes to SQL Express having done all my SQL using Access.
Many thanks
Andy
View 1 Replies
View Related
Mar 12, 2008
Dear,
I Had VS20005 and SQL 2005 Working perfectly. For some errors, I did formatted my PC and installed VS2008. After doing that, I am trying to install MSSQL2005, when installation be in "Integration development environment with 2005" Phase, An error appears, and the installation stopped. What I have to Do to solve this?
Note: I ahve XPSP2 32 bit installed.
View 5 Replies
View Related
Feb 12, 2008
Using the new Visual Studio 2008 I created a setup project for a small program, and added SQL Express 2005 SP2 to the list of prerequisites.
I checked the box so the setup project will contain all necessary files in a sub directory of the setup project.
My setup starts nice (on windows vista) prompts me to install SQL Express, setup of SQL Express runs for some time, I get an UAC prompt, then setup fails with error 1706.
The last lines of the setup log file:
Installing using command 'C:UserswilfiAppDataLocalTempVSDE5B7.tmpSqlExpresssqlexpr32.exe' and parameters '-q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1 ADDUSERASADMIN=1'
Process exited with code 1706
Status of package 'SQL Server 2005 Express Edition SP2 (x86)' after install is 'InstallFailed'
I really would like to install SQL Express as part of the setup project, can someone help me with this problem?
Thanks in advance,
Sam
View 8 Replies
View Related
Mar 11, 2008
Hi
Can I install just Business Intelligence Development Studio without installing SQL Server?
Thanks,
Salman Shehbaz.
View 5 Replies
View Related
Feb 28, 2007
Thank you to all that take the time to read this!
All software is installed on a single development pc. I have a SQL Server 2000 Developer Edition Database that I am using to test a new Accounting System. SQL Server 2000 is the required format. I would like to start developing some SRSS reports against that database. It was suggested that I install the SQL Server 2005 Reporting Services, because I was told 2005 is less buggy and easier to use. I installed SRSS 2005, and only SRSS 2005, and used the Configuration Tool to get it configured properly, I think. I have green checks on everything except "Email Settings" and "Execution Account"
Now, I want to write some reports. BIDS is not under the "Microsoft SQL Server 2005" program group, only "Configuration Tools". I was also told that I could use Visual Studio to write reports. I installed Visual Studio 2005 Standard Edition. When I go start a new project, "Business Intelligence€? is not a project type or sub-type.
What do I need to do so I can either install BIDS or use VS 2005 to write reports?
View 4 Replies
View Related
Mar 11, 2007
I am runing WinXP Pro SP2 with all current updates and also VS2005 Team Ed for Developers. VS2005 is installed on D drive as is nearly all of my development tools. SQL Server 2000 SP4 is on the C drive and just installed SQL 2005 express with advanced services to D drive. I then attempted to install the express toolkit BIDS to the D drive only to learn it's hard coded(really stupid to not check for existing VS 2005) to install on C drive only. I've gotten past the denenv.exe issue.
The issue now is when I open VS2005 with the normal shortcut or the Business Intelligence Development Studio short cut and open any project that contains Crystal Reports reports and attempt to open a report I get package load failures for ReportDesignerPackage and Datawarehouse VSIntegration Layer Package. Also get this same error if you try to now create a BIDS report project.
I thought maybe VS2005 has a search path variable in tools/options or maybe a system envirnoment variable that could be tweaked to tell VS2005 to also look in the IDE folder for the dummy VS install on the C Drive. If there is I have not discovered it yet.
Second thought was to copy the files in the IDE folder of the dummy VS install on C drive to the IDE folder where my VS2005 is actually installed. I saw a post last night by someone that had done that with apparent success. That solution seems a little suspect since the BIDS packages files are registered at the C drive paths, so you certainly don't want to delete or move those files from where they were installed.
I'm nervous about side effects on my existing VS2005 projects during development and deployment and aren't even using BIDS.
So, now the question is how does one resolve this conumdrum?
View 1 Replies
View Related
Oct 24, 2007
I have a client that has a SQL 2000 Standard installation. They are keen to start using Reporting Services. I know I could just install 2000 Reporting Services, but I am the one who will be creating the reports, and I'm really not geared up to develop 2000 reports. I could install the development environment, but would rather not if it is avoidable.
What I was thinking of doing, is installing SQL Express with Advanced Services on the same server that SQL 2000 is currently installed on. I could then use it's Reporting Services. The date would of course be sitting in the existing 2000 databases.
Is this viable/recommended?
The client will eventually upgrade to 2005, but more in the 6-12 month time-frame.
I think I should be able to administer it from here - I have remote connectivity into their server.
Regards,
Tim
View 3 Replies
View Related
Apr 17, 2015
I need to recover some data in a table but i'm not 100% sure the right way to do this safely.
I'll need to query the two tables to compare the before and after but how do i go about restoring/attaching the backup database to SQL without causing conflicts?
If I restore, i assume this would just overwrite which is obviously the worst thing that can happen. If i attach the backup, how does this affect the current live DB? how do i make sure that it's not getting accessed and mistaken for the live DB?
The SQL server is 2008 R2 running as a VM.
View 2 Replies
View Related
Apr 2, 2008
i have been trying to get MSSQL 2005EE to work with VS2003 when i go into the server explorer and try to add a new data connection it says that the database is not available, but when i browse the servers it is there and the database i am trying to connect to is there. i do not understand why it can see the sql server but not connect to it.
View 1 Replies
View Related
Apr 17, 2015
I need to recover some data in a table but i'm not 100% sure the right way to do this safely.
I'll need to query the two tables to compare the before and after but how do i go about restoring/attaching the backup database to SQL without causing conflicts?
If I restore, I assume this would just overwrite which is obviously the worst thing that can happen. if i attach the backup, how does this affect the current live DB? how do i make sure that it's not getting accessed and mistaken for the live DB?
The SQL server is 2008 R2 running as a VM.
View 9 Replies
View Related
May 23, 2006
Hi,
Please assist with the following.
How do I connect to SQL Server Express in VS2003? "Do I still use using System.Data.SqlClient;"?
What would the connection string be in the code? The following does not work.
try { string connectionString = "server=localhost;uid=webserver;pwd=wordpass;database=dbMV;"; // create a new SqlConnection object with the appropriate connection string SqlConnection sqlConn = new SqlConnection(connectionString); // open the connection sqlConn.Open(); // do some operations ... // close the connection sqlConn.Close(); } catch(Exception err) { Response.Write(err); }
View 1 Replies
View Related
Aug 25, 2006
We have an existing project developed using VS 2003 with SQL server 2000.
Now planning to switch to SQL server 2005.
Are there any compatibility issues between VS 2003 and SQL server 2005, Plus sql server reporting services 2005.
We have been developing this project over a year and don't want to mess it. Now we are at the stage of developing reports and finidng lot of problems with sql server 2000 reporting services.
Thank you very much for the information.
View 1 Replies
View Related
Mar 14, 2008
we're all pretty fluent with 2005 products, but must enhance our legacy 2000 RS product, and prefer to use vs2003. Does anyone recall how we used to get vs2003 to allow RS2000 design. We dont believe we saw such an option in installation of vs2003, but since installing the db preceded that, arent sure if we would have been given such an option had vs2003 been installed prior to the 2000 db.
View 1 Replies
View Related
Aug 24, 2006
Hi,
I'm trying to use reporting services in teh VS2003 but the Option to I create the project does not appear, i've already installed SP3 and no success, any idea ?
Thanks
View 6 Replies
View Related
Nov 13, 2006
Hi,
I am using VS2003. I have installed .net2.0 so that I can run SQL Express. I am using XP Pro SP2.
My server is called ikitsch. The path to my database is
ikitschsqlexpressDatabasesTest1
I am using windows authentication. For some reason I can't seem to connect to the database. What would be a correct connection string to
connect to this database on my local machine?
Thanks
View 2 Replies
View Related
Aug 21, 2005
I am trying to follow an exercise for debugging a stored procedure in the .net IDE. I have had success in adding a connection to the application, until I get the point of where I should set a BreakPoint in the stored procedure "Ten Most Expensive Products" which belongs to the Northwind database. When I open Sever Explorer -->Data Connections- ->WI0001.NorthWind.dbo-->Stored Procedures and Right-click the procedure, the context menu does not give me an edit item to select to open this SP in the editor. Nor can I double-click on the stored procedure to open it either.
View 1 Replies
View Related
Oct 19, 2006
Hi all,
We have many domain users who develop/deploy reports using VS2003 to our remote server at https://server/reportserver with no problems at all.
A single workstation on the domain that been used to develop reports cannot deploy though. The message looks fairly simple to diagnose "no report server was found at https://server/reportserver". I have checked dns and the servername resolves no problem. I have manaully edited and added the server to the hosts file also. I have updated and service packed all VS elements (VS2003 7.1.6030).
The server is contactable in all ways on this workstation, all ip/dns settings are the same as other domain workstations.
Can anyone point me in the direction of log files to look at, or if i am missing any basic options in VS. I have checked all deployment settings from other workstations.
Many Thanks!
Alex
View 4 Replies
View Related
Feb 4, 2008
Hello
Know that VS2008 is out, when would be possible to create SSIS and BI projects for SQL2005 with it?
Thanks a lot.
View 1 Replies
View Related
Feb 8, 2008
I have VS2008 (9.0.21022.8 RTM) and I cannot get SQL Compact 3.5 to work with it. Whenever I attempt to open a compact edition database, I get a message that "The operation cannot complete, click OK on the "Package Load Failure" dialog, reinstall SQL Server Compact 3.5 and then from the command line run devenv /resetskippkgs. I've tried that twice and no joy. I can connect and work just fine with SSMS 2005, but I cannot get it to work in VS2008.
Also when in VS2008 and I go to Server Explorer | Data Connections | Add Connection, I do not have Microsoft SQL Server Compact 3.5 in the list.
Any suggestions? Thanks.
-John
View 10 Replies
View Related
Nov 20, 2007
I just installed VS2008 RTM and noticed that it really wants me to use 3.5 instead of 3.1. As I am doing most of my SSCE work through the SQL Server 2005 Management Studio (its query editor is still far superior to VS'), I found that I can still use 3.1 without much trouble (so long as I manually browse and add the 3.1 reference to my project).
That said, I'd like to use 3.5. My two questions are:
- Is the SSCE 3.5 version included in VS2008 final? I noticed the dlls are all over a month old. Can I redistribute these with my app?
- Will there be support in SQL 2005 or SQL 2008 for connecting to 3.5 databases? I know that a new SQL server 2008 CTP was released, but haven't seen mention of SSCE support. I'd really hate to lose the great query editor of the Management Studio when moving to 3.5.
View 5 Replies
View Related
Feb 21, 2008
I was initially interested in building my small retail app on Framework 3.5, until just now when I saw the download size. I won't make a single sale with that as a prerequisite.
I would, however, like to use VS2008 for this. If I target Framework 2.0, will I still be able to use SQLCE v3.5? The new SET IDENTITY INSERT functionality is an absolute requirement. (Note: I haven't installed VS2008 yet--I'm still investigating options.)
Thanks!
View 1 Replies
View Related
Dec 1, 2007
Hi. I recently upgrading my dev machine to Vista and VS 2008 simultaneously (clean install) and upgraded my VS2005 project, which was previously using SQL CE 3.1. Now when I compile and run it, I get a database exception telling me to upgrade my database to version 3.5!
First of all, I tried running the Repair() method to upgrade the database file, but then I get an exception telling me the password is incorrect (it most certainly is not, I didn't change a thing), so it won't even let me upgrade it.
Secondly, I even tried removing the reference to System.Data.SqlServerCe and manually adding the verison 3.1 reference back, but it still for some reason loads version 3.5 instead of version 3.1.
So! Please either tell me how I can properly upgrade my users' database file to version 3.5 and have it work with the latest libraries, or tell me how I can at least use the old libraries like I was under VS2005. The .dll files are all present in the project and I haven't changed them at all, they're being properly copied to the output directory and everything. I even checked the "Specific Version" attribute on the reference in the project, but no help.
Do I have to do something special to tell my application to load the local copy of the assembly as opposed to, say, one in the GAC?
View 1 Replies
View Related
Oct 9, 2006
Is it possible to run both Sql Server Management Studio: Express and full blown side by side?
I am developing with the full blown product but would like to test Management Studio Express on the same box.
Is this possible?
Thanks
Eric
View 3 Replies
View Related
May 10, 2008
I've just upgraded my C# app from .NET 2.0 to 3.5 in VS 2008. Now my SQL Server CE database file won't open. When I run the app, it falls over on the connection.Open() method call, saying I have to upgrade the database to 3.5. It says if it was created in 3.0 or 3.1 to run the compact/repair utility. Well, I did that - a full compaction - but it didn't help at all. According to somewhere on MSDN, I should get an option to upgrade if I reconnect to the database in Server Explorer. Not so. It connects quite happily. If I try to connect to some earlier copies of the database, I do get this dialog, so I am assuming that it has already been upgraded. But then why won't the damn thing work?
I tried running the command-line upgrade.exe too, but being a bit clueless when it comes to the command line, I couldn't get it to work. Kept telling me the thing wouldn't run in Win32 mode, even though I was running it from the command prompt (sigh!).
View 2 Replies
View Related
Feb 4, 2008
we're getting an error that says "C:....rptproj' cannot be opened because its project type (.rptprroj) is not supported by this version of Visual Studio. To open it, please use a version that supports this type of project." when trying to open RS projects created in VS2005 with VS2008.
We concluded from the specs on VS2008 that the DB Version of VS2008 wouldnt be necessary for RS projects. Were we wrong? Is there some other add in that we need, perhaps BIDS? Is there some conversion step that we need to follow?
View 1 Replies
View Related
Apr 28, 2008
I'm using VS2008 (as shipped with SQL CE 3.5 as shipped).
I want to write a database app and started with a quite simple example:
One table "Master" has 2 columns: int MasterID, int Value (where the MasterID is the primary key and is an identity column.
For the GUI I used the typed dataset components (based on the namespace: System.Data.SqlServerCe) which were automatically generated by VS2008. I just dropped the table from the datasources view to a form and got a DataGridview, a Navigator and some DB components, quite fine so far.
When i run the app i can add new rows and the identity column is filled with -1, -2 ... as expected. When I hit the save button, the rows are saved to DB, but the values of the identity columns are not updated (the still have -1, -2..)
When I use the exact same example with SQL Express evrything works fine: the identity Column's values are updated automatically and have +1, +2, ...
Sure there is a statement "SELECT @@IDENTITY"... but I'm just using automated code so far, and i expect that code to work (automatically). Next problem: if i want to insert that "Select @@identity" stuff (I don't want to do that, but perhaps I have to?) where can I do this, I did not found a OnInsertedRow-Event?
This problem is part of a bigger one: I want to use Master/Detail, but inserting the Details fails because the inserting of the master rows didn't return the correct Indentity values, so the detail rows cannot be inserted (the foreign keys -1, -2... will raise an error).
thanks in advance, Bernd.
View 6 Replies
View Related
Dec 12, 2007
When I try to convert a report project from 2005, it seems to convert fine but then the project closes because VS2008 doesn't support that project type (.rptproj ?). I see that there is a report project type under VB (and I assume C#) but there is no Business Intelligence project catagory. It's a new machine and I did install SQL Server 2005 before VS2008.
I'm in the process of moving a bunch of projects and websites from another machine and got hung up on this one. Any pointers greatly appreciated.
View 1 Replies
View Related
Jan 26, 2008
Parser Error Message: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
I'm not sure what to do to fix this. I've downloaded the redistributable for the report viewer. Please help, I need to have this before the weekend is over.
Thanks,
View 4 Replies
View Related
Nov 30, 2007
I'm using VS2008 RTM with a new SQL Compact 3.5 database and I read in VS2008 and SQL Compact 3.5 BOL that Database Diagrams are supported as well as Foreign Key creation from Server Explorer.
However, there doesn't seem to be support for this. Database Diagram commands are not displayed for this new database (but it is for my SQL Express database) as instructed by BOL.
Can anyone tell me if VS2008 fully supports SQL Compact 3.5 with database diagrams and visual tools to create relationships? If so, how can you create a database diagram in VS2008 for SQL Compact 3.5?
View 1 Replies
View Related
Apr 11, 2008
Hi,
A simple question. I installed successfully Visual Studio 2008 Standard edition on my VISTA Ultimate 32bits machine. During install process, I also checked SQL Server Express 2005 item.
Which version of SQL Server Express 2005 did it install? Are we talking about SP2? If so, can I install without problem a more complete SP2 package using following links
SQL Server 2005 Express Edition with Advanced Services SP2 http://go.microsoft.com/fwlink/?LinkId=65109
Microsoft SQL Server 2005 Express Edition Toolkit http://go.microsoft.com/fwlink/?LinkId=65111
without screwing the now existing SQL Server Express setup VS2008 installed?
Thanks in advance,
Stéphane
View 14 Replies
View Related
Apr 15, 2008
I have previously installed SQL Server 2005 Client tools on my machine (XP Professional). When I launch Visual Studio 2005 and go to create a new project, I can see all of the Business Intelligence Templates (i.e. Report Server Project, Integration Services Project, etc).
I recently installed Visual Studio 2008. When I go to create a new project in VS2008, none of the Business Intelligence templates appear.
How would I go about getting these BI Templates to appear so that I can create new Report Services projects in VS2008?
Thank you in advance for your assistance.
View 5 Replies
View Related
