Failed to Net Send to the address '%s'

Can you please post your code.
Peter

>--Original Message--
>i'm trying to setup operators on one of our SQL Server.
>On the server locally i can open a command window, and
enter
>and it works.
>But SQL Server agent says, when i test send the
message, "Failed to Net Send
>to the address '%s'"
>Agent is logging on with a valid domain account.
>
>.
>
Start->Programs->Microsoft SQL Server->Enterprise Manager
Expand your server.
Managment->SQL Server Agent->Operators
Double click an operator
Net send address: Type in a user name or machine name
Click "Test"
"Peter the Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:68cb01c4756f$b3a19fb0$a501280a@.phx.gbl...[vbcol=seagreen]
> Can you please post your code.
> Peter
>
> enter
> message, "Failed to Net Send
sql

Failed to Net Send to the address '%s'

i'm trying to setup operators on one of our SQL Server.
On the server locally i can open a command window, and enter
>net send TargetMachine message
and it works.
But SQL Server agent says, when i test send the message, "Failed to Net Send
to the address '%s'"
Agent is logging on with a valid domain account.Can you please post your code.
Peter
>--Original Message--
>i'm trying to setup operators on one of our SQL Server.
>On the server locally i can open a command window, and
enter
>>net send TargetMachine message
>and it works.
>But SQL Server agent says, when i test send the
message, "Failed to Net Send
>to the address '%s'"
>Agent is logging on with a valid domain account.
>
>.
>|||Start->Programs->Microsoft SQL Server->Enterprise Manager
Expand your server.
Managment->SQL Server Agent->Operators
Double click an operator
Net send address: Type in a user name or machine name
Click "Test"
"Peter the Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:68cb01c4756f$b3a19fb0$a501280a@.phx.gbl...
> Can you please post your code.
> Peter
>
> >--Original Message--
> >i'm trying to setup operators on one of our SQL Server.
> >
> >On the server locally i can open a command window, and
> enter
> >>net send TargetMachine message
> >
> >and it works.
> >
> >But SQL Server agent says, when i test send the
> message, "Failed to Net Send
> >to the address '%s'"
> >
> >Agent is logging on with a valid domain account.
> >
> >
> >.
> >

Failed to Net Send to the address '%s'

Can you please post your code.
Peter

>--Original Message--
>i'm trying to setup operators on one of our SQL Server.
>On the server locally i can open a command window, and
enter
>and it works.
>But SQL Server agent says, when i test send the
message, "Failed to Net Send
>to the address '%s'"
>Agent is logging on with a valid domain account.
>
>.
>Start->Programs->Microsoft SQL Server->Enterprise Manager
Expand your server.
Managment->SQL Server Agent->Operators
Double click an operator
Net send address: Type in a user name or machine name
Click "Test"
"Peter the Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:68cb01c4756f$b3a19fb0$a501280a@.phx.gbl...[vbcol=seagreen]
> Can you please post your code.
> Peter
>
> enter
> message, "Failed to Net Send

Failed client connection by name\name.

Attempting ODBC connection to SQL Server by MachineName\SqlServerName doesn't work.
Can only connect by using IP address of server machine with name of SQL Server instance.
Any help would be appreciated.
thanksPlease refer to the following url, it may help you:
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForSQLServer|||Rather than SQL-Server, can u access that machine by name from the client? It also happens bcz of WINS entry or if the Server is in DMZ etc. If u can't access the server over the LAN by name, edit ur client's HOSTS file.|||Add the entry in LMHOSTS file and if its still timeouts then ensure proper value is defined on SQL server to login timeout.

Also ensure similar protocols are enabled between client & server.

Extracting a specific amount of data from a field

I am working with a particular field in my SQL database that has the addresses of all our customers. Each part of the address is seperated with a Carriage return but is shown in the database as just a single line of text.
I need to show this in my report as a seperate field for each part of the address (A1, A2, A3 etc..) however I am unsure as to how to extract the data up to each carriage return and then from that one to the next one.
I can use the following which obviously just extracts the data up to the first specified character length but this doesnt really help very much.

SELECT LEFT(ADDRESS, X) AS A1
FROM GTW_BUSINESS_PARTNER

Has anybody got any ideas how this can be done.

Many thanks

From a performance point of view it is probably best, to perform the string splitting operation directly in the SQL statement or in a stored procedure.

If you want to do it with RDL expressions in the report, you could use the VB Split function as follows:

To get the first line: =Split(Fields!Address.Value, VbCrLf)(0)
To get the second line: =Split(Fields!Address.Value, VbCrLf)(1)

Notes:
* VbCrLf means Cr+Lf, you can also try VbCr if you only have Cr between the lines.
* The VB Split function will result in bad performance if used very often (e.g. called multiple times for thousands of rows in the report)

-- Robert

|||The SQL character (ascii) for carriage return is char(13) - char converts to ascii character..... does this point you in the right direction?

Extracting a specific amount of data from a field

I am working with a particular field in my SQL database that has the addresses of all our customers. Each part of the address is seperated with a Carriage return but is shown in the database as just a single line of text.
I need to show this in my report as a seperate field for each part of the address (A1, A2, A3 etc..) however I am unsure as to how to extract the data up to each carriage return and then from that one to the next one.
I can use the following which obviously just extracts the data up to the first specified character length but this doesnt really help very much.

SELECT LEFT(ADDRESS, X) AS A1
FROM GTW_BUSINESS_PARTNER

Has anybody got any ideas how this can be done.

Many thanks

From a performance point of view it is probably best, to perform the string splitting operation directly in the SQL statement or in a stored procedure.

If you want to do it with RDL expressions in the report, you could use the VB Split function as follows:

To get the first line: =Split(Fields!Address.Value, VbCrLf)(0)
To get the second line: =Split(Fields!Address.Value, VbCrLf)(1)

Notes:
* VbCrLf means Cr+Lf, you can also try VbCr if you only have Cr between the lines.
* The VB Split function will result in bad performance if used very often (e.g. called multiple times for thousands of rows in the report)

-- Robert

|||The SQL character (ascii) for carriage return is char(13) - char converts to ascii character..... does this point you in the right direction?