Error Locating Server/Instance

Hi All, i'm using Sql Server 2005 Standard, IIS 6.0 an Windows 2003 Server.
I deployed my project on IIS (Default web site) everything goes well, but i created new web site on IIS called MCSite and deplyed here same project as to Default web site. I navigate to project on new web site, the login screen show, i've inserted credentials(credentials to application not to SQL Server!!) and try to login, then an error message show: error 26:Error Locating Server/Instance.

Can someone help me what to do with that?
Thank you very muchCan you send connection string which you r using

thanks|||A quick Google of the error message you listed revealed numerous causes and solutions to the problem. Rather than list them all here, I request you try Google first and come back if you are still having the issue.

Error in MSDE Toolkit

Hello,
I am using the MSDE deployment Toolkit (RC) to deploy my application. I have my application, the setup project and the installer project in my solution. The installer project has embedded sql files for database creation and dropping only (which I create
d using the enterprise manager). Now when I run the setup, MSDE installs fine but during my applications setup I get the following error message:
"An exception occured in the OnAfterInstall event handler of PostInstall.CustomInstallActions. --> Value cannot be null."
I looked on web but couldnt really find anything about this error message.
Please suggest something. I wanted to post the SQL here but the message reached it's max count.
Thanks
dev
Hello dev,
Did you write the code that is running in the OnAfterInstall event? Or are
you using the sample code that comes with the Toolkit?
Can you post the code you're using? I don't need to seee the SQL at this
point.
Cheers,
Brian A. Randell
MCW Technologies
"Dev" <anonymous@.discussions.microsoft.com> wrote in message
news:E029D919-F1F8-42B8-B985-1691B9DC6658@.microsoft.com...
> Hello,
> I am using the MSDE deployment Toolkit (RC) to deploy my application. I
have my application, the setup project and the installer project in my
solution. The installer project has embedded sql files for database
creation and dropping only (which I created using the enterprise manager).
Now when I run the setup, MSDE installs fine but during my applications
setup I get the following error message:
> "An exception occured in the OnAfterInstall event handler of
PostInstall.CustomInstallActions. --> Value cannot be null."
> I looked on web but couldnt really find anything about this error message.
> Please suggest something. I wanted to post the SQL here but the message
reached it's max count.
> Thanks
> dev

Error in Metadata manager when trying to open calculations

Having an issue when I try to open the calculations tab in BIDS against an OLAP database or a MSAS project. BIDS hangs for a second than comes back with an "unexpected errror" in the middle of the screen and then shuts down. If I check the event viewer I get

Errors in the metadata manager. The configuration property updates were not persisted. Internal error: An unexpected exception occured

I can access every other tab in the project, just not the calculations tab.

Anyone run into this before?

Thanks

FJK,

I think I read some time ago that you could get this message if you have different msolap90.dll installed on your PC in different folders. Could you search for this dll on your PC and if different version found, try to replace dll to match.

Vidas Matelis

Error in Deployment SSAS Project

Hi all,

I am getting an error while deploying an Analysis services project to my local server.

The error is as follows:

"Internal error: An unexpected exception occured."

I have no idea what this error refers to.....

Regards...

Girija Shankar

Hi,

I encountered this error before.

you should be able to see the detailed erroe message which you can discover from 'Event Viewer'.

Probably you have not started up your Analysis services server (you may want to look at if your analysis services has started up and if not, restart it and deploy your cube again).

Hope it helps.

With best regards,

Yours sincerely,

Error in Deploying an Analysis Services Project

Hi,

I am trying to deploy an Analysis Project and I get the error:

