changing Authentication mode

Hi,
I am a newbie and i am trying to change authenication mode under enterprise
manager the sql server properties -> security tab to "SQl Server and Windows
NT" but as soon as i click on ok and close the properties it changes bak, to
Windows NT.
I have installed sharepoint services and someday i would configure something
(i dont remember what) i changed authentication to Windows NT , now i want t
o
change it back to mixed mode (Sql server and Windows) but it does want to
obey.
what can i do?From memory, changing the authentication mode only takes affect the
next time you restart SQL Server. Have you stopped & restarted SQL
Server since changing the authentication mode?
*mike hodgson*
http://sqlnerd.blogspot.com
Cyrus wrote:

>Hi,
>I am a newbie and i am trying to change authenication mode under enterprise
>manager the sql server properties -> security tab to "SQl Server and Window
s
>NT" but as soon as i click on ok and close the properties it changes bak, t
o
>Windows NT.
>I have installed sharepoint services and someday i would configure somethin
g
>(i dont remember what) i changed authentication to Windows NT , now i want
to
>change it back to mixed mode (Sql server and Windows) but it does want to
>obey.
>what can i do?
>sql

Changing Article Properties without a new Snapshot

In our replication environment, the subscriber is initially set up with an snapshot of the publisher database. However, after that, the subscriber and publisher are different and we can never re-initialize from a snapshot again (we purge data on the publisher to reduce the database size but do not purge the same data on the subscriber; we do this by stubbing out the stored procedures on the subscriber that purge data on the publisher).

If an article is added or dropped from the publication, using snapshot and synchronize, just these changes are propagated to the publisher (without an entire new snapshot).

However, if an Article Property is changed (change SCALL to MCALL under Statement Delivery options for the UPDATE statement), the interface REQUIRES an entire new snapshot. Is there any way I can avoid the new Snapshot? It overwrites the subscriber database and this cannot happen!

Linda

Adding/dropping article(s) from an existing publication requires generates a new snapshot in general. This is to make sure the data convergence.

Do you mind sharing the business purpose - 'avoiding the new Snapshot' and 'can not overwrite the subscriber database'?

Thanks.

This posting is provided AS IS with no warranties, and confers no rights.

|||

Hi Linda,

Yes, changing CALL format will require a new snapshot.

