ArcServ and SQl Server 2000

Hi,

I am trying to create a backup agent for a SQl Server. I have given the information for the following: instance, AUTHENTICATION, USERNAME, PASSWORD, CONFIRM PASSWORD.

I keep getting the error message, enter valid instance, even though i am entering in the instance.

any ideas?

Is this a named instance? Do you have any special characters like dashes in the server name?

-Sue

|||Problem solved ? If yes, post how you solved it, or if the hint from Sue helped you′.

Jens K. Suessmeyer

http://www.sqlserver2005.de

sql

Archiving AS 2000 Database to a network backup server

WE are currently using the following to archive our AS 2000 OLAP cubes to the local directory on the server:

"C:\Program Files (x86)\Microsoft Analysis Services\Bin\msmdarch" /a ServerName"C:\Program Files (x86)\Microsoft Analysis Services\Data\DataMart" "DataMart" "c:\BackupFiles\DataMart.cab" It runs inside an agent job. It works fine.

I wanted to change it to archive to our standard backup server location. So I changed it to the following:

"C:\Program Files (x86)\Microsoft Analysis Services\Bin\msmdarch" /a ServerName"C:\Program Files (x86)\Microsoft Analysis Services\Data\DataMart" "DataMart" "\\10.0.50.115\Disk3\servers\SQL\ServerName\DataMart.cab". The job now fails & outputs nothing to the log file. The only thing it says when I view history on the job is : Executed as user: SqlAdmin. The step did not generate any output. Process Exit Code 1. The step failed.

At first I thought maybe AS 2000 couldn't archive over the network so I open up AS Manager & manually did an archive to the same network location. It was successfull. So that blew my theory.

I don't know why the job won't do the archive to the network location. Any ideas?

Thanks,

John

If you can manually run the command

"C:\Program Files (x86)\Microsoft Analysis Services\Bin\msmdarch" /a ServerName"C:\Program Files (x86)\Microsoft Analysis Services\Data\DataMart" "DataMart" "\\10.0.50.115\Disk3\servers\SQL\ServerName\DataMart.cab"

then it's possible that the SqlAdmin user doesn't have write permissions to the share.

Adrian

|||

Adrian,

I forgot to mention that SQLAdmin does have privileges to the network backup location. We use this same login for all our SQL backups as well.

I wasn't ever able to get the command to run manually. I was able to manually run the archive process through Analysis manager. Don't know if that makes a difference or not.

Any other ideas?

Thanks,

JOhn

|||

Unless you have changed the default data directory, I think you have an incorrect "datamart" sub folder in your data directory parameter.

"C:\Program Files (x86)\Microsoft Analysis Services\Bin\msmdarch" /a ServerName"C:\Program Files (x86)\Microsoft Analysis Services\Data\DataMart" "DataMart" "\\10.0.50.115\Disk3\servers\SQL\ServerName\DataMart.cab"

try removing it and see if the command works then.

"C:\Program Files (x86)\Microsoft Analysis Services\Bin\msmdarch" /a ServerName"C:\Program Files (x86)\Microsoft Analysis Services\Data\" "DataMart" "\\10.0.50.115\Disk3\servers\SQL\ServerName\DataMart.cab"

Also, where are you running Analysis Manager from? Judging by the (x86) in the path I would say that your AS2k server is 64bit and all the management tools (including msmdarch.exe) are 32 bit. The last recommendation I saw said to try to run these tools from a 32bit machine and not on the 64bit server. I don't know if that means it would not work, but it might be another option to explore.

|||

Darren,

I removed the extra "datamart" from the command but same result.

Sorry I didn't mention this earlier. I am running W2K3 64 bit with AS 2000 32 bit. I was running Analysis Manager on the 64 bit server when I was able to do the archive manually. WIth this command, I am running it under SQL 2005 EE 64 bit agent job.

I tried running the following command from our 32 bit test server but it had the same result:

"C:\Program Files\Microsoft Analysis Services\Bin\msmdarch" /a 64BitServer"C:\Program Files (x86)\Microsoft Analysis Services\Data\" "DataMart" "\\10.0.50.115\Disk3\servers\SQL\64BitServer\DataMart.cab"

Any other ideas?

Thanks,

John

|||

Hmm, running out of ideas.

Have you tried mapping a drive so that you are backing up to z:\... or something like that?

Have you tried specifying the other 2 optional parameter (the logfile and tempfolder)? The log file might give you some ideas, although it might be blank, I seem to remember having trouble like this once, but I can't remember how I resolved it.

Finally, if all else fails there was some documentation, I think in the operations guide whitepaper, on how to "manually" back up an AS2k server by taking a file back up of the data directory and the repository database.

|||

Darren,

A mapped drive seems to work. Although, I don't like using mapped drives on our servers but I may have to make an exception in this instance. Maybe I will have it archive locally & then execute a batch job that would xcopy the .cab file to the backup server.

I also tried adding the log & temp folder parameters but that did not make any difference. I still got the useless blank log file. It seems like this should work or somewhere it would be documented that you can't use UNC paths for the archive process.

Thanks for the help,

JOhn

|||

Hello,

Enjoyed reading the thread, I had a thought that might be helpful:

You might try enabling UNC support for your command prompt. By default, Microsoft ships this flag turned off, but I've yet to have any trouble with it turned on. YMMV.

Microsoft KB156276 instructions for doing this:

Under the registry path:

HKEY_CURRENT_USER
\Software
\Microsoft
\Command Processor

add the value DisableUNCCheck REG_DWORD and set the value to 0 x 1 (Hex).

http://support.microsoft.com/kb/156276

I hope this helps you. Good luck...!

-ed2

|||

Ed,

Thanks for the thought. I added this to the registry & then ran my job but same result. It may need to have a reboot to get the change into effect. However, the KB article lists this as a bug for Win NT 4 & states that it would be fixed in a SP. So I would hope that this has been fixed in Windows 2003 server. I will leave it until after a reboot to see if it works or not.

THe batch job is working great btw.

John

|||

I'm sorry to hear this wasn't a fix... WIth only 8 months of mainstream support remaining on SQL Server 2000, it's hard to imagine this will get much attention, but you might try opening a call if you can justify the expense...

Read the KB article I sent you over again, and you'll find out that the fix is in Win2K, XP, and Win2K3. The KB article said that NT4 originally had no check for UNC pathing in the command prompt, and that caused problems for users who would launch Windows apps from the command prompt session, then close the command prompt and the pipeline to the exe file would become broken. To remedy this Microsoft changed CMD.EXE such that whenever you use a UNC path at the command line it produces an error message UNLESS you put in the registry entry from the KB article. So basically the fix was to decide that it was inappropriate to use UNC pathing at the command prompt. However, I think that once you understand the limitations (and know what not to do), the benefits gained by using the UNC pathing outweigh the risks.

