Recent content by CBell

Thanx for all the great info. It seemed the problem was with Mcafee virus protection that AOL sent out. THat was the last install on the system and I removed it and all is well. THanx again, Chris...

I have a win 98 system that hangs when it boots. It gets to where the win 98 logo come up with the blue colr bar moving. It makes about 3 passes of the bar and han it hangs. I got it into safe mode and ran the disk error check and it found nothing. Any ideas?

Hi, I'm trying to de-bug a client problem on SQL 7.0. The book says to edit a file called "sqsapi32.ini", but the file does not exist on the client system. Is there something that needs to be "turned on" for this file to exist? Thanx, Chris...

That did it..... Thanx... chris...

HI, I have a WIn 2000 Server that we have forgotten the local admin password, is there an easy way to get into the system without re-building the OS? Also, this machine was never attached to our network so going thru th network won't work either. THanx, Chris...

I have a laptop running win2000. We install the desktop edition of SQL 7.0 and it install fine. Everything seems to work ok, until the system reboots. When you reboot the system and its booting up an error pops up about the SQL 7 install being corrupt. An error about cannot initialize snapin...

Tried Deja.com and nothing out there cured the problem. THanx for the link though. We also noticed something else with this system and not sure if this is part of the problem. If we stop and start the SQL services and the SQL agent the following error gets logged to the event viewer...

Hi, I'm having a problem on a NT 4, SQL 7 server. One of the programmers is trying to do a "bulk insert" and she keeps getting the following error: "Could not create an instance of OLE DB Provider stream (error 7302)". We looked up error 7302 in the bokks online, but it...

I got it to work. THanx for all the info, it really helped. What I did was on the account we want to use for the backups, I went into the Security/Logins and noticed the Server Roles had every role chcked off. So I removed all the checks except the System Admin one. THan I checked the DB...

I just did a test. The backup job that fails uses the sql SA account. I logged onto SQl with a domain users acct with admin privs (acct. is superuser). Started the backups and everything worked fine. But why won't the backup work with the SQL sa acct.? My boss told me they have always used...

Terry, Yes. I can map a network drive to the network machine. Chris...

I changed the SQL server service to use the domain account (the agent uses the same account). THis account has admin privs attached to it also. We tried the backup this morning and it still fails when we try to create a backup device with the UNC to the network machine. Keeps coming back with...

I really don't understand why it wouldn't work either. These problems arose before I got here. I'm gonna change the login to use a domain account tonite and than have the operators reboot the server during "quit time" and than try the backups tomorrow. I'll keep ya posted... Chris...

Thanx for the info so far guys... I kinda figured hte service would need privs in order to run over the network. I also just found out the reason they account was set to use the Local System is because they were having problems with the "full text search" building when the service...

Rick, THe SQL server runs under the Local System account. Is this the correct way to run this or should it be run under a domain account with privs? CHris...