General Network Error / SQL Server does not exist

Hi world,
I get the General Network Error (and sometimes the SqlServer does not
exist).
I used to get this issue for the past few months. What I used to do is
restart SQL Server (from the system tray) one or two times and it used
to continue working. I never cared.
Now one of our customers is complaining the same issue! :-)
Googling about i heard people offering "setting named pipes as the
default". I went to the Sql Server Client Network Utility program and
couldn't find any such option in the "DB-Library Options" tab to change
this default setting.
Or is the above solution for some other problem.
Thanks a lot..
Regards,
MichelleHave you tried setting up an alias to your sql server using tcp/ip?
Please post your os/sql environment as well as your clients
nivek
<mich_stone@.yahoo.com> wrote in message
news:1109590304.342547.188290@.f14g2000cwb.googlegroups.com...
> Hi world,
> I get the General Network Error (and sometimes the SqlServer does not
> exist).
> I used to get this issue for the past few months. What I used to do is
> restart SQL Server (from the system tray) one or two times and it used
> to continue working. I never cared.
> Now one of our customers is complaining the same issue! :-)
> Googling about i heard people offering "setting named pipes as the
> default". I went to the Sql Server Client Network Utility program and
> couldn't find any such option in the "DB-Library Options" tab to change
> this default setting.
> Or is the above solution for some other problem.
> Thanks a lot..
> Regards,
> Michelle
>|||Thanks for the reply. Here is some more info on my problem
OS : Windows XP
Application: On ASP.NET
Sql Server: Developer Edition (also tried with MSDE)
The application always looks at "localhost"
I have "NAMED PIPES" and "TCPIP" in the GENERAL tab selected in the
network client utility. Clicking Properties on NAMED PIPES gives
"Network Protocal Default Value Setup = sql\query". Clicking properties
on TCPIP gives "1433".
I have two aliases defined to two OTHER servers on the internet. I am
just mentioning that for completeness, as those two servers have got
nothing to do with the one having the problem.
DB Library Options File Name = "c:\windows\system32\ntwdlib.dll"
Hope this is enough information for someone to help me out.
Thanks and regards
Michelle
nivek wrote:
> Have you tried setting up an alias to your sql server using tcp/ip?
> Please post your os/sql environment as well as your clients
> nivek
> <mich_stone@.yahoo.com> wrote in message
> news:1109590304.342547.188290@.f14g2000cwb.googlegroups.com...
> > Hi world,
> >
> > I get the General Network Error (and sometimes the SqlServer does
not
> > exist).
> >
> > I used to get this issue for the past few months. What I used to do
is
> > restart SQL Server (from the system tray) one or two times and it
used
> > to continue working. I never cared.
> >
> > Now one of our customers is complaining the same issue! :-)
> >
> > Googling about i heard people offering "setting named pipes as the
> > default". I went to the Sql Server Client Network Utility program
and
> > couldn't find any such option in the "DB-Library Options" tab to
change
> > this default setting.
> >
> > Or is the above solution for some other problem.
> >
> > Thanks a lot..
> >
> > Regards,
> >
> > Michelle
> >

General Network Error / SQL Server does not exist

Hi world,
I get the General Network Error (and sometimes the SqlServer does not
exist).
I used to get this issue for the past few months. What I used to do is
restart SQL Server (from the system tray) one or two times and it used
to continue working. I never cared.
Now one of our customers is complaining the same issue! :-)
Googling about i heard people offering "setting named pipes as the
default". I went to the Sql Server Client Network Utility program and
couldn't find any such option in the "DB-Library Options" tab to change
this default setting.
Or is the above solution for some other problem.
Thanks a lot..
Regards,
Michelle
Have you tried setting up an alias to your sql server using tcp/ip?
Please post your os/sql environment as well as your clients
nivek
<mich_stone@.yahoo.com> wrote in message
news:1109590304.342547.188290@.f14g2000cwb.googlegr oups.com...
> Hi world,
> I get the General Network Error (and sometimes the SqlServer does not
> exist).
> I used to get this issue for the past few months. What I used to do is
> restart SQL Server (from the system tray) one or two times and it used
> to continue working. I never cared.
> Now one of our customers is complaining the same issue! :-)
> Googling about i heard people offering "setting named pipes as the
> default". I went to the Sql Server Client Network Utility program and
> couldn't find any such option in the "DB-Library Options" tab to change
> this default setting.
> Or is the above solution for some other problem.
> Thanks a lot..
> Regards,
> Michelle
>
|||Thanks for the reply. Here is some more info on my problem
OS : Windows XP
Application: On ASP.NET
Sql Server: Developer Edition (also tried with MSDE)
The application always looks at "localhost"
I have "NAMED PIPES" and "TCPIP" in the GENERAL tab selected in the
network client utility. Clicking Properties on NAMED PIPES gives
"Network Protocal Default Value Setup = sql\query". Clicking properties
on TCPIP gives "1433".
I have two aliases defined to two OTHER servers on the internet. I am
just mentioning that for completeness, as those two servers have got
nothing to do with the one having the problem.
DB Library Options File Name = "c:\windows\system32\ntwdlib.dll"
Hope this is enough information for someone to help me out.
Thanks and regards
Michelle
nivek wrote:[vbcol=seagreen]
> Have you tried setting up an alias to your sql server using tcp/ip?
> Please post your os/sql environment as well as your clients
> nivek
> <mich_stone@.yahoo.com> wrote in message
> news:1109590304.342547.188290@.f14g2000cwb.googlegr oups.com...
not[vbcol=seagreen]
is[vbcol=seagreen]
used[vbcol=seagreen]
and[vbcol=seagreen]
change[vbcol=seagreen]

