Showing posts with label machine. Show all posts
Showing posts with label machine. Show all posts

Friday, March 30, 2012

Invisible controls durig runtime

Hi,
Do you know why when I run my ssis packages in the dev machine, the diagrams are not visible during run time.
I can design the package but not sure why when I start the package, the diagrams in the control flow can not be viewed.
Please note that if I do this on the server, I can see the diagrams during run time.

Thanks

The controls or the diagram indicating the control/data flows? You change nouns between the subject and the body of this post. ("controls" versus "diagrams")

If the latter, are you sure you don't just need to scroll to the left, up, down, or to the right to see them?|||

Hi,

I mean the controls such as flat file source, ...

Thanks

Friday, March 23, 2012

Invalid Object Name 'OlapObjects'

We are using Microsoft Analysis Service with SP3 on Microsoft SQL Server. The Repository has been migrated to SQL server on the same machine. Recently for no reason, using Microsoft Analysis Manager, we would unable to log in to the repository. We have tried to do reinstallation of the Analysis Service component. After which when using local Analysis Manager to connect, it would show "Cannot connect to the repository. Analysis server: WEBTEST. Error: Not a valid account name or password."

Local Repository Connection String then was: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Analysis Services\Bin\msmdrep.mdb

After confirming that the repository has been moved to SQL server, we changed the repository connection string to the following:

Local Repository Connection String:

Provider=SQLOLEDB.1;Password=sa_password;Persist Security Info=True;User ID=sa;Initial Catalog=DataMart; Data Source=WEBTEST;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=WEBTEST; Use Encryption for Data=False;Tag with column collation when possible=False

where DataMart was the database for the Analysis Service repository and WEBTEST is the server name.

After which when using local Analysis Manager to connect, it would show error "Invalid Object Name 'OlapObjects'".

Interestingly, when the Analysis Services component was just installed, the sample Food Mart also did not displayed.

Please advise on how to solve the problem, thank you.

It sounds as if something went wrong during migration. The error message makes me believe the OlapObjects table does not exist in the DataMart database. I would double-check the contents of this database. It should contain a Server table and an OlapObjects table.

Wednesday, March 7, 2012

Invalid attribute/option identifier - SQL Server 2000 SP2

From the Enterprise Manager on the server machine, we saw a disconnection to
a SQL Server Group. The SQL Server is running and the client worksations are
able to run applications against the databases. We got the following error,
Invalid attribute/option identifier when trying to register a new server.
Any help would be appricated. EliHi
If I were you, I would apply SQL Server SP3a or SP4 immediately to your
installation.
Ever heard of the virus "slammer"? You are seriously exposed.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Eli Feng" <efeng@.kerisys.com> wrote in message
news:OXXfLx6%23FHA.1248@.TK2MSFTNGP14.phx.gbl...
> From the Enterprise Manager on the server machine, we saw a disconnection
> to
> a SQL Server Group. The SQL Server is running and the client worksations
> are
> able to run applications against the databases. We got the following
> error,
> Invalid attribute/option identifier when trying to register a new server.
> Any help would be appricated. Eli
>|||Mike,
Have fixed the issue. Thanks for your reminder. Will have it updated with
SP4 very soon.
Best Regards,
Eli
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uiKhoT$%23FHA.1256@.TK2MSFTNGP15.phx.gbl...
> Hi
> If I were you, I would apply SQL Server SP3a or SP4 immediately to your
> installation.
> Ever heard of the virus "slammer"? You are seriously exposed.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Eli Feng" <efeng@.kerisys.com> wrote in message
> news:OXXfLx6%23FHA.1248@.TK2MSFTNGP14.phx.gbl...
disconnection[vbcol=seagreen]
server.[vbcol=seagreen]
>|||Hi Eli,
I have the same problem. Can you tell me how you solve this problem?
Thanks in advance,
Patrick
"Eli Feng" wrote:

> Mike,
> Have fixed the issue. Thanks for your reminder. Will have it updated with
> SP4 very soon.
> Best Regards,
> Eli
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:uiKhoT$%23FHA.1256@.TK2MSFTNGP15.phx.gbl...
> disconnection
> server.
>
>

Invalid attribute/option identifier - SQL Server 2000 SP2

