Showing posts with label security. Show all posts
Showing posts with label security. Show all posts

Wednesday, March 7, 2012

Another 17055 error problem

After applying some updates (root certificate,jet4.0 SP8
and security updates 810217,828749and 824145), I now get
the following error:
18454 :
Login succeeded for user '<user name>_SQL'. Connection:
Non-Trusted.
Where <user name> is the login name.
We are running SQL2000. Permissions are set for Windows
and SQL.
Any thoughts?That just looks like you have Auditing set to either Success or All. You can
check this by looking at the Security Tab on the Server Properies dialog.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Bob" <anonymous@.discussions.microsoft.com> wrote in message
news:955c01c3ea8c$b7036580$a001280a@.phx.gbl...
quote:

> After applying some updates (root certificate,jet4.0 SP8
> and security updates 810217,828749and 824145), I now get
> the following error:
> 18454 :
> Login succeeded for user '<user name>_SQL'. Connection:
> Non-Trusted.
> Where <user name> is the login name.
> We are running SQL2000. Permissions are set for Windows
> and SQL.
> Any thoughts?
|||Those are now off and it made no change. I have turned
off the information also and that stops the log from
filling up. But it does not stop the problem.
Thanks
quote:

>--Original Message--
>That just looks like you have Auditing set to either

Success or All. You can
quote:

>check this by looking at the Security Tab on the Server

Properies dialog.
quote:

>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"Bob" <anonymous@.discussions.microsoft.com> wrote in

message
quote:

>news:955c01c3ea8c$b7036580$a001280a@.phx.gbl...
>
>.
>
|||I'm not quite sure what you mean by "I have turned off the information also"
?
Changing the audit setting requires a restart of the service I think to take
effect
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:932701c3eac2$bc05d640$a301280a@.phx.gbl...[QUOTE]
> Those are now off and it made no change. I have turned
> off the information also and that stops the log from
> filling up. But it does not stop the problem.
> Thanks
>
> Success or All. You can
> Properies dialog.
> message|||I meant in the filter settings is where I turned those
off.
quote:

>--Original Message--
>I'm not quite sure what you mean by "I have turned off

the information also"
quote:

>?
>Changing the audit setting requires a restart of the

service I think to take
quote:

>effect
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
><anonymous@.discussions.microsoft.com> wrote in message
>news:932701c3eac2$bc05d640$a301280a@.phx.gbl...
SP8[QUOTE]
get[QUOTE]
Connection:[QUOTE]
Windows[QUOTE]
>
>.
>

Saturday, February 25, 2012

Announcing a GUI tool for configuring dialog security and routing

Hi,

I am not

able to get “Service Broker” under my database? Can you tell me what is wrong

with my installation?

Regards,

If you are using SQL Server Management Studio Express, it does not have the functionality to view or create Service Broker objects. The paid version of the same lets you view Service Broker objects but not create them. Unfortunately, the only way to create, alter and use Service Broker objects is via T-SQL commands. Please look at the Service Broker section of Books Online, the SQL Server online documentation on MSDN.

Thursday, February 16, 2012

Analysis Svc security problem

Hi All
Whether I set roles or non at all to my cubes ANY user can
connect and read data from them via excel.
Is this a known issue? Anyone else having this problem or
am I doing something wrong?
Thanks
JHi,
The Users can access the Cubes by any means, only if they have enough access
rights to the Cube.
Check whether you have added "Everyone" in the Cube Roles mistakenly or whet
her "Everyone" has been added to the System Administrator group or OLAP Admi
nistrator group.
Cheers,
Sanka
-- J wrote: --
Hi All
Whether I set roles or non at all to my cubes ANY user can
connect and read data from them via excel.
Is this a known issue? Anyone else having this problem or
am I doing something wrong?
Thanks
J

Sunday, February 12, 2012

Analysis Services Deployment Security Issue

We have been working on moving our database from SQL2000 to 2003 the last couple of months. We are now working on our cube migration and have attempted a few deployments. The problem is, every time we try to process the deployed cube it gives us the following error:

The following system error occurred: Logon failure: unknown user name or bad password.

We only have one connection in this deployment and have tried with various cubes all the way down to one dimension.

Our connection always tests successfully on the dialog box itself, we have attempted both, windows and SQL authentication, and both always yield the same error.

Up to this point we have not able to process any cube we have attempted.

As far as I can tell our SQL and Analysis services both are set to the same instance name, but I’m thinking this may be a configuration issue, since it seems that internally Analysis services just cant contact SQL services.

Anyone has an idea of what may be wrong with the configuration?

Have you tried setting the Impersonation Information to Default, and including the user name and password in the connect string?|||Hmm, I had not tried that. Attempted it now and it worked.

This solves my problem but now I question why would the other settings not work?