Can't Connect to Developer Edition SQL Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Can't Connect to Developer Edition SQL Server

Author

Topic

mchadwell
Starting Member

4 Posts

Posted - 2009-11-27 : 10:43:47

I am trying to use SQL Server 2008 after upgrading from 2005. I had 2005 working by connecting to localhost with Windows Authentication. Now I've upgraded and I can no longer connect. I am running SQL Server 2008 sp1. Although the server (named DEVELOPMENT) is running, it does not show up in the list of local databases. I've tried connecting to ., localhost, Michael-PC, and (local). Please see pictures below. Any ideas?

Thanks!

support.sql
Starting Member

15 Posts

Posted - 2009-11-29 : 19:11:31

Verify your network setting to accept remote connections, verify SQL Area Surface setting and enable remote connections.

SNM

Try Free Microsoft SQL Server Data Collector & Performance Monitor.

http://www.analyticsperformance.com

@nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

mchadwell
Starting Member

4 Posts

Posted - 2009-11-30 : 14:15:05

Can you be a little more specific? I am using Windows 7 and I disabled the firewall completely with no luck. How do I verify SQL Area Surface settings and enable remote connections?

Thanks!

mchadwell
Starting Member

4 Posts

Posted - 2009-11-30 : 21:11:11

It looks like they removed Surface Area support in 2008. When I browse for servers, the only one that shows up is Michael-PC under Integration Services. Task manager shows that the server is running. The account I am using is an administrative account, so I don't see how there can be any more security issues.

mchadwell
Starting Member

4 Posts

Posted - 2009-11-30 : 21:15:01

Wow. I don't know how I did it, but I got this database to show up under network servers even though it is running on my local PC...

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 2009-12-01 : 14:59:33

localhost is a network. even if it is a local host.

savior faire
Posting Yak Master

194 Posts

Posted - 2009-12-04 : 18:02:22

Note that in the "Browse for Servers" dialogue, that database, MICHEAL-PC, is under Integration Services and not the database engine.

Talk sense to a fool and he calls you foolish.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-04 : 22:42:24

Since you named the instance "development", you need to specify that when connecting. Use HostName\Development, where HostName is your host's name. HostName may possibly be MICHEAL-PC, but to be sure run hostname command from a cmd window.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-12-04 : 22:58:09

Hi

HostName\Development

HostName - Machine name
Development - Instance name

Example

rajdaksha\sqlexpress

-------------------------
R...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources