Showing posts with label environment. Show all posts
Showing posts with label environment. Show all posts

Thursday, March 29, 2012

Changing the SQL Server Service Account

I have a SQL 2000 (SP3) running on a Windows NT 4.0 (SP6) box used in our test environment. The SQL Server was configured to run under the local system account before I got here. In an effort to standardize things, I tried changing the SQL Service account to run under a designated domain user account purpose built for the job. We use this particular account for all of our new-build servers (which are W2K). This domain account is configured to be a "Power User" on the NT 4.0 Server in question.

Soon after changing things over to run under the new account, all the developers complained that they could no longer connect to the server. I could through QA and EM, but none of the developers could.

The developers are using WebLogic and JDBC drivers for the most part. I wasn't aware that the SQL Server service account affected client connectivity. Was I wrong or is there something else at work here?

Thanks,

hmscottDamn...I'm dealing with something similar right now...

The SSSA run things on behalf of the server...

My guess is that they all connect using sa blank (or whatever, connection pooling id and are still connectiong using sql server auth) and now that it's trusted, their connections are wrong...

How do they connect?

Like when you register a server in EM?

I don't think the service account has anything to do with it...

MOO|||Hi Brett,

They're connecting via various user accounts that are application-specific. Unfortunately, I am only beginning to make progress on convincing management to swing to all trusted connections. The developers insist that WebLogic doesn't support the concept of running under a service account.

Anyway, one guy was using sa, others were using different application accounts. I was able to connect successfully using a trusted connection (but then, I'm a Domain Admin, too, so there's no telling for sure.

It's far from an ideal setup; I'm just trying to correct things bit by bit.

Regards,

Hugh|||Hi Brett,
The developers insist that WebLogic doesn't support the concept of running under a service account.

That may be true...we use websphere and we set a connection pooling account that authenticates through sql server...but it's 1 id and many connections

Anyway, one guy was using sa
Hugh

There's always one...

Still no one is using the SSSA to connect...right?|||No, no one is using that account. I'm sure because the pasword is quite complex and other than being documented in a restricted folder for the DBAs, it's not known.

Thanks for your time...

Regards,

hmscott

Sunday, March 25, 2012

Changing the language in the Report Builder interface

Hi @. all,

I work on a german Windows environment and use the Report Builder. For showing details in their it is necessary to switch the German interface in Report Builder into English.

I already tried to change my environment into English but it even after a restart it did not change the Report Builder interface....
I also tried to search all the XML-files for a language setting - with no success....

Does anyone know how to do this? Would be very helpful....!

Thanks in advance,

Jochen

Schliff, in your report click an empty area then go to the properties window and there is a language settings-this allows you to set your language preference.

|||

First: thanks for the answer :-)

