Before I get deep into SQL Installation let me tell you where we are starting…
I am walking through the installation of SCVMM 2008 R2 SP1 on a new server that I just setup in my demo environment. I want to use SQL Server 2008 R2 for my deployment so I need to set that up as a prerequisite. I figured this is a good opportunity to document the process.
I am starting with a sysprep’d Windows Server 2008 R2 Server. I have allocated 2 processors and 512mb memory to the guest using dynamic memory. Once I get the system up and running, I will bump up the memory to be close to what I actually need but I will leave it dynamic.
Great… Now Let’s Get Started!!!
After you open the port and before you confirm whether remote users can access the report server on the port that you open, you must grant user access to the report server through role assignments on Home and at the site level. You can open a port correctly and still have report server connections fail if users do not have sufficient permissions. For more information, see How to: Grant User Access to a Report Server (Report Manager) in SQL Server Books Online.
You can also verify that the port is opened correctly by starting Report Manager on a different computer. For more information, see Report Manager in SQL Server Books Online.
To enhance the security of your SQL Server connection, it is recommended that you enable SSL encryption by modifying the connection string as described in article 316898 in the Microsoft Knowledge Base at http://go.microsoft.com/fwlink/?LinkId=89722.
When connecting remotely to SQL Server using a port other than the default port (1433), you must append the port number after the instance name using the following syntax: instance name, port.
Long post… I hope you find it useful! Please feel free to comment!
This was a very in depth and simple and complicatedly easy guide I highly reccomend it!!!!
I was wondering if you could. I installed, uninstalled and re-installed Microsoft SQL2008 R2. I always getting an error 26 notice when I try to connect the server. I did just about everything which was recommended on several forums.
Do you have any advice. I am using Win7.
hi i got an error saying that you sql server 2008 r2 instalation not succesful at end of completion
could u help me i'm confused about using the accounts
i'm installing sql and tfs on the same server
i must use "install the native mode , right ?
i have account "domain/user" could i use it as the same account for all services and for the reporting service and tfs ??
Just passed through overlooking it...and no doubt it's easy to see how great is this material!! Thank you Very much!!!