View Complete Post
Anyone know what I am doing wrong here?
When the DBP (Database Publishing Wizard) starts it wants either a connection string or a server. I enter the name of my server (I am running SQL 2008 R2, locally) and I get the list of databases that are on my server. Great, it's all there including
Northwind and my database which is being regularily used by a localhost website. Yet, selecting my database, I get this (I did not find the answer at the link):
TITLE: Microsoft SQL Server
This wizard will close because it encountered the following error:
For help, click:
Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=220.127.116.11, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its de
Marty Wasznicky and Scott Zimmerman
MSDN Magazine May 2007
Trying to copy a SQL2000 database on server TUNA to destination server MOJITO which runs default instance of SQL2008 (at ServicePack1) via the CD Wizard. Resulting job fails on MOJITO with this in application log:
SQL Server Scheduled Job 'CopyDatabaseWizard_TUNA_MOJITO_1' (0x64AB69F2880A7E4DA3708546C33DFF40) - Status: Failed - Invoked on: 2010-09-23 17:05:04 - Message: The job failed. Unable to determine if the owner (CBMIWEB\johna) of job CopyDatabaseWizard_TUNA_MOJITO_1
has server access (reason: Could not obtain information about Windows NT group/user 'CBMIWEB\johna', error code 0x5. [SQLSTATE 42000] (Error 15404)).
There is a credential on MOJITO defined for CBMIWEB\johna. There is a proxy on MOJITO that uses that credential. The job has one step and in the properties I have set the RUN AS value for the job to be the name of the Proxy. The proxy is established for
The "owner" of the job is also CBMIWEB\johna which is a domain userid in the local Administrators group of each machine (both TUNA and MOJITO). This userid has been granted the permission to
Logon as a Batch Job on both servers.
TUNA is a Windows 2000 standalone server; MOJITO is Windows 2003. I can logon to each server as CBMIWEB\johna.
I don't know what else to do.
Let's start a very intresting thread here:
As you all know moving the database from one server(2000, 2005, 2008) to (2000, 20005, 20008) is not a big deal and can be done in many ways like backup-restore, attcah-detach, and most easy (some time very complex:-)).
Here i wanna discuss an issue which i have faced.
I have two instances of SQL server 2008, i have created a new database Test in one instance, created few logins and mapped to Test database with some permissions for this Test database.
Now i used copy database wizard to copy this test database to other instance, i sucessfully went through the wizard and selected SQL server object method to copy the Test database in other instance then i followed the remaing wizard, i selected the logins which i have created for the Test database and finnaly i reached the finish button i clicked finished and the copy of database completed sucessfully. I verified that Test dabase was there in other instance with the logins which i have created. So easy i was happy:-)
Problem: Some other day i wanted to copy AdventureWork database to the other instance of SQl server i was happy that its a very easy task i followed the same steps above(to copy the Test database ) and every thing went in the same way and i clicked finish to complete the wizard it took some time
We turned on the Office SharePoint Server Publishing Infrastructure feature on our MOSS 2007 (after we already had sites created) to allow users to be able to use features like excel services and reporting which both require this be activated the Publishing
feature to be turned on, In order to do this you have to activate the Office SharePoint Server Publishing Infrastructure feature at I beleive the top level site, however when we activate this feature it changes the templates and navigation
for all the existing SharePoint sites in our collection.
Is there a way to turn this feature on with out impacting existing site sites? Or am I doing something wrong that is causing this to happen? Basically I need to know how I can activate this option (Office SharePoint Server
Publishing Infrastructure) to just specific sites but not all or turn it on so it does not impact all sites?
In my Visual Studio 2008 web site, I created a new folder named Reporting. Then one of my web pages creates an xml file in this new folder when the user clicks a button. The user then clicks another button and the xml file displays in the browser. This all works fine on my development PC.
But if I publish this web site to my production server, it does not work. I get an error when I click the first button to create my xml file. The error reads:
Could not find part of the path 'c:\windows\system32\inetsrv\Reporting\abc.xml'
What must I do so that this works on my development PC and also my production server?
I'm trying to setup SSRS using the Reporting Services Configuration Manager. Everything seems to be working except the database creation. When I click on the Database (3rd option down) then Change Database I run through the wizard. Put
in proper SA credentials. Accept the defaults clicking next through and when it gets to running the script to create the data base I get the Error I pasted below. We do not have a G drive so I went into SSMS and changed the Default Database settings
to point to the F drive (where our other DBs reside) - I got that tip off of this forum but it didn't fix my issue. Any ideas what to try next? Do I need to stop and restart a service or something? Thanks for any help you guys can offer.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)