localized messages for SQL SERVER 2000

I found a usefull link to my problem : http://support.microsoft.com/Default.aspx?id=277535

But I am unable to find the s80xLang.exe file anywhere. I have looked through all my DVDs and nothing.

Anyone know where to look or download it from ?

The KB article mentions that you need to contact Customer Support to be able to download this. That wording implies the file is not available for public download. If you use email support to open a case with CSS, I'm pretty sure they will either send the file to you or provide you with the path to the download.|||

All the developper email contacts costs money for support. I called support and they gave me the same response : I need to give a credit card to the routing agent and the support tech will decide if it's free or not after we resolve the issue. I have sent an email through our partner account and am waiting for a response.

I noticed that a lot of people are looking for an answer on this topic.

|||

Anyone has had success in obtaining the localization s80xLang.exe file?

What's the point of Microsoft for not making this file public (or better, include it on the original product CD)?

|||

Hi Antonio,

I finally called microsoft with our partner ID because we have so many free calls per year we can use. After speaking to a SQL specialist, he sent me the file. They were supposed to make the file public on the web site (it's available for them internally) but not for the rest of us.

You can give them a call and they will send you the file. I was not charged for the support call since it's their mistake.

Good luck and take care

|||

All right, I've got the localization file (thanks, Marco!).... only to discover that it doesn't work with SQLServer 2005!

The problem is:

1 - for the script to run it must have permission to update the system table sysmessage;

2 - up to SQL 2000 this was achieved by issuing "sp_configure 'allow updates',1" or starting SQL with the -m option;

3 - SQL 2005 explicity states that updates to system tables are not allowed and that "sp-configure allow updates" is outdated and won't work (http://msdn2.microsoft.com/en-us/library/ms144262.aspx). Running the script in single-user mode (starting SQL with the -m option) doesn't work either, since "updates to system tables are not allowed".

Any ideas or further help will be appreciated.

Regards,

Antonio Plais - Brazil

|||

Further developments on localizing SQL 2005 messages:

1 - I'm developing an application using SQL Express 2005, and I'd like to show SQL messages in Brazilian Portuguese (one of the SQL 2005 supported languages);

2 - The solution pointed by Microsoft support doesn't work on SQL 2005;

3 - Localized Brazilian SQL Express 2005 Standard can be downloaded from Microsoft, while SQL Express 2005 Advanced is available only in English;

4 - Standard edition doesn't install full-text search; trying to install it from Advanced edition (after installing the Brazilian standard version) doesn't work;

5 - So, until Microsoft gently makes available a Brazilian Advanced version, I'll have to choose between localized messages or full-text search;

How hard Microsoft can make our lives!

Regards,

Antonio Plais - Brazil

localized messages for SQL SERVER 2000

I found a usefull link to my problem : http://support.microsoft.com/Default.aspx?id=277535

But I am unable to find the s80xLang.exe file anywhere. I have looked through all my DVDs and nothing.

Anyone know where to look or download it from ?

The KB article mentions that you need to contact Customer Support to be able to download this. That wording implies the file is not available for public download. If you use email support to open a case with CSS, I'm pretty sure they will either send the file to you or provide you with the path to the download.|||

All the developper email contacts costs money for support. I called support and they gave me the same response : I need to give a credit card to the routing agent and the support tech will decide if it's free or not after we resolve the issue. I have sent an email through our partner account and am waiting for a response.

I noticed that a lot of people are looking for an answer on this topic.

|||

Anyone has had success in obtaining the localization s80xLang.exe file?

What's the point of Microsoft for not making this file public (or better, include it on the original product CD)?

|||

Hi Antonio,

I finally called microsoft with our partner ID because we have so many free calls per year we can use. After speaking to a SQL specialist, he sent me the file. They were supposed to make the file public on the web site (it's available for them internally) but not for the rest of us.

You can give them a call and they will send you the file. I was not charged for the support call since it's their mistake.

Good luck and take care

|||

All right, I've got the localization file (thanks, Marco!).... only to discover that it doesn't work with SQLServer 2005!

The problem is:

1 - for the script to run it must have permission to update the system table sysmessage;

2 - up to SQL 2000 this was achieved by issuing "sp_configure 'allow updates',1" or starting SQL with the -m option;

3 - SQL 2005 explicity states that updates to system tables are not allowed and that "sp-configure allow updates" is outdated and won't work (http://msdn2.microsoft.com/en-us/library/ms144262.aspx). Running the script in single-user mode (starting SQL with the -m option) doesn't work either, since "updates to system tables are not allowed".

Any ideas or further help will be appreciated.

Regards,

Antonio Plais - Brazil

|||

Further developments on localizing SQL 2005 messages:

1 - I'm developing an application using SQL Express 2005, and I'd like to show SQL messages in Brazilian Portuguese (one of the SQL 2005 supported languages);

2 - The solution pointed by Microsoft support doesn't work on SQL 2005;

3 - Localized Brazilian SQL Express 2005 Standard can be downloaded from Microsoft, while SQL Express 2005 Advanced is available only in English;

4 - Standard edition doesn't install full-text search; trying to install it from Advanced edition (after installing the Brazilian standard version) doesn't work;

5 - So, until Microsoft gently makes available a Brazilian Advanced version, I'll have to choose between localized messages or full-text search;

How hard Microsoft can make our lives!

Regards,

Antonio Plais - Brazil

Local administrators was removed from SQL server logins, SQL Agent is not running

Colleagues,
I am experiencing problems described in (MSSQL 2000):
http://support.microsoft.com/default.aspx?scid=kb;en-us;237604
My problem is, that I have no MSSQL account I can use to solve the problem,
I cannot access SQL Servers Logins.
What can I do? Could please somebody help me?
Best regards,
PeterSQL Server Agent has to have an Administrative account. I would recommend
that the agent account be a local administrator on the server with far
reaching access accross the network. The only suggestion that I have is to
try and locate someone who can grant you sa or a minimum Security Admin for
this instance. One thing you might try is to determine if the console account
for the server is a user in SQL. I have always used the console account and
password as the SA on that SQL instance as well as the account that the
agent/service uses which is I believe to be quite common. Might get lucky.
(i.e If there server console name is Server1 and the console login in
P@.ssw0rd, then use that to try and login through Query analyizer. If it lets
you in, try editing the instance registration in Enterprise Manager and see
what kind of access that account has.)
Good Luck.
"Peter Rus" wrote:
> Colleagues,
> I am experiencing problems described in (MSSQL 2000):
> http://support.microsoft.com/default.aspx?scid=kb;en-us;237604
> My problem is, that I have no MSSQL account I can use to solve the problem,
> I cannot access SQL Servers Logins.
> What can I do? Could please somebody help me?
> Best regards,
> Peter
>
>

LoadReport() - SoapException - Help needed

Hi Experts,

getting the Error:

Server did not recognize the value of HTTP Header SOAPAction: http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/LoadReport

when calling LoadReport().

I can access the ReportServer and ReportManager through Browser and get perfect results.

I also can querying the WebService through a DataSet (XML-Data-Provider) in a Report Project.

VS 2005; SQL SERVER 2005; IIS6; Windows Server 2003. RS is configured on DefaultWebSite(Port 80)

rsExec = new rsExecService.ReportExecutionService();

rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials;

rsExec.Url = http://pserver01/ReportServer/ReportService2005.asmx;

// Render arguments

byte[] result = null;

string reportPath = "/ObjectsRpt/Sales";

string format = "PDF";

string historyID = null;

string devInfo = @."<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";

// Prepare report parameter.

rsExecService.ParameterValue[] parameters = new rsExecService.ParameterValue[1];

parameters[0] = new rsExecService.ParameterValue();

parameters[0].Name = "SalesOrderNumber";

parameters[0].Value = "SO43659";

string encoding;

string mimeType;

string extension;

rsExecService.Warning[] warnings = null;

string[] streamIDs = null;

rsExecService.ExecutionInfo execInfo = new rsExecService.ExecutionInfo();

rsExecService.ExecutionHeader execHeader = new rsExecService.ExecutionHeader();

rsExec.ExecutionHeaderValue = execHeader;

// Next line will cause the Error, when API tries to call Invoke

execInfo = rsExec.LoadReport(reportPath, historyID);

Help wanted

Thanx Ronny

Your code looks good. What happens when you browse http://pserver01/ReportServer/ReportService2005.asmx?|||

Hi Theo,

Browser opens with the XML-Definition.

If i put this URL in VS when adding a Web-Reference i also get the correct Definition of the Web-Services.

Any other suggestions?

Ronny

|||

I assume the URL line to be actually:

rsExec.Url = "http://pserver01/ReportServer/ReportService2005.asmx";

|||

Hi Teo,

it is like you assumed.

rsExec.Url = "http://pserver01/ReportServer/ReportService2005.asmx";

i added a watch and url is correct!

?

Ronny

|||If you run the code locally on the server using localhost as server name, does it work?|||

Hi Teo,

no, not with localhost and also not with the IP-Address..

No Entry in logs-Folder (RS or IIS), Configuration-Files looking good..

Any other ideas?

Ronny

|||It looks like IIS is rejecting the remote request. Intercepting the response with utilities like tcpTrace or SOAPTrace will help determining the cause.|||You are binding the proxy to the wrong endpoint (you are binding it to the management endpoint). Change the URL to http://pserver01/ReportServer/ReportExecution2005.asmx|||

Hello John, thanx for the great hint! - It's working fine now!

Ronny

LoadReport() - SoapException - Help needed

Hi Experts,

getting the Error:

Server did not recognize the value of HTTP Header SOAPAction: http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/LoadReport

when calling LoadReport().

I can access the ReportServer and ReportManager through Browser and get perfect results.

I also can querying the WebService through a DataSet (XML-Data-Provider) in a Report Project.

VS 2005; SQL SERVER 2005; IIS6; Windows Server 2003. RS is configured on DefaultWebSite(Port 80)

rsExec = new rsExecService.ReportExecutionService();

rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials;

rsExec.Url = http://pserver01/ReportServer/ReportService2005.asmx;

// Render arguments

byte[] result = null;

string reportPath = "/ObjectsRpt/Sales";

string format = "PDF";

string historyID = null;

string devInfo = @."<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";

// Prepare report parameter.

rsExecService.ParameterValue[] parameters = new rsExecService.ParameterValue[1];

parameters[0] = new rsExecService.ParameterValue();

parameters[0].Name = "SalesOrderNumber";

parameters[0].Value = "SO43659";

string encoding;

string mimeType;

string extension;

rsExecService.Warning[] warnings = null;

string[] streamIDs = null;

rsExecService.ExecutionInfo execInfo = new rsExecService.ExecutionInfo();

rsExecService.ExecutionHeader execHeader = new rsExecService.ExecutionHeader();

rsExec.ExecutionHeaderValue = execHeader;

// Next line will cause the Error, when API tries to call Invoke

execInfo = rsExec.LoadReport(reportPath, historyID);

Help wanted

Thanx Ronny

Your code looks good. What happens when you browse http://pserver01/ReportServer/ReportService2005.asmx?|||

Hi Theo,

Browser opens with the XML-Definition.

If i put this URL in VS when adding a Web-Reference i also get the correct Definition of the Web-Services.

Any other suggestions?

Ronny

|||

I assume the URL line to be actually:

rsExec.Url = "http://pserver01/ReportServer/ReportService2005.asmx";

|||

Hi Teo,

it is like you assumed.

rsExec.Url = "http://pserver01/ReportServer/ReportService2005.asmx";

i added a watch and url is correct!

?

Ronny

|||If you run the code locally on the server using localhost as server name, does it work?|||

Hi Teo,

no, not with localhost and also not with the IP-Address..

No Entry in logs-Folder (RS or IIS), Configuration-Files looking good..

Any other ideas?

Ronny

|||It looks like IIS is rejecting the remote request. Intercepting the response with utilities like tcpTrace or SOAPTrace will help determining the cause.|||You are binding the proxy to the wrong endpoint (you are binding it to the management endpoint). Change the URL to http://pserver01/ReportServer/ReportExecution2005.asmx|||

Hello John, thanx for the great hint! - It's working fine now!

Ronny