General Network Error / SQL Server does not exist

Hi world,
I get the General Network Error (and sometimes the SqlServer does not
exist).
I used to get this issue for the past few months. What I used to do is
restart SQL Server (from the system tray) one or two times and it used
to continue working. I never cared.
Now one of our customers is complaining the same issue! :-)
Googling about i heard people offering "setting named pipes as the
default". I went to the Sql Server Client Network Utility program and
couldn't find any such option in the "DB-Library Options" tab to change
this default setting.
Or is the above solution for some other problem.
Thanks a lot..
Regards,
MichelleHave you tried setting up an alias to your sql server using tcp/ip?
Please post your os/sql environment as well as your clients
nivek
<mich_stone@.yahoo.com> wrote in message
news:1109590304.342547.188290@.f14g2000cwb.googlegroups.com...
> Hi world,
> I get the General Network Error (and sometimes the SqlServer does not
> exist).
> I used to get this issue for the past few months. What I used to do is
> restart SQL Server (from the system tray) one or two times and it used
> to continue working. I never cared.
> Now one of our customers is complaining the same issue! :-)
> Googling about i heard people offering "setting named pipes as the
> default". I went to the Sql Server Client Network Utility program and
> couldn't find any such option in the "DB-Library Options" tab to change
> this default setting.
> Or is the above solution for some other problem.
> Thanks a lot..
> Regards,
> Michelle
>|||Thanks for the reply. Here is some more info on my problem
OS : Windows XP
Application: On ASP.NET
Sql Server: Developer Edition (also tried with MSDE)
The application always looks at "localhost"
I have "NAMED PIPES" and "TCPIP" in the GENERAL tab selected in the
network client utility. Clicking Properties on NAMED PIPES gives
"Network Protocal Default Value Setup = sql\query". Clicking properties
on TCPIP gives "1433".
I have two aliases defined to two OTHER servers on the internet. I am
just mentioning that for completeness, as those two servers have got
nothing to do with the one having the problem.
DB Library Options File Name = "c:\windows\system32\ntwdlib.dll"
Hope this is enough information for someone to help me out.
Thanks and regards
Michelle
nivek wrote:[vbcol=seagreen]
> Have you tried setting up an alias to your sql server using tcp/ip?
> Please post your os/sql environment as well as your clients
> nivek
> <mich_stone@.yahoo.com> wrote in message
> news:1109590304.342547.188290@.f14g2000cwb.googlegroups.com...
not[vbcol=seagreen]
is[vbcol=seagreen]
used[vbcol=seagreen]
and[vbcol=seagreen]
change[vbcol=seagreen]

Function TRIM does not exist?

Hi;
i have this code for my data tab on one of my reports, im getting an error
that says TRIM function does not exists...
Any ideas?
declare @.MESACTUAL INT,@.MESANTERIOR INT;
declare @.ANOACTUAL INT,@.ANOANTERIOR INT;
declare @.MESACT CHAR(2),@.MESANT char(2);
SET @.MESACTUAL=MONTH(@.MES)
SET @.ANOACTUAL=YEAR(@.MES)
IF @.MESACTUAL=12
BEGIN
SET @.MESANTERIOR=1
SET @.ANOANTERIOR=(@.ANOACTUAL-1)
END
ELSE
BEGIN
SET @.MESANTERIOR=(@.MESACTUAL-1)
SET @.ANOANTERIOR=@.ANOACTUAL
END
SET @.MESACT=CONVERT(char(2),@.MESACTUAL)
SET @.MESANT=CONVERT(char(2),@.MESANTERIOR)
IF @.MESACTUAL < 10
begin
SET @.MESACT='0' & Trim(@.MESACT)
end
IF @.MESANTERIOR < 10
begin
SET @.MESANT='0' & Trim(@.MESANT)
end
IF @.MESACTUAL>1
BEGIN
exec('Select c.*,(case when c.Naturaleza='+@.dato+'D'+@.dato+' then
s.s'+@.MESACT+' else 0 end) as Deudor,'+
'(case when c.Naturaleza='+@.dato+'A'+@.dato+' then
s.s'+@.MESACT+' else 0 end) as Acreedor,'+
's.C'+@.MESACT+' as CargosActual,s.A'+@.MESACT+' as
AbonosActual,'+
'(case when c.Naturaleza='+@.dato+'A'+@.dato+' then
s.s'+@.MESANT+' else 0 end) as AcreedorAnt,'+
'(case when c.Naturaleza='+@.dato+'D'+@.dato+' then
s.s'+@.MESANT+' else 0 end) as DeudorAnt '+
' from GrupoVilla.dbo.CuentasContables c INNER JOIN '+
@.BASEDATOS+'.dbo.cnt_Saldos s ON
s.id_CuentasContables=c.id_CuentasContables where 1=1'
)
ENDtry rtrim and ltrim
"Willo" <willoberto@.yahoo.com.mx> wrote in message
news:%23s6Knw0ZHHA.2436@.TK2MSFTNGP06.phx.gbl...
> Hi;
> i have this code for my data tab on one of my reports, im getting an error
> that says TRIM function does not exists...
> Any ideas?
> declare @.MESACTUAL INT,@.MESANTERIOR INT;
> declare @.ANOACTUAL INT,@.ANOANTERIOR INT;
> declare @.MESACT CHAR(2),@.MESANT char(2);
> SET @.MESACTUAL=MONTH(@.MES)
> SET @.ANOACTUAL=YEAR(@.MES)
> IF @.MESACTUAL=12
> BEGIN
> SET @.MESANTERIOR=1
> SET @.ANOANTERIOR=(@.ANOACTUAL-1)
> END
> ELSE
> BEGIN
> SET @.MESANTERIOR=(@.MESACTUAL-1)
> SET @.ANOANTERIOR=@.ANOACTUAL
> END
> SET @.MESACT=CONVERT(char(2),@.MESACTUAL)
> SET @.MESANT=CONVERT(char(2),@.MESANTERIOR)
> IF @.MESACTUAL < 10
> begin
> SET @.MESACT='0' & Trim(@.MESACT)
> end
> IF @.MESANTERIOR < 10
> begin
> SET @.MESANT='0' & Trim(@.MESANT)
> end
>
>
> IF @.MESACTUAL>1
> BEGIN
> exec('Select c.*,(case when c.Naturaleza='+@.dato+'D'+@.dato+' then
> s.s'+@.MESACT+' else 0 end) as Deudor,'+
> '(case when c.Naturaleza='+@.dato+'A'+@.dato+' then
> s.s'+@.MESACT+' else 0 end) as Acreedor,'+
> 's.C'+@.MESACT+' as CargosActual,s.A'+@.MESACT+' as
> AbonosActual,'+
> '(case when c.Naturaleza='+@.dato+'A'+@.dato+' then
> s.s'+@.MESANT+' else 0 end) as AcreedorAnt,'+
> '(case when c.Naturaleza='+@.dato+'D'+@.dato+' then
> s.s'+@.MESANT+' else 0 end) as DeudorAnt '+
> ' from GrupoVilla.dbo.CuentasContables c INNER JOIN '+
> @.BASEDATOS+'.dbo.cnt_Saldos s ON
> s.id_CuentasContables=c.id_CuentasContables where 1=1'
> )
> END
>|||On Mar 15, 5:00 pm, "Jeje" <willg...@.hotmail.com> wrote:
> try rtrim and ltrim
> "Willo" <willobe...@.yahoo.com.mx> wrote in message
> news:%23s6Knw0ZHHA.2436@.TK2MSFTNGP06.phx.gbl...
> > Hi;
> > i have this code for my data tab on one of my reports, im getting an error
> > that says TRIM function does not exists...
> > Any ideas?
> > declare @.MESACTUAL INT,@.MESANTERIOR INT;
> > declare @.ANOACTUAL INT,@.ANOANTERIOR INT;
> > declare @.MESACT CHAR(2),@.MESANT char(2);
> > SET @.MESACTUAL=MONTH(@.MES)
> > SET @.ANOACTUAL=YEAR(@.MES)
> > IF @.MESACTUAL=12
> > BEGIN
> > SET @.MESANTERIOR=1
> > SET @.ANOANTERIOR=(@.ANOACTUAL-1)
> > END
> > ELSE
> > BEGIN
> > SET @.MESANTERIOR=(@.MESACTUAL-1)
> > SET @.ANOANTERIOR=@.ANOACTUAL
> > END
> > SET @.MESACT=CONVERT(char(2),@.MESACTUAL)
> > SET @.MESANT=CONVERT(char(2),@.MESANTERIOR)
> > IF @.MESACTUAL < 10
> > begin
> > SET @.MESACT='0' & Trim(@.MESACT)
> > end
> > IF @.MESANTERIOR < 10
> > begin
> > SET @.MESANT='0' & Trim(@.MESANT)
> > end
> > IF @.MESACTUAL>1
> > BEGIN
> > exec('Select c.*,(case when c.Naturaleza='+@.dato+'D'+@.dato+' then
> > s.s'+@.MESACT+' else 0 end) as Deudor,'+
> > '(case when c.Naturaleza='+@.dato+'A'+@.dato+' then
> > s.s'+@.MESACT+' else 0 end) as Acreedor,'+
> > 's.C'+@.MESACT+' as CargosActual,s.A'+@.MESACT+' as
> > AbonosActual,'+
> > '(case when c.Naturaleza='+@.dato+'A'+@.dato+' then
> > s.s'+@.MESANT+' else 0 end) as AcreedorAnt,'+
> > '(case when c.Naturaleza='+@.dato+'D'+@.dato+' then
> > s.s'+@.MESANT+' else 0 end) as DeudorAnt '+
> > ' from GrupoVilla.dbo.CuentasContables c INNER JOIN '+
> > @.BASEDATOS+'.dbo.cnt_Saldos s ON
> > s.id_CuentasContables=c.id_CuentasContables where 1=1'
> > )
> > END
Here's an example:
ltrim(rtrim(@.MESACT))
Regards,
Enrique Martinez
Sr. SQL Server Developer|||SQL server doens't have TRIM, but RS has "TRIM" function, which can be used
in layout and not on Data tab. Just for your info.
Amarnath, MCTS.
"Willo" wrote:
> Hi;
> i have this code for my data tab on one of my reports, im getting an error
> that says TRIM function does not exists...
> Any ideas?
> declare @.MESACTUAL INT,@.MESANTERIOR INT;
> declare @.ANOACTUAL INT,@.ANOANTERIOR INT;
> declare @.MESACT CHAR(2),@.MESANT char(2);
> SET @.MESACTUAL=MONTH(@.MES)
> SET @.ANOACTUAL=YEAR(@.MES)
> IF @.MESACTUAL=12
> BEGIN
> SET @.MESANTERIOR=1
> SET @.ANOANTERIOR=(@.ANOACTUAL-1)
> END
> ELSE
> BEGIN
> SET @.MESANTERIOR=(@.MESACTUAL-1)
> SET @.ANOANTERIOR=@.ANOACTUAL
> END
> SET @.MESACT=CONVERT(char(2),@.MESACTUAL)
> SET @.MESANT=CONVERT(char(2),@.MESANTERIOR)
> IF @.MESACTUAL < 10
> begin
> SET @.MESACT='0' & Trim(@.MESACT)
> end
> IF @.MESANTERIOR < 10
> begin
> SET @.MESANT='0' & Trim(@.MESANT)
> end
>
>
> IF @.MESACTUAL>1
> BEGIN
> exec('Select c.*,(case when c.Naturaleza='+@.dato+'D'+@.dato+' then
> s.s'+@.MESACT+' else 0 end) as Deudor,'+
> '(case when c.Naturaleza='+@.dato+'A'+@.dato+' then
> s.s'+@.MESACT+' else 0 end) as Acreedor,'+
> 's.C'+@.MESACT+' as CargosActual,s.A'+@.MESACT+' as
> AbonosActual,'+
> '(case when c.Naturaleza='+@.dato+'A'+@.dato+' then
> s.s'+@.MESANT+' else 0 end) as AcreedorAnt,'+
> '(case when c.Naturaleza='+@.dato+'D'+@.dato+' then
> s.s'+@.MESANT+' else 0 end) as DeudorAnt '+
> ' from GrupoVilla.dbo.CuentasContables c INNER JOIN '+
> @.BASEDATOS+'.dbo.cnt_Saldos s ON
> s.id_CuentasContables=c.id_CuentasContables where 1=1'
> )
> END
>
>

function does not exist for decision tree when running tutorial

When I run the Microsoft tutorial for data mining I get this error when I get to the decision tree part.
I get a similar error for clustering in the same tutorial.
However, The Naive Bayes demo seems fine.
The messages said the project was built and deployed without errors.

Does anyone know how to fix the error:

TITLE: Microsoft Visual Studio

The tree graph cannot be created because of the following error:

'Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[DecisionTrees].[GetTreeScores]' function does not exist.'.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.762&EvtSrc=Microsoft.AnalysisServices.Viewers.SR&EvtID=ErrorCreateGraphFailed&LinkId=20476

ADDITIONAL INFORMATION:

Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[DecisionTrees].[GetTreeScores]' function does not exist. (Microsoft OLE DB Provider for Analysis Services 2005)

BUTTONS:

OK

Please follow my answer in a previous thread to fix this problem:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=928000&SiteID=1

Please let me know whether this works.

Good luck,

|||Thank-you that did work - however, it did not seem to work the first time I tried it. I rebooted the server and then it worked - though I don't know if that is related.

I have an OLAP directory in two places MSSQL.2 and MSSQL.5.
The programs mentioned were in mssql.5 but the system entry was pointing to mssql.2
I wondering if I should also copy the subdirectories that are under olap/bin to mssql.2

