Receiving error:
"General network error. Check your network documentation. [SQLSTATE 08S01]
(Error 11)".
Running on SQLServer 2000 EE, SP3, Windows 2000 Adv.
This started after we rebuild the server. We have tens of jobs that run at
night. This error is happening only randomly as some days nothing happens
and same job runs fine but other day it blows up. It is not happening with
same job either. Then we restart the job and it runs fine.This error message is generated from ODBC, and not really
from SQL Server. It is generated when a connection
something the ODBC fails ie DB2 (see Microsoft) so
although SQL Server is reporting it, it is not the cause.
I would sugest that you go through the Event View on your
NT, or put in a trace to see exactly where it fails.
J
>--Original Message--
>Receiving error:
>"General network error. Check your network documentation.
[SQLSTATE 08S01]
>(Error 11)".
>Running on SQLServer 2000 EE, SP3, Windows 2000 Adv.
>This started after we rebuild the server. We have tens
of jobs that run at
>night. This error is happening only randomly as some
days nothing happens
>and same job runs fine but other day it blows up. It is
not happening with
>same job either. Then we restart the job and it runs
fine.
>
>.
>|||Nothing in the event log or SQLServer log accept that error message.
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:1302301c4433d$9f6096f0$a101280a@.phx.gbl...
> This error message is generated from ODBC, and not really
> from SQL Server. It is generated when a connection
> something the ODBC fails ie DB2 (see Microsoft) so
> although SQL Server is reporting it, it is not the cause.
> I would sugest that you go through the Event View on your
> NT, or put in a trace to see exactly where it fails.
> J
>
> >--Original Message--
> >Receiving error:
> >"General network error. Check your network documentation.
> [SQLSTATE 08S01]
> >(Error 11)".
> >
> >Running on SQLServer 2000 EE, SP3, Windows 2000 Adv.
> >
> >This started after we rebuild the server. We have tens
> of jobs that run at
> >night. This error is happening only randomly as some
> days nothing happens
> >and same job runs fine but other day it blows up. It is
> not happening with
> >same job either. Then we restart the job and it runs
> fine.
> >
> >
> >
> >.
> >|||Hi ilovesql,
We are expiriencing the same issue - I was woundering if you had this resolved.
I also wanted to ask you - when you rebuild the server did it have the same configuration as before or you installed SP3 for SQL Server?
We went from Win2000 server SQL server 2000 SP2 to WIN2003 server SP3 and we started to have this problem from that day on. Microsoft is working on it but this is the second day and they haven't came up with the solution.
I think it is SP3 - something is not right with it.
Thanks,
Anna
"ilovesql" wrote:
> Nothing in the event log or SQLServer log accept that error message.
>
> "Julie" <anonymous@.discussions.microsoft.com> wrote in message
> news:1302301c4433d$9f6096f0$a101280a@.phx.gbl...
> > This error message is generated from ODBC, and not really
> > from SQL Server. It is generated when a connection
> > something the ODBC fails ie DB2 (see Microsoft) so
> > although SQL Server is reporting it, it is not the cause.
> > I would sugest that you go through the Event View on your
> > NT, or put in a trace to see exactly where it fails.
> >
> > J
> >
> >
> > >--Original Message--
> > >Receiving error:
> > >"General network error. Check your network documentation.
> > [SQLSTATE 08S01]
> > >(Error 11)".
> > >
> > >Running on SQLServer 2000 EE, SP3, Windows 2000 Adv.
> > >
> > >This started after we rebuild the server. We have tens
> > of jobs that run at
> > >night. This error is happening only randomly as some
> > days nothing happens
> > >and same job runs fine but other day it blows up. It is
> > not happening with
> > >same job either. Then we restart the job and it runs
> > fine.
> > >
> > >
> > >
> > >.
> > >
>
>
Showing posts with label windows. Show all posts
Showing posts with label windows. Show all posts
Thursday, March 29, 2012
General Network Error while backing up databases
Microsoft SQL Server 2000 - 8.00.780 (Intel X86)
Mar 3 2003 10:28:28
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
Client is Windows XP SP 1
I have this intermittent problem when attempting to backup a database
from another machine. Each time SQL Server communicates back the
status of the backup, I get a general network error as follows:
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
10 percent backed up.
Connection Broken
My backup script is very simple, as I am just backing up a test
database:
BACKUP DATABASE Development
TO DISK = 'Development_2003_09_04.bak'
WITH STATS = 10
It is not a query timeout, because I checked. I also varied the STATS
parameter to smaller values and the connection breaks at different
times, as follows:
Disconnect@.15 seconds:
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
10 percent backed up.
Connection Broken
Disconnect@.9 seconds:
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
5 percent backed up.
Connection Broken
Disconnect@.4 seconds:
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
2 percent backed up.
Connection Broken
The SQL Server log only lists that the backup fails, but doesn't give
a reason. The event log also listed the backup failures but didn't
give any more information than the sql log. I did notice the
following error in the server's application log:
Event Type: Error
Event Source: MSSQLServer
Event Category: (8)
Event ID: 19011
Date: 9/4/2003
Time: 3:02:29 AM
User: N/A
Computer: DAEDALUS
Description:
SuperSocket info: Failed to get Exclusive port use(MSAFD Tcpip
[TCP/IP]) : Error 10013.
followed by this warning:
Event Type: Warning
Event Source: MSSQLServer
Event Category: (8)
Event ID: 19011
Date: 9/4/2003
Time: 3:02:30 AM
User: N/A
Computer: DAEDALUS
Description:
SuperSocket info: (SpnRegister) : Error 8344.
Ideas?
Brandon Lilly
--
"In the beginning the universe was created. This has made a lot of
people very angry, and has been widely regarded as a bad move." -
Douglas Noel Adams (1952-2001)"jeff" <jeff@.hotmail.com> wrote in message
news:217001c37318$11a76be0$a601280a@.phx.gbl...
> Looks like a permission issue. Try adding sql server
> startup account to local NT admin, restart sql server,
> connect using sysadmin or sa from the xp client, and issue
> backup command again.
I added the account to Builtin\Administrators and also to Domain
Admins to no avail. After stopping and starting SQL Server, the
backup command would still fail if run from my client, regardless of
whether I logged in as SA, or using windows authentication (I am the
domain admin).
I am able to backup a different database remotely, but it is very
small (< 3MB) as opposed to the development database which is about 1
GB. They have the same security.
Brandon
--
"In the beginning the universe was created. This has made a lot of
people very angry, and has been widely regarded as a bad move." -
Douglas Noel Adams (1952-2001)|||I don't know anything more on this. Try posting your
question to microsoft.public.win2000.networking group, or
to one of winsock progrrammers group.
Good luck.
>--Original Message--
>"jeff" <jeff@.hotmail.com> wrote in message
>news:217001c37318$11a76be0$a601280a@.phx.gbl...
>> Looks like a permission issue. Try adding sql server
>> startup account to local NT admin, restart sql server,
>> connect using sysadmin or sa from the xp client, and
issue
>> backup command again.
>I added the account to Builtin\Administrators and also to
Domain
>Admins to no avail. After stopping and starting SQL
Server, the
>backup command would still fail if run from my client,
regardless of
>whether I logged in as SA, or using windows
authentication (I am the
>domain admin).
>I am able to backup a different database remotely, but it
is very
>small (< 3MB) as opposed to the development database
which is about 1
>GB. They have the same security.
>Brandon
>--
>"In the beginning the universe was created. This has
made a lot of
>people very angry, and has been widely regarded as a bad
move." -
>Douglas Noel Adams (1952-2001)
>
>.
>|||Brandon,
I am a little confused as to what your actually trying to do. You state
your backing up to a remote server but your backup command does not show
that.
> BACKUP DATABASE Development
> TO DISK = 'Development_2003_09_04.bak'
> WITH STATS = 10
Actually it doesn't show a location at all. You should probably be using
UNC to specify the device if it's remote.
--
Andrew J. Kelly
SQL Server MVP
"Brandon Lilly" <brandon.lilly@.nospam_medevolve.com> wrote in message
news:epoqWBwcDHA.2436@.TK2MSFTNGP12.phx.gbl...
> Microsoft SQL Server 2000 - 8.00.780 (Intel X86)
> Mar 3 2003 10:28:28
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
>
> Client is Windows XP SP 1
>
> I have this intermittent problem when attempting to backup a database
> from another machine. Each time SQL Server communicates back the
> status of the backup, I get a general network error as follows:
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> 10 percent backed up.
> Connection Broken
>
> My backup script is very simple, as I am just backing up a test
> database:
> BACKUP DATABASE Development
> TO DISK = 'Development_2003_09_04.bak'
> WITH STATS = 10
>
> It is not a query timeout, because I checked. I also varied the STATS
> parameter to smaller values and the connection breaks at different
> times, as follows:
> Disconnect@.15 seconds:
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> 10 percent backed up.
> Connection Broken
>
> Disconnect@.9 seconds:
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> 5 percent backed up.
> Connection Broken
>
> Disconnect@.4 seconds:
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> 2 percent backed up.
> Connection Broken
>
> The SQL Server log only lists that the backup fails, but doesn't give
> a reason. The event log also listed the backup failures but didn't
> give any more information than the sql log. I did notice the
> following error in the server's application log:
>
> Event Type: Error
> Event Source: MSSQLServer
> Event Category: (8)
> Event ID: 19011
> Date: 9/4/2003
> Time: 3:02:29 AM
> User: N/A
> Computer: DAEDALUS
> Description:
> SuperSocket info: Failed to get Exclusive port use(MSAFD Tcpip
> [TCP/IP]) : Error 10013.
> followed by this warning:
> Event Type: Warning
> Event Source: MSSQLServer
> Event Category: (8)
> Event ID: 19011
> Date: 9/4/2003
> Time: 3:02:30 AM
> User: N/A
> Computer: DAEDALUS
> Description:
> SuperSocket info: (SpnRegister) : Error 8344.
> Ideas?
>
> Brandon Lilly
> --
> "In the beginning the universe was created. This has made a lot of
> people very angry, and has been widely regarded as a bad move." -
> Douglas Noel Adams (1952-2001)
>|||OK, I see now.. It looks like your using named pipes, have you tried
connecting with tcp instead and see if that makes any difference?
--
Andrew J. Kelly
SQL Server MVP
"Brandon Lilly" <brandon.lilly@.nospam_medevolve.com> wrote in message
news:u5jcPl%23cDHA.2392@.TK2MSFTNGP10.phx.gbl...
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:Oji9ot7cDHA.2564@.TK2MSFTNGP09.phx.gbl...
> > I am a little confused as to what your actually trying to do. You
> state
> > your backing up to a remote server but your backup command does not
> show
> > that.
> > Actually it doesn't show a location at all. You should probably be
> using
> > UNC to specify the device if it's remote.
> I am backing up a remote server, meaning that I am not at that machine
> running query analyzer - I am at a client machine on the domain
> executing the backup script. I don't specify a location, because I am
> just wanting it to backup to the default location
> Sorry if my post was misleading.
> Brandon
> --
> "In the beginning the universe was created. This has made a lot of
> people very angry, and has been widely regarded as a bad move." -
> Douglas Noel Adams (1952-2001)
>
Mar 3 2003 10:28:28
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
Client is Windows XP SP 1
I have this intermittent problem when attempting to backup a database
from another machine. Each time SQL Server communicates back the
status of the backup, I get a general network error as follows:
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
10 percent backed up.
Connection Broken
My backup script is very simple, as I am just backing up a test
database:
BACKUP DATABASE Development
TO DISK = 'Development_2003_09_04.bak'
WITH STATS = 10
It is not a query timeout, because I checked. I also varied the STATS
parameter to smaller values and the connection breaks at different
times, as follows:
Disconnect@.15 seconds:
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
10 percent backed up.
Connection Broken
Disconnect@.9 seconds:
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
5 percent backed up.
Connection Broken
Disconnect@.4 seconds:
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
2 percent backed up.
Connection Broken
The SQL Server log only lists that the backup fails, but doesn't give
a reason. The event log also listed the backup failures but didn't
give any more information than the sql log. I did notice the
following error in the server's application log:
Event Type: Error
Event Source: MSSQLServer
Event Category: (8)
Event ID: 19011
Date: 9/4/2003
Time: 3:02:29 AM
User: N/A
Computer: DAEDALUS
Description:
SuperSocket info: Failed to get Exclusive port use(MSAFD Tcpip
[TCP/IP]) : Error 10013.
followed by this warning:
Event Type: Warning
Event Source: MSSQLServer
Event Category: (8)
Event ID: 19011
Date: 9/4/2003
Time: 3:02:30 AM
User: N/A
Computer: DAEDALUS
Description:
SuperSocket info: (SpnRegister) : Error 8344.
Ideas?
Brandon Lilly
--
"In the beginning the universe was created. This has made a lot of
people very angry, and has been widely regarded as a bad move." -
Douglas Noel Adams (1952-2001)"jeff" <jeff@.hotmail.com> wrote in message
news:217001c37318$11a76be0$a601280a@.phx.gbl...
> Looks like a permission issue. Try adding sql server
> startup account to local NT admin, restart sql server,
> connect using sysadmin or sa from the xp client, and issue
> backup command again.
I added the account to Builtin\Administrators and also to Domain
Admins to no avail. After stopping and starting SQL Server, the
backup command would still fail if run from my client, regardless of
whether I logged in as SA, or using windows authentication (I am the
domain admin).
I am able to backup a different database remotely, but it is very
small (< 3MB) as opposed to the development database which is about 1
GB. They have the same security.
Brandon
--
"In the beginning the universe was created. This has made a lot of
people very angry, and has been widely regarded as a bad move." -
Douglas Noel Adams (1952-2001)|||I don't know anything more on this. Try posting your
question to microsoft.public.win2000.networking group, or
to one of winsock progrrammers group.
Good luck.
>--Original Message--
>"jeff" <jeff@.hotmail.com> wrote in message
>news:217001c37318$11a76be0$a601280a@.phx.gbl...
>> Looks like a permission issue. Try adding sql server
>> startup account to local NT admin, restart sql server,
>> connect using sysadmin or sa from the xp client, and
issue
>> backup command again.
>I added the account to Builtin\Administrators and also to
Domain
>Admins to no avail. After stopping and starting SQL
Server, the
>backup command would still fail if run from my client,
regardless of
>whether I logged in as SA, or using windows
authentication (I am the
>domain admin).
>I am able to backup a different database remotely, but it
is very
>small (< 3MB) as opposed to the development database
which is about 1
>GB. They have the same security.
>Brandon
>--
>"In the beginning the universe was created. This has
made a lot of
>people very angry, and has been widely regarded as a bad
move." -
>Douglas Noel Adams (1952-2001)
>
>.
>|||Brandon,
I am a little confused as to what your actually trying to do. You state
your backing up to a remote server but your backup command does not show
that.
> BACKUP DATABASE Development
> TO DISK = 'Development_2003_09_04.bak'
> WITH STATS = 10
Actually it doesn't show a location at all. You should probably be using
UNC to specify the device if it's remote.
--
Andrew J. Kelly
SQL Server MVP
"Brandon Lilly" <brandon.lilly@.nospam_medevolve.com> wrote in message
news:epoqWBwcDHA.2436@.TK2MSFTNGP12.phx.gbl...
> Microsoft SQL Server 2000 - 8.00.780 (Intel X86)
> Mar 3 2003 10:28:28
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
>
> Client is Windows XP SP 1
>
> I have this intermittent problem when attempting to backup a database
> from another machine. Each time SQL Server communicates back the
> status of the backup, I get a general network error as follows:
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> 10 percent backed up.
> Connection Broken
>
> My backup script is very simple, as I am just backing up a test
> database:
> BACKUP DATABASE Development
> TO DISK = 'Development_2003_09_04.bak'
> WITH STATS = 10
>
> It is not a query timeout, because I checked. I also varied the STATS
> parameter to smaller values and the connection breaks at different
> times, as follows:
> Disconnect@.15 seconds:
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> 10 percent backed up.
> Connection Broken
>
> Disconnect@.9 seconds:
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> 5 percent backed up.
> Connection Broken
>
> Disconnect@.4 seconds:
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> 2 percent backed up.
> Connection Broken
>
> The SQL Server log only lists that the backup fails, but doesn't give
> a reason. The event log also listed the backup failures but didn't
> give any more information than the sql log. I did notice the
> following error in the server's application log:
>
> Event Type: Error
> Event Source: MSSQLServer
> Event Category: (8)
> Event ID: 19011
> Date: 9/4/2003
> Time: 3:02:29 AM
> User: N/A
> Computer: DAEDALUS
> Description:
> SuperSocket info: Failed to get Exclusive port use(MSAFD Tcpip
> [TCP/IP]) : Error 10013.
> followed by this warning:
> Event Type: Warning
> Event Source: MSSQLServer
> Event Category: (8)
> Event ID: 19011
> Date: 9/4/2003
> Time: 3:02:30 AM
> User: N/A
> Computer: DAEDALUS
> Description:
> SuperSocket info: (SpnRegister) : Error 8344.
> Ideas?
>
> Brandon Lilly
> --
> "In the beginning the universe was created. This has made a lot of
> people very angry, and has been widely regarded as a bad move." -
> Douglas Noel Adams (1952-2001)
>|||OK, I see now.. It looks like your using named pipes, have you tried
connecting with tcp instead and see if that makes any difference?
--
Andrew J. Kelly
SQL Server MVP
"Brandon Lilly" <brandon.lilly@.nospam_medevolve.com> wrote in message
news:u5jcPl%23cDHA.2392@.TK2MSFTNGP10.phx.gbl...
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:Oji9ot7cDHA.2564@.TK2MSFTNGP09.phx.gbl...
> > I am a little confused as to what your actually trying to do. You
> state
> > your backing up to a remote server but your backup command does not
> show
> > that.
> > Actually it doesn't show a location at all. You should probably be
> using
> > UNC to specify the device if it's remote.
> I am backing up a remote server, meaning that I am not at that machine
> running query analyzer - I am at a client machine on the domain
> executing the backup script. I don't specify a location, because I am
> just wanting it to backup to the default location
> Sorry if my post was misleading.
> Brandon
> --
> "In the beginning the universe was created. This has made a lot of
> people very angry, and has been widely regarded as a bad move." -
> Douglas Noel Adams (1952-2001)
>
General network error when you try to back up or restore a SQL Server 2000 on Windows 2000
I am receiving General network error when I try to back up a SQL Server
database on a computer that is running Windows Server 2000
I receive Following error when running DB maintenance job:
[2] Database master: Database Backup...
Destination: [\\LGA01\SysDbBackup_01\master_db_200503311443.BAK ]
[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft][ODBC SQL
Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
[Microsoft][ODBC SQL Server Driver][Named Pipes]General network error. Check
your network documentation.
[Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pages for
database 'master', file 'mastlog' on file 1.
[3] Database model: Database Backup...
Destination: [\\LGA01\SysDbBackup_01\model_db_200503311443.B AK]
Please Help
Hi
Maintenance plans do not support UNC paths. You need to use T-SQL to do
that.
At the same time, check that the account that the SQL Service is running
under has permissions on the destination directory.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rafet Ducic" <rducic@.hotmail.com> wrote in message
news:OZbJL6iNFHA.164@.TK2MSFTNGP12.phx.gbl...
>I am receiving General network error when I try to back up a SQL Server
> database on a computer that is running Windows Server 2000
> I receive Following error when running DB maintenance job:
> [2] Database master: Database Backup...
> Destination: [\\LGA01\SysDbBackup_01\master_db_200503311443.BAK ]
> [Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft][ODBC
> SQL
> Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
> [Microsoft][ODBC SQL Server Driver][Named Pipes]General network error.
> Check
> your network documentation.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pages for
> database 'master', file 'mastlog' on file 1.
> [3] Database model: Database Backup...
> Destination: [\\LGA01\SysDbBackup_01\model_db_200503311443.B AK]
> Please Help
>
database on a computer that is running Windows Server 2000
I receive Following error when running DB maintenance job:
[2] Database master: Database Backup...
Destination: [\\LGA01\SysDbBackup_01\master_db_200503311443.BAK ]
[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft][ODBC SQL
Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
[Microsoft][ODBC SQL Server Driver][Named Pipes]General network error. Check
your network documentation.
[Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pages for
database 'master', file 'mastlog' on file 1.
[3] Database model: Database Backup...
Destination: [\\LGA01\SysDbBackup_01\model_db_200503311443.B AK]
Please Help
Hi
Maintenance plans do not support UNC paths. You need to use T-SQL to do
that.
At the same time, check that the account that the SQL Service is running
under has permissions on the destination directory.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rafet Ducic" <rducic@.hotmail.com> wrote in message
news:OZbJL6iNFHA.164@.TK2MSFTNGP12.phx.gbl...
>I am receiving General network error when I try to back up a SQL Server
> database on a computer that is running Windows Server 2000
> I receive Following error when running DB maintenance job:
> [2] Database master: Database Backup...
> Destination: [\\LGA01\SysDbBackup_01\master_db_200503311443.BAK ]
> [Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft][ODBC
> SQL
> Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
> [Microsoft][ODBC SQL Server Driver][Named Pipes]General network error.
> Check
> your network documentation.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pages for
> database 'master', file 'mastlog' on file 1.
> [3] Database model: Database Backup...
> Destination: [\\LGA01\SysDbBackup_01\model_db_200503311443.B AK]
> Please Help
>
General network error when you try to back up or restore a SQL Server 2000 on Windows
I am receiving General network error when I try to back up a SQL Server
database on a computer that is running Windows Server 2000
I receive Following error when running DB maintenance job:
[2] Database master: Database Backup...
Destination: & #91;\\LGA01\SysDbBackup_01\master_db_200
503311443.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft]&#
91;ODBC SQL
Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
[Microsoft][ODBC SQL Server Driver][Named Pipes]General network
error. Check
your network documentation.
[Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pages
for
database 'master', file 'mastlog' on file 1.
[3] Database model: Database Backup...
Destination: & #91;\\LGA01\SysDbBackup_01\model_db_2005
03311443.BAK]
Please HelpHi
Maintenance plans do not support UNC paths. You need to use T-SQL to do
that.
At the same time, check that the account that the SQL Service is running
under has permissions on the destination directory.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rafet Ducic" <rducic@.hotmail.com> wrote in message
news:OZbJL6iNFHA.164@.TK2MSFTNGP12.phx.gbl...
>I am receiving General network error when I try to back up a SQL Server
> database on a computer that is running Windows Server 2000
> I receive Following error when running DB maintenance job:
> [2] Database master: Database Backup...
> Destination: & #91;\\LGA01\SysDbBackup_01\master_db_200
503311443.BAK]
> [Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft]
[ODBC
> SQL
> Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
> [Microsoft][ODBC SQL Server Driver][Named Pipes]General networ
k error.
> Check
> your network documentation.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pag
es for
> database 'master', file 'mastlog' on file 1.
> [3] Database model: Database Backup...
> Destination: & #91;\\LGA01\SysDbBackup_01\model_db_2005
03311443.BAK]
> Please Help
>
database on a computer that is running Windows Server 2000
I receive Following error when running DB maintenance job:
[2] Database master: Database Backup...
Destination: & #91;\\LGA01\SysDbBackup_01\master_db_200
503311443.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft]&#
91;ODBC SQL
Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
[Microsoft][ODBC SQL Server Driver][Named Pipes]General network
error. Check
your network documentation.
[Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pages
for
database 'master', file 'mastlog' on file 1.
[3] Database model: Database Backup...
Destination: & #91;\\LGA01\SysDbBackup_01\model_db_2005
03311443.BAK]
Please HelpHi
Maintenance plans do not support UNC paths. You need to use T-SQL to do
that.
At the same time, check that the account that the SQL Service is running
under has permissions on the destination directory.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rafet Ducic" <rducic@.hotmail.com> wrote in message
news:OZbJL6iNFHA.164@.TK2MSFTNGP12.phx.gbl...
>I am receiving General network error when I try to back up a SQL Server
> database on a computer that is running Windows Server 2000
> I receive Following error when running DB maintenance job:
> [2] Database master: Database Backup...
> Destination: & #91;\\LGA01\SysDbBackup_01\master_db_200
503311443.BAK]
> [Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft]
[ODBC
> SQL
> Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
> [Microsoft][ODBC SQL Server Driver][Named Pipes]General networ
k error.
> Check
> your network documentation.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pag
es for
> database 'master', file 'mastlog' on file 1.
> [3] Database model: Database Backup...
> Destination: & #91;\\LGA01\SysDbBackup_01\model_db_2005
03311443.BAK]
> Please Help
>
General Network Error on subscriber
I am trying to replicate over a dial-up connection a database between
a server running Sql Server 2000 on Windows 2000 server and two SQL
server 2000 personal edition on Windows XP pro.
For one site, the replication worked correclty. For the other one, the
replication process starts, but when trying to connect to the
subscriber (i.e Windows XP pro), after waiting 5 minutes the following
error message is displayed:
Merge Process could not retreive generation information at the
subscriber.
General Network error source <windows xp database> (data source) error
number 11.
Replication tries again automatically and same error is displayed.
All suggestions are welcome.
Best Regards
Patrick
Use the slow link profile for this problem subscribe. Right click on the
agent (expand replication monitor, replication agents, merge agents, locate
your agent), select agent profiles, select the slow link profile, accept
defaults and restart it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Patrick" <pmenage@.intnet.mu> wrote in message
news:4b9f6ca1.0411250208.6f22429a@.posting.google.c om...
>I am trying to replicate over a dial-up connection a database between
> a server running Sql Server 2000 on Windows 2000 server and two SQL
> server 2000 personal edition on Windows XP pro.
> For one site, the replication worked correclty. For the other one, the
> replication process starts, but when trying to connect to the
> subscriber (i.e Windows XP pro), after waiting 5 minutes the following
> error message is displayed:
> Merge Process could not retreive generation information at the
> subscriber.
> General Network error source <windows xp database> (data source) error
> number 11.
> Replication tries again automatically and same error is displayed.
> All suggestions are welcome.
> Best Regards
> Patrick
|||I just found the solution. When I entered my user name in the dial-up
connection box I entered it with the remote machine name eg: PC1\User1.
But when I checked the user in the "add user to operating system" module
in Windows XP, the machine name was dropped, only the user name
appeared. So when connecting, I entered only the user name, and
everything worked fine.
Thank you for your support.
Best Regards
Patrick
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
a server running Sql Server 2000 on Windows 2000 server and two SQL
server 2000 personal edition on Windows XP pro.
For one site, the replication worked correclty. For the other one, the
replication process starts, but when trying to connect to the
subscriber (i.e Windows XP pro), after waiting 5 minutes the following
error message is displayed:
Merge Process could not retreive generation information at the
subscriber.
General Network error source <windows xp database> (data source) error
number 11.
Replication tries again automatically and same error is displayed.
All suggestions are welcome.
Best Regards
Patrick
Use the slow link profile for this problem subscribe. Right click on the
agent (expand replication monitor, replication agents, merge agents, locate
your agent), select agent profiles, select the slow link profile, accept
defaults and restart it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Patrick" <pmenage@.intnet.mu> wrote in message
news:4b9f6ca1.0411250208.6f22429a@.posting.google.c om...
>I am trying to replicate over a dial-up connection a database between
> a server running Sql Server 2000 on Windows 2000 server and two SQL
> server 2000 personal edition on Windows XP pro.
> For one site, the replication worked correclty. For the other one, the
> replication process starts, but when trying to connect to the
> subscriber (i.e Windows XP pro), after waiting 5 minutes the following
> error message is displayed:
> Merge Process could not retreive generation information at the
> subscriber.
> General Network error source <windows xp database> (data source) error
> number 11.
> Replication tries again automatically and same error is displayed.
> All suggestions are welcome.
> Best Regards
> Patrick
|||I just found the solution. When I entered my user name in the dial-up
connection box I entered it with the remote machine name eg: PC1\User1.
But when I checked the user in the "add user to operating system" module
in Windows XP, the machine name was dropped, only the user name
appeared. So when connecting, I entered only the user name, and
everything worked fine.
Thank you for your support.
Best Regards
Patrick
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Tuesday, March 27, 2012
General Network error
I am using Windows Form with web service, I am getting error ocassionally when I am accessing records "System.data.sqlclient.sqlexception General Network error" , When I click again the error disappears.This is not a security related error. You should try the SQL Server Data Access forum. If you want, I can move this thread there, just let me know.
Thanks
Laurentiu|||HI!! Laurentiu,
Kindly move the thread to Sql Server Data Access Forum.
Thank You
Uminder Khatri|||
The information here is really not sufficient for us to help figure this out. Can you give us some more detail as to what your configuration is?
Are you running .Net 1.1?
What version of SQL Server are you running?
It could quite possibly be that the server is crashing. Can you check out the error logs on the server and see if there's anything suspicious there?
Thanks.
sqlWednesday, March 21, 2012
Funny Results from using Surface Area Configuration for Features
Hi,
I am using a Windows account that is a local admin on the server yet when I
use Surface Area Configuration for features I only see Reporting Services
and Integration Services. I understand that this feature is using WMI but
what would stop me from seeing the actual Database Engine components?
Thanks
Chris
Worse still I can only see those 2 services when I use the Configuration
Manager/SQL Server 2005 Services. Some how I have lost the ability to see
all the services. I would have to believe that this is a permissions
problem?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I am using a Windows account that is a local admin on the server yet when
> I use Surface Area Configuration for features I only see Reporting
> Services and Integration Services. I understand that this feature is using
> WMI but what would stop me from seeing the actual Database Engine
> components?
> Thanks
> Chris
>
|||Could this have happened because a different person, using a different
Windows Account, used Microsoft Update to update the server? Has some
permissions been changed to the other account?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:OG618d2iHHA.1884@.TK2MSFTNGP06.phx.gbl...
> Worse still I can only see those 2 services when I use the Configuration
> Manager/SQL Server 2005 Services. Some how I have lost the ability to see
> all the services. I would have to believe that this is a permissions
> problem?
> Thanks
> Chris
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
>
I am using a Windows account that is a local admin on the server yet when I
use Surface Area Configuration for features I only see Reporting Services
and Integration Services. I understand that this feature is using WMI but
what would stop me from seeing the actual Database Engine components?
Thanks
Chris
Worse still I can only see those 2 services when I use the Configuration
Manager/SQL Server 2005 Services. Some how I have lost the ability to see
all the services. I would have to believe that this is a permissions
problem?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I am using a Windows account that is a local admin on the server yet when
> I use Surface Area Configuration for features I only see Reporting
> Services and Integration Services. I understand that this feature is using
> WMI but what would stop me from seeing the actual Database Engine
> components?
> Thanks
> Chris
>
|||Could this have happened because a different person, using a different
Windows Account, used Microsoft Update to update the server? Has some
permissions been changed to the other account?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:OG618d2iHHA.1884@.TK2MSFTNGP06.phx.gbl...
> Worse still I can only see those 2 services when I use the Configuration
> Manager/SQL Server 2005 Services. Some how I have lost the ability to see
> all the services. I would have to believe that this is a permissions
> problem?
> Thanks
> Chris
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
>
Funny Results from using Surface Area Configuration for Features
Hi,
I am using a Windows account that is a local admin on the server yet when I
use Surface Area Configuration for features I only see Reporting Services
and Integration Services. I understand that this feature is using WMI but
what would stop me from seeing the actual Database Engine components?
Thanks
ChrisWorse still I can only see those 2 services when I use the Configuration
Manager/SQL Server 2005 Services. Some how I have lost the ability to see
all the services. I would have to believe that this is a permissions
problem?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I am using a Windows account that is a local admin on the server yet when
> I use Surface Area Configuration for features I only see Reporting
> Services and Integration Services. I understand that this feature is using
> WMI but what would stop me from seeing the actual Database Engine
> components?
> Thanks
> Chris
>|||Could this have happened because a different person, using a different
Windows Account, used Microsoft Update to update the server? Has some
permissions been changed to the other account?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:OG618d2iHHA.1884@.TK2MSFTNGP06.phx.gbl...
> Worse still I can only see those 2 services when I use the Configuration
> Manager/SQL Server 2005 Services. Some how I have lost the ability to see
> all the services. I would have to believe that this is a permissions
> problem?
> Thanks
> Chris
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
>sql
I am using a Windows account that is a local admin on the server yet when I
use Surface Area Configuration for features I only see Reporting Services
and Integration Services. I understand that this feature is using WMI but
what would stop me from seeing the actual Database Engine components?
Thanks
ChrisWorse still I can only see those 2 services when I use the Configuration
Manager/SQL Server 2005 Services. Some how I have lost the ability to see
all the services. I would have to believe that this is a permissions
problem?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I am using a Windows account that is a local admin on the server yet when
> I use Surface Area Configuration for features I only see Reporting
> Services and Integration Services. I understand that this feature is using
> WMI but what would stop me from seeing the actual Database Engine
> components?
> Thanks
> Chris
>|||Could this have happened because a different person, using a different
Windows Account, used Microsoft Update to update the server? Has some
permissions been changed to the other account?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:OG618d2iHHA.1884@.TK2MSFTNGP06.phx.gbl...
> Worse still I can only see those 2 services when I use the Configuration
> Manager/SQL Server 2005 Services. Some how I have lost the ability to see
> all the services. I would have to believe that this is a permissions
> problem?
> Thanks
> Chris
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
>sql
Funny Results from using Surface Area Configuration for Features
Hi,
I am using a Windows account that is a local admin on the server yet when I
use Surface Area Configuration for features I only see Reporting Services
and Integration Services. I understand that this feature is using WMI but
what would stop me from seeing the actual Database Engine components?
Thanks
ChrisWorse still I can only see those 2 services when I use the Configuration
Manager/SQL Server 2005 Services. Some how I have lost the ability to see
all the services. I would have to believe that this is a permissions
problem?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I am using a Windows account that is a local admin on the server yet when
> I use Surface Area Configuration for features I only see Reporting
> Services and Integration Services. I understand that this feature is using
> WMI but what would stop me from seeing the actual Database Engine
> components?
> Thanks
> Chris
>|||Could this have happened because a different person, using a different
Windows Account, used Microsoft Update to update the server? Has some
permissions been changed to the other account?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:OG618d2iHHA.1884@.TK2MSFTNGP06.phx.gbl...
> Worse still I can only see those 2 services when I use the Configuration
> Manager/SQL Server 2005 Services. Some how I have lost the ability to see
> all the services. I would have to believe that this is a permissions
> problem?
> Thanks
> Chris
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I am using a Windows account that is a local admin on the server yet when
>> I use Surface Area Configuration for features I only see Reporting
>> Services and Integration Services. I understand that this feature is
>> using WMI but what would stop me from seeing the actual Database Engine
>> components?
>> Thanks
>> Chris
>
I am using a Windows account that is a local admin on the server yet when I
use Surface Area Configuration for features I only see Reporting Services
and Integration Services. I understand that this feature is using WMI but
what would stop me from seeing the actual Database Engine components?
Thanks
ChrisWorse still I can only see those 2 services when I use the Configuration
Manager/SQL Server 2005 Services. Some how I have lost the ability to see
all the services. I would have to believe that this is a permissions
problem?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I am using a Windows account that is a local admin on the server yet when
> I use Surface Area Configuration for features I only see Reporting
> Services and Integration Services. I understand that this feature is using
> WMI but what would stop me from seeing the actual Database Engine
> components?
> Thanks
> Chris
>|||Could this have happened because a different person, using a different
Windows Account, used Microsoft Update to update the server? Has some
permissions been changed to the other account?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:OG618d2iHHA.1884@.TK2MSFTNGP06.phx.gbl...
> Worse still I can only see those 2 services when I use the Configuration
> Manager/SQL Server 2005 Services. Some how I have lost the ability to see
> all the services. I would have to believe that this is a permissions
> problem?
> Thanks
> Chris
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I am using a Windows account that is a local admin on the server yet when
>> I use Surface Area Configuration for features I only see Reporting
>> Services and Integration Services. I understand that this feature is
>> using WMI but what would stop me from seeing the actual Database Engine
>> components?
>> Thanks
>> Chris
>
Wednesday, March 7, 2012
Function - List Windows Group Members
Hello!
I thinking of creating a SQL Server clr function that works like this.
Input paremeter: A Windows group, e.g. Domain1\Group1
Resultset: A list of all accounts that directely or indirectely belongs to
that Windows group.
e.g.
Domain1\Account1
Domain1\Account2
Domain1\Account3
The idea is to use this together with the security catalog views to get a
list of accounts that is for example sysadmins.
Could it be that a function like this exist in SQL Server?
I also thought about what AD permisssions that would be needed?
Best regards
Ola Hallengren
Hi
You can create an ADSI linked server and query the active directory, but
recursing through the groups not always that easy. There is a script to list
all group members on http://www.rlmueller.net/freecode3.htm
John
"Ola Hallengren" wrote:
> Hello!
> I thinking of creating a SQL Server clr function that works like this.
> Input paremeter: A Windows group, e.g. Domain1\Group1
> Resultset: A list of all accounts that directely or indirectely belongs to
> that Windows group.
> e.g.
> Domain1\Account1
> Domain1\Account2
> Domain1\Account3
> The idea is to use this together with the security catalog views to get a
> list of accounts that is for example sysadmins.
> Could it be that a function like this exist in SQL Server?
> I also thought about what AD permisssions that would be needed?
> Best regards
> Ola Hallengren
|||Thanks, John. As I understand it I have about these options.
1. Create an ADSI linked server and query against that with TSQL. This can
be packaged into a SQL Server function.
2. Use the VBScript at http://www.rlmueller.net/freecode3.htm from
xp_cmdshell. This can be packaged into a stored procedure.
3. Create some CLR code with the same logic as in the VBScript and use that
assambly in a SQL Server function.
Is this right?
/Ola
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You can create an ADSI linked server and query the active directory, but
> recursing through the groups not always that easy. There is a script to list
> all group members on http://www.rlmueller.net/freecode3.htm
> John
> "Ola Hallengren" wrote:
|||I think so, I would opt for either 2 or 3 but have never tried 3!.
John
"Ola Hallengren" <OlaHallengren@.discussions.microsoft.com> wrote in message
news:05FC89C1-3816-41B9-9123-5D9E4FFBEFC0@.microsoft.com...[vbcol=seagreen]
> Thanks, John. As I understand it I have about these options.
> 1. Create an ADSI linked server and query against that with TSQL. This can
> be packaged into a SQL Server function.
> 2. Use the VBScript at http://www.rlmueller.net/freecode3.htm from
> xp_cmdshell. This can be packaged into a stored procedure.
> 3. Create some CLR code with the same logic as in the VBScript and use
> that
> assambly in a SQL Server function.
> Is this right?
> /Ola
>
> "John Bell" wrote:
I thinking of creating a SQL Server clr function that works like this.
Input paremeter: A Windows group, e.g. Domain1\Group1
Resultset: A list of all accounts that directely or indirectely belongs to
that Windows group.
e.g.
Domain1\Account1
Domain1\Account2
Domain1\Account3
The idea is to use this together with the security catalog views to get a
list of accounts that is for example sysadmins.
Could it be that a function like this exist in SQL Server?
I also thought about what AD permisssions that would be needed?
Best regards
Ola Hallengren
Hi
You can create an ADSI linked server and query the active directory, but
recursing through the groups not always that easy. There is a script to list
all group members on http://www.rlmueller.net/freecode3.htm
John
"Ola Hallengren" wrote:
> Hello!
> I thinking of creating a SQL Server clr function that works like this.
> Input paremeter: A Windows group, e.g. Domain1\Group1
> Resultset: A list of all accounts that directely or indirectely belongs to
> that Windows group.
> e.g.
> Domain1\Account1
> Domain1\Account2
> Domain1\Account3
> The idea is to use this together with the security catalog views to get a
> list of accounts that is for example sysadmins.
> Could it be that a function like this exist in SQL Server?
> I also thought about what AD permisssions that would be needed?
> Best regards
> Ola Hallengren
|||Thanks, John. As I understand it I have about these options.
1. Create an ADSI linked server and query against that with TSQL. This can
be packaged into a SQL Server function.
2. Use the VBScript at http://www.rlmueller.net/freecode3.htm from
xp_cmdshell. This can be packaged into a stored procedure.
3. Create some CLR code with the same logic as in the VBScript and use that
assambly in a SQL Server function.
Is this right?
/Ola
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You can create an ADSI linked server and query the active directory, but
> recursing through the groups not always that easy. There is a script to list
> all group members on http://www.rlmueller.net/freecode3.htm
> John
> "Ola Hallengren" wrote:
|||I think so, I would opt for either 2 or 3 but have never tried 3!.
John
"Ola Hallengren" <OlaHallengren@.discussions.microsoft.com> wrote in message
news:05FC89C1-3816-41B9-9123-5D9E4FFBEFC0@.microsoft.com...[vbcol=seagreen]
> Thanks, John. As I understand it I have about these options.
> 1. Create an ADSI linked server and query against that with TSQL. This can
> be packaged into a SQL Server function.
> 2. Use the VBScript at http://www.rlmueller.net/freecode3.htm from
> xp_cmdshell. This can be packaged into a stored procedure.
> 3. Create some CLR code with the same logic as in the VBScript and use
> that
> assambly in a SQL Server function.
> Is this right?
> /Ola
>
> "John Bell" wrote:
Function - List Windows Group Members
Hello!
I thinking of creating a SQL Server clr function that works like this.
Input paremeter: A Windows group, e.g. Domain1\Group1
Resultset: A list of all accounts that directely or indirectely belongs to
that Windows group.
e.g.
Domain1\Account1
Domain1\Account2
Domain1\Account3
The idea is to use this together with the security catalog views to get a
list of accounts that is for example sysadmins.
Could it be that a function like this exist in SQL Server?
I also thought about what AD permisssions that would be needed?
Best regards
Ola HallengrenHi
You can create an ADSI linked server and query the active directory, but
recursing through the groups not always that easy. There is a script to list
all group members on http://www.rlmueller.net/freecode3.htm
John
"Ola Hallengren" wrote:
> Hello!
> I thinking of creating a SQL Server clr function that works like this.
> Input paremeter: A Windows group, e.g. Domain1\Group1
> Resultset: A list of all accounts that directely or indirectely belongs to
> that Windows group.
> e.g.
> Domain1\Account1
> Domain1\Account2
> Domain1\Account3
> The idea is to use this together with the security catalog views to get a
> list of accounts that is for example sysadmins.
> Could it be that a function like this exist in SQL Server?
> I also thought about what AD permisssions that would be needed?
> Best regards
> Ola Hallengren|||Thanks, John. As I understand it I have about these options.
1. Create an ADSI linked server and query against that with TSQL. This can
be packaged into a SQL Server function.
2. Use the VBScript at http://www.rlmueller.net/freecode3.htm from
xp_cmdshell. This can be packaged into a stored procedure.
3. Create some CLR code with the same logic as in the VBScript and use that
assambly in a SQL Server function.
Is this right?
/Ola
"John Bell" wrote:
> Hi
> You can create an ADSI linked server and query the active directory, but
> recursing through the groups not always that easy. There is a script to list
> all group members on http://www.rlmueller.net/freecode3.htm
> John
> "Ola Hallengren" wrote:
> > Hello!
> >
> > I thinking of creating a SQL Server clr function that works like this.
> >
> > Input paremeter: A Windows group, e.g. Domain1\Group1
> >
> > Resultset: A list of all accounts that directely or indirectely belongs to
> > that Windows group.
> >
> > e.g.
> > Domain1\Account1
> > Domain1\Account2
> > Domain1\Account3
> >
> > The idea is to use this together with the security catalog views to get a
> > list of accounts that is for example sysadmins.
> >
> > Could it be that a function like this exist in SQL Server?
> >
> > I also thought about what AD permisssions that would be needed?
> >
> > Best regards
> >
> > Ola Hallengren|||I think so, I would opt for either 2 or 3 but have never tried 3!.
John
"Ola Hallengren" <OlaHallengren@.discussions.microsoft.com> wrote in message
news:05FC89C1-3816-41B9-9123-5D9E4FFBEFC0@.microsoft.com...
> Thanks, John. As I understand it I have about these options.
> 1. Create an ADSI linked server and query against that with TSQL. This can
> be packaged into a SQL Server function.
> 2. Use the VBScript at http://www.rlmueller.net/freecode3.htm from
> xp_cmdshell. This can be packaged into a stored procedure.
> 3. Create some CLR code with the same logic as in the VBScript and use
> that
> assambly in a SQL Server function.
> Is this right?
> /Ola
>
> "John Bell" wrote:
>> Hi
>> You can create an ADSI linked server and query the active directory, but
>> recursing through the groups not always that easy. There is a script to
>> list
>> all group members on http://www.rlmueller.net/freecode3.htm
>> John
>> "Ola Hallengren" wrote:
>> > Hello!
>> >
>> > I thinking of creating a SQL Server clr function that works like this.
>> >
>> > Input paremeter: A Windows group, e.g. Domain1\Group1
>> >
>> > Resultset: A list of all accounts that directely or indirectely belongs
>> > to
>> > that Windows group.
>> >
>> > e.g.
>> > Domain1\Account1
>> > Domain1\Account2
>> > Domain1\Account3
>> >
>> > The idea is to use this together with the security catalog views to get
>> > a
>> > list of accounts that is for example sysadmins.
>> >
>> > Could it be that a function like this exist in SQL Server?
>> >
>> > I also thought about what AD permisssions that would be needed?
>> >
>> > Best regards
>> >
>> > Ola Hallengren
I thinking of creating a SQL Server clr function that works like this.
Input paremeter: A Windows group, e.g. Domain1\Group1
Resultset: A list of all accounts that directely or indirectely belongs to
that Windows group.
e.g.
Domain1\Account1
Domain1\Account2
Domain1\Account3
The idea is to use this together with the security catalog views to get a
list of accounts that is for example sysadmins.
Could it be that a function like this exist in SQL Server?
I also thought about what AD permisssions that would be needed?
Best regards
Ola HallengrenHi
You can create an ADSI linked server and query the active directory, but
recursing through the groups not always that easy. There is a script to list
all group members on http://www.rlmueller.net/freecode3.htm
John
"Ola Hallengren" wrote:
> Hello!
> I thinking of creating a SQL Server clr function that works like this.
> Input paremeter: A Windows group, e.g. Domain1\Group1
> Resultset: A list of all accounts that directely or indirectely belongs to
> that Windows group.
> e.g.
> Domain1\Account1
> Domain1\Account2
> Domain1\Account3
> The idea is to use this together with the security catalog views to get a
> list of accounts that is for example sysadmins.
> Could it be that a function like this exist in SQL Server?
> I also thought about what AD permisssions that would be needed?
> Best regards
> Ola Hallengren|||Thanks, John. As I understand it I have about these options.
1. Create an ADSI linked server and query against that with TSQL. This can
be packaged into a SQL Server function.
2. Use the VBScript at http://www.rlmueller.net/freecode3.htm from
xp_cmdshell. This can be packaged into a stored procedure.
3. Create some CLR code with the same logic as in the VBScript and use that
assambly in a SQL Server function.
Is this right?
/Ola
"John Bell" wrote:
> Hi
> You can create an ADSI linked server and query the active directory, but
> recursing through the groups not always that easy. There is a script to list
> all group members on http://www.rlmueller.net/freecode3.htm
> John
> "Ola Hallengren" wrote:
> > Hello!
> >
> > I thinking of creating a SQL Server clr function that works like this.
> >
> > Input paremeter: A Windows group, e.g. Domain1\Group1
> >
> > Resultset: A list of all accounts that directely or indirectely belongs to
> > that Windows group.
> >
> > e.g.
> > Domain1\Account1
> > Domain1\Account2
> > Domain1\Account3
> >
> > The idea is to use this together with the security catalog views to get a
> > list of accounts that is for example sysadmins.
> >
> > Could it be that a function like this exist in SQL Server?
> >
> > I also thought about what AD permisssions that would be needed?
> >
> > Best regards
> >
> > Ola Hallengren|||I think so, I would opt for either 2 or 3 but have never tried 3!.
John
"Ola Hallengren" <OlaHallengren@.discussions.microsoft.com> wrote in message
news:05FC89C1-3816-41B9-9123-5D9E4FFBEFC0@.microsoft.com...
> Thanks, John. As I understand it I have about these options.
> 1. Create an ADSI linked server and query against that with TSQL. This can
> be packaged into a SQL Server function.
> 2. Use the VBScript at http://www.rlmueller.net/freecode3.htm from
> xp_cmdshell. This can be packaged into a stored procedure.
> 3. Create some CLR code with the same logic as in the VBScript and use
> that
> assambly in a SQL Server function.
> Is this right?
> /Ola
>
> "John Bell" wrote:
>> Hi
>> You can create an ADSI linked server and query the active directory, but
>> recursing through the groups not always that easy. There is a script to
>> list
>> all group members on http://www.rlmueller.net/freecode3.htm
>> John
>> "Ola Hallengren" wrote:
>> > Hello!
>> >
>> > I thinking of creating a SQL Server clr function that works like this.
>> >
>> > Input paremeter: A Windows group, e.g. Domain1\Group1
>> >
>> > Resultset: A list of all accounts that directely or indirectely belongs
>> > to
>> > that Windows group.
>> >
>> > e.g.
>> > Domain1\Account1
>> > Domain1\Account2
>> > Domain1\Account3
>> >
>> > The idea is to use this together with the security catalog views to get
>> > a
>> > list of accounts that is for example sysadmins.
>> >
>> > Could it be that a function like this exist in SQL Server?
>> >
>> > I also thought about what AD permisssions that would be needed?
>> >
>> > Best regards
>> >
>> > Ola Hallengren
Sunday, February 26, 2012
FullTextSearch
Hi,
My FullTextSearch on clustered SQL Server 2000 in Windows 2003 is failing.
How do i fix it or do i need to reinstall?How?
This is the error msg i get.What file is it looking for?By replacing the
file, can i get it back online?
"An error occurred during the online operation for instance <SQL Server
Fulltext (CLUSTERABC)>: 80070002 - The system cannot find the file specified."
TIA
Did you rebuild the cluster? You may get this error after attempting to
rebuild the cluster when linger components of the initial failed cluster
installation failed. Consult
http://support.microsoft.com/kb/2909...22120121120120 for
more information.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:2B996818-7985-4B50-8F53-8E8336E18EDB@.microsoft.com...
> Hi,
> My FullTextSearch on clustered SQL Server 2000 in Windows 2003 is failing.
> How do i fix it or do i need to reinstall?How?
> This is the error msg i get.What file is it looking for?By replacing the
> file, can i get it back online?
> "An error occurred during the online operation for instance <SQL Server
> Fulltext (CLUSTERABC)>: 80070002 - The system cannot find the file
> specified."
> TIA
|||hi,
i didnt reinstall the cluster. It's just failing recently. Any idea? Any way
to fix it?
TIA
"Hilary Cotter" wrote:
> Did you rebuild the cluster? You may get this error after attempting to
> rebuild the cluster when linger components of the initial failed cluster
> installation failed. Consult
> http://support.microsoft.com/kb/2909...22120121120120 for
> more information.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:2B996818-7985-4B50-8F53-8E8336E18EDB@.microsoft.com...
>
>
My FullTextSearch on clustered SQL Server 2000 in Windows 2003 is failing.
How do i fix it or do i need to reinstall?How?
This is the error msg i get.What file is it looking for?By replacing the
file, can i get it back online?
"An error occurred during the online operation for instance <SQL Server
Fulltext (CLUSTERABC)>: 80070002 - The system cannot find the file specified."
TIA
Did you rebuild the cluster? You may get this error after attempting to
rebuild the cluster when linger components of the initial failed cluster
installation failed. Consult
http://support.microsoft.com/kb/2909...22120121120120 for
more information.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:2B996818-7985-4B50-8F53-8E8336E18EDB@.microsoft.com...
> Hi,
> My FullTextSearch on clustered SQL Server 2000 in Windows 2003 is failing.
> How do i fix it or do i need to reinstall?How?
> This is the error msg i get.What file is it looking for?By replacing the
> file, can i get it back online?
> "An error occurred during the online operation for instance <SQL Server
> Fulltext (CLUSTERABC)>: 80070002 - The system cannot find the file
> specified."
> TIA
|||hi,
i didnt reinstall the cluster. It's just failing recently. Any idea? Any way
to fix it?
TIA
"Hilary Cotter" wrote:
> Did you rebuild the cluster? You may get this error after attempting to
> rebuild the cluster when linger components of the initial failed cluster
> installation failed. Consult
> http://support.microsoft.com/kb/2909...22120121120120 for
> more information.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:2B996818-7985-4B50-8F53-8E8336E18EDB@.microsoft.com...
>
>
FullTextSearch
Hi,
My FullTextSearch on clustered SQL Server 2000 in Windows 2003 is failing.
How do i fix it or do i need to reinstall?How?
This is the error msg i get.What file is it looking for?By replacing the
file, can i get it back online?
"An error occurred during the online operation for instance <SQL Server
Fulltext (CLUSTERABC)>: 80070002 - The system cannot find the file specified."
TIADid you rebuild the cluster? You may get this error after attempting to
rebuild the cluster when linger components of the initial failed cluster
installation failed. Consult
http://support.microsoft.com/kb/290991/en-us#XSLTH3208121122120121120120 for
more information.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:2B996818-7985-4B50-8F53-8E8336E18EDB@.microsoft.com...
> Hi,
> My FullTextSearch on clustered SQL Server 2000 in Windows 2003 is failing.
> How do i fix it or do i need to reinstall?How?
> This is the error msg i get.What file is it looking for?By replacing the
> file, can i get it back online?
> "An error occurred during the online operation for instance <SQL Server
> Fulltext (CLUSTERABC)>: 80070002 - The system cannot find the file
> specified."
> TIA|||hi,
i didnt reinstall the cluster. It's just failing recently. Any idea? Any way
to fix it?
TIA
"Hilary Cotter" wrote:
> Did you rebuild the cluster? You may get this error after attempting to
> rebuild the cluster when linger components of the initial failed cluster
> installation failed. Consult
> http://support.microsoft.com/kb/290991/en-us#XSLTH3208121122120121120120 for
> more information.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:2B996818-7985-4B50-8F53-8E8336E18EDB@.microsoft.com...
> > Hi,
> > My FullTextSearch on clustered SQL Server 2000 in Windows 2003 is failing.
> > How do i fix it or do i need to reinstall?How?
> >
> > This is the error msg i get.What file is it looking for?By replacing the
> > file, can i get it back online?
> >
> > "An error occurred during the online operation for instance <SQL Server
> > Fulltext (CLUSTERABC)>: 80070002 - The system cannot find the file
> > specified."
> >
> > TIA
>
>
My FullTextSearch on clustered SQL Server 2000 in Windows 2003 is failing.
How do i fix it or do i need to reinstall?How?
This is the error msg i get.What file is it looking for?By replacing the
file, can i get it back online?
"An error occurred during the online operation for instance <SQL Server
Fulltext (CLUSTERABC)>: 80070002 - The system cannot find the file specified."
TIADid you rebuild the cluster? You may get this error after attempting to
rebuild the cluster when linger components of the initial failed cluster
installation failed. Consult
http://support.microsoft.com/kb/290991/en-us#XSLTH3208121122120121120120 for
more information.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:2B996818-7985-4B50-8F53-8E8336E18EDB@.microsoft.com...
> Hi,
> My FullTextSearch on clustered SQL Server 2000 in Windows 2003 is failing.
> How do i fix it or do i need to reinstall?How?
> This is the error msg i get.What file is it looking for?By replacing the
> file, can i get it back online?
> "An error occurred during the online operation for instance <SQL Server
> Fulltext (CLUSTERABC)>: 80070002 - The system cannot find the file
> specified."
> TIA|||hi,
i didnt reinstall the cluster. It's just failing recently. Any idea? Any way
to fix it?
TIA
"Hilary Cotter" wrote:
> Did you rebuild the cluster? You may get this error after attempting to
> rebuild the cluster when linger components of the initial failed cluster
> installation failed. Consult
> http://support.microsoft.com/kb/290991/en-us#XSLTH3208121122120121120120 for
> more information.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:2B996818-7985-4B50-8F53-8E8336E18EDB@.microsoft.com...
> > Hi,
> > My FullTextSearch on clustered SQL Server 2000 in Windows 2003 is failing.
> > How do i fix it or do i need to reinstall?How?
> >
> > This is the error msg i get.What file is it looking for?By replacing the
> > file, can i get it back online?
> >
> > "An error occurred during the online operation for instance <SQL Server
> > Fulltext (CLUSTERABC)>: 80070002 - The system cannot find the file
> > specified."
> >
> > TIA
>
>
FullTextSearch
Hi,
My FullTextSearch on clustered SQL Server 2000 in Windows 2003 is failing.
How do i fix it or do i need to reinstall?How?
This is the error msg i get.What file is it looking for?By replacing the
file, can i get it back online?
"An error occurred during the online operation for instance <SQL Server
Fulltext (CLUSTERABC)>: 80070002 - The system cannot find the file specified
."
TIADid you rebuild the cluster? You may get this error after attempting to
rebuild the cluster when linger components of the initial failed cluster
installation failed. Consult
http://support.microsoft.com/kb/290...122120121120120 for
more information.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:2B996818-7985-4B50-8F53-8E8336E18EDB@.microsoft.com...
> Hi,
> My FullTextSearch on clustered SQL Server 2000 in Windows 2003 is failing.
> How do i fix it or do i need to reinstall?How?
> This is the error msg i get.What file is it looking for?By replacing the
> file, can i get it back online?
> "An error occurred during the online operation for instance <SQL Server
> Fulltext (CLUSTERABC)>: 80070002 - The system cannot find the file
> specified."
> TIA|||hi,
i didnt reinstall the cluster. It's just failing recently. Any idea? Any way
to fix it?
TIA
"Hilary Cotter" wrote:
> Did you rebuild the cluster? You may get this error after attempting to
> rebuild the cluster when linger components of the initial failed cluster
> installation failed. Consult
> http://support.microsoft.com/kb/290...122120121120120 f
or
> more information.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:2B996818-7985-4B50-8F53-8E8336E18EDB@.microsoft.com...
>
>
My FullTextSearch on clustered SQL Server 2000 in Windows 2003 is failing.
How do i fix it or do i need to reinstall?How?
This is the error msg i get.What file is it looking for?By replacing the
file, can i get it back online?
"An error occurred during the online operation for instance <SQL Server
Fulltext (CLUSTERABC)>: 80070002 - The system cannot find the file specified
."
TIADid you rebuild the cluster? You may get this error after attempting to
rebuild the cluster when linger components of the initial failed cluster
installation failed. Consult
http://support.microsoft.com/kb/290...122120121120120 for
more information.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:2B996818-7985-4B50-8F53-8E8336E18EDB@.microsoft.com...
> Hi,
> My FullTextSearch on clustered SQL Server 2000 in Windows 2003 is failing.
> How do i fix it or do i need to reinstall?How?
> This is the error msg i get.What file is it looking for?By replacing the
> file, can i get it back online?
> "An error occurred during the online operation for instance <SQL Server
> Fulltext (CLUSTERABC)>: 80070002 - The system cannot find the file
> specified."
> TIA|||hi,
i didnt reinstall the cluster. It's just failing recently. Any idea? Any way
to fix it?
TIA
"Hilary Cotter" wrote:
> Did you rebuild the cluster? You may get this error after attempting to
> rebuild the cluster when linger components of the initial failed cluster
> installation failed. Consult
> http://support.microsoft.com/kb/290...122120121120120 f
or
> more information.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:2B996818-7985-4B50-8F53-8E8336E18EDB@.microsoft.com...
>
>
Friday, February 24, 2012
Full-Text Search Error - Server: Msg 7635 The Microsoft Search service cannot be administered un
Hello and thank you for your assistance.
I have two instances of SQL Server 2000 Enterprise Edition (SP4) database running on Windows 2000 Enterprise server. The default instance is dev and a named instance for QA. Full-text search is enabled for dev and is functioning properly.
@.@.Version:
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
I am trying to enable full text search in the QA instance with this command: "sp_fulltext_database 'enable' ", but I am receiving the error "Server: Msg 7635 The Microsoft Search service cannot be administered under the present user account.
I can find any reference to what account it needs to run under. Can you provide me with info on why I am getting this message?
This is a common error with SQL Server 2000 Full-text Search (FTS) and the MSSearch service and there can be a few root reasons for it.
1. Did this error occur after a service pack upgrade? If so - review the files and folders under \FTDATA (in the sql server installed instance folder) against what is on your SQL Server 2000 CD. If you find any difference - copy the missing or different file from the CD to the problem server.
2. Have you removed the BUILTIN\Administrators login? If so - either add it back in or execute the sp_grantlogin from the code below as the MSSearch service requires this level of access to the MSSQLServer service.
3. Check these:
317746 PRB: SQL Server Full-Text Search Does Not Populate Catalogs
http://support.microsoft.com/kb/317746
277549 PRB: Unable to Build Full-Text Catalog After You Modify MSSQLServer Logon Account Through Control Panel
http://support.microsoft.com/kb/277549
4. Can you run this script and post the results back?
use master
go
SELLECT @.@.version
go
-- many need to set on "show advanced options"
sp_configure 'default full-text language'
go
SELECT FullTextServiceProperty('ResourceUsage') as MSSearch_Resource_Usage
go
xp_logininfo 'BUILTIN\ADMINISTRATORS', 'members'
go
-- if you have removed the BUILTIN\Administrators login, run:
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System','us_english'
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
5. And just to cover all the bases, when you changed the MSSQLServer startup account, did you do it via Win2K's Component Services? If so, could you "re-change" it via the Enterprise Manager's server property security tab?
Filip Skakun
|||Filip,
Thank you so much for your response. To answer your questions; No we haven't added any service packs recently. Yes, we do have the Builtin/Administer removed and the NT Authority has all the required privileges. Keep in mind that the default instance was working just fine.
Since the MSSQL$Inst2/FTData directory didn't exist; I suspect that FullText search was not installed with the second instance. None the less, I re-installed fulltext search (see http://support.microsoft.com/kb/827449). After doing this I no longer received the "Cannot be administered under the present account" error and the FTData directory was created for the second instance. But, at this point Full text search didn't work for both instances. I wasn't receiving any errors, but the catalogs were not getting populated. We later found that the switch in the KB article was incorrect for our servers. The article had us run "ftsetup.exe SQLServer$Instance 1 0 0 0" (incorrect). After we ran "ftsetup.exe SQLServer$Instance 0 1 0 0 0" (correct) FullText search began to function correctly for both instances.
To be honest, I don't think I had to reinstall everything. I believe I could have gotten away with just running ftsetup.exe for the second instance.
|||I am glad you got it working,
Regards,
Filip
Full-Text Search Error - Server: Msg 7635 The Microsoft Search service cannot be administered un
Hello and thank you for your assistance.
I have two instances of SQL Server 2000 Enterprise Edition (SP4) database running on Windows 2000 Enterprise server. The default instance is dev and a named instance for QA. Full-text search is enabled for dev and is functioning properly.
@.@.Version:
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
I am trying to enable full text search in the QA instance with this command: "sp_fulltext_database 'enable' ", but I am receiving the error "Server: Msg 7635 The Microsoft Search service cannot be administered under the present user account.
I can find any reference to what account it needs to run under. Can you provide me with info on why I am getting this message?
This is a common error with SQL Server 2000 Full-text Search (FTS) and the MSSearch service and there can be a few root reasons for it.
1. Did this error occur after a service pack upgrade? If so - review the files and folders under \FTDATA (in the sql server installed instance folder) against what is on your SQL Server 2000 CD. If you find any difference - copy the missing or different file from the CD to the problem server.
2. Have you removed the BUILTIN\Administrators login? If so - either add it back in or execute the sp_grantlogin from the code below as the MSSearch service requires this level of access to the MSSQLServer service.
3. Check these:
317746 PRB: SQL Server Full-Text Search Does Not Populate Catalogs
http://support.microsoft.com/kb/317746
277549 PRB: Unable to Build Full-Text Catalog After You Modify MSSQLServer Logon Account Through Control Panel
http://support.microsoft.com/kb/277549
4. Can you run this script and post the results back?
use master
go
SELLECT @.@.version
go
-- many need to set on "show advanced options"
sp_configure 'default full-text language'
go
SELECT FullTextServiceProperty('ResourceUsage') as MSSearch_Resource_Usage
go
xp_logininfo 'BUILTIN\ADMINISTRATORS', 'members'
go
-- if you have removed the BUILTIN\Administrators login, run:
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System','us_english'
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
5. And just to cover all the bases, when you changed the MSSQLServer startup account, did you do it via Win2K's Component Services? If so, could you "re-change" it via the Enterprise Manager's server property security tab?
Filip Skakun
|||Filip,
Thank you so much for your response. To answer your questions; No we haven't added any service packs recently. Yes, we do have the Builtin/Administer removed and the NT Authority has all the required privileges. Keep in mind that the default instance was working just fine.
Since the MSSQL$Inst2/FTData directory didn't exist; I suspect that FullText search was not installed with the second instance. None the less, I re-installed fulltext search (see http://support.microsoft.com/kb/827449). After doing this I no longer received the "Cannot be administered under the present account" error and the FTData directory was created for the second instance. But, at this point Full text search didn't work for both instances. I wasn't receiving any errors, but the catalogs were not getting populated. We later found that the switch in the KB article was incorrect for our servers. The article had us run "ftsetup.exe SQLServer$Instance 1 0 0 0" (incorrect). After we ran "ftsetup.exe SQLServer$Instance 0 1 0 0 0" (correct) FullText search began to function correctly for both instances.
To be honest, I don't think I had to reinstall everything. I believe I could have gotten away with just running ftsetup.exe for the second instance.
|||I am glad you got it working,
Regards,
Filip
Full-Text Search Error - Server: Msg 7635 The Microsoft Search service cannot be administere
Hello and thank you for your assistance.
I have two instances of SQL Server 2000 Enterprise Edition (SP4) database running on Windows 2000 Enterprise server. The default instance is dev and a named instance for QA. Full-text search is enabled for dev and is functioning properly.
@.@.Version:
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
I am trying to enable full text search in the QA instance with this command: "sp_fulltext_database 'enable' ", but I am receiving the error "Server: Msg 7635 The Microsoft Search service cannot be administered under the present user account.
I can find any reference to what account it needs to run under. Can you provide me with info on why I am getting this message?
This is a common error with SQL Server 2000 Full-text Search (FTS) and the MSSearch service and there can be a few root reasons for it.
1. Did this error occur after a service pack upgrade? If so - review the files and folders under \FTDATA (in the sql server installed instance folder) against what is on your SQL Server 2000 CD. If you find any difference - copy the missing or different file from the CD to the problem server.
2. Have you removed the BUILTIN\Administrators login? If so - either add it back in or execute the sp_grantlogin from the code below as the MSSearch service requires this level of access to the MSSQLServer service.
3. Check these:
317746 PRB: SQL Server Full-Text Search Does Not Populate Catalogs
http://support.microsoft.com/kb/317746
277549 PRB: Unable to Build Full-Text Catalog After You Modify MSSQLServer Logon Account Through Control Panel
http://support.microsoft.com/kb/277549
4. Can you run this script and post the results back?
use master
go
SELLECT @.@.version
go
-- many need to set on "show advanced options"
sp_configure 'default full-text language'
go
SELECT FullTextServiceProperty('ResourceUsage') as MSSearch_Resource_Usage
go
xp_logininfo 'BUILTIN\ADMINISTRATORS', 'members'
go
-- if you have removed the BUILTIN\Administrators login, run:
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System','us_english'
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
5. And just to cover all the bases, when you changed the MSSQLServer startup account, did you do it via Win2K's Component Services? If so, could you "re-change" it via the Enterprise Manager's server property security tab?
Filip Skakun
|||Filip,
Thank you so much for your response. To answer your questions; No we haven't added any service packs recently. Yes, we do have the Builtin/Administer removed and the NT Authority has all the required privileges. Keep in mind that the default instance was working just fine.
Since the MSSQL$Inst2/FTData directory didn't exist; I suspect that FullText search was not installed with the second instance. None the less, I re-installed fulltext search (see http://support.microsoft.com/kb/827449). After doing this I no longer received the "Cannot be administered under the present account" error and the FTData directory was created for the second instance. But, at this point Full text search didn't work for both instances. I wasn't receiving any errors, but the catalogs were not getting populated. We later found that the switch in the KB article was incorrect for our servers. The article had us run "ftsetup.exe SQLServer$Instance 1 0 0 0" (incorrect). After we ran "ftsetup.exe SQLServer$Instance 0 1 0 0 0" (correct) FullText search began to function correctly for both instances.
To be honest, I don't think I had to reinstall everything. I believe I could have gotten away with just running ftsetup.exe for the second instance.
|||I am glad you got it working,
Regards,
Filip
Subscribe to:
Posts (Atom)