March 5, 2011 at 7:56 am
Hi all,
I had SQL Server Express 2008 R2 installed
I uninstalled successfully and rebooted
I then installed SQL Server 2008 R2 Developer
Now when I go into SSMS, the default server type is Integration Services
I clicked the drop down and selected "Database Engine"
I clicked the drop down for Server Name and selected Browse for more
On Local Servers tab I expanded the Database Engine node
The only server listed is MYPC\SQLEXPRESS
Even if I select that (I don't think that is the correct server) and use Windows Authentication, I keep receiving error message:
"A network-related or instance-specific error occurred while establishing a connection to SQL Server."
I worked through a tutorial I found on-line, checked all configurations, enabled TCP/IP, made sure all SQL Services are started (They are)
Still same error message
What am I missing?
Thanks
w
March 5, 2011 at 9:06 am
There are two things you can do first go to configuration manager and turn off the Express and try to connect to the developer edition. The other option is to repair the developer edition install and make sure it is a named instance and also the workstation components are not disabled in the install because if it is then you don't have management studio for the developer to use. If the workstation components are disabled then you need to go into add remove programs and uninstall them from the SQL Server install and then rerun setup and it will be enabled then you can install it and connect to management studio.
Kind regards,
Gift Peddie
March 5, 2011 at 10:00 am
Thanks Gift,
There appear to be 3 folders:
1.) Start >> All Programs >> Microsoft SQL Server 2005 >> Configuration Tools >> SQL Server Configuration Manager
2.) Start >> All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Installation Center (64-bit)
3.) Start >> All Programs >> Microsoft SQL Server 2005 >> Configuration Tools >> SQL Server Configuration Manager
SQL Server Network Configuration (32bit)
|_Protocols for SQLEXPRESS
SQL Server Network Configuration
|_Protocols for MSSQLSERVER
I did not see any options in 1 or 3 to start or stop an instance of SQL Server
Option 2 only lead me back to the installation panel that launched with SQL Server 2008 R2 Developer DVD.
I also checked in component services, but all services running appeared to be related to MSSQLSERVER not SQLEXPRESS
Thanks
w
March 5, 2011 at 10:27 am
winston.snyder (3/5/2011)
Thanks Gift,There appear to be 3 folders:
1.) Start >> All Programs >> Microsoft SQL Server 2005 >> Configuration Tools >> SQL Server Configuration Manager
2.) Start >> All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Installation Center (64-bit)
3.) Start >> All Programs >> Microsoft SQL Server 2005 >> Configuration Tools >> SQL Server Configuration Manager
SQL Server Network Configuration (32bit)
|_Protocols for SQLEXPRESS
SQL Server Network Configuration
|_Protocols for MSSQLSERVER
I did not see any options in 1 or 3 to start or stop an instance of SQL Server
Option 2 only lead me back to the installation panel that launched with SQL Server 2008 R2 Developer DVD.
I also checked in component services, but all services running appeared to be related to MSSQLSERVER not SQLEXPRESS
Thanks
w
In the SQL Server 2008 installation go into configuration tools and then connect to configuration manager make sure all services are running because you can see all instances and components of SQL Server installed in your box in this configuration manager. Another thing I have seen many issues with DVD based installs so I advice to copy content of DVD to C drive and run setup from C drive.
Kind regards,
Gift Peddie
March 5, 2011 at 10:42 am
Thanks Gift,
I do not see an option for Configuration Manager?
From the SQL Server Installation Center these tabs:
-Planning
-Installation
-Maintenance
-Tools
-Resources
-Advanced
-Options
I stepped through each of the tabs, selected many of the links under each tab, but none of them lead me to a configuration manager
Thanks,
w
March 5, 2011 at 11:46 am
winston.snyder (3/5/2011)
Thanks Gift,I do not see an option for Configuration Manager?
From the SQL Server Installation Center these tabs:
-Planning
-Installation
-Maintenance
-Tools
-Resources
-Advanced
-Options
I stepped through each of the tabs, selected many of the links under each tab, but none of them lead me to a configuration manager
Thanks,
w
I am in Windows 7 Ultimate x86 (32bits) and Windows 7 Enterprise x64 (64 bits) the later my employer's box. If I go into SQL Server 2008 I see BID and SMS, then Analysis Service, then Configuration Tools here you have SSRS config tool and Configuration manager. If you don't have that then you may have run into known issue with DVD install so copy the content to you C drive and rerun setup form your C drive and make sure you have configuration manager. You should also skip TCP/IP enabling during the install you can do that in Network configuration in configuration manager.
Kind regards,
Gift Peddie
March 5, 2011 at 1:48 pm
Thanks Gift,
Here is what I see in Configuration Manager:
SQL Server Configuration Manager (local)
|-SQL Server Services
|-SQL Server Network Configuration (32bit)
...|-Protocols for SQLEXPRESS
SQL Native Client 10.0 Configuration (32bit)
...|-Client Prtocols
...|-Aliases
SQL Server Network Configuration
...|-Protocols for MSSQLSERVER
SQL Native Client 10.0 Configuration
...|-Client Protocols
...|-Aliases
I do not see an option to turn off EXPRESS
I only see the 4 protocols
1.) Shared Memory
2.) Named Pipes
3.) TCP/IP
4.) VIA
Thanks
w
March 5, 2011 at 2:31 pm
SQL Server Services
SQL Server Network Configuration
SQL Native Client 10.0 Configuration
The above three options are the ones you need, you will find Express in the services that is the top one. Try turning off Express and you could leave the Agent service off too that service is turned off by default in the developer edition. Then check network configuration and make sure both TCP/IP and Named Pipes are enabled. And Native Client make sure both TCP/IP and Named Pipes are enabled. If all these did not fix it rerun setup and repair the install. One more thing use Windows authentication for the first connection if you get the browse just put your computer name on the network.
Kind regards,
Gift Peddie
March 5, 2011 at 2:49 pm
Thanks Gift
It does not appear that any of the services listed are SQLEXPRESS
Here is what is listed:
-SQL Server Integration Services 10.0
-SQL Full-text Filter Daemon Launcher (MSSQLSERVER)
-SQL Server (MSSQLSERVER)
-SQL Server Analysis Services (MSSQLSERVER)
-SQL Server Reporting Services (MSSQLSERVER)
-SQL Server Browser
-SQL Server Agent (MSSQLSERVER)
Thanks
w
March 5, 2011 at 3:10 pm
winston.snyder (3/5/2011)
Thanks GiftIt does not appear that any of the services listed are SQLEXPRESS
Here is what is listed:
-SQL Server Integration Services 10.0
-SQL Full-text Filter Daemon Launcher (MSSQLSERVER)
-SQL Server (MSSQLSERVER)
-SQL Server Analysis Services (MSSQLSERVER)
-SQL Server Reporting Services (MSSQLSERVER)
-SQL Server Browser
-SQL Server Agent (MSSQLSERVER)
Thanks
w
It means something is wrong with the Express install so I think you need to remove Express from add remove programs and repair the developer edition install. The reason in both my boxes Express is listed but yours is showing Express not part of the services so something is wrong with it, I would remove it if you want to learn SQL Server, the developer edition is the version to use because it is a single user Enterprise edition.
Kind regards,
Gift Peddie
March 5, 2011 at 8:42 pm
Thanks Gift,
I wonder is something happened to SQL Server 2008 R2 when I installed Visual Studio Pro 2010
Here is what I see for programs
Which should I delete before I reinstall SQL Server 2008 R2 Developer?
Microsoft SQL Server 2008 R2 (64-bat)
Microsoft SQL Server 2008 R2 Books Online
Microsoft SQL Server 2008 R2 Data-Tier Application Framework
Microsoft SQL Server 2008 R2 Data-Tier Application Project
Microsoft SQL Server 2008 R2 Management Objects
Microsoft SQL Server 2008 R2 Management Objects (x64)
Microsoft SQL Server 2008 R2 Native Client
Microsoft SQL Server 2008 R2 Policies
Microsoft SQL Server 2008 R2 Setup (English)
Microsoft SQL Server 2008 R2 Transact-SQL Language Service
Microsoft SQL Server 2008 R2 Setup Support Files
Microsoft SQL Server Browser
Microsoft SQL Server Compact 3.5 SP2 ENU
Microsoft SQL Server Compact 3.5 SP2 Query Tools ENU
Microsoft SQL Server Compact 3.5 SP2 x64 ENU
Microsoft SQL Server Database Publishing Wizard 1.4
Microsoft SQL Server System CLR Types
Microsoft SQL Server System CLR Types (x64)
Microsoft SQL Server VSS Writer
Thanks,
w
March 5, 2011 at 9:54 pm
It looks the same in my x64 box where I have SQL Server 2005, 2008 and 2008 R2 installed with VS2008 pro and VS2010 Utimate without issues. So rerun setup because I think your SQL Server 2005 Express may have been upgraded to SQL Server 2008 Express by the VS2010 installer because it installs SQL Server Express if you don't use custom install options to disable the SQL Server Express install during the installation of Visual Studio.
Kind regards,
Gift Peddie
March 6, 2011 at 2:37 pm
Thanks Gift,
I tried to repair first, but that did not seem to fix the problem
So Installed with a new instance
I'm now up and running
Thanks for your help
Kind regards,
w
March 6, 2011 at 5:21 pm
winston.snyder (3/6/2011)
Thanks Gift,I tried to repair first, but that did not seem to fix the problem
So Installed with a new instance
I'm now up and running
Thanks for your help
Kind regards,
w
I am glad your issues are all resolved.
Kind regards,
Gift Peddie
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply