ssmse will not connect to ssexpress

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 2005 Forums

Express Edition and Compact Edition (2005)

ssmse will not connect to ssexpress

Author

Topic

zhoover
Starting Member

1 Post

Posted - 2006-02-18 : 17:44:45

I have installed SQL Server 2k5 Express on my local machine. I also installed SSMSE on my local machine. When I try to launch SSMSE and connect to the SSExpress I get an error indicating that SSExpress is not configured to accept remote connections. Huh? Everything is local...I'm confused and frustrated. Any help is profusely appreciated.

Thank you

Zach

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-02-20 : 15:31:36

What connection string are you using?

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine + SQL Express
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

mikewa
Microsoft SQL Server Product Team

84 Posts

Posted - 2006-02-21 : 03:33:13

Here are a few things to try:

First, connect using SQLCmd to see if that works, open a command prompt and type:

SQLCmd -E -L .\sqlexpress

This assumes you've installed to the default instance name and are using Windows Authentication. If this works, try SSMSE again and see if it works.

Check SQL Configuration Manager to see if you have any Aliases set up, I've found problems if you try to create an Alias that is the the same name as the normal local name, for example, if you create an actual Alias for ".\sqlexpress" that might cause problems.

If you still can't connect, check out the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\LastConnect

and look at the Key with the name that you are tyring to connect to. Grab the value and post it back here so we can take a look at it.

Regards,
Mike Wachal
SQL Express

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources