sql server programming: Hello,

I'm new to SQL Server and I have 2000 and 2005Exp on the same machine. I
created a database/tables in 2000 then tried to use VC++2005 Express to
access the database... 'tried' being the operative word.

Can 2000 and 2005Exp be on the same machine?
Can 2000 be accessed using VC++2005 Express?

The error I get is 'unable to connect to SQL Server *2005*' (error 40). I
have 2000 running and 2005 stopped (???) but it only reports for 2005.

Any comments or links for simplified SQL Server configuration would be
appreciated.

TIA,
M

[quoted text, click to view]

Yes, but they will have different instance names. In other words, the
connection strings will be different.

[quoted text, click to view]

Yes.

[quoted text, click to view]

There are dozens of reasons for this message, and the cause will depend on
various things, like, is the service running, are you connecting on the
right port, are you using the right server/instance name, are you using SQL
auth or Windows auth, etc.

I'd suggest starting with Google and seeing how other people were helped
along when they provided more details. I'm not shooing you away, but
reading those threads will probably be faster than figuring out what details
to post, posting them, and waiting for further replies.

http://groups.google.com/groups/search?q=sql+server+2005+express+unable+to+connect&qt_s=Search

[quoted text, click to view]

Thanks Aaron, I figured there would not be a simple answer. Atleast I know
I'm good with the side-by-side and now I can focus on connecting. I'll sort
through the google search you provided. Much appreciated - M