how to change the login for connect to the report database?

when we install report server database, a login and password is needed to
connect to the RS server database.
but my boss change the password in the server so i cant access to the report
server again as the report server said login in failed.
how can i tell teh reporting service the new password?
thanks in advance> how can i tell teh reporting service the new password?
Use the rsconfig.exe utility. Look for the syntax in RS Books OnLine.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.comsql

how to change SS name ?

i set the name of my ss to default on install, and now i want to use 'AttachDbFilename' to attach my dbfile in my asp.net app, but i cannot connect to the server. i fond in the adv. options, that the DataSource is set to '.\SQLEXPRESS' which is not the name of my SS, but i can't change it, so i want to ask if i can change the name of my SS withou reinstall.

thx for helping!

No you can not change Instance name... u have to reinstall it... BTW why u can not change the connection string...

Madhu

|||

it's not the connection string, i have not get yet, because i can not pass the test.

when i select the file, i click the test button, and got a fail message. i click the advence button, and i found that the DataSource is set the .\SQLEXPRESS, it's a dropdown list, in which you can choose DataSources, but you can't type in...

|||

\SQLEXPRESS is the default server name for an instance of SQL Server 2005 Express.

Are you sure that is not your server name?

Please post the complete error messages.

|||

well, i have reinstall SQL, and i can't remember the original error message, i can show you a step-by-step about how i get this problem

in vs.net(i use web dev), open the 'database explorer'-->'add connection'-->click 'change' atop of the dialog box-->select 'microsoft sql server database file'-->click 'advance' on the bottom of the dialog box-->in 'source' section, find 'datasource', you will see it's a drop-down list, so you can select the SS you want to use, but you can't type in. so if you install SS, and set the modal to 'default', rather than 'named instance', you cant find you'r SS here

how to change in SQL 2005 and accept the bin caracter and the langage

Hello

I am newbies with SQL 2005

I want install Windows sharepoint services 3 in french on my SBS 2003 R2 SP2 also in frecnh langage and at the end of the install, a message say to me :

Bin caracter are not accepted in your configuration SQL

Langage is not correct (I have French_CS_AS)

Where is possible to change these parameters ?

I try to find but never find

Thank You in advance for your help

++

Michel

If you have the answer in French it's better for me but not neccessary !

You need to change your collation to French_BIN which means alter database and change collation you can do it in the database properties. You have to know that BIN(binary collation) is the fastest sort but it also require you to use case sensitive data including queries. Run a search for ALTER database, table and columns and binary sort in SQL Server BOL. Check out SQL Server collations below.

http://msdn2.microsoft.com/en-us/library/ms180175.aspx

how to change default system database location after install of ssql express?

don't like the default location being in c:\program files\Microsoft SQL Server\MSSQL.1\If you want to move the system databases you will have to suhtdown the service, move the system database files and change the appropiate settings in the registry. Then you will be able to start the service again.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\Parameters

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||thank you very much. I was not able to find parameters under mssql.1 but under .3

How to Change Data Directory to D: drive

Hi everyone,
I have a problem here. I install SQL Server and set it's Data Folder to C:
drive.
Unfortunately my C drive is running out of space and I plan to add another
drive (D: drive).
I want to move my database to D: drive, but however I cannot see D: drive in
the SQL Server Enterprise Manager
when I try to add a new database.
Could anyone help me?
Best Regards,
Deili.Hi,
Execute the command XP_FIXEDDRIVES from Query Anayzer. If you can see D
drive then you can very well move the datbases to D drive. If you are not
able to
see please check the access prev. of D Drive.
How to Move.
1. Detach all user databases (SP_detach_db)
2. Move it to D Drive
3. Attach the dataabases (SP_attach_db)
How to chage the default data folder:
In Enterprise manager , right click above server -- Properties
select "database setting" option, there you can chage the
Default data and Log directory.
Thanks
Hari
MCDBA
"news.microsoft.com" <deili@.yahoo.com> wrote in message
news:OrfWGmw1DHA.2680@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Hi everyone,
> I have a problem here. I install SQL Server and set it's Data Folder to C:
> drive.
> Unfortunately my C drive is running out of space and I plan to add another
> drive (D: drive).
> I want to move my database to D: drive, but however I cannot see D: drive

