I'm trying to set-up a test Sharepoint 2010 Enterprise server for our small office, but got completely stuck after the Sharepoint installation, and where I'm "configuring" it to work with the SQL server.
My setup (all on one server)
MS Server 2008 Ent R2 SP2 (DC)
Sharepoint 2010 Ent 64bit
MS SQL Server 2008 Ent 64bit SP2
I was able to install the Sharepoint 2010, and SQL 2008 servers, but when I run Sharepoint Configuration Wizard, I can not get through the screen where it asks to specify SQL database name, server name, usernames. It gives me the following error message:
SharePoint Products Configuration Wizard
Cannot connect to database master at QL server at MyServerName. The database might not exist, or the current user does not have permission to connect to it.
That window is asking me for:
a). Database server - which is this same server's name, i'm sure it's correct
b). Database name - Don't know, I probably don't have DB ready for it, but it's also saying that it will create a DB if there's no database with that name... not sure if it applies to Server 2008 though. Please help. How can I create a db in Server 2008, and check if it's working?
"Specify Database Access Account"
c). Don't know this one... I tried to use the same account that I created in AD for my SQL server installation (i used same account for all roles), but it wouldn't work. I also tried using Administrator account, but that didn't work either! Pleas help. How do I create an account that should work?
I'm very new to this, and never before installed MS SQL Server. In a tutorial that I found, it seems that I must set-up a username in the SQL database? But I don't know how do I create a database, and if i use "SQL Server Management Studio", i can't connect to any databases with it.
I've been following this tutorial, but getting completely lost on Step 5 - Administrative and Service accounts. http://andreasglaser.net/post/2009/11/18/Installing-SharePoint-Server-2010-on-Windows-Server-2008-R2-and-SQL-Server-2008-R2-Part-5-Administrative-and-service-accounts.aspx
Any help is greatly appreciated! Thanks in advance! :-)