Groups | Blog | Home
all groups > sql server connect > august 2007 >

sql server connect : Starter kit error when using SQL Server Dev instead of Express.


EGON
8/21/2007 2:22:03 PM
Hi!

I have downloaded Club Website Starter Kit from MS. I don't have SQL Server
Express but I do have SQL Server 2005 Development.

I have changed the name of the DB server in the connection string, but
nothing else in the string.

Remote connections is aloud and port is set to 1433.

Well, when I try to run I get:

An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
Specified)

My question is:
- Shouldn't it be possible to use Development instead of Express version?
- If it should be ok, what adjustments do I have to do?

Ps. Sorry if this is wrong newsgroup, but I couldn't find any better.
Please, help me out!

Regards
William Vaughn
8/21/2007 2:34:26 PM
Start with my blog. There are a couple of whitepapers there that discuss
connecting. If that does not help, come back here.


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]
AddThis Social Bookmark Button