But there is another way which might do what do you need (although requires more steps and a little intrusive). You can drop the subscription and publication. It will delete the replication, but not the data at subscriber. Then you can create the publication and subscription again. But when you create the subscription, you can choose to initialize subscription without snapshot. BOL has instruction (http://msdn2.microsoft.com/en-us/library/ms151705.aspx) on how to do it. Just follow the instructions under "Initializing a subscription with an alternative method".

Thanks,

Peng

|||

Thanks again, Peng. I have used this method in the past (breaking replication and restoring without a snapshot). I will test it for this scenario and let you know the results.

Linda

|||

Peng,

This works for changing article properties. Thanks!

Under what conditions will SQL2005 Replication generate an entire new snapshot?

Our configuration will not allow the subscription database to be re-initialized with a snapshot. The snapshot from the publisher will only be used for the initial subscription.

I need to identify all cases when a new snapshot will be created and use the alternative method of breaking replication, make the changes and then re-add the subscription without a snapshot.

Examples:

Adding or dropping a table: the snapshot agent just applies changes from the 1 item I changed without breaking replication.

Dropping a view: I dropped a view and the snapshot agent recreated the entire snaphot. Why?

How can I tell if my changes to replication are going to cause a new snapshot to be generated?

Linda

Changing a Columns Identity Properties

Hi,
How do I change the identity properties of an existing column using
trans-sql?
Thanks
----
--
----
--Razak wrote:
> Hi,
> How do I change the identity properties of an existing column using
> trans-sql?
> Thanks
> ----
--
> ----[/
color]
What do you mean exactly? The seed? See DBCC CHECKIDENT.
David Gugick
Imceda Software
www.imceda.com|||I meant changing the property of the column to become an IDENTITY column.
This is because the column used to be an identity column, but someone has
messed up with the db and all the identity columns inside all tables has
lost their identity property. The columns are still there. Because of this,
every "INSERT ..." sql scripts to add new records generate error.
Therefore, I need to set back the IDENTITY prop for the id columns in every
table, but I need to do it using T-SQL since the db is in remote sql server.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:ea8pUeiGFHA.1500@.TK2MSFTNGP09.phx.gbl...
> Razak wrote:
> What do you mean exactly? The seed? See DBCC CHECKIDENT.
> --
> David Gugick
> Imceda Software
> www.imceda.com|||Razak wrote:
> I meant changing the property of the column to become an IDENTITY
> column. This is because the column used to be an identity column, but
> someone has messed up with the db and all the identity columns inside
> all tables has lost their identity property. The columns are still
> there. Because of this, every "INSERT ..." sql scripts to add new
> records generate error.
> Therefore, I need to set back the IDENTITY prop for the id columns in
> every table, but I need to do it using T-SQL since the db is in
> remote sql server.
There is no supported SQL to add an identity attribute to an existing
column. Creating a new table and inserting the data between them is the
easiest way (in most cases).
You could use SQL EM, which will try and automate most of the this for
you, probably by creating a new table and then dropping the old one.
See this article for more information:
http://www.windowsitpro.com/Article...2080/22080.html
David Gugick
Imceda Software
www.imceda.com|||Thanks for your reply.. It seems like I will have to there and fix it
locally on the sever.
Thanks again
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:Oj8pn3jGFHA.2616@.tk2msftngp13.phx.gbl...
> Razak wrote:
> There is no supported SQL to add an identity attribute to an existing
> column. Creating a new table and inserting the data between them is the
> easiest way (in most cases).
> You could use SQL EM, which will try and automate most of the this for
> you, probably by creating a new table and then dropping the old one.
> See this article for more information:
> http://www.windowsitpro.com/Article...2080/22080.html
>
> --
> David Gugick
> Imceda Software
> www.imceda.com|||Razak wrote:
> Thanks for your reply.. It seems like I will have to there and fix it
> locally on the sever.
You don't need to be on the server to fix it, unless I'm
misunderstanding what you're saying. You can connect through any query
tool and execute a custom script to make the change or possibly use SQL
EM (remotely is needed) to make the change. I would encourage you to
test all changes on a dev server first.
David Gugick
Imceda Software
www.imceda.com|||Creating a new copy of the table will break its relationship with other
tables since I need to maintain the values inside the supposedly id column.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OasMiRoGFHA.544@.TK2MSFTNGP12.phx.gbl...
> Razak wrote:
> You don't need to be on the server to fix it, unless I'm misunderstanding
> what you're saying. You can connect through any query tool and execute a
> custom script to make the change or possibly use SQL EM (remotely is
> needed) to make the change. I would encourage you to test all changes on a
> dev server first.
> --
> David Gugick
> Imceda Software
> www.imceda.com|||Razak wrote:
> Creating a new copy of the table will break its relationship with
> other tables since I need to maintain the values inside the
> supposedly id column.
But that's the only solution to your problem AFAIK. If you try and make
the change using SQL EM on a dev server, you can run Profiler at the
same time and capture all the SQL SQLEM is uing to make the change. It
may shed some light on how to script this out yourself. I think the
article I referenced goes into this quite a bit.
David Gugick
Imceda Software
www.imceda.com

Changes to SQL 2000 Server Properties Don't "Stick"

Hello,
I have a new installation of SQL 2000 (via SBS 2003). When it was originally
setup, "Windows Only" security was configured. Using the "Server Properties
" dialog in Enterprise Manager, I tried changing it to "Windows and SQL", bu
t the changes don't "stick"
after clicking OK. I tried some other general changes (for example: min/max
memory) and none of the changes I make are stored after clicking OK.
Has anyone run across this before?
ThanksHi,
I have not encountered this sort of sitiuations before,
For changing the Memory and other parameters please try executing
SP_CONFIGURE procedure (Look books online for info).
For changing the Authentication mode you have to change the registry entry
& #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\Microsoft SQL
Server\HARISQL\MSSQLServer]
Change the value for "LoginMode" to 2 for SQL server and Windows , AFter
this restart SQL server sevice and verify the status.
Thanks
Hari
MCDBA
"FJOHN" <anonymous@.discussions.microsoft.com> wrote in message
news:A9887B4F-FFD3-4E7A-B465-210476166479@.microsoft.com...
> Hello,
> I have a new installation of SQL 2000 (via SBS 2003). When it was
originally setup, "Windows Only" security was configured. Using the "Server
Properties" dialog in Enterprise Manager, I tried changing it to "Windows
and SQL", but the changes don't "stick" after clicking OK. I tried some
other general changes (for example: min/max memory) and none of the changes
I make are stored after clicking OK.
> Has anyone run across this before?
> Thanks|||It sounds like the login that SQL Server is running under may NOT have
permissions to alter the registry keys for SQL Server...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"FJOHN" <anonymous@.discussions.microsoft.com> wrote in message
news:A9887B4F-FFD3-4E7A-B465-210476166479@.microsoft.com...
> Hello,
> I have a new installation of SQL 2000 (via SBS 2003). When it was
originally setup, "Windows Only" security was configured. Using the "Server
Properties" dialog in Enterprise Manager, I tried changing it to "Windows
and SQL", but the changes don't "stick" after clicking OK. I tried some
other general changes (for example: min/max memory) and none of the changes
I make are stored after clicking OK.
> Has anyone run across this before?
> Thankssql

