TheLizzard
asked on
Sharepoint 2007 Setup
Hi
i am trying to install Sharepoint 2007 and i been having som problems.
I have 2 nets: one int and one pub
My sharepoint server is in the pub net and my db server is in the int net, the user i am useing is in the int domain and i have a trust setup. So when i start the installation i can see that it creates the config_db and admin_content but i get a error:
An exception of type Microsoft.Sharepoint.SPExc eption was thrown. Additional excepyion information: Unable to connect to database. Check database connection information and make sure the database server is running
i am trying to install Sharepoint 2007 and i been having som problems.
I have 2 nets: one int and one pub
My sharepoint server is in the pub net and my db server is in the int net, the user i am useing is in the int domain and i have a trust setup. So when i start the installation i can see that it creates the config_db and admin_content but i get a error:
An exception of type Microsoft.Sharepoint.SPExc
ASKER
Hi
I can ping the server and it makes the databases on the sql server but it some how looses the connection i think ?
I can ping the server and it makes the databases on the sql server but it some how looses the connection i think ?
can you telnet into the db server from teh sharepont server using the sql port?
i.e telnet dbserver 1433
i.e telnet dbserver 1433
ASKER
yes i can
ASKER
Here is the SQL log
09/06/2011 12:43:06,spid80,Unknown,Se tting database option AUTO_CLOSE to OFF for database SharePoint_AdminContent_af 204f16-237 6-4c54-a7e 5-53dfed36 70a7.
09/06/2011 12:43:06,spid80,Unknown,St arting up database 'SharePoint_AdminContent_a f204f16-23 76-4c54-a7 e5-53dfed3 670a7'.
09/06/2011 12:42:53,spid79,Unknown,Se tting database option AUTO_CLOSE to OFF for database INTERNET_SharePoint_Config .
09/06/2011 12:42:53,spid79,Unknown,St arting up database 'INTERNET_SharePoint_Confi g'.
09/06/2011 11:22:01,spid77,Unknown,Se tting database option AUTO_CLOSE to OFF for database SharePoint_AdminContent_23 64cf4d-635 d-4e1e-ade 4-41628d17 314c.
09/06/2011 11:22:01,spid77,Unknown,St arting up database 'SharePoint_AdminContent_2 364cf4d-63 5d-4e1e-ad e4-41628d1 7314c'.
09/06/2011 11:21:47,spid70,Unknown,Se tting database option AUTO_CLOSE to OFF for database INTERNET_SharePoint_Config .
09/06/2011 11:21:47,spid70,Unknown,St arting up database 'INTERNET_SharePoint_Confi g'.
09/06/2011 11:10:20,spid76,Unknown,Se tting database option AUTO_CLOSE to OFF for database SharePoint_AdminContent_7a d986a3-ba9 2-484e-8ab e-9dece0dc f2a2.
09/06/2011 11:10:20,spid76,Unknown,St arting up database 'SharePoint_AdminContent_7 ad986a3-ba 92-484e-8a be-9dece0d cf2a2'.
09/06/2011 11:10:05,spid69,Unknown,Se tting database option AUTO_CLOSE to OFF for database INTERNET_SharePoint_Config .
09/06/2011 11:10:05,spid69,Unknown,St arting up database 'INTERNET_SharePoint_Confi g'.
09/06/2011 12:43:06,spid80,Unknown,Se
09/06/2011 12:43:06,spid80,Unknown,St
09/06/2011 12:42:53,spid79,Unknown,Se
09/06/2011 12:42:53,spid79,Unknown,St
09/06/2011 11:22:01,spid77,Unknown,Se
09/06/2011 11:22:01,spid77,Unknown,St
09/06/2011 11:21:47,spid70,Unknown,Se
09/06/2011 11:21:47,spid70,Unknown,St
09/06/2011 11:10:20,spid76,Unknown,Se
09/06/2011 11:10:20,spid76,Unknown,St
09/06/2011 11:10:05,spid69,Unknown,Se
09/06/2011 11:10:05,spid69,Unknown,St
why not rerun the sharepoint configuration wizard -detach teh databases and then run it again to create teh databases afresh?
ASKER
i have done that 3 times :(, i allsow tryed to add the hostname of the sql server to the host file on the Sharepoint server but no luck
ASKER
In summary:
1. Wizard connects to SQL Server successfully.
2. Creates a login of the service account that will be running the Central Admin.
3. Creates two databases for Central Admin
4. Builds up a new connection string but fails with 'invalid instance' when it tries to connect with the new string.
1. Wizard connects to SQL Server successfully.
2. Creates a login of the service account that will be running the Central Admin.
3. Creates two databases for Central Admin
4. Builds up a new connection string but fails with 'invalid instance' when it tries to connect with the new string.
can you try using IP for server name?
could be a dns problem
also confirm instance name in sql server by going using select @@servername
The servername in connection string should appear exactly like what will result from that
could be a dns problem
also confirm instance name in sql server by going using select @@servername
The servername in connection string should appear exactly like what will result from that
ASKER
HI
I have tryed to use IP same happens, im not sure i understand what you mean by @@servername ?
My sql instance is "sp-20-003\SQL03" but i cant use "\SQL03" from public so i use only "sp-20-003"
And i added "sp-20-003 xxx.xxx.xxx.xxx" to the host file
And i logon to the server whit the same user that i am useing for the sharepoint install
By the way i have a sharepoint farm allready running on int nettwork on the same sql instance whit no problems
I have tryed to use IP same happens, im not sure i understand what you mean by @@servername ?
My sql instance is "sp-20-003\SQL03" but i cant use "\SQL03" from public so i use only "sp-20-003"
And i added "sp-20-003 xxx.xxx.xxx.xxx" to the host file
And i logon to the server whit the same user that i am useing for the sharepoint install
By the way i have a sharepoint farm allready running on int nettwork on the same sql instance whit no problems
ASKER
Do anyone have a solution ???
Hello,
I would suggest try using the full instance name i.e "sp-20-003\SQL03"
I would suggest try using the full instance name i.e "sp-20-003\SQL03"
ASKER
but i cant for it dosent find the server when i try to use the full name
server name="sp-20-003" AND instance name = "sp-20-003\SQL03"
It would have been easier for you if you had the instance name = server name
If you have another instance in teh server -and it is the default instance,then that could be the reason for the error -trying to connect to wrong instance with credentials and database existing in another instance.
It would have been easier for you if you had the instance name = server name
If you have another instance in teh server -and it is the default instance,then that could be the reason for the error -trying to connect to wrong instance with credentials and database existing in another instance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i worked it out my self
i.e Lets say your two nets have two different sub nets like 192.168.2.0 network and 192.168.1.0 network
In the 192.168.2.0 network,open the command promt(as admin) and write
route add 192.168.1.0 mask 255.255.255.0 192.168.1.1 metric 1 -p
Basically that it to forward all trafik from the 192.168.1.0 network to the GATEWAY which is aware of the other network.