In one of the earlier posts it sounded as though you might be running the job from SQL Server Agent. I've seen some odd behavior from that in some ways -- for example, I wasn't able to call an osql command from SQL Server Agent using xp_cmdshell (pointless as that might seem). So, if you haven't already done so, try the Windows Job Scheduler instead.

Best wishes,

Ed

Archiving AS 2000 Database to a network backup server

WE are currently using the following to archive our AS 2000 OLAP cubes to the local directory on the server:

"C:\Program Files (x86)\Microsoft Analysis Services\Bin\msmdarch" /a ServerName"C:\Program Files (x86)\Microsoft Analysis Services\Data\DataMart" "DataMart" "c:\BackupFiles\DataMart.cab" It runs inside an agent job. It works fine.

I wanted to change it to archive to our standard backup server location. So I changed it to the following:

"C:\Program Files (x86)\Microsoft Analysis Services\Bin\msmdarch" /a ServerName"C:\Program Files (x86)\Microsoft Analysis Services\Data\DataMart" "DataMart" "\\10.0.50.115\Disk3\servers\SQL\ServerName\DataMart.cab". The job now fails & outputs nothing to the log file. The only thing it says when I view history on the job is : Executed as user: SqlAdmin. The step did not generate any output. Process Exit Code 1. The step failed.

At first I thought maybe AS 2000 couldn't archive over the network so I open up AS Manager & manually did an archive to the same network location. It was successfull. So that blew my theory.

I don't know why the job won't do the archive to the network location. Any ideas?

Thanks,

John

If you can manually run the command

"C:\Program Files (x86)\Microsoft Analysis Services\Bin\msmdarch" /a ServerName"C:\Program Files (x86)\Microsoft Analysis Services\Data\DataMart" "DataMart" "\\10.0.50.115\Disk3\servers\SQL\ServerName\DataMart.cab"

then it's possible that the SqlAdmin user doesn't have write permissions to the share.

Adrian

|||

Adrian,

I forgot to mention that SQLAdmin does have privileges to the network backup location. We use this same login for all our SQL backups as well.

I wasn't ever able to get the command to run manually. I was able to manually run the archive process through Analysis manager. Don't know if that makes a difference or not.

Any other ideas?

Thanks,

JOhn

|||

Unless you have changed the default data directory, I think you have an incorrect "datamart" sub folder in your data directory parameter.

"C:\Program Files (x86)\Microsoft Analysis Services\Bin\msmdarch" /a ServerName"C:\Program Files (x86)\Microsoft Analysis Services\Data\DataMart" "DataMart" "\\10.0.50.115\Disk3\servers\SQL\ServerName\DataMart.cab"

try removing it and see if the command works then.

"C:\Program Files (x86)\Microsoft Analysis Services\Bin\msmdarch" /a ServerName"C:\Program Files (x86)\Microsoft Analysis Services\Data\" "DataMart" "\\10.0.50.115\Disk3\servers\SQL\ServerName\DataMart.cab"

Also, where are you running Analysis Manager from? Judging by the (x86) in the path I would say that your AS2k server is 64bit and all the management tools (including msmdarch.exe) are 32 bit. The last recommendation I saw said to try to run these tools from a 32bit machine and not on the 64bit server. I don't know if that means it would not work, but it might be another option to explore.

|||

Darren,

I removed the extra "datamart" from the command but same result.

Sorry I didn't mention this earlier. I am running W2K3 64 bit with AS 2000 32 bit. I was running Analysis Manager on the 64 bit server when I was able to do the archive manually. WIth this command, I am running it under SQL 2005 EE 64 bit agent job.

I tried running the following command from our 32 bit test server but it had the same result:

"C:\Program Files\Microsoft Analysis Services\Bin\msmdarch" /a 64BitServer"C:\Program Files (x86)\Microsoft Analysis Services\Data\" "DataMart" "\\10.0.50.115\Disk3\servers\SQL\64BitServer\DataMart.cab"

Any other ideas?

Thanks,

John

|||

Hmm, running out of ideas.

Have you tried mapping a drive so that you are backing up to z:\... or something like that?

Have you tried specifying the other 2 optional parameter (the logfile and tempfolder)? The log file might give you some ideas, although it might be blank, I seem to remember having trouble like this once, but I can't remember how I resolved it.

Finally, if all else fails there was some documentation, I think in the operations guide whitepaper, on how to "manually" back up an AS2k server by taking a file back up of the data directory and the repository database.

|||

Darren,

A mapped drive seems to work. Although, I don't like using mapped drives on our servers but I may have to make an exception in this instance. Maybe I will have it archive locally & then execute a batch job that would xcopy the .cab file to the backup server.

I also tried adding the log & temp folder parameters but that did not make any difference. I still got the useless blank log file. It seems like this should work or somewhere it would be documented that you can't use UNC paths for the archive process.

Thanks for the help,

JOhn

|||

Hello,

Enjoyed reading the thread, I had a thought that might be helpful:

You might try enabling UNC support for your command prompt. By default, Microsoft ships this flag turned off, but I've yet to have any trouble with it turned on. YMMV.

Microsoft KB156276 instructions for doing this:

Under the registry path:

HKEY_CURRENT_USER
\Software
\Microsoft
\Command Processor

add the value DisableUNCCheck REG_DWORD and set the value to 0 x 1 (Hex).

http://support.microsoft.com/kb/156276

I hope this helps you. Good luck...!

-ed2

|||

Ed,

Thanks for the thought. I added this to the registry & then ran my job but same result. It may need to have a reboot to get the change into effect. However, the KB article lists this as a bug for Win NT 4 & states that it would be fixed in a SP. So I would hope that this has been fixed in Windows 2003 server. I will leave it until after a reboot to see if it works or not.

THe batch job is working great btw.

John

|||

I'm sorry to hear this wasn't a fix... WIth only 8 months of mainstream support remaining on SQL Server 2000, it's hard to imagine this will get much attention, but you might try opening a call if you can justify the expense...

Read the KB article I sent you over again, and you'll find out that the fix is in Win2K, XP, and Win2K3. The KB article said that NT4 originally had no check for UNC pathing in the command prompt, and that caused problems for users who would launch Windows apps from the command prompt session, then close the command prompt and the pipeline to the exe file would become broken. To remedy this Microsoft changed CMD.EXE such that whenever you use a UNC path at the command line it produces an error message UNLESS you put in the registry entry from the KB article. So basically the fix was to decide that it was inappropriate to use UNC pathing at the command prompt. However, I think that once you understand the limitations (and know what not to do), the benefits gained by using the UNC pathing outweigh the risks.

