Can RS Developer Edition be installed on machines which do not have Visual
Studios installed?
--The server part yes, the report writer no. The development tool for RS
requires some version of VS. Any version. I believe you can get vb.net for
$100.
Bruce L-C
"Richard Cranium" <mgreco40@.hotmail.com> wrote in message
news:%23tdn0DnmEHA.704@.TK2MSFTNGP09.phx.gbl...
> Can RS Developer Edition be installed on machines which do not have Visual
> Studios installed?
> --
>
>
Showing posts with label machines. Show all posts
Showing posts with label machines. Show all posts
Friday, March 9, 2012
Quick question about security and MS SQL 2000
OK, we have a couple of MS SQL 2000 servers running in a Win2k AD domain.
Both machines are using mixed mode security, the issue appears to be this.
If I go into AD and change a groups name that has been granted access to
the SQL server, it doesn't seem to pick up on the name change.
I also can't add the new name to the SQL server, because of a conflict of a
SID.
So how do I get the MS SQL server to refresh the names of the native NT
groups that have been granted access, then have the names changed ??I think you need to drop the old name and add the new one. Why are you doing this? Experimenting?|||Its not uncommon to have a native AD Security group renamed to match
a changed "department" name lets say.
SQL 2000 doesn't seem to see the name change in AD, where is this info stored in
the SQL server ?? is there a SP to refresh the cache or this table ?|||I'd say changing a department name should result in a change of an OU, not a group. But that's just me.
Both machines are using mixed mode security, the issue appears to be this.
If I go into AD and change a groups name that has been granted access to
the SQL server, it doesn't seem to pick up on the name change.
I also can't add the new name to the SQL server, because of a conflict of a
SID.
So how do I get the MS SQL server to refresh the names of the native NT
groups that have been granted access, then have the names changed ??I think you need to drop the old name and add the new one. Why are you doing this? Experimenting?|||Its not uncommon to have a native AD Security group renamed to match
a changed "department" name lets say.
SQL 2000 doesn't seem to see the name change in AD, where is this info stored in
the SQL server ?? is there a SP to refresh the cache or this table ?|||I'd say changing a department name should result in a change of an OU, not a group. But that's just me.
Saturday, February 25, 2012
queued updating error
We have setup transactional replication with queued updating between two
machines. both machines have the same sqlagent account with the same
password. When inserting records on the Publishers ( e. on the table) then
the data gets replicated fine and the subscriber gets updated with the insert
record. the problem is when we try to insert the records from the subscriber
then replication fails with login. What could possible be the problem here
because the account we are using is the same and has writes in both machines
the publisher and subscriber.
Mandla,
please take a look at this link :
http://support.microsoft.com/default...;en-us;Q320773
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
machines. both machines have the same sqlagent account with the same
password. When inserting records on the Publishers ( e. on the table) then
the data gets replicated fine and the subscriber gets updated with the insert
record. the problem is when we try to insert the records from the subscriber
then replication fails with login. What could possible be the problem here
because the account we are using is the same and has writes in both machines
the publisher and subscriber.
Mandla,
please take a look at this link :
http://support.microsoft.com/default...;en-us;Q320773
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Posts (Atom)