sql server express connection? -- sql server msde

sql server msde : sql server express connection?

Brent
2/9/2006 11:23:04 AM

I have just installed VS2005 along with sql server express. I couldn't
connect from vs2005 to express so i specifically enabled tcp/ip and started
the sql browser service. I then tried to connect. Still had problems. So i
went and enabled named piples. I tried again and it still failed. I have
restarted the sql server service every time i made a change. The error i get
is:
"an error has occurred whil establishing a connection to sql server. when
connecting to sql server 2005, this failure may be caused under the default
settings sql server does not allow remote connections."

I have of course taken care of the remote connection problem even though im
really connecting locally to my machine. What else do i need to do to get
this working?

thanks,
Brent

Roger Wolter[MSFT]
2/9/2006 2:51:27 PM

You can connect without specifying the instance name if the instance is
installed as the default instance on the server. This applies to both SQL
Express and full SQL Server. You installed SQL Express as a named instance
so you need to specify the name. This would be the same if you had
installed Enterprise Edition as a named instance.

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

[quoted text, click to view]

Brent
2/9/2006 3:04:36 PM

I think i found the problem:
http://support.microsoft.com/default.aspx?scid=kb;en-us;896613

I will try this to see if it fixes my connection problems.

[quoted text, click to view]

Brent
2/9/2006 3:19:14 PM

Ok figured it out FINALLY. You have to do the following to connect:
MachineName\SQLEXPRESS. Kind of wierd because in the past i could just
specify the machine name without having to specifically tell which instance
of sql server i want to connect to. In fact, i can do that with the full
version of Sql Server 2005.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server msde

home · blog · groups

Questions? Comments? Contact the dn