In one of the earlier posts it sounded as though you might be running the job from SQL Server Agent. I've seen some odd behavior from that in some ways -- for example, I wasn't able to call an osql command from SQL Server Agent using xp_cmdshell (pointless as that might seem). So, if you haven't already done so, try the Windows Job Scheduler instead.

Best wishes,

Ed

Archiving AS 2000 Database to a network backup server

WE are currently using the following to archive our AS 2000 OLAP cubes to the local directory on the server:

"C:\Program Files (x86)\Microsoft Analysis Services\Bin\msmdarch" /a ServerName"C:\Program Files (x86)\Microsoft Analysis Services\Data\DataMart" "DataMart" "c:\BackupFiles\DataMart.cab" It runs inside an agent job. It works fine.

I wanted to change it to archive to our standard backup server location. So I changed it to the following:

"C:\Program Files (x86)\Microsoft Analysis Services\Bin\msmdarch" /a ServerName"C:\Program Files (x86)\Microsoft Analysis Services\Data\DataMart" "DataMart" "\\10.0.50.115\Disk3\servers\SQL\ServerName\DataMart.cab". The job now fails & outputs nothing to the log file. The only thing it says when I view history on the job is : Executed as user: SqlAdmin. The step did not generate any output. Process Exit Code 1. The step failed.

At first I thought maybe AS 2000 couldn't archive over the network so I open up AS Manager & manually did an archive to the same network location. It was successfull. So that blew my theory.

I don't know why the job won't do the archive to the network location. Any ideas?

Thanks,

John

If you can manually run the command

"C:\Program Files (x86)\Microsoft Analysis Services\Bin\msmdarch" /a ServerName"C:\Program Files (x86)\Microsoft Analysis Services\Data\DataMart" "DataMart" "\\10.0.50.115\Disk3\servers\SQL\ServerName\DataMart.cab"

then it's possible that the SqlAdmin user doesn't have write permissions to the share.

Adrian

|||

Adrian,

I forgot to mention that SQLAdmin does have privileges to the network backup location. We use this same login for all our SQL backups as well.

I wasn't ever able to get the command to run manually. I was able to manually run the archive process through Analysis manager. Don't know if that makes a difference or not.

Any other ideas?

Thanks,

JOhn

|||

Unless you have changed the default data directory, I think you have an incorrect "datamart" sub folder in your data directory parameter.

"C:\Program Files (x86)\Microsoft Analysis Services\Bin\msmdarch" /a ServerName"C:\Program Files (x86)\Microsoft Analysis Services\Data\DataMart" "DataMart" "\\10.0.50.115\Disk3\servers\SQL\ServerName\DataMart.cab"

try removing it and see if the command works then.

"C:\Program Files (x86)\Microsoft Analysis Services\Bin\msmdarch" /a ServerName"C:\Program Files (x86)\Microsoft Analysis Services\Data\" "DataMart" "\\10.0.50.115\Disk3\servers\SQL\ServerName\DataMart.cab"

Also, where are you running Analysis Manager from? Judging by the (x86) in the path I would say that your AS2k server is 64bit and all the management tools (including msmdarch.exe) are 32 bit. The last recommendation I saw said to try to run these tools from a 32bit machine and not on the 64bit server. I don't know if that means it would not work, but it might be another option to explore.

|||

Darren,

I removed the extra "datamart" from the command but same result.

Sorry I didn't mention this earlier. I am running W2K3 64 bit with AS 2000 32 bit. I was running Analysis Manager on the 64 bit server when I was able to do the archive manually. WIth this command, I am running it under SQL 2005 EE 64 bit agent job.

I tried running the following command from our 32 bit test server but it had the same result:

"C:\Program Files\Microsoft Analysis Services\Bin\msmdarch" /a 64BitServer"C:\Program Files (x86)\Microsoft Analysis Services\Data\" "DataMart" "\\10.0.50.115\Disk3\servers\SQL\64BitServer\DataMart.cab"

Any other ideas?

Thanks,

John

|||

Hmm, running out of ideas.

Have you tried mapping a drive so that you are backing up to z:\... or something like that?

Have you tried specifying the other 2 optional parameter (the logfile and tempfolder)? The log file might give you some ideas, although it might be blank, I seem to remember having trouble like this once, but I can't remember how I resolved it.

Finally, if all else fails there was some documentation, I think in the operations guide whitepaper, on how to "manually" back up an AS2k server by taking a file back up of the data directory and the repository database.

|||

Darren,

A mapped drive seems to work. Although, I don't like using mapped drives on our servers but I may have to make an exception in this instance. Maybe I will have it archive locally & then execute a batch job that would xcopy the .cab file to the backup server.

I also tried adding the log & temp folder parameters but that did not make any difference. I still got the useless blank log file. It seems like this should work or somewhere it would be documented that you can't use UNC paths for the archive process.

Thanks for the help,

JOhn

|||

Hello,

Enjoyed reading the thread, I had a thought that might be helpful:

You might try enabling UNC support for your command prompt. By default, Microsoft ships this flag turned off, but I've yet to have any trouble with it turned on. YMMV.

Microsoft KB156276 instructions for doing this:

Under the registry path:

HKEY_CURRENT_USER
\Software
\Microsoft
\Command Processor

add the value DisableUNCCheck REG_DWORD and set the value to 0 x 1 (Hex).

http://support.microsoft.com/kb/156276

I hope this helps you. Good luck...!

-ed2

|||

Ed,

Thanks for the thought. I added this to the registry & then ran my job but same result. It may need to have a reboot to get the change into effect. However, the KB article lists this as a bug for Win NT 4 & states that it would be fixed in a SP. So I would hope that this has been fixed in Windows 2003 server. I will leave it until after a reboot to see if it works or not.

THe batch job is working great btw.

John

|||

I'm sorry to hear this wasn't a fix... WIth only 8 months of mainstream support remaining on SQL Server 2000, it's hard to imagine this will get much attention, but you might try opening a call if you can justify the expense...

Read the KB article I sent you over again, and you'll find out that the fix is in Win2K, XP, and Win2K3. The KB article said that NT4 originally had no check for UNC pathing in the command prompt, and that caused problems for users who would launch Windows apps from the command prompt session, then close the command prompt and the pipeline to the exe file would become broken. To remedy this Microsoft changed CMD.EXE such that whenever you use a UNC path at the command line it produces an error message UNLESS you put in the registry entry from the KB article. So basically the fix was to decide that it was inappropriate to use UNC pathing at the command prompt. However, I think that once you understand the limitations (and know what not to do), the benefits gained by using the UNC pathing outweigh the risks.

