I have just ordered a copy of Wise Package Studio 7 SP3, on installing i am having problems creating the 3 backend DB's on a SQL (2008) server, as i go through the repository wizard i supple the SQL server name and select SQL Authentication with a valid account and password with SYSAdmin permissions (tried and tested), all seems good the Wise Share Point is Created at the specified location but the whole process fails with "A database processing error was encountered".
In the event viewer on the SQL server all the error message says is as below:
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: Logon
Event ID: 18456
Date: 5/11/2009
Time: 5:08:51 PM
User: N/A
Computer: BAS-FLU-SQL-01
Description:
Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 172.16.11.15]
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 0f 00 00 00 42 00 41 00 ....B.A.
0010: 53 00 2d 00 46 00 4c 00 S.-.F.L.
0018: 55 00 2d 00 53 00 51 00 U.-.S.Q.
0020: 4c 00 2d 00 30 00 31 00 L.-.0.1.
0028: 00 00 07 00 00 00 6d 00 ......m.
0030: 61 00 73 00 74 00 65 00 a.s.t.e.
0038: 72 00 00 00 r...
Can anyone throw light on the problem, i have setup WPS many times and never encountered these problems, maybe i am just doing something wrong but i have tried everything to get this working. I could really do with some help!!!
The PC i am using is running XPProSP3
Thanks in advance