Solved

Sharepoint 2007 Setup

Posted on 2011-09-06
16
229 Views
Last Modified: 2012-05-12
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.SPException was thrown. Additional excepyion information: Unable to connect to database. Check database connection information and make sure the database server is running


 
0
Comment
Question by:TheLizzard
  • 10
  • 6
16 Comments
 
LVL 12

Expert Comment

by:NormanMaina
ID: 36487953
Trying pinging the db server from teh sharepoint box - if it cant you may need to add a persistent route in the sharepoint machine and in the db server using teh command promt.

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.
0
 

Author Comment

by:TheLizzard
ID: 36487963
Hi


I can ping the server and it makes the databases on the sql server but it some how looses the connection i think ?
0
 
LVL 12

Expert Comment

by:NormanMaina
ID: 36487976
can you telnet into the db server from teh sharepont server using the sql port?

i.e telnet dbserver 1433


0
 

Author Comment

by:TheLizzard
ID: 36488022
yes i can
0
 

Author Comment

by:TheLizzard
ID: 36488035
Here is the SQL log

09/06/2011 12:43:06,spid80,Unknown,Setting database option AUTO_CLOSE to OFF for database SharePoint_AdminContent_af204f16-2376-4c54-a7e5-53dfed3670a7.
09/06/2011 12:43:06,spid80,Unknown,Starting up database 'SharePoint_AdminContent_af204f16-2376-4c54-a7e5-53dfed3670a7'.
09/06/2011 12:42:53,spid79,Unknown,Setting database option AUTO_CLOSE to OFF for database INTERNET_SharePoint_Config.
09/06/2011 12:42:53,spid79,Unknown,Starting up database 'INTERNET_SharePoint_Config'.
09/06/2011 11:22:01,spid77,Unknown,Setting database option AUTO_CLOSE to OFF for database SharePoint_AdminContent_2364cf4d-635d-4e1e-ade4-41628d17314c.
09/06/2011 11:22:01,spid77,Unknown,Starting up database 'SharePoint_AdminContent_2364cf4d-635d-4e1e-ade4-41628d17314c'.
09/06/2011 11:21:47,spid70,Unknown,Setting database option AUTO_CLOSE to OFF for database INTERNET_SharePoint_Config.
09/06/2011 11:21:47,spid70,Unknown,Starting up database 'INTERNET_SharePoint_Config'.
09/06/2011 11:10:20,spid76,Unknown,Setting database option AUTO_CLOSE to OFF for database SharePoint_AdminContent_7ad986a3-ba92-484e-8abe-9dece0dcf2a2.
09/06/2011 11:10:20,spid76,Unknown,Starting up database 'SharePoint_AdminContent_7ad986a3-ba92-484e-8abe-9dece0dcf2a2'.
09/06/2011 11:10:05,spid69,Unknown,Setting database option AUTO_CLOSE to OFF for database INTERNET_SharePoint_Config.
09/06/2011 11:10:05,spid69,Unknown,Starting up database 'INTERNET_SharePoint_Config'.
0
 
LVL 12

Expert Comment

by:NormanMaina
ID: 36488074
why not rerun the sharepoint configuration wizard -detach teh databases and then run it again to create teh databases afresh?
0
 

Author Comment

by:TheLizzard
ID: 36488093
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
0
 

Author Comment

by:TheLizzard
ID: 36488168
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.

0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 12

Expert Comment

by:NormanMaina
ID: 36488401
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
0
 

Author Comment

by:TheLizzard
ID: 36488771
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
0
 

Author Comment

by:TheLizzard
ID: 36495007
Do anyone have a solution ???
0
 
LVL 12

Expert Comment

by:NormanMaina
ID: 36495123
Hello,
I would suggest try using the full instance name i.e "sp-20-003\SQL03"
0
 

Author Comment

by:TheLizzard
ID: 36495131
but i cant for it dosent find the server when i try to use the full name
0
 
LVL 12

Expert Comment

by:NormanMaina
ID: 36495295
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.
0
 

Accepted Solution

by:
TheLizzard earned 0 total points
ID: 36580384
well the solution was to enter the name of the database server like this:

databaseserver.yourdomain.com,1433\instance name
0
 

Author Closing Comment

by:TheLizzard
ID: 36708066
i worked it out my self
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Suggested Solutions

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now