would new virus protection block startup? 2

[naselle]

The store computer recently had a virus , so a computer guy came to fix it. He cleaned things up and installed a new virus protection, but now we cannot connect to the POS system. When I go to connect, it gives an error message that says "cannot connect to the database". I also tried disabling the new virus protection and then connecting and that didn't work. Do you think it could be fouling things up? What should I try?
thank you so much...Lori

 

[mrdenny]

Odds are the Anti-Virus didn't do anything, unless it thought that the database files were infected. In which case all bets are off.

Has the SQL Server service started? Check and see if the services are running in the Computer Management > Services applet.

Find the ERRORLOG file for the SQL Server. It's in C:\Program Files\Microsoft SQL Server\MSSQL\Log by default and see what it says about why the service won't start.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[naselle]

Hi - thank you for replying. When I try to connect - the error message says:
SQL server cannot find the default instance (MSSQLSERVER). Please specify the name of an existing instance on the invoation of sqlserver.exe

I don't know what that means....

 

[mrdenny]

Probably that the service isn't running.

Has the SQL Server service started? Check and see if the services are running in the Computer Management > Services applet.

Find the ERRORLOG file for the SQL Server. It's in C:\Program Files\Microsoft SQL Server\MSSQL\Log by default and see what it says about why the service won't start.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[SQLBill]

Check the services as mrdenny says...they may be set to start manually. If so, I suggest changing them to start automatically.

Right click on My Computer icon, select Management, expand Services and Applications, click on services.

The other issue is you might have a named instance...we are assuming you know what type of instance was installed and are calling it correctly (you show you are trying to connect to the default instance).

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[naselle]

thank you both - I will try first thing in the morning and post again...Lori

 

[naselle]

Hi - I did a copy and paste so you can see what it says - (also - there were 3 error logs for that morning - this one was the first)

2009-08-06 15:41:42.31 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)

2009-08-06 15:41:42.31 server Copyright (C) 1988-2002 Microsoft Corporation.
2009-08-06 15:41:42.31 server All rights reserved.
2009-08-06 15:41:42.31 server Server Process ID is 2036.
2009-08-06 15:41:42.31 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2009-08-06 15:41:42.40 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2009-08-06 15:41:42.73 server SQL Server configured for thread mode processing.
2009-08-06 15:41:42.73 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2009-08-06 15:41:42.79 spid4 Starting up database 'master'.
2009-08-06 15:41:43.09 server Using 'SSNETLIB.DLL' version '8.0.766'.
2009-08-06 15:41:43.09 spid5 Starting up database 'model'.
2009-08-06 15:41:43.12 spid4 Server name is 'POS'.
2009-08-06 15:41:43.12 spid4 Skipping startup of clean database id 4
2009-08-06 15:41:43.15 spid4 Skipping startup of clean database id 5
2009-08-06 15:41:43.15 spid4 Skipping startup of clean database id 6
2009-08-06 15:41:43.15 spid4 Skipping startup of clean database id 7
2009-08-06 15:41:43.21 server SQL server listening on 192.168.7.102: 1433.
2009-08-06 15:41:43.21 server SQL server listening on 127.0.0.1: 1433.
2009-08-06 15:41:43.24 server SQL server listening on TCP, Shared Memory, Named Pipes.
2009-08-06 15:41:43.24 server SQL Server is ready for client connections
2009-08-06 15:41:43.31 spid5 Clearing tempdb database.
2009-08-06 15:41:43.68 spid5 Starting up database 'tempdb'.
2009-08-06 15:41:43.92 spid4 Recovery complete.
2009-08-06 15:41:43.92 spid4 SQL global counter collection task is created.
2009-08-06 15:45:44.38 spid51 Starting up database 'dbnov14'.
2009-08-12 09:57:17.10 server SQL Server terminating because of system shutdown.

 

[mrdenny]

Everything looks normal in there.

It is a little concerning that there are three from one day. Does this machine get rebooted often? Each time the SQL Server is restarted a new file is created, so the only way you should get three files in one day would be if you rebooted the machine a few times, or if something stopped and restarted the SQL Server service a few times.

I'm also not seeing any database backups in the log file (just something else to think about setting up at some point).

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[naselle]

does this one mean anything different?

2009-08-12 10:24:13.32 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)

2009-08-12 10:24:13.32 server Copyright (C) 1988-2002 Microsoft Corporation.
2009-08-12 10:24:13.32 server All rights reserved.
2009-08-12 10:24:13.32 server Server Process ID is 684.
2009-08-12 10:24:13.32 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2009-08-12 10:24:13.37 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2009-08-12 10:24:13.62 server SQL Server configured for thread mode processing.
2009-08-12 10:24:13.65 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2009-08-12 10:24:13.71 spid4 Starting up database 'master'.
2009-08-12 10:24:14.01 server Using 'SSNETLIB.DLL' version '8.0.766'.
2009-08-12 10:24:14.01 spid5 Starting up database 'model'.
2009-08-12 10:24:14.04 spid4 Server name is 'POS'.
2009-08-12 10:24:14.04 spid4 Skipping startup of clean database id 4
2009-08-12 10:24:14.07 spid4 Skipping startup of clean database id 5
2009-08-12 10:24:14.07 spid4 Skipping startup of clean database id 6
2009-08-12 10:24:14.07 spid4 Skipping startup of clean database id 7
2009-08-12 10:24:14.14 server SQL server listening on 192.168.7.102: 1433.
2009-08-12 10:24:14.14 server SQL server listening on 127.0.0.1: 1433.
2009-08-12 10:24:14.14 server SQL server listening on TCP, Shared Memory, Named Pipes.
2009-08-12 10:24:14.14 server SQL Server is ready for client connections
2009-08-12 10:24:14.18 spid5 Clearing tempdb database.
2009-08-12 10:24:14.62 spid5 Starting up database 'tempdb'.
2009-08-12 10:24:14.73 spid4 Recovery complete.
2009-08-12 10:24:14.73 spid4 SQL global counter collection task is created.
2009-08-12 12:11:06.60 server SQL Server terminating because of system shutdown.

 

