Error accessing Workspace

Hi,

Check the web.config file for your WorkspaceService virtual directory (C:Program FilesK2.net 2003K2WSWorkspaceServiceweb.config).
There is a key in the appSettings node called "DSN". Make sure that the values in this connection string is pointing to the correct database server with the correct username and password.

<add key="DSN" value="Data Source=(local); initial catalog=K2Log; User ID=sa;Password=k2pass" />

Also have a look at the K2Server.config file (C:Program FilesK2.net 2003BinK2Server.config).
In this file there should be a connection string to each database (K2 and K2Log). Verify that the database server name, username and password is correct.

<Database ConnectionString="server=k2megasrv;database=k2;uid=sa;pwd=k2pass;pooling=true;enlist=false;min pool size=5" />
<LogDatabase ConnectionString="server=k2megasrv;database=k2log;uid=sa;pwd=k2pass;pooling=true;enlist=false;min pool size=5" />

Hope this helps.

Regards,

JohanL

Thanks Johan, but I still get the exact same error. K2 Server seems to work fine - It's just Workspace that won't load.

k2server.config:

<K2Server>
<DataSources>
<DataSource Path="LDAP://DC=ZZZZZ,DC=com" NetBiosName="HNC" Type="ActiveDirectory" />
</DataSources>
<Database ConnectionString="server=HGLONDEVK2;database=k2;uid=sa;pwd=ZZZZZ;pooling=true;enlist=false;min pool size=5" />
<LogDatabase ConnectionString="server=HGLONDEVK2;database=k2log;uid=sa;pwd=ZZZZZ;pooling=true;enlist=false;min pool size=5" />
<ThreadPooling Value="K2.net" Count="25" />
<LogThreadPooling Count="5" Priority="Low" />
<Framework Version="v2.0.50727" />
<Trace Enable="False" FileName="K2Server.log" />
<WorklistRemove Seconds="100" />
<IPCThreadPooling Count="5" Priority="Normal" />
<DefaultSMTPServer Server="hglondon2" />
<SharePoint>
<BasicAuthentication>False</BasicAuthentication>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</SharePoint>
<MACResolve Enable="False" />
<PerfMonCounters Enable="False" Interval="300" />
</K2Server>

workspaceservice web.config:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
<system.web>
<compilation defaultLanguage="vb" debug="false" />
<customErrors mode="RemoteOnly" />
<identity impersonate="true" />
<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />
<sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="Data Source=HGLONDEVK2;initial catalog=K2Log;user id=sa;password=ZZZZZ" cookieless="false" timeout="99999" />
<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
</system.web>
<appSettings>
<add key="DSN" value="Data Source=HGLONDEVK2; initial catalog=K2Log; User ID=sa;Password=ZZZZZ" />
<add key="TimeOut" value="120" />
</appSettings>
</configuration>

Is now fixed by getting the permissions sorted out on the SQL Server :oops:

Glad you sorted it out!