---

in

quote:

---

> the SQL Server Enterprise Manager
> when I try to add a new database.
> Could anyone help me?
> Best Regards,
> Deili.
>

---

How to Change Data Directory to D: drive

Hi everyone,
I have a problem here. I install SQL Server and set it's Data Folder to C:
drive.
Unfortunately my C drive is running out of space and I plan to add another
drive (D: drive).
I want to move my database to D: drive, but however I cannot see D: drive in
the SQL Server Enterprise Manager
when I try to add a new database.
Could anyone help me?
Best Regards,
Deili.Hi,
Execute the command XP_FIXEDDRIVES from Query Anayzer. If you can see D
drive then you can very well move the datbases to D drive. If you are not
able to
see please check the access prev. of D Drive.
How to Move.
1. Detach all user databases (SP_detach_db)
2. Move it to D Drive
3. Attach the dataabases (SP_attach_db)
How to chage the default data folder:
In Enterprise manager , right click above server -- Properties
select "database setting" option, there you can chage the
Default data and Log directory.
Thanks
Hari
MCDBA
"news.microsoft.com" <deili@.yahoo.com> wrote in message
news:OrfWGmw1DHA.2680@.TK2MSFTNGP11.phx.gbl...
> Hi everyone,
> I have a problem here. I install SQL Server and set it's Data Folder to C:
> drive.
> Unfortunately my C drive is running out of space and I plan to add another
> drive (D: drive).
> I want to move my database to D: drive, but however I cannot see D: drive
in
> the SQL Server Enterprise Manager
> when I try to add a new database.
> Could anyone help me?
> Best Regards,
> Deili.
>sql

How to change collation settings after install

I need to change the collation setting on a server which has already been
installed and setup. How do I do this?
Thanks.
moondaddy@.newsgroup.nospamIt depends on to what extent you want to change collation. The collation for system databases you
change using rebuildm.exe (2000) or setup (2005). See books online for details. This will rebuild
the system databases, so you need to recreate everything you need in the system databases.
A user database is a different thing...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"moondaddy" <moondaddy@.newsgroup.nospam> wrote in message
news:eTbPg7gAIHA.4232@.TK2MSFTNGP04.phx.gbl...
>I need to change the collation setting on a server which has already been installed and setup. How
>do I do this?
> Thanks.
>
> moondaddy@.newsgroup.nospam
>|||Take a look at this tip:
http://www.sqlcommunity.com/Default.aspx?grm2id=25&tabid=77
Hope this helps.
Saleem
WWW.SQLCOMMUNITY.COM
SQL Server Tips, SQL Server Scripts, SQL Server Forums, SQL Server Blogs,
SQL Server Radio, SQL Server Events..
"Tibor Karaszi" wrote:
> It depends on to what extent you want to change collation. The collation for system databases you
> change using rebuildm.exe (2000) or setup (2005). See books online for details. This will rebuild
> the system databases, so you need to recreate everything you need in the system databases.
> A user database is a different thing...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "moondaddy" <moondaddy@.newsgroup.nospam> wrote in message
> news:eTbPg7gAIHA.4232@.TK2MSFTNGP04.phx.gbl...
> >I need to change the collation setting on a server which has already been installed and setup. How
> >do I do this?
> >
> > Thanks.
> >
> >
> > moondaddy@.newsgroup.nospam
> >
>|||Hi,
I agree with Tibor. Just add some helpful links here for your reference.
For SQL 2000, please refer to:
How to rebuild the master database (Rebuild Master utility)
http://msdn2.microsoft.com/en-us/library/aa197950(sql.80).aspx
For SQL 2005, you may refer to:
Setting and Changing the Server Collation
http://msdn2.microsoft.com/en-us/library/ms179254.aspx
How to: Install SQL Server 2005 from the Command Prompt
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Additionally if you would like to change your user database collation, you
can use ALTER DATABASE statement which is applicable for both SQL 2000 and
2005:
Setting and Changing the Database Collation
http://msdn2.microsoft.com/en-us/library/ms175835.aspx
ALTER DATABASE (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms174269.aspx
Please feel free to let us know if you have any questions or concerns.
Best regards,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================