changeing Dataflow tasks propeties by coding

Hi,
Is it possible to change the Dataflow tasks properties with VB coding? I've managed to change the properties of the control Flow tasks with VB code! as I wan to create a generic dataflow that will change everytime I run it.
CheersYes, you can. It is a bit more complicated, as many of the properties are contained in a CustomProperties collection on the data flow objects, so you need to find the names of the specific properties that you are interested in.|||

Kolf wrote:

Hi,
Is it possible to change the Dataflow tasks properties with VB coding? I've managed to change the properties of the control Flow tasks with VB code! as I wan to create a generic dataflow that will change everytime I run it.
Cheers

Kolf,

You know that you cannot change this stuff while the package is running right? You need to affect the change prior to the package running.

-Jamie

|||would you be able to give me on example so it will keep me going, yes and I am aware of the issue that I need to change the properties prior to running the package. therefore it dataflow should be in a sub-package.
Thanks|||

Kolf wrote:

would you be able to give me on example so it will keep me going, yes and I am aware of the issue that I need to change the properties prior to running the package. therefore it dataflow should be in a sub-package.
Thanks

This is quite a big area and I don't know of one example that covers everything. What in particular are you having trouble with? Navigating through the package to the property or knowing how to change it?

-Jamie

|||Thanks again Jamie, you've been very helpful

So there is no escape or work around this issue. I was hoping instead on using Transfer SQL Server object task (to copy the table to destination server, which dynamic tablelist feed – and using sub-package ), I could use dataflow tasks within one package (and avoid using sub-package and changing the property of the sub-package from parent package – as this is how it works now and it’s very slow) .

So I can use execute sql task to populate the table schema on the destination and then use a dataflowtask to push the data across , all in one package. And be able to put this in a loop to do for a list of tables.

I hope I’ve explained it clearly

|||

Kolf wrote:

would you be able to give me on example so it will keep me going, yes and I am aware of the issue that I need to change the properties prior to running the package. therefore it dataflow should be in a sub-package.
Thanks

Kolf,

Jessica Elise has posted some great code here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1404157&SiteID=1&mode=1 that may be of use.

-Jamie

changeing Dataflow tasks propeties by coding

Hi,
Is it possible to change the Dataflow tasks properties with VB coding? I've managed to change the properties of the control Flow tasks with VB code! as I wan to create a generic dataflow that will change everytime I run it.
Cheers

Yes, you can. It is a bit more complicated, as many of the properties are contained in a CustomProperties collection on the data flow objects, so you need to find the names of the specific properties that you are interested in.|||

Kolf wrote:

Hi,
Is it possible to change the Dataflow tasks properties with VB coding? I've managed to change the properties of the control Flow tasks with VB code! as I wan to create a generic dataflow that will change everytime I run it.
Cheers

Kolf,

You know that you cannot change this stuff while the package is running right? You need to affect the change prior to the package running.

-Jamie

|||would you be able to give me on example so it will keep me going, yes and I am aware of the issue that I need to change the properties prior to running the package. therefore it dataflow should be in a sub-package.
Thanks
|||

Kolf wrote:

would you be able to give me on example so it will keep me going, yes and I am aware of the issue that I need to change the properties prior to running the package. therefore it dataflow should be in a sub-package.
Thanks

This is quite a big area and I don't know of one example that covers everything. What in particular are you having trouble with? Navigating through the package to the property or knowing how to change it?

-Jamie

|||Thanks again Jamie, you've been very helpful

So there is no escape or work around this issue. I was hoping instead on using Transfer SQL Server object task (to copy the table to destination server, which dynamic tablelist feed – and using sub-package ), I could use dataflow tasks within one package (and avoid using sub-package and changing the property of the sub-package from parent package – as this is how it works now and it’s very slow) .

So I can use execute sql task to populate the table schema on the destination and then use a dataflowtask to push the data across , all in one package. And be able to put this in a loop to do for a list of tables.

I hope I’ve explained it clearly

|||

Kolf wrote:

would you be able to give me on example so it will keep me going, yes and I am aware of the issue that I need to change the properties prior to running the package. therefore it dataflow should be in a sub-package.
Thanks

Kolf,

Jessica Elise has posted some great code here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1404157&SiteID=1&mode=1 that may be of use.

-Jamie

Change the username in Active Directory

We use extended properties of Active Directory to filter the data in reporting services throw a web services. We send the userid (User!UserId) to the webservices and retrieve some information about the user.
But if we change the name of one user (rename not recreate), he lost all this properties. When try to execute a report show an error:

Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError) I know this issue is in the border of reporting services, but we have spent a lot of time without results and we need any help.

Thanks in advance

How are you doing your rename? Because that's where your issue is <s>.

If you're doing it through some GUI interface and that interface doesn't transfer your extended properties on a rename, then that interface has a bug in it <sigh>.

I do some AD coding but don't have an example I can throw in here. Basically, when any consumer queries AD for a user object, it is allowed to say what properties it's interested in retrieving. If it doesn't know about yours and doesn't retrieve them, it probably doesn't clone them along with the rest of the object. (I think, under the covers, a rename likely does a clone-and-delete.)

So you have to write something that does know about your extended properties and write a better rename...

>L<

|||We rename the user in Active directory but i supposed that in some part of reporting services store the previous username, guid or something to refers to the old user. When we use the user!userID functions, reporting services get the old value instead the new value.

Our process is:
We have two parameters, one with the user and other with the information to retrieve and send to another queries. Send this two parameters to the web services and retrieve a parameter (a custom property defined in AD) to send in another query.

We use directly in web browser the reporting services. And it is the default configuration of report server web.

Thanks for your patience

|||

>>We rename the user in Active directory

I know that's what you did. I asked you *how* you did this (through what interface).

But, yes, if you're getting the old version when you look at user!userID, it doesn't matter.

I don't see why the report server would be caching the previous user name etc, unless you have put this information in as the credentials of the user to run the report in the report configuration?

Could this possibly be an AD refresh type of problem, instead? IOW, you do the rename and all the domain servers don't know about it?

>L<

Change style for HTML Viewer - toolbar