In one of the earlier posts it sounded as though you might be running the job from SQL Server Agent. I've seen some odd behavior from that in some ways -- for example, I wasn't able to call an osql command from SQL Server Agent using xp_cmdshell (pointless as that might seem). So, if you haven't already done so, try the Windows Job Scheduler instead.

Best wishes,

Ed

Architecture

Hello,
I want to kow if the following architecture is good :
Disque 1&2 ( Raid 1)
c: OS
d: sqlserver + system tables + log files
Disque 3&4&5 (Raid 5)
e: dataIf you don't plan on having any volume it would be fine. Otherwise, it would suck. A 3 disk RAID array is the slowest RAID 5 configuration possible. In addition, if you want high performance you should have the tempdb and/or the log files on seperate disks.

If you only have five disks though, this should work.

architecture

Hi,
Someone can tell me if the following architecture is good :
f:master db
g:soft db + logI think the best discussion that I found on placement of log files, data files and the system databases was in Kalen Delaney's Inside SQL Server 2000. There is also a good discussion in the MS SQL Server 2000 Operations guide.

You don't really provide a lot of information about the dbs to tell us whether the design is "good" or not. Things like, expected i/o, the underlying disk architecture (RAID level) of the associated drives, etc.

That said, it's never a "good" idea to place both the data file(s) and the log file(s) on the same physical drive; always separate these if possible. It's more important (in my opinion) to separate the data and log files than it is to separate the system dbs from the user dbs. Be sure, too, that the files are really on separate physical disks (not just separate logical partitions of the same underlying physical disk). There is a lot more to say, but others have said it better before me; read the references above and use common sense.

HTH,

hmscott|||well... I think I once saw a master on a:... and urh... it didn't work.

hmscott is right, and common sense would include not to install the tempdb on a c-drive, as I saw today.. again... eventhough I keep saying not to.

apt select

Hi all,

can any one clearly distinguish between the following 2 select stmts.
which one should I Choose for better performance.

1) select * from tab1,tab2,tab3,tab4
where tab1.Id1=tab2.Id
and tab1.Id2=tab3.Id
and tab1.Id3=tab4.Id

2)select * from tab1 join tab2
on tab1.Id1=tab2.Id
join tab3
on tab1.Id2=tab3.Id
join tab4
on tab1.Id3=tab4.Idwell..............
this is an old one.and i will give the "check it out for yourself" answer first.
....depending on record size and count, (and other factors). the only true test is to check statistics [TIME and IO] against each executed (or estimated) running of the queries..

now for my opinion.
there is no difference between the two.
I prefer the ansi joins sheerly from an portability aspect. everyone who is anyone is using them (even oracle has switched to ansi joins as per 9i).

just me however.

A GIS for "join style" returns a consensus on this matter "no real difference but your code will be portable".

Application Warning

I can't find any information to correct the following warning message that I
receive in Event Viewer.
Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3055
Description: The gatherer property mapping file cannot be opened. Error:
80070003. The default values are being used. You may have to copy the
property mapping file from the Setup CD-ROM, or reinstall the application.
Environment:
Windows 2000 Server SP4
SQL Server 2000 SP4 Standard Edition (8.00.2039)
MDAC 2.81.1117.6
The server is not in a cluster, and doesn't have Exchange installed. Any
assistance would greatly be appreciated!!!
Tom
Tom
Are you sure that it relates to SQL Server?
"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>I can't find any information to correct the following warning message that
>I
> receive in Event Viewer.
> Event Type: Warning
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3055
> Description: The gatherer property mapping file cannot be opened. Error:
> 80070003. The default values are being used. You may have to copy the
> property mapping file from the Setup CD-ROM, or reinstall the application.
> Environment:
> Windows 2000 Server SP4
> SQL Server 2000 SP4 Standard Edition (8.00.2039)
> MDAC 2.81.1117.6
> The server is not in a cluster, and doesn't have Exchange installed. Any
> assistance would greatly be appreciated!!!
> --
> Tom
|||Uri:
I don't really have anything else on the server besides backup software.
The only items that I've found related to this message is for Exchange and
SQL in a clustered environment. I don't have Exchange installed on this
server and I'm not running SQL in a clustered environment.
Thanks!!!
Tom
"Uri Dimant" wrote:

> Tom
> Are you sure that it relates to SQL Server?
> "Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
> news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>
>
|||"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:6E260383-2E19-4C9C-8B3B-987293B9B57D@.microsoft.com...
> Uri:
> I don't really have anything else on the server besides backup software.
> The only items that I've found related to this message is for Exchange and
> SQL in a clustered environment. I don't have Exchange installed on this
> server and I'm not running SQL in a clustered environment.
If you search MSDN on "Gatherer", you will find that this term is a part of
other components as well. In particular, sharepoint and the Indexing
Services. There is also something called Windows Desktop Search. Also,
oblique references to outlook.
|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23yE7p9$BHHA.4256@.TK2MSFTNGP04.phx.gbl...
> Tom
> Are you sure that it relates to SQL Server?
Certainly looks like a Full Text Search issue.

> "Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
> news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>

Application Warning

I can't find any information to correct the following warning message that I
receive in Event Viewer.
Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3055
Description: The gatherer property mapping file cannot be opened. Error:
80070003. The default values are being used. You may have to copy the
property mapping file from the Setup CD-ROM, or reinstall the application.
Environment:
Windows 2000 Server SP4
SQL Server 2000 SP4 Standard Edition (8.00.2039)
MDAC 2.81.1117.6
The server is not in a cluster, and doesn't have Exchange installed. Any
assistance would greatly be appreciated!!!
--
TomTom
Are you sure that it relates to SQL Server?
"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>I can't find any information to correct the following warning message that
>I
> receive in Event Viewer.
> Event Type: Warning
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3055
> Description: The gatherer property mapping file cannot be opened. Error:
> 80070003. The default values are being used. You may have to copy the
> property mapping file from the Setup CD-ROM, or reinstall the application.
> Environment:
> Windows 2000 Server SP4
> SQL Server 2000 SP4 Standard Edition (8.00.2039)
> MDAC 2.81.1117.6
> The server is not in a cluster, and doesn't have Exchange installed. Any
> assistance would greatly be appreciated!!!
> --
> Tom|||Uri:
I don't really have anything else on the server besides backup software.
The only items that I've found related to this message is for Exchange and
SQL in a clustered environment. I don't have Exchange installed on this
server and I'm not running SQL in a clustered environment.
Thanks!!!
--
Tom
"Uri Dimant" wrote:

> Tom
> Are you sure that it relates to SQL Server?
> "Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
> news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>
>|||"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:6E260383-2E19-4C9C-8B3B-987293B9B57D@.microsoft.com...
> Uri:
> I don't really have anything else on the server besides backup software.
> The only items that I've found related to this message is for Exchange and
> SQL in a clustered environment. I don't have Exchange installed on this
> server and I'm not running SQL in a clustered environment.
If you search MSDN on "Gatherer", you will find that this term is a part of
other components as well. In particular, sharepoint and the Indexing
Services. There is also something called Windows Desktop Search. Also,
oblique references to outlook.|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23yE7p9$BHHA.4256@.TK2MSFTNGP04.phx.gbl...
> Tom
> Are you sure that it relates to SQL Server?
Certainly looks like a Full Text Search issue.

> "Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
> news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>

Application Warning

I can't find any information to correct the following warning message that I
receive in Event Viewer.
Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3055
Description: The gatherer property mapping file cannot be opened. Error:
80070003. The default values are being used. You may have to copy the
property mapping file from the Setup CD-ROM, or reinstall the application.
Environment:
Windows 2000 Server SP4
SQL Server 2000 SP4 Standard Edition (8.00.2039)
MDAC 2.81.1117.6
The server is not in a cluster, and doesn't have Exchange installed. Any
assistance would greatly be appreciated!!!
--
TomTom
Are you sure that it relates to SQL Server?
"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>I can't find any information to correct the following warning message that
>I
> receive in Event Viewer.
> Event Type: Warning
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3055
> Description: The gatherer property mapping file cannot be opened. Error:
> 80070003. The default values are being used. You may have to copy the
> property mapping file from the Setup CD-ROM, or reinstall the application.
> Environment:
> Windows 2000 Server SP4
> SQL Server 2000 SP4 Standard Edition (8.00.2039)
> MDAC 2.81.1117.6
> The server is not in a cluster, and doesn't have Exchange installed. Any
> assistance would greatly be appreciated!!!
> --
> Tom|||Uri:
I don't really have anything else on the server besides backup software.
The only items that I've found related to this message is for Exchange and
SQL in a clustered environment. I don't have Exchange installed on this
server and I'm not running SQL in a clustered environment.
Thanks!!!
--
Tom
"Uri Dimant" wrote:
> Tom
> Are you sure that it relates to SQL Server?
> "Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
> news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
> >I can't find any information to correct the following warning message that
> >I
> > receive in Event Viewer.
> > Event Type: Warning
> > Event Source: Microsoft Search
> > Event Category: Gatherer
> > Event ID: 3055
> > Description: The gatherer property mapping file cannot be opened. Error:
> > 80070003. The default values are being used. You may have to copy the
> > property mapping file from the Setup CD-ROM, or reinstall the application.
> >
> > Environment:
> > Windows 2000 Server SP4
> > SQL Server 2000 SP4 Standard Edition (8.00.2039)
> > MDAC 2.81.1117.6
> >
> > The server is not in a cluster, and doesn't have Exchange installed. Any
> > assistance would greatly be appreciated!!!
> > --
> > Tom
>
>|||"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:6E260383-2E19-4C9C-8B3B-987293B9B57D@.microsoft.com...
> Uri:
> I don't really have anything else on the server besides backup software.
> The only items that I've found related to this message is for Exchange and
> SQL in a clustered environment. I don't have Exchange installed on this
> server and I'm not running SQL in a clustered environment.
If you search MSDN on "Gatherer", you will find that this term is a part of
other components as well. In particular, sharepoint and the Indexing
Services. There is also something called Windows Desktop Search. Also,
oblique references to outlook.|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23yE7p9$BHHA.4256@.TK2MSFTNGP04.phx.gbl...
> Tom
> Are you sure that it relates to SQL Server?
Certainly looks like a Full Text Search issue.
> "Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
> news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>>I can't find any information to correct the following warning message that
>>I
>> receive in Event Viewer.
>> Event Type: Warning
>> Event Source: Microsoft Search
>> Event Category: Gatherer
>> Event ID: 3055
>> Description: The gatherer property mapping file cannot be opened.
>> Error:
>> 80070003. The default values are being used. You may have to copy the
>> property mapping file from the Setup CD-ROM, or reinstall the
>> application.
>> Environment:
>> Windows 2000 Server SP4
>> SQL Server 2000 SP4 Standard Edition (8.00.2039)
>> MDAC 2.81.1117.6
>> The server is not in a cluster, and doesn't have Exchange installed. Any
>> assistance would greatly be appreciated!!!
>> --
>> Tom
>

Application Server and Max Capacity of DB under SQL 2000

Hi,
Please help me on the following:
1.) If SQL 2000 Server has an Application server, same as Oracle Application Server?
2.) What is the maximum size of database capacity under SQL 2000?
Hope to receive your reply ASAP.
Thanks.
Merce> 1.) If SQL 2000 Server has an Application server, same as Oracle Application Server?
Please define "Application Server".
> 2.) What is the maximum size of database capacity under SQL 2000?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_6x6b.asp?frame=true
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Merce" <anonymous@.discussions.microsoft.com> wrote in message
news:5A5249D8-8B61-4AFB-9B92-95501AA6BF33@.microsoft.com...
> Hi,
> Please help me on the following:
> 1.) If SQL 2000 Server has an Application server, same as Oracle Application Server?
> 2.) What is the maximum size of database capacity under SQL 2000?
> Hope to receive your reply ASAP.
> Thanks.
> Merce|||Hi,
Thanks for helping me. As for the Application Server, I am verifying if SQL has the Application Server same functionality as Oracle Application Server.
Hope this explanation is OK.
Thanks again.|||You're welcome :-).
Please understand that not all of us here are using Oracle, where I'm one of them. So I leave that
question to someone who know that Oracle Application Server does.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Merce" <anonymous@.discussions.microsoft.com> wrote in message
news:2752BA69-25D5-4C53-BBFF-F0C2EAA6CB32@.microsoft.com...
> Hi,
> Thanks for helping me. As for the Application Server, I am verifying if SQL has the Application
Server same functionality as Oracle Application Server.
> Hope this explanation is OK.
> Thanks again.|||Hi
Thanks again. I just wait for others to reply
Regards.|||No, SQL2000 doesn't have an equivalent to Oracle Application Server.
Maximum size of a single database: 1,048,516 TB
Mike
"Merce" <anonymous@.discussions.microsoft.com> wrote in message
news:5A5249D8-8B61-4AFB-9B92-95501AA6BF33@.microsoft.com...
> Hi,
> Please help me on the following:
> 1.) If SQL 2000 Server has an Application server, same as Oracle
Application Server?
> 2.) What is the maximum size of database capacity under SQL 2000?
> Hope to receive your reply ASAP.
> Thanks.
> Merce|||Thanks, Mike. This helps a lot.

Application Role with VB6

