SharePoint User Group UK

HI All,

I'm trying to install WSS v3.0 on Multi-Box environment. My Domain name is SPDOMAIN and my sql server is VSSQL. Im trying to connect to DB from another machine called vids. with lot of effort I'm able to connect to DB some time and mostly thrown error cannot connect to DB. When i get hold of connection and trying to configure it fails on step 2/9 and the following error is thrown.

Entering function SqlServerHelper.SqlServerHelper
05/15/2008 10:40:44  1  INF                        Entering function SqlServerHelper.Initialize
05/15/2008 10:40:44  1  INF                          Entering function SqlServerHelper.ParseSqlServerInstance
05/15/2008 10:40:44  1  INF                          Leaving function SqlServerHelper.ParseSqlServerInstance
05/15/2008 10:40:44  1  INF                          Entering function SqlSession.SqlSession
05/15/2008 10:40:44  1  INF                          Leaving function SqlSession.SqlSession
05/15/2008 10:40:44  1  INF                        Leaving function SqlServerHelper.Initialize
05/15/2008 10:40:44  1  INF                      Leaving function SqlServerHelper.SqlServerHelper
05/15/2008 10:40:44  1  INF                      The parameter database is chosen, so returning the value as VSWSS_Config
05/15/2008 10:40:44  1  INF                      Executing sql command now to see if the server vids\vssql is a sql server at database VSWSS_Config
05/15/2008 10:40:44  1  INF                      The parameter database is chosen, so returning the value as VSWSS_Config
05/15/2008 10:40:44  1  INF                      Entering function SqlServerHelper.DatabaseExists
05/15/2008 10:40:44  1  INF                        Entering function SqlServerHelper.ValidateDatabaseName
05/15/2008 10:40:44  1  INF                          Searching for bad characters " < > | : * ? \ /  in database VSWSS_Config
05/15/2008 10:40:44  1  INF                          Did not find any invalid characters in database VSWSS_Config
05/15/2008 10:40:44  1  INF                        Leaving function SqlServerHelper.ValidateDatabaseName
05/15/2008 10:40:44  1  INF                        Entering function SqlSession.ExecuteNonQuery
05/15/2008 10:40:58  1  INF                        Leaving function SqlServerHelper.DatabaseExists
05/15/2008 10:40:58  1  INF                        The parameter database is chosen, so returning the value as VSWSS_Config
05/15/2008 10:40:58  1  ERR                        A System.Data.SqlClient.SqlException was thrown on server vids\vssql, database VSWSS_Config
05/15/2008 10:40:58  1  INF                        Entering function Common.BuildExceptionInformation
05/15/2008 10:40:58  1  INF                          Entering function Common.BuildExceptionMessage
05/15/2008 10:40:58  1  INF                            Entering function StringResourceManager.GetResourceString
05/15/2008 10:40:58  1  INF                              Resource id to be retrieved is ExceptionInfo for language English (United States)
05/15/2008 10:40:58  1  INF                              Resource retrieved id ExceptionInfo is An exception of type {0} was thrown.  Additional exception information: {1}
05/15/2008 10:40:58  1  INF                            Leaving function StringResourceManager.GetResourceString
05/15/2008 10:40:58  1  INF                          Leaving function Common.BuildExceptionMessage
05/15/2008 10:40:58  1  INF                        Leaving function Common.BuildExceptionInformation
05/15/2008 10:40:58  1  ERR                        An exception of type System.Data.SqlClient.SqlException was thrown.  Additional exception information: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

 

can any one direct me how to solve this issue.

 

Cheers,

Vids

Have you tried just creating a system DSN test connection under ODBC Data Source Adminstrator in Control panel, it mau be worth trying this to rule out any network/configuration connection issues first?

---

Andrew Carter
.Net & SharePoint

It looks like a domain/network config error. Note that the connection is testing VIDS\VSSQL when it should be SPDOMAIN\VSSQL\[optionally any SQL instance name]

Chek that the domain is working correctly and all servers can see each other (not just ping), on the network, then go for the installation.

---

Paul Leigh

Hi Paul,

I tried connencting from the two account and I have the same problem.

HI Andrew,

When I tried to connect via ODBC source , it says Timeout Expired. SQL error 0. I'm running this multi-box env on Virtual PC. Is the problem  some thing to do with this set up?

Cheers,

Vids

make sure the SQL server is accepting remote connections using the SQL Server configuration manager.

 

s.

---

Cheers
Spence
www.harbar.net

HI Paul/Andrew,

I retried connecting via System DSN. It says " Cannot generate SSPI" context.

Vids

If you're using VPC, then I'd suggest you simply use the standalone installation off WSS and SQL on the same machine. It'll sort out your networking issues and having two or more seperate virtual machines doesn't really give you any credible benefit (unless they are part of a staging platform).

 

---

Paul Leigh

Paul,

Atlast I decided to install on the single box. Im trying to create the environment described in the book "Building office 2007 solution in C# 2005" by scott hiller. I tried working on it for 3 days now and  going for single box. In the mean time I found this post my help to resolve my issue " http://support.microsoft.com/kb/811889 ". which I might try later on.

Cheers,

Vids

 

HI yeh,

I turned the remote connection and nothing seems to be working. I figured the problem might be due to SPN of SQL server not registered to the Active directory. " http://support.microsoft.com/kb/811889 ". I would try this option later on. Im planning to install on single box and start practical with SP 2007.

Cheers,

Vids

this is only relevant if you have configured the SQL server to only accept kerberos authenticated connections. You may also need to enable TCP/IP and/or named pipes within COnfiguration Manager.

If you just want to get started then a single box is however the best option.

---

Cheers
Spence
www.harbar.net

HI Paul,

 

I have successfully configured the Share Point on the Multi Box now. After I have registered SQL Server named instance on the AD of DC Share Point Installed with out any issues.  I have noticed that DNS server , DHCP server should be configured on the ever machine in the domain inorder to install Share Point Successfully.

Regards,

Vids

Hi Vids,

Firstly, well done for getting the SharePoint server successfully built.

There are many ways to configure a server to suit a SharePoint Installation. It's all down to what you intend to use the server for and the type of environment if fits in with. To a have a routable url, the server should at least have one fixed IP address (DHCP isn't a requirement). As a standalone server, it does not need DNS but it must be able to access and query a properly setup a DNS server. If you don;t have these on your network, the yes DNS should be installed and you would typically use and AD Integrated DNS service.

Setting up a server is a specialist job and whilst there are various wizards and self help tools to get you going, there is no substitute (in my opinion) for a solid understanding of network architecture which would include TCP/IP, DNS, Active Directory amongst others.

---

Paul Leigh

HI Paul,

Thanks for your valuable feedback. I dont have much experience in setting up the server. This is first time I did extensive configuration on MULTI BOX. Though I have configured the DNS  on the DC I was not able to successfully communicate with it. I did lot of searching and tweaked everything step by step. It took me 10 days to complete just installation. Could you recomment me any post or link for the detailed learning of installation and configuration.

Thanks,

Vids