Symptoms
Creating a SQL Server Service for a database with 6,000+ objects causes timeouts.
Diagnoses
This is due to the fact that K2 validates every single object in the database to which it has rights.
Resolution
There are two options:
1) Either up the timeout interval to as high as it needs to be (this will vary) and wait as long as necessary.
2) **Best option** Restrict rights to only objects that are destined to be tied to smartobjects. If it is determined later that more smartobjects for more objects are needed it is a simple matter of granting rights and refreshing the service instance.