SQL 2005 Editions and Installation

To install sql server we do have the following options based on the requirement.

1. SQL Server Standard Edition (32 and 64 bit) ---- For medium business and to handle large databases.

2. SQL Server Enterprise Edition (32 and 64 bit) ---- For large business and to handle very large databases.

3. SQL Server Express Edition (32 bit only) --- This is a free version of sql server easy to use for small database

4. SQL Server Workgroup (32 bit only) --- For small business and small database has no limits on size and number of sizes.

5. SQL Server Developer Edition (32 and 64 bit) --- This has functionality of the Enterprise version but used only for development and testing.


Tip: To install sql server 2005 standard edition 64 bit we have used windows server 2003 (service pack 1) standard x64 edition. Different sql server 2005 64 bit require different editions and service packs of the windos operating systems.

Sql Connection

Error - 26 A network related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or not accessible. Verify the instance name is correct and the sql server is configured to allow remote connections

For the above please check the following.

Option 1
1. Log into sql server , go to start --- control panel ---administrative tools --- services
2. Check sql server and make sure it is running.
3. Check for sql browsing services and make sure it is running.

Option 2
1. go to start --- programs --- administrator tools --- computer management
2. Click on services and applications
3. Click on sql server 2005 network configurations
4. Click on protocols for MSSQL Server
5. Click on TCP/IP
5. click on IPAddresses tab , check for the ports to be 1433

Option 3


1. check the main  firewall , please make sure you contact your network admin when you do this.
2. Under the change settings
3. Go to the exception tab
4. add port
5. Name : SQLPort Number: 1433Protocol: Select TCP

We had the same issue again on 20th July 2012 where Brian had a condition to allow the ports, this was removed by Brian in the main firewall and it worked.

SQL Server Names Instance installation

SQL Server Named Instance --- Connection issue

I have created a second instance in my sql server as MSSQL2, after the installation I tried to connect using the SSMS sql server management studio, but to my surprise i was given a error to check if the sql server exists or user details are correct.

The first instance connected without issues. But the second instance MSSQL2 will not connect.
I did check my authentication details, username and password.
I did check the sql surface area configureation details to see the MSSQL2 is online.
I did check the services to see if the MSQL2 is online.

But the issue was the sql server browser service was NOT online. When I brought is online i was able to connect without issues.

Installing SQL Server 2005

Installing SQL Server 2005 standard edition and windows 2008

Please make sure all the pre-requisties are installed.

1. The important componnet IIS Feature to be installed, with all the relevent components.click on start --- server manager ---- roles --- add roles.if IIS is intalled and to need the required components please click on Web services IIS --- go to Role services --- add roles.Make sure the follow compnents are added.

• Web Management Tools
• IIS 6 Management Compatibility
• IIS 6 WMI Compatibility IIS Metabase and
• IIS 6 configuration compatibility
• World Wide Web Services
• Application Development .NET Extensibility
• ASP.NET
• ISAPI Extensions
• ISAPI Filters Common
• HTTP Features
• Default Document Directory Browsing
• HTTP Redirection Static Content Security Windows Authentication
  

2. Now insert the CD and click on setup if autorun does not run.

3. Please clikc next and go through the normal installation.

4. When you get the window system configuration check make sure there is no warning message.

5. If there is message on IIS do not continue make sure the IIS component is completed or if there is warning message on Edition change, note there is a existing sql 2005 installed on this system.

6. To install another version start the cd from the command prompt. type in D:\setup.exe SKUUPGRADE=1

7. Now when there is no warning message click next, select the components you want to install.

8. Enter the instance name for example : MSSQL1

9. Now use the domain account to set up. for example username : vijay password : vijay domain : DOM

10. Select the authentication mode windows mode or mixed mode. This can be changed to mixed mode later as well.

11. Make all the selected components are installed successfully.

To check the installed components, let us first check sql server services.

1. Open sql management studio and select database services and enter username and password based on your authentication selection either windows or sql authentication.

2. When connected you have successful sql database services installed.

3. If not click on sql server configuration manager and start the sql server service.

To check Analysis services

1. Open sql management studio and select analysis services, this is opened through windows authentication.

2. When connected you have successful analysis services installed.

3. If not click on sql server configuration manager and start the analysis services.

To check Reporting services
1. Open sql management studio and select reporting services, this is opened through windows authentication.

2. When connected you have successful reporting services installed.
3. If not click on sql server configuration manager and start the reporting services.

4. Click on Reporting services configureation make sure the following is on.

• Server status --- running
• Report virtual directory --- name : reportserver --- website : default website
• Report manager virtual directory --- name : reports --- website : default website
• Windows services Identity --- service name : reportserver$MSSQL1 --- service account : localsystem builtin account : local system please note in this example MSQL1 is the sql instance name
• Web services Identity --- asp.net service account : NT Authority\NetworkService --- report server: reportserver$MSSQL1 --- report manager : reportserver$MSSQL1
• Database setup ---- server name : local(MSSQL1) --- database name : reportserver --- credential type : windows credentials --- account name ---- DOM\vijay ( please note the user name you had given earlier for installation)
• email setting : sender name : emailid (or any other company email id) --- current delivery method --- user smtp server ---- smtp server ---- enter the ip address of smtp server.

If there is still error on the reporting services

Fix / workaround solution

please go to C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager

open the RSWebapplicaton file on the notepad and check the following.

1.ReportServerUrl>

2.reportServerVirtualDirectory>ReportServer ( this is the name on the virtual directory of the report server configuration.

3. FullTrust