Hi,
Is it possible to change properties such background colour for HTML viewer â'
toolbar?
I just want co customise report â's look to match our applicationâ's style
where report is displayed (we use frames).
ThanksHi
you can customise it by changing the properties in the file:
"Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\Styles\ReportingServices.css"
Soan
"Pendula" wrote:
> Hi,
> Is it possible to change properties such background colour for HTML viewer â'
> toolbar?
> I just want co customise report â's look to match our applicationâ's style
> where report is displayed (we use frames).
> Thanks
>|||"Pendula" <Pendula@.discussions.microsoft.com> wrote in message news:<29B698BD-3E9B-4117-A2DD-06C14F3BD296@.microsoft.com>...
> Hi,
> Is it possible to change properties such background colour for HTML viewer â'
> toolbar?
> I just want co customise report â's look to match our applicationâ's style
> where report is displayed (we use frames).
> Thanks
You can modify the stylesheet located:
\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\styles\htmlviewer.css
Andy Potter
Intellinet|||The htmlviewer.css file is not in the directory you specified.
Any reason why this file would not be created on install?
I did a search on the server and could not find the file.
Thanks
"Andrew Potter" wrote:
> "Pendula" <Pendula@.discussions.microsoft.com> wrote in message news:<29B698BD-3E9B-4117-A2DD-06C14F3BD296@.microsoft.com>...
> > Hi,
> >
> > Is it possible to change properties such background colour for HTML viewer â'
> > toolbar?
> > I just want co customise report â's look to match our applicationâ's style
> > where report is displayed (we use frames).
> >
> > Thanks
>
> You can modify the stylesheet located:
> \Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\styles\htmlviewer.css
> Andy Potter
> Intellinet
>|||Are you logged on as a member of the administrator group? I just double
checked on my server and I see it exactly as specified here.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Don H" <Don H@.discussions.microsoft.com> wrote in message
news:6D2088A1-2C43-4A6A-9D1B-0DDD5CB49C84@.microsoft.com...
> The htmlviewer.css file is not in the directory you specified.
> Any reason why this file would not be created on install?
> I did a search on the server and could not find the file.
> Thanks
> "Andrew Potter" wrote:
> > "Pendula" <Pendula@.discussions.microsoft.com> wrote in message
news:<29B698BD-3E9B-4117-A2DD-06C14F3BD296@.microsoft.com>...
> > > Hi,
> > >
> > > Is it possible to change properties such background colour for HTML
viewer -
> > > toolbar?
> > > I just want co customise report 's look to match our application's
style
> > > where report is displayed (we use frames).
> > >
> > > Thanks
> >
> >
> > You can modify the stylesheet located:
> >
> > \Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\ReportServer\styles\htmlviewer.css
> >
> > Andy Potter
> > Intellinet
> >|||I am logged on as member of the admin group.
I did find in the RS SP1 readme that the new URL Access Parameters
can be used to add a custom stylesheet.
The property is: rc:Stylesheet
Do you have any idea how this gets set in the development environment?
Thanks,
Don
"Bruce L-C [MVP]" wrote:
> Are you logged on as a member of the administrator group? I just double
> checked on my server and I see it exactly as specified here.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Don H" <Don H@.discussions.microsoft.com> wrote in message
> news:6D2088A1-2C43-4A6A-9D1B-0DDD5CB49C84@.microsoft.com...
> > The htmlviewer.css file is not in the directory you specified.
> > Any reason why this file would not be created on install?
> > I did a search on the server and could not find the file.
> >
> > Thanks
> >
> > "Andrew Potter" wrote:
> >
> > > "Pendula" <Pendula@.discussions.microsoft.com> wrote in message
> news:<29B698BD-3E9B-4117-A2DD-06C14F3BD296@.microsoft.com>...
> > > > Hi,
> > > >
> > > > Is it possible to change properties such background colour for HTML
> viewer -
> > > > toolbar?
> > > > I just want co customise report 's look to match our application's
> style
> > > > where report is displayed (we use frames).
> > > >
> > > > Thanks
> > >
> > >
> > > You can modify the stylesheet located:
> > >
> > > \Program Files\Microsoft SQL Server\MSSQL\Reporting
> > > Services\ReportServer\styles\htmlviewer.css
> > >
> > > Andy Potter
> > > Intellinet
> > >
>
>|||Unless I am mistaken, the presence of that file is moot.
The style sheet that controls the look of the html viewer toolbar
has been compiled into the ReportingServicesWebServer.dll
I don't believe that the htmlviewer.css file is used at all.
Please confirm.
Thanks,
Rob
"Bruce L-C [MVP]"
> Are you logged on as a member of the administrator group? I just double
> checked on my server and I see it exactly as specified here.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Don H"
> > The htmlviewer.css file is not in the directory you specified.
> > Any reason why this file would not be created on install?
> > I did a search on the server and could not find the file.
> >
> > Thanks
> >
> > "Andrew Potter" wrote:
> >
> > > "Pendula"
> > > > Hi,
> > > >
> > > > Is it possible to change properties such background colour for HTML
> viewer - toolbar? I just want co customise report 's look to match our
application's
> style where report is displayed (we use frames).
> > > >
> > > > Thanks
> > >
> > >
> > > You can modify the stylesheet located:
> > >
> > > \Program Files\Microsoft SQL Server\MSSQL\Reporting
> > > Services\ReportServer\styles\htmlviewer.css
> > >
> > > Andy Potter
> > > Intellinet|||hi goinoutwest,
it looks to me that you are right. no meter what properties i am changing
in any of the ".css" files on reporting server / designer there is no changes
at all. Actually some properties can be changed on report manager but that is
not what I am after.
Regards
"goinoutwest" wrote:
> Unless I am mistaken, the presence of that file is moot.
> The style sheet that controls the look of the html viewer toolbar
> has been compiled into the ReportingServicesWebServer.dll
> I don't believe that the htmlviewer.css file is used at all.
> Please confirm.
> Thanks,
> Rob
>
> "Bruce L-C [MVP]"
> > Are you logged on as a member of the administrator group? I just double
> > checked on my server and I see it exactly as specified here.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Don H"
> > > The htmlviewer.css file is not in the directory you specified.
> > > Any reason why this file would not be created on install?
> > > I did a search on the server and could not find the file.
> > >
> > > Thanks
> > >
> > > "Andrew Potter" wrote:
> > >
> > > > "Pendula"
> > > > > Hi,
> > > > >
> > > > > Is it possible to change properties such background colour for HTML
> > viewer - toolbar? I just want co customise report 's look to match our
> application's
> > style where report is displayed (we use frames).
> > > > >
> > > > > Thanks
> > > >
> > > >
> > > > You can modify the stylesheet located:
> > > >
> > > > \Program Files\Microsoft SQL Server\MSSQL\Reporting
> > > > Services\ReportServer\styles\htmlviewer.css
> > > >
> > > > Andy Potter
> > > > Intellinet
>
>