Friday, March 30, 2012
how to change the login for connect to the report database?
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 the localtion of WSS_Content Database (sharepoint3.0)
Hi, i am using sharepoint 3.0 and default Embedded Version of SQL express.
Now I would like to change the directory of WSS Content and Search database
(instead of C drive)
When I was using WSS2, I changed it using OSQL command.
For WSS3.0 it is a little different.
Could you help me how to change database directory?
Thanks
That KB article should guide you, through it is for 2.0 > 3.0http://support.microsoft.com/default.aspx/kb/925190
Jens K. Suessmeyer.
http://www.sqlserver2005.de
How to change the letters of the cutline in the CrystalReport?
How to change the letters of the cutline in the CrystalReport?
How to change the letters on the cakychart bigger in the CrystalReport?
If you know some methods,please write back to me as soon as quickly.
My Email is Nanty201@.hotmail.com .
Expect your letter.
Thank you very much!No One Knows?|||Don't know what either one of those are.
GJ
How to change the language settings of an rdl
Hi,
Can we change the language settings for a report by modifying the rdl code?
For example:- If my report is in English US, how do I change it to English UK?
Thanks in advance
Hi
In Solution Explorer Right Click on the Report for which you want to change the language and select "View Code".
In the Code that opened search for "Language" there you can change the language
How to change the instance name?
Hello DBA's
I have installed SQL Server 2005 on a machine with named instance, but later I noticed that I created it with the wrong name than desired. Now I need to change the instace name of the SQL Server that I have installed. How can I do that
Thanks
Satya
There is not a supported way to rename an instance. You need to uninstall and then reinstall.
Thanks,
Peter Saddow
|||Thanks Peter
Satya
how to change the instance name back to default of SQL2k5
hi,
While installing SQL SERVER 2005, I had opted for providing custom name for the SQL Server and named it as for eg. as 'xyz' . Now I would prefer to change it back to default instance so that I can use server=localhost in my connection string of my ASP.NET page. With the custom instance name everytime I have to give
server="Machinename\xyz" which is annoying as I will have to change the connection strings in so many places for my exisiting ASP.NET page.
For e.g.
strConnection="server="Machinename\xyz";database=test;Integrated Security=SSPI;";
I tried using server=(local). It did not work...:(
Also on my another machine which has SQL2k5 installed with default instance I am able to use this string:
strConnection="server=localhost;database=test;Integrated Security=SSPI;";
while the same string I cannot use on the one in which I provided the instance name.
Guess uninstall is the only way.
anyone knows how can I change it back to default instance?
Thanks JonM. I know how to create datasources but I don;t know what needs to be put in the ASP.NET file or web.config files to establish the connection.
Suppose I have database called 'test' with DSN name as 'test' in the 'xyz' instance of SQL Server on my machine named 'Development'
How do I achieve this?
Thank you once again for your help.
|||Basically you change your connection string to 'Datasource=xyx', and remove all of the other stuff, you may still have to specify a username and password if you didnt specify it in the datasouce.
sqlHow to change the Identity value
Thanks.Check out DBCC CHECKIDENT in BOL. It should give you everything you need.|||-- SET IDENTITY_INSERT to ON.
SET IDENTITY_INSERT <TableName> ON
GO
INSERT INTO <TableName> (<FieldName>) VALUES(2845747)
GO