March 30, 2009 at 7:37 am
IKON installed Fortis. Anything beyond the workings of their software and they have someone on the east coast call me back. Usually hours and hours later. I will ask them again.
March 30, 2009 at 7:43 am
john (3/30/2009)
Oddly though there are two instances of sqlserver running in the task manager there is only one in services and it is Backup Exec.
Check both under SQL and under Microsoft. The different versions give the services different descriptive names.
Agreed that you should be speaking to the vendor on this.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2009 at 8:26 am
Found it.
The other is...
Service Name: MSSQLSERVER
Display Name: MSSQLSERVER
JohnC
March 30, 2009 at 8:49 am
Ok. What does the services dialog give as the path to the executable?
Is the other one something like MSSQL$BACKUPEXEC ?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2009 at 9:21 am
C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL\BINN\SQLSERVER.EXE -sMSSQLSERVER
C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\BINN\SQLSERVER.EXE -sBKUPEXEC
March 30, 2009 at 9:33 am
john (3/30/2009)
C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL\BINN\SQLSERVER.EXE -sMSSQLSERVER
I have an odd feeling that is a SQL 2000 instance. The directory is wrong for SQL 2005 (which uses the MSSQL.1, MSSQL2. format)
Can you navigate to that directory (C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL\BINN), find the SQL executable (sqlservr.exe), right click the file, get the properties, go to the details tab and get the version of the file.
General question to anyone reading: Anyone know if SQL 2000 allowed a local admin to connect if it was started in single user mode? I know 2005 and 2008 do, can't remember for 2000 and I don't have an instance to test on.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2009 at 9:47 am
2000.080.0760.00
March 30, 2009 at 9:54 am
Yup, that's SQL 2000, not 2005 at all.
I just need to check and see of the 'backdoor' admin access worked on SQL 2000.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 8 posts - 16 through 23 (of 23 total)
You must be logged in to reply to this topic. Login to reply