How Do I Move A Project Between Machines?
Sep 19, 2006
Hi,
I'm an SQL Server novice.
After developing some websites (VS 2005 VWD), my machine started to crumble. (e.g, SQL Server won't uninstall and lots of other software problems)
So I bought a new machine and set up a clean installation of SQL Server 2005 Standard and Visual Studio 2005 standard.
I copied my old "projects" folder to the new machine but I cannot use it.
1: When I try to import I get a "cannot import external files" error.
2: When I click on a project, it launches VS 2005 and I can edit etc.
However, when I try to run the website in VS 2005, I get the following error.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) an error
Please can someone let me know how I can get my "old" projects running in my new environment?
Thanks
Ken
View 7 Replies
ADVERTISEMENT
Aug 19, 2006
I need to move our production database to a brand new machine on our LAN.Both machines are running SQL2K. I'd like to place the production databasein a directory on the destination machine with a slightly different pathname than the source SQL server.How can I shrink the transaction log to the minimum size before I try themove? What is the best way to move the database to the new machine? Wehave Veritus Backup Exec.Regards,Charles MacLean
View 1 Replies
View Related
Apr 4, 2008
I am not sure if this is possible or not, but I have to at least ask.
I have a SQL Reporting Services project that has a QA server version and then a Production server version. So when requested changes are made to the reports, I make the changes in Visual Studio and then push to QA. After the changes have been tested and approved, I then push the changes to the Production server.
I have come across an issue, where requested changes were made in Visual Studio (a lot of changes), and pushed to QA. The users now have changed their minds and they want instead to stay with what is in production. So, I am looking for a way to recover the report file on the production web server, bring it back into my visual studio project to replace the report that I had changed.
Is this possible, or will I have to start over and step one and reverse the changes in Visual Studio.
Let me know.
Thank you,
T.J.
View 3 Replies
View Related
May 29, 2008
For some reason in a Team Foundation Team Project that has multiple project types (SSRS, SSIS, WebSite, C# Business DLL...), the SSIS project makes itself the startup project to the team project. If I explicitly set another project as the startup project to the team project and then select an SSIS package in the SSIS project in the team project, the SSIS project becomes the startup project automatically.
I am using Visual Studio 2005 SP1.
View 3 Replies
View Related
Jun 24, 2007
Hi,
I have been working on some SSIS packages for a while now and today while i was working i was trying to create a new connection and in the process there was an error and it said the BIDS has to be closed and i closed it but later when i open BIDS and try to open my project(.sln) from the file menu to work on the half done package it pops up an error which shows the path to my project location on the first line and next statement on the pop up error box says:
"Make Sure the application for the project type (.dtproj) is installed."
I tried to check some forums in which some suggested to try installing SP1 which i tried but ..i dont know why but the SP1 fails to install (i dont know if its causing problem becoz i already installed SP2 as i had some other problem before for which the cure was to install SP2).
Did anyone here face such a problem before ?
I'd really appreciate if the experts here can tell a cure for this problem.
thanks,
Ravi
View 4 Replies
View Related
Feb 23, 2007
I have a Visual Studio 2005 solution which contains a Sql Server Integration Services (SSIS) project.
In this solution I have explicitly set a Web application project as startup project, but whenever I edit a DTS package within the SSIS project, VS automatically sets the SSIS project as startup project and the package I edit as startup object.
Needless to say, this may cause some really unwanted incidents when running the solution - thinking that you're about to run the Web application project (that was explicitly set as startup project), but instead, you run the edited package in the SSIS project.
Is there any way to avoid having the SSIS project automatically setting itself as startup project, any workaround here at all? :)
Thanks.
View 4 Replies
View Related
Jun 16, 2015
in order to maintain a deployed project into an Integration Services Catalog I'd like to know if it is possible to import it into a new project inside SSDT.
View 5 Replies
View Related
May 6, 2007
Hi,
I want to update value of a custom field for a perticular project in Project Server 2007 using PSI.
I have created 5 enterprise custom fields(A,B,C,D,E) through PWA/Server Settings.
I want to search all Projects on Server. If any project is having value for custom field A then I want to update rest of the custom fields(B,C,D,E) for that perticular project.
I dont know how to do it please help.
Thanks in Advance
Madhukar
View 5 Replies
View Related
Feb 3, 2007
I have a very small project written in VB.Net 2005 using the SQL Server 2005 SSiS DTSx package.
I took a SQL Server 2000 dts package and using the SQL Server 3005 legacy tools migrated it so I could still use the package withing SQL 2005 until I can build one using BI/SSIS.
Anyway,I added the reference Microsoft.SqlServer.ManagedDTS so I could then use the Microsoft.SqlServer.Dts.Runtime so I can execute the commands:
Dim oApp As New Application
Dim oPkg As New Package
oPkg = oApp.LoadPackage(g_DTSx_Directory & "AOC copy Generic1 CSV to AOC_verify_file_1.dtsx", Nothing)
Dim oResults As DTSExecResult
oResults = oPkg.Execute
Ok. That works fine. Executes without a hitch. So now I try and create a setup project for this and I use the setup wizard.
During the creation of the setup project I get a message that states:
The following files may have dependencies that cannot be determined automatically. Please confirm that all dependencies have been added to the project.
C:windowssystem32msxml6.dll
OK. The dll is part of the reference I mentioned above and I have no idea what other dependencies it may have.
How do I find this out?
Has anyone else created a project like this and experenced the same?
I am on a clean build running WinXP Pro with SP2 - VS2005 with SP1 and the SQL Server 2005 tools.
View 1 Replies
View Related
Apr 20, 2015
I've got an SSIS solution file with project deployment model in VS 2013 and would like to deploy that to SSISDB on different environments.All these days I followed the regular way to create a project in SSISDB and deploy it to that. Now want to find out if i can automate this process and so got some questionsÂ
1. Can we automate the process of creating a project on SSISDB based on our SSIS project name? This will be like when we do a deployment it should check if the project exists or not on SSISDB based on our SSIS project name, if the project exists we just deploy the packages in the project and if the project does not exists in SSISDB it will create that project and deploy the packages.
2. Can we also automate the process of creating environments? In traditional way we manually create the environment variables under environment tab of SSISDB, but can we make that also as part of deployment? Like when we are releasing to Dev server we look if that particular Dev variable exists on that server, if it exists we just update the existing stuff and if it does not exists we just create it.
View 2 Replies
View Related
Mar 31, 2008
I have visual studio 2005 and sql server 2005 with integration service installed on my machine. Couple of days ago, I installed visual studio 2008 professional. When I go to create SSIS project I dont see it in visual studio 2008. What do I have to do to make it appear in visual studio 2008 so that I can create SSIS projects.
Thanks.
View 7 Replies
View Related
Jul 23, 2007
I fail to use project professional 2003 to access to the project server 2003 using MSDE 2000 in local area network, following message was shown,
Connection failed:
SQLState: '01000' SQL Server Error 1326 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
Connection failed:
SQLState '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
I have seen these pages with similiar cases but can't help.
http://support.microsoft.com/kb/818047/
http://support.microsoft.com/kb/837653/en-us
Can anyone help me?? Thanks a lot!
View 1 Replies
View Related
Mar 13, 2008
Hi all How can create trigger in sql server project in VB.NET 2.0 ?thanks in advance
View 1 Replies
View Related
Jan 12, 2007
Howdy again...
Do I need to re-create a new package from scratch after doing what I did?
It seems I've made what is probably a typical newbie mistake: I used COPY/PASTE
to
consolidate containers from two packages into a single new project/package.
Now my new package generates multiple duplicate errors (23 of each...) whenever I open it:
Warning loading LoadBillingData.dtsx: Process configuration failed to set the
destination at the package path of "PackageData Flow Task to Load
Profiles, Versions, and
Transactions.EventHandlers[OnError].Variables[System::Propagate].Properties[Namespace]".
This occurs when attempting to set the destination property or variable fails.
Check the destination property or variable.
Error loading LoadBillingData.dtsx: Changing the name of a variable failed
because it is a system variable. System variables are read-only.
What happened:
new guy (goes without saying...) creates:
01. PROJECT A
02. add PACKAGE
A to PROJECT A
03. add some
containers, figger out what the heck is going on, get containers working
04. create
PROJECT B
05. create
PACKAGE B
06. add
containers, they work fine
07. whoops!
Want to consolidate the packages. Unix guy naively expects Bill has made MS
Visual Studio like all windows products (of which newbie is aware€¦):
08. create
PROJECT C
09. create
PACKAGE C
10. <ctrl
a> PACKAGE A
11. <crtl
c> PACKAGE A
12. <ctrl
v> PACKAGE C
13. <ctrl
a> PACKAGE B
14. <crtl
c> PACKAGE B
15. <ctrl
v> PACKAGE C
16. copy Flat
File Connection Managers
17. copy
Database Connection Manager
18. drag the
arrows around, fix the flat file sources, renew the column maps, etc
19. whoops! the
connections all look like a registry number! Fix the OLE DB Destinations,
Execute SQL Task containers by selecting the DB Connection Manager copied from
PROJECT A
20. successfully
execute PROJECT C/PACKAGE C
21. save all
22. exit
23. start MS
Visual Studio
24. Open
Solution
25. ERRORS!!!
Is this fixable?
Thanks,
Bill
View 1 Replies
View Related
Jan 17, 2008
Hello,
I've created a Report Model Project that can be used by Report Builder to generate ad-hoc reports. I'm trying to create a connection string in my Report Server Project that points to the Report Model Project data source view.
All I can do is create a regular datasource, which bypasses the metadata contained in the Data Source View.
Basically I want my Report Server Project and my Report Builder reports to leverage the same metadata. Is this possible? If so how do I get the connection string?
Thanks!!
-Matt
View 1 Replies
View Related
Feb 28, 2002
Question - is there anyone out there running SQL Server on machines in the 2GB-4GB of RAM Range who has quick sec for a ? The documentation I have found for running SQL Server(native 32bit 2 GB RAM max) on 2GB+ machines is a little confusing (to me) if anyone can answer my question that would be great. I am running Ent SQL Server on WIN2K Adv box with 8 Xeons and 4 GB of RAM. I have enabled the /3GB switch in the boot.ini file but have not enabled AWE memory management in SQL. I have set the MAX amount of RAM avialble to my SQL box at 3GB and SQL Serve appears to be using all of the 3 GB under load. Is this the right way to set this or is there another more efficient way? Any answer explenations would be great. Thanks in advance
PS The server is only a SQL box no other apps / servers are running it.
View 2 Replies
View Related
May 17, 2007
Windows Server 2003
SQL Server 2005 Enterprise SP2
The mirroring wizard insists I enter a fully qualitifeid domain name for my servers. But my servers are not on a domain - I just address them as machinenameinstancename, which the wizard convertrs to TCP://machinename:5022. When I click Start Mirroring it tells me that this is not a FQDN, which is true. How do I make this work?
Cheers,
Mike
View 3 Replies
View Related
Jul 2, 2007
SQL server 2005 developer version
I have about a dozen db's scattered on 3 machines and want to
consolidate all of them on my desktop with the data intact.
What's the easiest, best way to accomplish this?
Can I backup on one and restore on another?
View 6 Replies
View Related
Jul 1, 2006
Hi All,I've been struggling with this for hours...Could someone please advise me on how to convert my current File based SQL Server Express website to a Server based SQL Express one.Particularly interested in what I need to do in the SQL Express management tool, changes I need to make the projecvt itself and changes needed to get IIS to understand things have been changed.Thanks,Martin.
View 1 Replies
View Related
Jan 16, 2004
Hi All,
I have got MSSQL 2000 set up on a machine in my rack at my local telehouse, and a web server set up at home on an ADSL line.
Both servers can see (ping) eachother fine , so you can rule out any kind of connectivity issues straight away, but when i try to get my forum to connect to the mssql database using the correct credentials it just fails saying that the credentials are incorrect ot the server does not exist.
I also installed an SQL database tool on my web server (Shusheng SQL Tool) and attempted to connect to my SQL server using that tool, and got the following message: '[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.'
The server is currently using mixed mode authentication (SQL/Windows) and has both TCP/IP and Named pipes enabled.
Is there some kind of 'Enable remote connections' option in SQL? I need to be able to allow connections to my SQL server from any system, anywhere...
Any ideas?
View 1 Replies
View Related
Nov 4, 1999
Can I write a select statement which will querry from two different machines.
such as select mach1.db1.dbowner.table1.column1, mach2.db2.dbowner.table1.column1 from mach1.db1.dbowner.table1, mach2.dbowner.table2
View 1 Replies
View Related
Jan 25, 2007
Good morning,
I am looking for some first-hand experiences from fellow DBA's where they had SQL Server running on a Win2K3 VM. What sort of issues (or successes) did you find re: resource sharing, swap files, etc? Are there any experiences where using a VM negatively affected your environment?
Thanks so much. What a great forum!
View 5 Replies
View Related
May 1, 2008
Hi,
I'm in the process of designing a system which will have a central internet based SQL Server database, and one or more clients running SQL CE.
If there is more than one client machine running the same software, is it possible to have all these clients use a central SQL CE db on one of the clients? In other words can other machines access a SQL CE running on say a "master" machine? These machines my be in a workgroup or on a domain by the way.
I know I could use a SQL Express db on the master machine, but I'm keen to use SQL CE because of the Sync services dlls that came with VS 2008 (which I believe only work in CE).
Thanks,
Russ
View 3 Replies
View Related
Jul 31, 2007
I have a server with a sqlexpress database on it.
It has 'Allow Remote Connections' checked
It has the Browser Service enabled and started utilizing Surface Area Configuration
It has Local and Remote Connections Using both TCP/IP and named Pipes.
I have used http://support.microsoft.com/kb/914277
And one machine can connect to it fine.. .
but others can't?
Any Ideas?
Casey
View 13 Replies
View Related
Mar 11, 2008
Hi Guys!
I'm trying to find a way to either importexport or synchronise an SQL 2005 db between a local and remote server, is there any way to do this programatically or otherwise? doesn't have to be the entire db, (like just aspnet_users and related tables will do)
Thanks for the help all!
View 3 Replies
View Related
Feb 6, 2002
I am trying to copy DTS Packages and Jobs from two different Servers to one new server. I know I can script the jobs, but they won't run without the DTS packages. I have backed up and restored the MSDB database from Server 1 to my Main server and therefore I have all the jobs from that machine. My problem is how do I get the jobs stored in SERVER 2's MSDB over to my main server without replacing the tables I already have thus losing the jobs and packages that I imported? I have thought about backing up Server 2's MSDB then importing to another database,on the MAIN SERVER and then importing with an append to the 'live" msdb, but I believe the table names are the same and I may end up with duplicate entires. I don't know what problem this will cause. Any suggestions will be great. Thanks in advance
View 1 Replies
View Related
Apr 6, 2001
Hi all. I'm having a strange problem occur - any help would be appreciated. I have a data driven query task that is a part of a much larger package that runs fine and completes successfully if I run it by right-clicking on it and running an 'execute task' on just that individual task. This completes successfully only when I run it from my local machine with the SQL 2000 box registered on it. The task does not complete - or at least runs for as long as I'm willing to wait - if I run it either as part of the entire package or alone, as described above, directly on the SQL 2000(running Win 2000 Advanced). Obviously this is not good because the larger overall package is an integral part of a nightly cycle. Any thoughts?????
View 1 Replies
View Related
Oct 23, 2015
I'm specifically referring to 2008 R2, and TomCat in particular (not sure of the *Nix variant involved), where I was asked if there were any configuration settings on the database side (meaning SQL Server) that can be viewed to show how long a connection to the server, once idle, will last, before it is forcibly closed. I when Googling, but as I'm not very knowledgeable on that topic, I'm not really sure what I'm looking for, and the only results I came across didn't identify what I'm looking for. Of course, it may be that such a config setting doesn't exist, but it would be useful to know how such things are handled.
View 0 Replies
View Related
Jun 17, 2008
Hi,
How do I get a list of sql server 2005 machines from the network please?
Thanks
View 1 Replies
View Related
Feb 22, 2008
What is a good simple way to scan the servers in your network for SQLServers?Does anyone have any scripts or code that would show me how to dothis?I think WMI might be able to do this but don't know where to start.If possible I'd like to be able to get the version (2000 or 2005) ifpossible.Thanks,Kelly GreerJoin Bytes!change nospam to yahoo
View 1 Replies
View Related
Jul 28, 2006
HI,
I've got the folloing scenario:
Client app is a windows forms app on client machine. Web Service on a dev machine (Windows 2003 standard), SQL Server 2000 on a seperate machine. The user logs on to the using their windows login. I'd like to pass these credentials to the web service, have the web service impersonate the user and access the SQL Server with these credentials... not a problem I thought.
Setup windows integrated login on IIS for the web service, impersonate="true" in the web.config, Mixed mode on the SQL server. Passed the network credentials through to the Web Service, and this works correctly, however when the web service (impersonating the user) tries to access the SQL Server, I get the message about access denied, user is null, blah, blah. (if remote access the Web Service box, and call the web service locally, all works well, and voila, until the thread recycles, the client machine access also works... same user/pass)..
I've seen various posts about this but nothing seems to solve the problem. Am I right in thinking that this method (Windows integrated login) of passing credentials through to the SQL Server is the best method? If so... er, shouldn't it work? What am I doing wrong here? and if it doesn't work, what other method would work?
I've just about given up on this and thinking of passing the SQL Server Username/Password across the network (shudder), encrypted yes, but not ideal!
Anyone got any idea?
Regards
Kevin
View 4 Replies
View Related
Jul 31, 2007
Hi,
My Reportserver Homepage is http://d620xp/Reports
Requirement is that Users should be able to view all the reports from this URL( from their Desktops)
What are the steps I need to do, to get this ?
Thanks in Advance,
Sundar
View 9 Replies
View Related
Sep 21, 2015
I have an SQL2012instance  running.Â
I create a sql user who is part of sysadmin, securityadmin, setupadmin and serveradmin roles.Â
When I try to connect through odbc using this user from other machines, it works fine. But if I remove it from sysadmin, I get an error message Connection Failed:Â
SQLState : '28000'
SQL Server Error: 18456
[Microsoft][SQL Server Native Client 11.0][SQL Server][Login Failed for user:user1]
View 6 Replies
View Related