In VB6 I've got the following code when opening a connection to sql server:
With cn
.ConnectionString = "MyConnectionString"
.ConnectionTimeout = 10
.Properties("OLE DB SERVICES") = -2
.Open
'Had to allow execute for sps against the windows group until we can
suss app role
.Execute "EXEC sp_setapprole 'MyApp',{ENCRYPT N 'MyPassword'},'ODBC'"
End With
In sql server I've added a windows group to the database to allow the users
of the application to open the connection. I gave the windows group no
permissions of any kind. I added an application role and gave it select,
insert etc. permissions on the tables and execute permissions on all stored
procedures
When the application runs under a windows user (who is in the windows group
I added to the databse), the application can select data from the database
but gets 'execute permission denied' on any stored procedure that it tries t
o
run.
If I examine the permissions of one of these stored procedures, there is a
grant on it for the application role (there are no denies on it at all). If
I
then explicitly grant permission on one of these stored procedures to the
windows group containing the windows user, they are able to access it.
Ok, I think, it looks like it is ignoring the application role, so I deleted
the application role from the database and amended the VB code, the user is
then unable to access any data.
My conclusion then becomes the application role was giving the user access
to table data, but not to stored procedures, and when I granted permission t
o
the windows group this somehow overrode the application role. This is clearl
y
rubbish, because as I understand it, once an application role takes over, no
other permissions matter.
Anybody see what I'm doing wrong?
Thanks
PaulPlease ignore - accidentally posted twice
"Paul Whittaker" wrote:

> In VB6 I've got the following code when opening a connection to sql server
:
> With cn
> .ConnectionString = "MyConnectionString"
> .ConnectionTimeout = 10
> .Properties("OLE DB SERVICES") = -2
> .Open
> 'Had to allow execute for sps against the windows group until we c
an
> suss app role
> .Execute "EXEC sp_setapprole 'MyApp',{ENCRYPT N 'MyPassword'}
,'ODBC'"
> End With
> In sql server I've added a windows group to the database to allow the user
s
> of the application to open the connection. I gave the windows group no
> permissions of any kind. I added an application role and gave it select,
> insert etc. permissions on the tables and execute permissions on all store
d
> procedures
> When the application runs under a windows user (who is in the windows grou
p
> I added to the databse), the application can select data from the database
> but gets 'execute permission denied' on any stored procedure that it tries
to
> run.
> If I examine the permissions of one of these stored procedures, there is a
> grant on it for the application role (there are no denies on it at all). I
f I
> then explicitly grant permission on one of these stored procedures to the
> windows group containing the windows user, they are able to access it.
> Ok, I think, it looks like it is ignoring the application role, so I delet
ed
> the application role from the database and amended the VB code, the user i
s
> then unable to access any data.
> My conclusion then becomes the application role was giving the user access
> to table data, but not to stored procedures, and when I granted permission
to
> the windows group this somehow overrode the application role. This is clea
rly
> rubbish, because as I understand it, once an application role takes over,
no
> other permissions matter.
> Anybody see what I'm doing wrong?
> Thanks
> Paul

Application Role VB6

In VB6 I have the following code to use an application role
With cn
.ConnectionString = "MyConnectionString"
.ConnectionTimeout = 10
.Properties("OLE DB SERVICES") = -2
.Open
'Had to allow execute for sps against the windows group until we can
suss app role
.Execute "EXEC sp_setapprole 'MyApp',{ENCRYPT N 'MyPassword'},'ODBC'"
End With
I added a windows group to my sql server database, containing windows users
who will use this app. I gave the group no permissions of any kind. This
group as I understand it will allow the users to open the initial connection
to the database before the application role is then applied to the connectio
n.
Next I added an application role to the database and gave it select, insert
etc. on any tables the app needs and execute permission on any stored
procedures the app uses.
When a user (from the windows group) runs the app, data can be selected from
the tables but you get 'Execute permission denied' on any stored procedure
that runs.
If I explicitly grant permission to the windows group for one of the stored
procedures, they are able to access the stored procedure from within the app
.
Ok, I think it looks like the app isn't using the application role.
If I delete the application role from the database and amend the VB code so
as not to use an application role, the user is unable to perform the select
operation on any table, this confuses me as it looks like it was using the
application role to gain access to the data.
Anybody got any ideas.
Regards
PaulYou might try running a Profiler trace to see what's going on behind the
scenes. I suspect ADO is opening a separate connection for your stored proc
execution and this fails because the app role wasn't activated on that
connection.
Note that ADO will implicitly open another connection when the specified
connection is busy, such as in the case of an open recordset on that
connection.
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul Whittaker" <PaulWhittaker@.discussions.microsoft.com> wrote in message
news:DEBB1148-23EF-425B-92D6-55DE6CA4DD77@.microsoft.com...
> In VB6 I have the following code to use an application role
> With cn
> .ConnectionString = "MyConnectionString"
> .ConnectionTimeout = 10
> .Properties("OLE DB SERVICES") = -2
> .Open
> 'Had to allow execute for sps against the windows group until we
> can
> suss app role
> .Execute "EXEC sp_setapprole 'MyApp',{ENCRYPT N
> 'MyPassword'},'ODBC'"
> End With
> I added a windows group to my sql server database, containing windows
> users
> who will use this app. I gave the group no permissions of any kind. This
> group as I understand it will allow the users to open the initial
> connection
> to the database before the application role is then applied to the
> connection.
> Next I added an application role to the database and gave it select,
> insert
> etc. on any tables the app needs and execute permission on any stored
> procedures the app uses.
> When a user (from the windows group) runs the app, data can be selected
> from
> the tables but you get 'Execute permission denied' on any stored procedure
> that runs.
> If I explicitly grant permission to the windows group for one of the
> stored
> procedures, they are able to access the stored procedure from within the
> app.
> Ok, I think it looks like the app isn't using the application role.
> If I delete the application role from the database and amend the VB code
> so
> as not to use an application role, the user is unable to perform the
> select
> operation on any table, this confuses me as it looks like it was using the
> application role to gain access to the data.
> Anybody got any ideas.
> Regards
> Paul|||Thanks Dan
That was spot on, it was opening another connection (a recordset hadn't been
closed before it tried to execute the stored procedure).
Paul
"Dan Guzman" wrote:

> You might try running a Profiler trace to see what's going on behind the
> scenes. I suspect ADO is opening a separate connection for your stored pr
oc
> execution and this fails because the app role wasn't activated on that
> connection.
> Note that ADO will implicitly open another connection when the specified
> connection is busy, such as in the case of an open recordset on that
> connection.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Paul Whittaker" <PaulWhittaker@.discussions.microsoft.com> wrote in messag
e
> news:DEBB1148-23EF-425B-92D6-55DE6CA4DD77@.microsoft.com...
>
>

Application insist open SQL Server 2005 while the host still with SQL Server 2000