I'm also wondering how this happened in the first place.
I am fairly certain the files were not deleted from mssql.2 by accident.

Could this be an installation issue?

I started out with the trial version and 'upgraded' to a fully licensed version.

Thanks again.|||

I think it is an installation issue.

I had the same problem when upgrading from "Standard Edition" to "Enterprise Edition".

Couldn't change the setting to MSSQL.5 in the path string. Needed to copy all the files into MSSQL.2. Now I've got them in both places, which seems a little redundant and weird.

FullText Search Error 1075: The dependency service does not exist or

Hi Guys,
Can you please help me with the following problem:
My website keeps crashing and the FullText Search cannot start. I keep
getting errors 7003 in the Event Log with the following message:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7003
Date: 3/8/2008
Time: 3:18:24 PM
User: N/A
Computer: MASTER
Description:
The SQL Server FullText Search (MSSQLSERVER) service depends on the
following nonexistent service: NTLMSSP
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
When trying to start the service from Services window I get the
following error:
FullText Search Error 1075: The dependency service does not exist or
has been marked for deletion
Checked the Dependencies in Registry and sqlserver has the following
dependencies: RPCSS NTLMSSP
I have had to restart the server multiple times and cannot figure out
what the problem is.
Windows Server 2003 Standart Edition
SQL Server 2005 Workgroup Edition
Please help
AlbanoOn Mar 9, 2:56=A0am, alstef...@.gmail.com wrote:
> Hi Guys,
> Can you please help me with the following problem:
> My website keeps crashing and the FullText Search cannot start. I keep
> getting errors 7003 in the Event Log with the following message:
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7003
> Date: =A03/8/2008
> Time: =A03:18:24 PM
> User: =A0N/A
> Computer: MASTER
> Description:
> The SQL Server FullText Search (MSSQLSERVER) service depends on the
> following nonexistent service: NTLMSSP
> For more information, see Help and Support Center athttp://go.microsoft.co=
m/fwlink/events.asp.
> When trying to start the service from Services window I get the
> following error:
> FullText Search Error 1075: The dependency service does not exist or
> has been marked for deletion
> Checked the Dependencies in Registry and sqlserver has the following
> dependencies: RPCSS NTLMSSP
> I have had to restart the server multiple times and cannot figure out
> what the problem is.
> Windows Server 2003 Standart Edition
> SQL Server 2005 Workgroup Edition
> Please help
> Albano
Try this
1. Open the registry key HKEY_LOCAL_MACHINE\System\CurrentControlSet
\Services\msftesql
2. Rename the value DependOnService to anything
3. Restart the server
This have helped me.

Fulltext query fails with "The content index is corrupt." on sql server 2005

What are my options here, does a repair exist or do I have to delete and rebuild the entire index?

I am afraid you will need to rebuild your entire index. There is no such option as 'repair'.

Please, feel free to contact me letting me know which operations toke place in order to have this corrupted status, as it is not common indeed.

Thanks.

Fulltext query fails with "The content index is corrupt." on sql server 2005

What are my options here, does a repair exist or do I have to delete and rebuild the entire index?

I am afraid you will need to rebuild your entire index. There is no such option as 'repair'.

Please, feel free to contact me letting me know which operations toke place in order to have this corrupted status, as it is not common indeed.

Thanks.