Change Username/password

The login for our sql server is the default sa with a password.
I would like to remove the password but cant find where I can actually do
this.
Can someone help ?
TIASetting a blank SA password is not a good idea, it can leave your machine
open to virus attacks. You'd be better off setting the SA password to
something nobody knows and create a new account for people to use with only
the permissions they require.
A. Change the password of a login without a former password
This example changes the password for the login Victoria from a NULL
password to "B3r12-36".
EXEC sp_password NULL, 'B3r12-36', 'Victoria'
--
HTH
Ryan Waight, MCDBA, MCSE
"Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
news:OQjbrDEqDHA.2964@.tk2msftngp13.phx.gbl...
> The login for our sql server is the default sa with a password.
> I would like to remove the password but cant find where I can actually do
> this.
> Can someone help ?
> TIA
>|||Poppy wrote:
> The login for our sql server is the default sa with a password.
> I would like to remove the password but cant find where I can
> actually do this.
> Can someone help ?
> TIA
you really dont want to do this. the sa login is the 'system
administrator' to sql and having no password on it will open a massive
hole in your security. You should ideally only use the sa on the server
itself (to prevent sniffer attacks). You should create a seperate login
for day to day activities.
--
Br,
Mark Broadbent
mcdba , mcse+i
=============|||Hi,
You can login to Sql Query analyzer using NT
Administrator ( Provider this has permission to access
sql) and you can reset/change the password using
sp_password - stored procedure.
Pls try this out . Hope this will do the needful.
Raghu
>--Original Message--
>The login for our sql server is the default sa with a
password.
>I would like to remove the password but cant find where I
can actually do
>this.
>Can someone help ?
>TIA
>
>.
>|||>--Original Message--
>Poppy wrote:
>> The login for our sql server is the default sa with a
password.
>> I would like to remove the password but cant find where
I can
>> actually do this.
>> Can someone help ?
>> TIA
>you really dont want to do this. the sa login is
the 'system
>administrator' to sql and having no password on it will
open a massive
>hole in your security. You should ideally only use the sa
on the server
>itself (to prevent sniffer attacks). You should create a
seperate login
>for day to day activities.
>--
>Br,
>Mark Broadbent
>mcdba , mcse+i
>=============>.
>Yes .. you are right ! and If Mr.Poppy had forgotten the
sa password , then change with above step and set the
right password for security reasons.
Raghu

Change username

I'm using the Forms Authentication with Reporting Services, and I have a
situation where i need to change a username for a user. The user already has
lots permissions to different reports, etc... When I change the username in
my UserAccounts DB and the ReportServer DB it logs in fine, but shows no
objects.
When I view the reports via an admin account, it shows the security still
lists the old username, before I changed it.
Any ideas on how to successfully change a username in reporting services?
Thanks,
-Jonathan
Please post this to the SQL Server Reporting Services newsgroup:
reportingsvcs
Chris Skorlinski
Microsoft SQL Server Support
Please reply directly to the thread with any updates.
This posting is provided "as is" with no warranties and confers no rights.

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 Report Criteria by Username

Hi,

I have a question about passing user information into a report. Right now I have a travel report that accepts trip ID as a parameter. I have multiple users who will access this report through active directory and I think using tripID is too constricting for them. Ideally, I want them to pick their name from a list and pick the travel date(s) that they want to print out.

How can I make the report read in their username from Active Directory and pass this along to the report so that it'll automatically apply a filter the report. Then from a pull-down list, pick the travel date(s) that they're interested. Is this even possible?

Thanks,

Curtis111

Hi Curtis,

You might try using the =User!UserID.Value in the report, pass that as a query parameter, and apply filtering in your database query. This would allow users to see only values based on their userid, and they would not have to select any sort of parameters.

A more secure approach would be to apply filtering in the underlying database based on the users windows credentials. You would set the report data source connection to use windows credentials and then configure the database as noted here:

http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx

Thanks, Jon

|||

Thanks, Jon. Sounds like the first approach is the simpliest. I'll take easy any day.

Curtis

|||

Can someone provide more detail on how to accomplish the first approach? I am very new to Reporting Services, thanks!

Change Report Criteria by Username

Hi,

I have a question about passing user information into a report. Right now I have a travel report that accepts trip ID as a parameter. I have multiple users who will access this report through active directory and I think using tripID is too constricting for them. Ideally, I want them to pick their name from a list and pick the travel date(s) that they want to print out.

How can I make the report read in their username from Active Directory and pass this along to the report so that it'll automatically apply a filter the report. Then from a pull-down list, pick the travel date(s) that they're interested. Is this even possible?

Thanks,

Curtis111

Hi Curtis,

You might try using the =User!UserID.Value in the report, pass that as a query parameter, and apply filtering in your database query. This would allow users to see only values based on their userid, and they would not have to select any sort of parameters.

A more secure approach would be to apply filtering in the underlying database based on the users windows credentials. You would set the report data source connection to use windows credentials and then configure the database as noted here:

http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx

Thanks, Jon

|||

Thanks, Jon. Sounds like the first approach is the simpliest. I'll take easy any day.

Curtis

|||

Can someone provide more detail on how to accomplish the first approach? I am very new to Reporting Services, thanks!