I don't know why my application on the internet try to access the SQL Server 2005, when the host still having the 2000 edition. I put the following connection string:

Data Source=##DBSERVER##;Initial Catalog=##DBNAME##;User ID=##DBUSER##;Password=##DBPASSWORD##;

Isn't everything fine with that? I created the table by host but dosen't work. I'm wondering if can I conect straight with Data Base, without register in the server, like with mdb?

This is the error that I'm getting.

When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Hi,

I'd like to know if the ##DBSERVER## you refer to is a correct database name with the desired SQL Server 2000. If you have multiple instance of SQL Server installed on that server, in order to access the correct one, you need to specify the instance name, if that's not the default instance, like "Data Source=DBServer\InstanceName".

For this specific error message, you can also check the following KB article for troubleshooting.

http://support.microsoft.com/kb/914277/en-us

Application Event log message

Recently, I have been seeing the following event(s) in the application event
log on a number of my SQL servers. I have Googled this and get the
impression that it can just be ignored, but these are becoming more
frequent, and was wondering if anyone here could shed a bit more light on
the cause, and any possible way of preventing them. All instances running
SQL 2000 SP3 (or SP3a)
Source: SQLSERVERAGENT
Category: Alert Engine
Event ID: 322
Message: The data portion of event 19004 from MSSQLSERVER is invalid.
R - MCSE (2003, 2000, NT4), MCSA (2003, 2000), MCDBA (SQL2000)Its just a bug...
http://support.microsoft.com/default.aspx?scid=kb;en-
us;230393
Peter
>--Original Message--
>Recently, I have been seeing the following event(s) in
the application event
>log on a number of my SQL servers. I have Googled this
and get the
>impression that it can just be ignored, but these are
becoming more
>frequent, and was wondering if anyone here could shed a
bit more light on
>the cause, and any possible way of preventing them. All
instances running
>SQL 2000 SP3 (or SP3a)
>Source: SQLSERVERAGENT
>Category: Alert Engine
>Event ID: 322
>Message: The data portion of event 19004 from MSSQLSERVER
is invalid.
>R - MCSE (2003, 2000, NT4), MCSA (2003, 2000), MCDBA
(SQL2000)
>
>.
>|||Thanks for the response. I had already seen that KB article, but was
wondering if anyone had identified what causes this to start occurring. For
well over a year, I have not seen this message, then recently it started to
appear. I am leaning towards an upgrade by our ITS team of SMS 2000 to SMS
2003, and the application of the new SMS advanced client (not sure if SMS
uses SNMP to communicate with clients, and vice-versa). This seems to
roughly coincide with the start of these messages. In the meantime, I will
configure my monitoring software to stop alerting me of these messages.
Any thoughts?
R
"Peter the Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:29be01c47df4$9064e4c0$a601280a@.phx.gbl...
> Its just a bug...
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;230393
> Peter
>
> >--Original Message--
> >Recently, I have been seeing the following event(s) in
> the application event
> >log on a number of my SQL servers. I have Googled this
> and get the
> >impression that it can just be ignored, but these are
> becoming more
> >frequent, and was wondering if anyone here could shed a
> bit more light on
> >the cause, and any possible way of preventing them. All
> instances running
> >SQL 2000 SP3 (or SP3a)
> >
> >Source: SQLSERVERAGENT
> >Category: Alert Engine
> >Event ID: 322
> >
> >Message: The data portion of event 19004 from MSSQLSERVER
> is invalid.
> >
> >R - MCSE (2003, 2000, NT4), MCSA (2003, 2000), MCDBA
> (SQL2000)
> >
> >
> >.
> >|||The only thing I can think of is to go through the check
list below
http://www.microsoft.com/technet/prodtechnol/sms/sms2003/de
ploy/spgsms03/spsmsaph.mspx
Apologies for the lack of answers.
Peter
>--Original Message--
>Thanks for the response. I had already seen that KB
article, but was
>wondering if anyone had identified what causes this to
start occurring. For
>well over a year, I have not seen this message, then
recently it started to
>appear. I am leaning towards an upgrade by our ITS team
of SMS 2000 to SMS
>2003, and the application of the new SMS advanced client
(not sure if SMS
>uses SNMP to communicate with clients, and vice-versa).
This seems to
>roughly coincide with the start of these messages. In the
meantime, I will
>configure my monitoring software to stop alerting me of
these messages.
>Any thoughts?
>R
>"Peter the Spate" <anonymous@.discussions.microsoft.com>
wrote in message
>news:29be01c47df4$9064e4c0$a601280a@.phx.gbl...
>> Its just a bug...
>> http://support.microsoft.com/default.aspx?scid=kb;en-
>> us;230393
>> Peter
>>
>> >--Original Message--
>> >Recently, I have been seeing the following event(s) in
>> the application event
>> >log on a number of my SQL servers. I have Googled this
>> and get the
>> >impression that it can just be ignored, but these are
>> becoming more
>> >frequent, and was wondering if anyone here could shed a
>> bit more light on
>> >the cause, and any possible way of preventing them. All
>> instances running
>> >SQL 2000 SP3 (or SP3a)
>> >
>> >Source: SQLSERVERAGENT
>> >Category: Alert Engine
>> >Event ID: 322
>> >
>> >Message: The data portion of event 19004 from
MSSQLSERVER
>> is invalid.
>> >
>> >R - MCSE (2003, 2000, NT4), MCSA (2003, 2000), MCDBA
>> (SQL2000)
>> >
>> >
>> >.
>> >
>
>.
>

Application Event ID 17177

I periodically get the following information from the
application event log:

quote:

---

>This instance of SQL Server has been using a process id
>of 204 since 1/15/04 8:36:46 PM (local) 1/16/04 3:36:46
>AM (UTC).

---

Why is this generated? What is the significance of this
information?This is an informational message and can be ignored.
Hope this helps.
Dan Guzman
SQL Server MVP
"Gary Brunton" <gary_brunton@.hotmail.com> wrote in message
news:6b3001c3e6a0$238ee8f0$a001280a@.phx.gbl...

quote:

---

> I periodically get the following information from the
> application event log:
>
> Why is this generated? What is the significance of this
> information?
>

---

|||We have a client who is getting the same error except it says a different pr
ocess id. The problem is it is showing up at 12:00 every night when sql ser
ver is supposed to backup to the Microsoft SQL Server\MSSQL\Backup folder.
When I view the dat files i
n the directory they are from November, needless to say not current. When I
am in the SQL enterprise manager under management- sql server agent-jobs, I
can see the separate jobs and when I look at the properties they are schedu
led for daily @. 12:00 am.
Why am I not getting updated files in the backup folder? Ntbackup is runni
ng nightly with no errors and is backing up all sql database files along wit
h this MSSQL\Backup folder but the files in it are not current. Ntbackup is
backing up to 4mmtape. An
y help guys would be greatly appreciated.
Phil