Second: it does not work ;-(

Maybe my explanation wasn't precise enough: I'm talking about the Report Builder on the Report Server, which is controlled and used via Internet Explorer....

Are we talking about the same or did I misunderstood something?

Jochen

|||

So let me get this..

you have a report, which is published in german but you want to view the published report in english...

if so cant you just go to Tools and Options and select English as the language in IE?

|||

Well - that works excellent!

Sometimes solutions are that easy - hard to believe that one does not try these first

Thank you very much, great work....

Jochen

sql

Monday, March 19, 2012

Changing SQL Server configuration in a cluster environment

I running SQL Server on a Windows active passive cluster and need to change
SQL Server configuration. If I change the configuration thru the virtual ser
ver the change is applied to the active node what happens to the passive nod
e? Is it necessary for me t
o failover and apply the change there too?Hi
Most configuration settings are stored in Master, which is shared.
If is recommended to fail over to the other nodes after you make a
configuration change as a test, you don't want to find out weeks down the
line that the failover failed because of a setting that was not identical on
all nodes.
There area a few settings in the registry under
" HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer", especially
" HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer" where
settings like LoginMode, AuditLevel and ListenOn are stored.
Cheers
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
Specialist SQL Server Solutions and Consulting
MVP Program: http://www.microsoft.com/mvp
"Jerrick D.H" <JerrickDH@.discussions.microsoft.com> wrote in message
news:301F2959-3BC0-4E96-8F55-838AC4813BA3@.microsoft.com...
> I running SQL Server on a Windows active passive cluster and need to
change SQL Server configuration. If I change the configuration thru the
virtual server the change is applied to the active node what happens to the
passive node? Is it necessary for me to failover and apply the change there
too?|||Your're so right about that.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Most configuration settings are stored in Master, which is shared.
> If is recommended to fail over to the other nodes after you make a
> configuration change as a test, you don't want to find out weeks down the
> line that the failover failed because of a setting that was not identical
on
> all nodes.
> There area a few settings in the registry under
> " HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer", especially
> " HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer" where
> settings like LoginMode, AuditLevel and ListenOn are stored.
> Cheers
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Epprecht Consulting (PTY) LTD
> Johannesburg, South Africa
> Mobile: +27-82-552-0268
> IM: mike@.epprecht.net
> Specialist SQL Server Solutions and Consulting
> MVP Program: http://www.microsoft.com/mvp
> "Jerrick D.H" <JerrickDH@.discussions.microsoft.com> wrote in message
> news:301F2959-3BC0-4E96-8F55-838AC4813BA3@.microsoft.com...
> change SQL Server configuration. If I change the configuration thru the
> virtual server the change is applied to the active node what happens to th
e
> passive node? Is it necessary for me to failover and apply the change ther
e
> too?
>
>

Changing SQL Server configuration in a cluster environment

I running SQL Server on a Windows active passive cluster and need to change SQL Server configuration. If I change the configuration thru the virtual server the change is applied to the active node what happens to the passive node? Is it necessary for me t
o failover and apply the change there too?
Hi
Most configuration settings are stored in Master, which is shared.
If is recommended to fail over to the other nodes after you make a
configuration change as a test, you don't want to find out weeks down the
line that the failover failed because of a setting that was not identical on
all nodes.
There area a few settings in the registry under
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer ", especially
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer \MSSQLServer" where
settings like LoginMode, AuditLevel and ListenOn are stored.
Cheers
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
Specialist SQL Server Solutions and Consulting
MVP Program: http://www.microsoft.com/mvp
"Jerrick D.H" <JerrickDH@.discussions.microsoft.com> wrote in message
news:301F2959-3BC0-4E96-8F55-838AC4813BA3@.microsoft.com...
> I running SQL Server on a Windows active passive cluster and need to
change SQL Server configuration. If I change the configuration thru the
virtual server the change is applied to the active node what happens to the
passive node? Is it necessary for me to failover and apply the change there
too?
|||Your're so right about that.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Most configuration settings are stored in Master, which is shared.
> If is recommended to fail over to the other nodes after you make a
> configuration change as a test, you don't want to find out weeks down the
> line that the failover failed because of a setting that was not identical on
> all nodes.
> There area a few settings in the registry under
> "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer ", especially
> "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer \MSSQLServer" where
> settings like LoginMode, AuditLevel and ListenOn are stored.
> Cheers
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Epprecht Consulting (PTY) LTD
> Johannesburg, South Africa
> Mobile: +27-82-552-0268
> IM: mike@.epprecht.net
> Specialist SQL Server Solutions and Consulting
> MVP Program: http://www.microsoft.com/mvp
> "Jerrick D.H" <JerrickDH@.discussions.microsoft.com> wrote in message
> news:301F2959-3BC0-4E96-8F55-838AC4813BA3@.microsoft.com...
> change SQL Server configuration. If I change the configuration thru the
> virtual server the change is applied to the active node what happens to the
> passive node? Is it necessary for me to failover and apply the change there
> too?
>
>

Sunday, March 11, 2012

Changing Security Access

I need to change the security access policy in my environment. We are
consolidating several older servers for licensing considerations and
we want to change our security to a group based security where
possible. I've created the groups that are required and gave it a go
on on of our servers.
Needless to say many jobs began to break - some were expected because
we didn't have any documentation for the accounts.
What is the best way to execute such a change. Can someone direct me
to resources for auditing security in SQL i.e. account names and what
they're priveleges are so I can effectively make the changes that I
want with minimal disruption.
Any pointer or gotchas are welcome.
Hi
You can query syspermissions in SQL 2000 and sys.database_permissions in
SQL 2005 to get what permissions have been granted or denied to a specific
group/user
e.g.
select o.name, u.name, p.actadd,
CASE WHEN p.actadd & 1 = 1 THEN 'Select' END AS [Select Permission Granted],
CASE WHEN p.actadd & 2 = 2 THEN 'Update' END AS [Update Permission Granted],
CASE WHEN p.actadd & 4 = 4 THEN 'DRI' END AS [DRI Permission Granted],
CASE WHEN p.actadd & 8 = 8 THEN 'Insert' END AS [Insert Permission Granted],
CASE WHEN p.actadd & 16 = 16 THEN 'Delete' END AS [Delete Permission Granted],
CASE WHEN p.actadd & 32 = 23 THEN 'Execute' END AS [Exec Permission Granted],
p.*
from syspermissions p
join sysusers u on p.grantee = u.uid
join sysobjects o on o.id = p.id
ORDER BY o.name
John
"NC3" wrote:

> I need to change the security access policy in my environment. We are
> consolidating several older servers for licensing considerations and
> we want to change our security to a group based security where
> possible. I've created the groups that are required and gave it a go
> on on of our servers.
> Needless to say many jobs began to break - some were expected because
> we didn't have any documentation for the accounts.
> What is the best way to execute such a change. Can someone direct me
> to resources for auditing security in SQL i.e. account names and what
> they're priveleges are so I can effectively make the changes that I
> want with minimal disruption.
> Any pointer or gotchas are welcome.
>

Changing Security Access

I need to change the security access policy in my environment. We are
consolidating several older servers for licensing considerations and
we want to change our security to a group based security where
possible. I've created the groups that are required and gave it a go
on on of our servers.
Needless to say many jobs began to break - some were expected because
we didn't have any documentation for the accounts.
What is the best way to execute such a change. Can someone direct me
to resources for auditing security in SQL i.e. account names and what
they're priveleges are so I can effectively make the changes that I
want with minimal disruption.
Any pointer or gotchas are welcome.Hi
You can query syspermissions in SQL 2000 and sys.database_permissions in
SQL 2005 to get what permissions have been granted or denied to a specific
group/user
e.g.
select o.name, u.name, p.actadd,
CASE WHEN p.actadd & 1 = 1 THEN 'Select' END AS [Select Permission Granted],
CASE WHEN p.actadd & 2 = 2 THEN 'Update' END AS [Update Permission Granted],
CASE WHEN p.actadd & 4 = 4 THEN 'DRI' END AS [DRI Permission Granted],
CASE WHEN p.actadd & 8 = 8 THEN 'Insert' END AS [Insert Permission Granted],
CASE WHEN p.actadd & 16 = 16 THEN 'Delete' END AS [Delete Permission Granted],
CASE WHEN p.actadd & 32 = 23 THEN 'Execute' END AS [Exec Permission Granted],
p.*
from syspermissions p
join sysusers u on p.grantee = u.uid
join sysobjects o on o.id = p.id
ORDER BY o.name
John
"NC3" wrote:
> I need to change the security access policy in my environment. We are
> consolidating several older servers for licensing considerations and
> we want to change our security to a group based security where
> possible. I've created the groups that are required and gave it a go
> on on of our servers.
> Needless to say many jobs began to break - some were expected because
> we didn't have any documentation for the accounts.
> What is the best way to execute such a change. Can someone direct me
> to resources for auditing security in SQL i.e. account names and what
> they're priveleges are so I can effectively make the changes that I
> want with minimal disruption.
> Any pointer or gotchas are welcome.
>

Friday, February 10, 2012

Changing Data Folders In a clustered environment

All,
I need to move the OLAP data folder across disks. The problem is that we
are running on a cluster environment, and I cannot see how to change the Dat
a
Folder setting on the general tab of the properties dialog, and its greyed
out.
Is it simply a matter of changing this on the Cluster resources to point at
the new data folder or do I have to move anything else?
TIA
JasonThat and moving the data.
As this is a production system, and the whole point of a cluster is
high-availability, I recommend that you open up a PSS case and work with
them directly to get the right sequences of events. It would be easy to mess
things up and have the whole AS service go down.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jason Lees" <JasonLees@.discussions.microsoft.com> wrote in message
news:E373CF5F-A126-49B5-ACFA-E4FBF57A95AA@.microsoft.com...
> All,
> I need to move the OLAP data folder across disks. The problem is that we
> are running on a cluster environment, and I cannot see how to change the
Data
> Folder setting on the general tab of the properties dialog, and its greyed
> out.
> Is it simply a matter of changing this on the Cluster resources to point
at
> the new data folder or do I have to move anything else?
> TIA
> Jason
>
>

Changing Data Folders In a clustered environment

All,
I need to move the OLAP data folder across disks. The problem is that we
are running on a cluster environment, and I cannot see how to change the Data
Folder setting on the general tab of the properties dialog, and its greyed
out.
Is it simply a matter of changing this on the Cluster resources to point at
the new data folder or do I have to move anything else?
TIA
Jason
That and moving the data.
As this is a production system, and the whole point of a cluster is
high-availability, I recommend that you open up a PSS case and work with
them directly to get the right sequences of events. It would be easy to mess
things up and have the whole AS service go down.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jason Lees" <JasonLees@.discussions.microsoft.com> wrote in message
news:E373CF5F-A126-49B5-ACFA-E4FBF57A95AA@.microsoft.com...
> All,
> I need to move the OLAP data folder across disks. The problem is that we
> are running on a cluster environment, and I cannot see how to change the
Data
> Folder setting on the general tab of the properties dialog, and its greyed
> out.
> Is it simply a matter of changing this on the Cluster resources to point
at
> the new data folder or do I have to move anything else?
> TIA
> Jason
>
>