[naselle]

also - the guy that was here on the day that the 3 error logs originated must have done the rebooting when he was "cleaning" things up....
I know the name of my data base - is there someway to check and see if it is available? I'm starting to wonder if it got erased? thanks -

 

[mrdenny]

That one looks fine as well. If the system is working now, then the database didn't get erased. If would be very hard for someone to erase a SQL Server database without knowing how to do it.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[naselle]

I just don't know what to do. The main problem is that I can not connect to the database server. I did some looking around and found the database file that I want to open, so I believe everything is still there - it just won't let me open. The message says the server either doesn't exist or I dont have access to it. Please stay with me on this - I called the microsoft help number and was told they quit supportting SQL 200 in 2007. thank you - Lori

 

[mrdenny]

Is the database on the same machine that you are running your POS system on?

Did the guy that cleaned the system install a firewall, or change the firewall settings at all?

The SQL Server appears to be working correctly, you just can't connect to it for some reason. You might want to get the person that "fixed" things to come back (at their expense since it worked when they got there and was broken when they left) and have them fix what ever firewall changes they put in place.

If that isn't an option take a look at faq962-5481 and go through the steps there and post all the results here and I'll take a look the results and see what we can come up with.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[naselle]

ok - I'll try that tomorrow - thank you -

 

[naselle]

Ok - when I did the ping - it came up a small black box with cursor for just a second and then went away. when I tried the telnet one - same thing although it looked like it stayed up a tiny bit longer - maybe a second or two; no error message either time - it just went away. I tried both of those things twice. The back office computer shows that it is running when you mouse over the icon, but when I click to open up the manager, it won't actually let me open it.
The guy that was here downloaded server 2008 (mine is the SQL 2000) but didn't end up completely installing it. Should I uninstall it? He also installed new virus protection. When I looked at the frirewall, there were a couple boxes regarding SQL that were checked in the exception area. (to the right of that the "group policy" says no - I don't know if that is important or not.)
Also - I checked on the file share and it appears I can easily open folders from the other office. Is that what is meant by the question regarding file share - question #3?.
I'm sorry about my limited knowledge about specific terminology. I sure appreciated your willingness to help...Lori

 

[gmmastros]

When you perform the ping and telnet tests, you should open a command window first. Then enter the ping (or telnet command).

Click Start -> Run
Type: CMD
Click OK

There will now be a black box (that won't go away). Now run the ping and telnet tests from within the already existing black box.

If anything appears after you run the command that "feels" like an error, you should copy/paste the message here. To do that, click the icon at the top left (in the title bar). Click Edit, then click "Select all". Click the icon again, click Edit, Click copy. Then, paste the contents here so we can have a look.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[mrdenny]

I'm guessing there were probably error messages in the windows that closed, you just didn't see them. Please follow George's instructions to open a command window, then run the first two tests again and post anything that comes back. (George put how to copy the information from the command line window as well.)

Thanks George.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[naselle]

I tried a couple of different things because I'm not absulutely sure at this point what the name should be. This computer (the main one that everything runs on I thought operated under POS as its name. The back computer shows that \\DF4STL21 is running. I don't know if that is becasue it is the back office. Anyway - here are the test results...


Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\OFFICE>ping {POS}
Ping request could not find host {POS}. Please check the name and try again.

C:\Documents and Settings\OFFICE>ping {\\DF4STL21}
Ping request could not find host {\\DF4STL21}. Please check the name and try aga
in.

C:\Documents and Settings\OFFICE>telnet{POS}
'telnet{POS}' is not recognized as an internal or external command,
operable program or batch file.

C:\Documents and Settings\OFFICE>telnetpos
'telnetpos' is not recognized as an internal or external command,
operable program or batch file.

C:\Documents and Settings\OFFICE>telnet {\\DF4STL21}
Connecting To {\\DF4STL21}...Could not open connection to the host, on port 23:
Connect failed

C:\Documents and Settings\OFFICE>

 

[mrdenny]

OK, you'll want to put a space between the command (ping, or telnet) and the servername (DF4STL21). The brackets and the slash marks aren't needed either.

You'll want do run commands like this.

ping DF4STL21

telnet DF4STL21 1433

Now is DF4STL21 the name of the computer in the back, or is it the one with the POS database on it?

We'll get there, sometimes it just takes a little while when doing this stuff over a forum.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[naselle]

looks like the POS ping offered up more this time. (I thought that was the name of this computer) here is the new info


Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\OFFICE>ping \\DF4STL21
Ping request could not find host \\DF4STL21. Please check the name and try again
.

C:\Documents and Settings\OFFICE>ping POS

Pinging POS [192.168.7.102] with 32 bytes of data:

Reply from 192.168.7.102: bytes=32 time<1ms TTL=128
Reply from 192.168.7.102: bytes=32 time<1ms TTL=128
Reply from 192.168.7.102: bytes=32 time<1ms TTL=128
Reply from 192.168.7.102: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.7.102:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Documents and Settings\OFFICE>telnet POS 1433
Connecting To POS...Could not open connection to the host, on port 1433: Connect
failed

C:\Documents and Settings\OFFICE>telnet \\DF4STL21 1433
Connecting To \\DF4STL21...Could not open connection to the host, on port 1433:
Connect failed

C:\Documents and Settings\OFFICE>