From the Enterprise Manager on the server machine, we saw a disconnection to
a SQL Server Group. The SQL Server is running and the client worksations are
able to run applications against the databases. We got the following error,
Invalid attribute/option identifier when trying to register a new server.
Any help would be appricated. EliHi
If I were you, I would apply SQL Server SP3a or SP4 immediately to your
installation.
Ever heard of the virus "slammer"? You are seriously exposed.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Eli Feng" <efeng@.kerisys.com> wrote in message
news:OXXfLx6%23FHA.1248@.TK2MSFTNGP14.phx.gbl...
> From the Enterprise Manager on the server machine, we saw a disconnection
> to
> a SQL Server Group. The SQL Server is running and the client worksations
> are
> able to run applications against the databases. We got the following
> error,
> Invalid attribute/option identifier when trying to register a new server.
> Any help would be appricated. Eli
>|||Mike,
Have fixed the issue. Thanks for your reminder. Will have it updated with
SP4 very soon.
Best Regards,
Eli
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uiKhoT$%23FHA.1256@.TK2MSFTNGP15.phx.gbl...
> Hi
> If I were you, I would apply SQL Server SP3a or SP4 immediately to your
> installation.
> Ever heard of the virus "slammer"? You are seriously exposed.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Eli Feng" <efeng@.kerisys.com> wrote in message
> news:OXXfLx6%23FHA.1248@.TK2MSFTNGP14.phx.gbl...
> > From the Enterprise Manager on the server machine, we saw a
disconnection
> > to
> > a SQL Server Group. The SQL Server is running and the client worksations
> > are
> > able to run applications against the databases. We got the following
> > error,
> > Invalid attribute/option identifier when trying to register a new
server.
> > Any help would be appricated. Eli
> >
> >
>|||Hi Eli,
I have the same problem. Can you tell me how you solve this problem?
Thanks in advance,
Patrick
"Eli Feng" wrote:
> Mike,
> Have fixed the issue. Thanks for your reminder. Will have it updated with
> SP4 very soon.
> Best Regards,
> Eli
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:uiKhoT$%23FHA.1256@.TK2MSFTNGP15.phx.gbl...
> > Hi
> >
> > If I were you, I would apply SQL Server SP3a or SP4 immediately to your
> > installation.
> > Ever heard of the virus "slammer"? You are seriously exposed.
> >
> > Regards
> > --
> > Mike Epprecht, Microsoft SQL Server MVP
> > Zurich, Switzerland
> >
> > IM: mike@.epprecht.net
> >
> > MVP Program: http://www.microsoft.com/mvp
> >
> > Blog: http://www.msmvps.com/epprecht/
> >
> > "Eli Feng" <efeng@.kerisys.com> wrote in message
> > news:OXXfLx6%23FHA.1248@.TK2MSFTNGP14.phx.gbl...
> > > From the Enterprise Manager on the server machine, we saw a
> disconnection
> > > to
> > > a SQL Server Group. The SQL Server is running and the client worksations
> > > are
> > > able to run applications against the databases. We got the following
> > > error,
> > > Invalid attribute/option identifier when trying to register a new
> server.
> > > Any help would be appricated. Eli
> > >
> > >
> >
> >
>
>

Invalid attribute/option identifier - SQL Server 2000 SP2

From the Enterprise Manager on the server machine, we saw a disconnection to
a SQL Server Group. The SQL Server is running and the client worksations are
able to run applications against the databases. We got the following error,
Invalid attribute/option identifier when trying to register a new server.
Any help would be appricated. Eli
Hi
If I were you, I would apply SQL Server SP3a or SP4 immediately to your
installation.
Ever heard of the virus "slammer"? You are seriously exposed.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Eli Feng" <efeng@.kerisys.com> wrote in message
news:OXXfLx6%23FHA.1248@.TK2MSFTNGP14.phx.gbl...
> From the Enterprise Manager on the server machine, we saw a disconnection
> to
> a SQL Server Group. The SQL Server is running and the client worksations
> are
> able to run applications against the databases. We got the following
> error,
> Invalid attribute/option identifier when trying to register a new server.
> Any help would be appricated. Eli
>
|||Mike,
Have fixed the issue. Thanks for your reminder. Will have it updated with
SP4 very soon.
Best Regards,
Eli
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uiKhoT$%23FHA.1256@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Hi
> If I were you, I would apply SQL Server SP3a or SP4 immediately to your
> installation.
> Ever heard of the virus "slammer"? You are seriously exposed.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Eli Feng" <efeng@.kerisys.com> wrote in message
> news:OXXfLx6%23FHA.1248@.TK2MSFTNGP14.phx.gbl...
disconnection[vbcol=seagreen]
server.
>
|||Hi Eli,
I have the same problem. Can you tell me how you solve this problem?
Thanks in advance,
Patrick
"Eli Feng" wrote:

> Mike,
> Have fixed the issue. Thanks for your reminder. Will have it updated with
> SP4 very soon.
> Best Regards,
> Eli
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:uiKhoT$%23FHA.1256@.TK2MSFTNGP15.phx.gbl...
> disconnection
> server.
>
>