Đang Thực Hiện

SQL Database Repair

I have a software (Quickbooks Point of Sale) installed on my computer. The software connects to a SQL databse at the back end. This SQL database seems to have gone corrupt. Having a look at the log file shows the following:

I. 04/23 15:06:26. SQL Anywhere Network Server Version [url removed, login to view]

I. 04/23 15:06:26. OEM Authenticated Edition, licensed only for use with authenticated OEM applications.

I. 04/23 15:06:26.

I. 04/23 15:06:26. Copyright © 2001-2009, iAnywhere Solutions, Inc.

I. 04/23 15:06:26. Portions copyright © 1988-2009, Sybase, Inc. All rights reserved.

I. 04/23 15:06:26. Use of this software is governed by the Sybase License Agreement. Refer to [url removed, login to view]

I. 04/23 15:06:26.

I. 04/23 15:06:26. Networked Seat (per-seat) model. Access to the server is limited to 100 seat(s).

I. 04/23 15:06:26. 2 logical processor(s) on 1 physical processor(s) detected.

I. 04/23 15:06:26. Maximum number of physical processors the server will use: 1

I. 04/23 15:06:26. This server is licensed to:

I. 04/23 15:06:26. Quickbooks Point of Sale

I. 04/23 15:06:26. Intuit Inc.

I. 04/23 15:06:26. Running Windows Vista Build 6002 Service Pack 2 on X86_64

I. 04/23 15:06:26. Server built for X86 processor architecture

I. 04/23 15:06:26. 65960K of memory used for caching

I. 04/23 15:06:26. Minimum cache size: 2048K, maximum cache size: 3603372K

I. 04/23 15:06:26. Using a maximum page size of 4096 bytes

I. 04/23 15:06:26. Starting database "qbpos" (C:\Users\Public\Documents\Intuit\QuickBooks Point of Sale 9.0\Data\New Company Data1\[url removed, login to view]) at Sat Apr 23 2011 15:06

I. 04/23 15:06:27. Database recovery in progress

I. 04/23 15:06:27. Last checkpoint at Sat Apr 23 2011 14:46

I. 04/23 15:06:27. Transaction log: qbpos.log...

I. 04/23 15:06:27. Checkpointing...

I. 04/23 15:06:27. Starting checkpoint of "qbpos" ([url removed, login to view]) at Sat Apr 23 2011 15:06

I. 04/23 15:06:27. Finished checkpoint of "qbpos" ([url removed, login to view]) at Sat Apr 23 2011 15:06

I. 04/23 15:06:27. Recovery complete

I. 04/23 15:06:27. Database "qbpos" ([url removed, login to view]) started at Sat Apr 23 2011 15:06

I. 04/23 15:06:27. This database is licensed for use with:

I. 04/23 15:06:27. Application: QuickBooks Point of Sale

I. 04/23 15:06:27. Company: Intuit Inc.

I. 04/23 15:06:27. Database server started at Sat Apr 23 2011 15:06

I. 04/23 15:06:27. Trying to start SharedMemory link ...

I. 04/23 15:06:27. SharedMemory link started successfully

I. 04/23 15:06:27. Trying to start TCPIP link ...

I. 04/23 15:06:32. TCPIP link started successfully

I. 04/23 15:06:32. Now accepting requests

E. 04/23 15:06:32. Login procedure 'sp_login_environment' caused SQLSTATE '52W09'

E. 04/23 15:06:32. Procedure 'sp_login_environment' not found

E. 04/23 15:06:35. Login procedure 'sp_login_environment' caused SQLSTATE '52W09'

E. 04/23 15:06:35. Procedure 'sp_login_environment' not found

E. 04/23 15:06:35. Login procedure 'sp_login_environment' caused SQLSTATE '52W09'

E. 04/23 15:06:35. Procedure 'sp_login_environment' not found

E. 04/23 15:06:35. Login procedure 'sp_login_environment' caused SQLSTATE '52W09'

E. 04/23 15:06:35. Procedure 'sp_login_environment' not found

I. 04/23 15:06:40. Starting checkpoint of "qbpos" ([url removed, login to view]) at Sat Apr 23 2011 15:06

I. 04/23 15:06:40. Finished checkpoint of "qbpos" ([url removed, login to view]) at Sat Apr 23 2011 15:06

As you can see from above we are experiencing the error:

E. 04/23 15:06:32. Login procedure 'sp_login_environment' caused SQLSTATE '52W09'

E. 04/23 15:06:32. Procedure 'sp_login_environment' not found

Can you have this error fixed so that my software can start functioning normally again?

The database is 42MB in size. You can download it from here: [url removed, login to view]

Kỹ năng: SQL

Xem thêm: login procedure sp_login_environment caused sqlstate 52w09, procedure sp_login_environment found, sqlstate 52w09, 2048k memory used caching, sybase starting checkpoint qbpos, login procedure sp_login_environment caused sqlstate 52w09 qbpos, qbpos sp_login_environment, sql anywhere oem login, sqlstate 52w09 quickbooks, intuit login procedure sp_login_environment caused sqlstate 52w09, sp_login_environment intuit, login procedure sp_login_environment, quickbooks procedure sp_login_environment found, 2048k memory used caching accepting requests, www intuit com, software seat license, service processor, service database access, seat license software, seat license, seat agreement, repair my, model service agreement, maximum data solutions, log used on company

Về Bên Thuê:
( 20 nhận xét ) London, Pakistan

Mã Dự Án: #1034928

5 freelancer đang chào giá trung bình $62 cho công việc này

pranesh1977

Hi Please check PMB

$30 USD trong 1 ngày
(1 Đánh Giá)
3.0
ddtaxe

Greetings. This is Denis Mello an IT Architect and Security Professional whose qualifications include a degree in computer science; Certified Ethical Hacker, LINUX LPI, MCP Windows Server (2k, 2k3 and 2k8), Control Ob Thêm

$80 USD trong 1 ngày
(1 Đánh Giá)
2.2
porchelino

Hi there, I am a dba and am sure I can help you in this. If you want I can go ahead. REgards

$70 USD trong 1 ngày
(0 Đánh Giá)
0.0
ninjatec

I all ready have a fix for this that I can apply in under an hour, as there is no milestone i can offer a no fix no fee deal

$50 USD trong 1 ngày
(0 Đánh Giá)
0.0
ihsanchahi

em ready to work

$80 USD trong 3 ngày
(0 Đánh Giá)
0.0