Error 1 The Description element at line 292, column 29 (namespace http://schemas.microsoft.com/analysisservices/2003/engine) cannot appear under Envelope/Body/Execute/Command/Batch/Alter/ObjectDefinition/Database/Cubes/Cube/Dimensions/Dimension. 0 0

Any idea?

Thanks in advance,

--Dimitris Doukas

Hi,

This is a defect that will be addressed in the service pack(s); meanwhile, to work around it, please do the followings:

- open each cube editor and, in the first tab (Cube Structure), check each cube dimension if it has a Description set

- remove all those Descriptions (by just specifying an empty string there) and then re-deploy

Adrian.

|||

Hi Adrian,

Thanks for the hint. Actually I had to edit the XML file to erase the description clause. If you just empty the string from the BI Studio if doesn't work.

Regards,

--DImitris Doukas

Error immediately on creating new Integration Services project in VS2005

I am creating my first Integration Services project and am getting an
error immediately after creating the project. The error is in the
designer and it displays a red X, saying "Microsoft Visual Studio is
unable to load this document: Object reference not set to an instance
of an object". Clicking on the error in the error window just opens up
the xml file which contains the following:

<?xml version="1.0"?><DTS:Executable xmlnsTS="www.microsoft.com/
SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTSroperty
DTS:Name="PackageFormatVersion">2</DTSroperty><DTSroperty
DTS:Name="VersionComments"></DTSroperty><DTSroperty
DTS:Name="CreatorName">BNHO1\mbell</DTSroperty><DTSroperty
DTS:Name="CreatorComputerName">BT4WKS1361</DTSroperty><DTSroperty
DTS:Name="CreationDate" DTSataType="7">8/14/2007 12:22:35 PM</
DTSroperty><DTSroperty DTS:Name="PackageType">5</
DTSroperty><DTSroperty DTS:Name="ProtectionLevel">1</
DTSroperty><DTSroperty DTS:Name="MaxConcurrentExecutables">-1</
DTSroperty><DTSroperty DTS:Name="PackagePriorityClass">0</
DTSroperty><DTSroperty DTS:Name="VersionMajor">1</
DTSroperty><DTSroperty DTS:Name="VersionMinor">0</
DTSroperty><DTSroperty DTS:Name="VersionBuild">0</
DTSroperty><DTSroperty
DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
DTSroperty><DTSroperty DTS:Name="EnableConfig">0</
DTSroperty><DTSroperty DTS:Name="CheckpointFileName"></
DTSroperty><DTSroperty DTS:Name="SaveCheckpoints">0</
DTSroperty><DTSroperty DTS:Name="CheckpointUsage">0</
DTSroperty><DTSroperty DTS:Name="SuppressConfigurationWarnings">0</
DTSroperty><DTSroperty DTS:Name="ForceExecValue">0</
DTSroperty><DTSroperty DTS:Name="ExecValue" DTSataType="3">0</
DTSroperty><DTSroperty DTS:Name="ForceExecutionResult">-1</
DTSroperty><DTSroperty DTS:Name="Disabled">0</
DTSroperty><DTSroperty DTS:Name="FailPackageOnFailure">0</
DTSroperty><DTSroperty DTS:Name="FailParentOnFailure">0</
DTSroperty><DTSroperty DTS:Name="MaxErrorCount">1</
DTSroperty><DTSroperty DTS:Name="ISOLevel">1048576</
DTSroperty><DTSroperty DTS:Name="LocaleID">4105</
DTSroperty><DTSroperty DTS:Name="TransactionOption">1</
DTSroperty><DTSroperty DTS:Name="DelayValidation">0</DTSroperty>
<DTS:LoggingOptions><DTSroperty DTS:Name="LoggingMode">0</
DTSroperty><DTSroperty DTS:Name="FilterKind">1</
DTSroperty><DTSroperty DTS:Name="EventFilter" DTSataType="8"></
DTSroperty></DTS:LoggingOptions><DTSroperty
DTS:Name="ObjectName">Package</DTSroperty><DTSroperty
DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
DTSroperty><DTSroperty DTS:Name="Description"></
DTSroperty><DTSroperty DTS:Name="CreationName">MSDTS.Package.1</
DTSroperty><DTSroperty DTS:Name="DisableEventHandlers">0</
DTSroperty></DTS:Executable>

I have VS2005 SP1, running WindowsXP SP2. Integration Services is
running on my machine, but I would think that this shouldn't matter
anyway as the error is happening before I have even indicated and data
source to use. If I take this xml file with the error and copy it to another new SSIS project on another machine, it works fine. Reinstalling VS2005 had no effect. I am now reinstalling SQL Server 2005 SP2 to see what effect that may have.

Any ideas?

Thanks,
MarcusTry searching, but in the mean time:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1627891&SiteID=1|||Thanks for the link. I have seen that one, and I tried re-registering the xml dlls, but that didn't do anything. Hopefully after my reinstall of Sql Server things will be better.

Marcus
|||

Well that was disappointing. After the SQL Server reinstall and adding SP2 there is no change with my problem. >>HEAVY SIGH!<<. I think it is time to call MS...unless any other ideas?!?!?!?

Marcus

|||

Anybody?

M.