During an installation of SPS 2003, I wished to create a new
configuration database. In every instance, I received the error :
"Unable to connect to database. Check database connection
information
and make sure the database server is running". This is not correct
because the connection informaition IS right and the server IS
running.
For what it's worth: I am attempting to connect to a SQL Server not
co-located on the Sharepoint machine
In desperation, I decided to connect to an existing configuration
database... and this appeared in the logs:
000C4D7A UNK 00000000 0000020C Configuration database: 'Server=3DVAADV-
DBT3\SQL3;Database=3DSharepointConfig_dxd1;Trusted_Connection=3Dyes;App=3DS=
harePo=AD
int
Portal Server;'
000C4DA9 UNK 00000000 0000020C Configuration database is
online
000C4DD7 UNK 00000000 0000020C Added local server [MyServer] to farm.
(c6ebcf1c-1e4d-4600-bb80-80b82ba7ebb0)
000C4E35 UNK 00000000 0000020C Registered WebService on current
server. (562624cf-bf02-4cf8-b78c-43c0091a092c)
000C4E45 UNK 00000000 0000020C Registered SearchService on current
server. (d0df327b-e31b-49b0-9387-40ffd7088ebb)
000C4E54 UNK 00000000 0000020C Registered IndexService on current
server. (84258b49-96b8-47f7-acbf-63e13af494d1)
000C4E64 UNK 00000000 0000020C Registered AlertsService on current
server. (3727400a-68b1-4603-8fad-789f0127c43b)
000C4E64 UNK 00000000 0000020C Updating configuration database
connection. ('VAADV-DBT3\SQL3', 'SharepointConfig_dxd1')
000C4E83 UNK 00000000 0000020C Microsoft.SharePoint.SPException:
Unable to connect to database. Check database connection information
and make sure the database server is running. --->
System.Runtime.InteropServices.COMException (0x8107053B): Unable to
connect to database. Check database connection information and make
sure the database server is running.
at
Microsoft.SharePoint.Library.SPRequestInternalClass.UpdateConfigDBDsn(Strin=
=AD
g
bstrDBServer, String bstrDBName, String bstrUsername, String
bstrPassword) <snip>
In other words: It DOES connect to the database server, insert some
rows, and then immediately says it can NOT. This is not a one time
error, but one that happens everytime I attempt to connect to an
existing database.. I did verify in the existing config database
that registered the above services, so my connection information IS
correct.
The bottom line is that this error "Cannot connect to database..."
seems to be masking something else. I cannot complete my
installation
at this time because I can neither connect (completely) to a config
db
nor create a new one. I am at a loss on how to fix this. Can
anyone lend any insight?