Application Event ID 17177

I periodically get the following information from the
application event log:
>This instance of SQL Server has been using a process id
>of 204 since 1/15/04 8:36:46 PM (local) 1/16/04 3:36:46
>AM (UTC).
Why is this generated? What is the significance of this
information?This is an informational message and can be ignored.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Gary Brunton" <gary_brunton@.hotmail.com> wrote in message
news:6b3001c3e6a0$238ee8f0$a001280a@.phx.gbl...
> I periodically get the following information from the
> application event log:
> >This instance of SQL Server has been using a process id
> >of 204 since 1/15/04 8:36:46 PM (local) 1/16/04 3:36:46
> >AM (UTC).
> Why is this generated? What is the significance of this
> information?
>|||We have a client who is getting the same error except it says a different process id. The problem is it is showing up at 12:00 every night when sql server is supposed to backup to the Microsoft SQL Server\MSSQL\Backup folder. When I view the dat files in the directory they are from November, needless to say not current. When I am in the SQL enterprise manager under management- sql server agent-jobs, I can see the separate jobs and when I look at the properties they are scheduled for daily @. 12:00 am. Why am I not getting updated files in the backup folder? Ntbackup is running nightly with no errors and is backing up all sql database files along with this MSSQL\Backup folder but the files in it are not current. Ntbackup is backing up to 4mmtape. Any help guys would be greatly appreciated
Phil

Application causing SQL Server to crash

An application (vb6) seems to be crashing our SQL Server. We're getting the
following error when a certain application accesses SQL Server. I've tried 2
different SQL Servers with the same results.
SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Any ideas as to what is happening? SQL2K sp3 - win2000
Thanks
RonHi,
With the SQL Dump created please contact microsoft PSS.
Thanks
Hari
SQL Server MVP
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:A062F4F9-2A20-496F-8630-7317F95C0A79@.microsoft.com...
> An application (vb6) seems to be crashing our SQL Server. We're getting
> the
> following error when a certain application accesses SQL Server. I've
> tried 2
> different SQL Servers with the same results.
> SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> Any ideas as to what is happening? SQL2K sp3 - win2000
> Thanks
> Ron

Apparent Security violations recorded in Event Viewer

I am receiving the following event in the event viewer. I
believe that it is from hackers trying to execute Sql
Statements against my Sql Server to gain access to my
website. I only have port 80 open via my firewall, so I'm
confused as to how they are getting in. Does anyone have
any suggestions?
Any help, ideas, suggestions would be greatly appreciated.
Pat Rogers
Event Type: Information
Event Source: ODBC Error (388221)
Event Category: None
Event ID: 0
Date: 7/21/2004
Time: 8:44:23 AM
User: N/A
Computer: P6-CR2-SVR
Description:
The description for Event ID ( 0 ) in Source ( ODBC Error
(388221) )
cannot be found. The local computer may not have the
necessary registry
information or message DLL files to display messages from
a remote
computer. The following information is part of the event:
Message Text:
=============
SQL Selected Record is invalid: - 00000.Pat,
I would at least make sure that you record all failed access attempts. This
can be done by properties - Security tab - Audit level and check Failure.
This way you can see who is trying to get access.
Chris Wood
Alberta Department of Energy
CANADA
"Pat Rogers" <progers@.kc.rr.com> wrote in message
news:2ea301c470e0$6a535d50$a401280a@.phx.gbl...
> I am receiving the following event in the event viewer. I
> believe that it is from hackers trying to execute Sql
> Statements against my Sql Server to gain access to my
> website. I only have port 80 open via my firewall, so I'm
> confused as to how they are getting in. Does anyone have
> any suggestions?
> Any help, ideas, suggestions would be greatly appreciated.
> Pat Rogers
> Event Type: Information
> Event Source: ODBC Error (388221)
> Event Category: None
> Event ID: 0
> Date: 7/21/2004
> Time: 8:44:23 AM
> User: N/A
> Computer: P6-CR2-SVR
> Description:
> The description for Event ID ( 0 ) in Source ( ODBC Error
> (388221) )
> cannot be found. The local computer may not have the
> necessary registry
> information or message DLL files to display messages from
> a remote
> computer. The following information is part of the event:
> Message Text:
> =============
> SQL Selected Record is invalid: - 00000.
>
>

Anyone use Litespeed?

I attempted installing yesterday on a cluster, and the installation
went fine, but when I kicked off the backup via Litespeed, I received
the following error...
[Microsoft][SQL Native Client][SQL Server]Failed to create the s
ecurity
environment for VDI. Ensure that the SQL Server Service account has
administrator access to this server. Note: Administrator privilege
can be restriced by registry/file and policy changes that can prevent
this operation from succeeding.
The SQL Service acct does have admin rights on the server. I installed
it as someone in the admin group. And I kicked off the backup as an
admin. I'm waiting for a call back from Imceda software on this, but
wanted to see if anyone out there had any ideas.Corey,
Might try making sure the SQL Agent is running under the SYSADMIN fixed
server role and that the domain user account for the SQL Server and SQL
Server Agent services have the necessary permissions to write backup files
to the disk.
HTH
Jerry
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1129206377.601106.49240@.z14g2000cwz.googlegroups.com...
>I attempted installing yesterday on a cluster, and the installation
> went fine, but when I kicked off the backup via Litespeed, I received
> the following error...
> [Microsoft][SQL Native Client][SQL Server]Failed to create the
security
> environment for VDI. Ensure that the SQL Server Service account has
> administrator access to this server. Note: Administrator privilege
> can be restriced by registry/file and policy changes that can prevent
> this operation from succeeding.
> The SQL Service acct does have admin rights on the server. I installed
> it as someone in the admin group. And I kicked off the backup as an
> admin. I'm waiting for a call back from Imceda software on this, but
> wanted to see if anyone out there had any ideas.
>|||The account for the agent is a local administrator, and it always
writes it native backups to the same spot, so still not sure why
Litespeed isn't working. I installed on a standalone server (not a
cluster) in the same domain, and pointed to the same backup loaction,
and everything worked. I've got a ticket in with Imceda, so I'll write
back with the results/findings.
Jerry Spivey wrote:[vbcol=seagreen]
> Corey,
> Might try making sure the SQL Agent is running under the SYSADMIN fixed
> server role and that the domain user account for the SQL Server and SQL
> Server Agent services have the necessary permissions to write backup files
> to the disk.
> HTH
> Jerry
> "Corey Bunch" <unc27932@.yahoo.com> wrote in message
> news:1129206377.601106.49240@.z14g2000cwz.googlegroups.com...