Sql Server 2008 - Cannot connect to local default instance

Posted by Tone on Server Fault See other posts from Server Fault or by Tone
Published on 2010-05-14T18:57:24Z Indexed on 2010/05/14 19:04 UTC
Read the original article Hit count: 837

Filed under:

sql-server-2008-r2

I recently rebuilt my machine to Windows 7 x64, installed Sql Server 2008 enterprise. I can connect fine to other remote instances via Management Studio (be they 2000, 2005 or 2008), but i cannot find my local default instance.

I have verified that a directory was created for the default instance C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER
I can connect to SQLEXPRESS instance fine
I have rerun setup to ensure I have everything installed
I have verified that the SQLSERVER(MSSQLSERVER) service is running
I have tried brownsing for the instance and see all the others available except my local one
I have tried using this for servername: TSOUTHERLANDPC\MSSQLSERVER, the first part being my local machine name

My issue is not the same as this post or this post.

Any ideas?

Related posts about sql-server-2008-r2

SQLAuthority News – SQL SERVER 2008 R2 Pricing

as seen on SQL Authority - Search for 'SQL Authority'
I was recently asked question about SQL Server 2008 pricing. I have bookmarked official site here which lists the pricing. Official site: What’s New in SQL Server 2008 R2 Editions Editions Per Processor PricingRetail Per Server Plus CAL PricingRetail Parallel Data Warehouse $57,498 Not… >>> More
SQLAuthority News – SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)

as seen on SQL Authority - Search for 'SQL Authority'
SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. The SQL Server 2008 R2 Update for Developers Training Kit is ideal for developers who want to understand how to take advantage of the key improvements introduced… >>> More
SQLAuthority News SQL SERVER 2008 R2 Pricing

as seen on Dot net Slackers - Search for 'Dot net Slackers'
I was recently asked question about SQL Server 2008 pricing. I have bookmarked official site here which lists the pricing.Official site: What’s New in SQL Server 2008 R2 EditionsEditionsPer Processor PricingRetailPer Server Plus CAL PricingRetailParallel Data Warehouse$57,498Not offered via Server… >>> More
Cumulative Update packages for SQL Server 2008 R2 RTM & SQL Server 2008 SP1

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Here is the news on Cumulative Update release news on SQL Server 2008 R2 RTM & SQL Server 2008 Service Pack 1. First let us go through SQL Server 2008 R2 RTM cumulative update, release consist the only hotfixes that were released in Cumulative Update 5, 6, & 7 for SQL Server 2008 SP1. Cumulative… >>> More
Installing SharePoint 2010 and PowerPivot for SharePoint on Windows 7

as seen on SQL Blog - Search for 'SQL Blog'
Many people like me want (or need) to do their business intelligence development work on a laptop. As someone who frequently speaks at various events or teaches classes on all subjects related to the Microsoft business intelligence stack, I need a way to run multiple server products on my laptop with… >>> More

Developer IT

Sql Server 2008 - Cannot connect to local default instance - Developer IT

Sql Server 2008 - Cannot connect to local default instance

sql-server-2008-r2

Related posts about sql-server-2008-r2

SQLAuthority News – SQL SERVER 2008 R2 Pricing

SQLAuthority News – SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)

SQLAuthority News SQL SERVER 2008 R2 Pricing

Cumulative Update packages for SQL Server 2008 R2 RTM & SQL Server 2008 SP1

Installing SharePoint 2010 and PowerPivot for SharePoint on Windows 7

Categories cloud