470,620 Members | 1,728 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,620 developers. It's quick & easy.

Can't connect to SQL Server(SQL Express) in VS 2005


In SQL Server Configuration Manager I apparantly have a server named
SQL Server(SQL Express) running - however, in VS 2005 when I try to
'add conection' (right click in server explorer) I cant see it- I
would like to see it so I can create a new SQL server database.

Any help much appreciated- trying to learn web programming using
vb.net, asp, html, vbscript and SQL server.

D

Feb 9 '07 #1
10 5369


<da*********@googlemail.comwrote in message
news:11*********************@v45g2000cwv.googlegro ups.com...
>
In SQL Server Configuration Manager I apparantly have a server named
SQL Server(SQL Express) running - however, in VS 2005 when I try to
'add conection' (right click in server explorer) I cant see it- I
would like to see it so I can create a new SQL server database.

Any help much appreciated- trying to learn web programming using
vb.net, asp, html, vbscript and SQL server.
Type

(local)\sqlexpress

in the "Server name" box on the "Add Connection" dialog.

David

Feb 9 '07 #2
Check if SQL Services are running.

--

Tiago Salgado

http://weblogs.pontonetpt.com/tiagosalgado
http://www.foruns.org
http://www.portugal-a-programar.org
http://www.revista-programar.info

"David Browne" <davidbaxterbrowne no potted me**@hotmail.comwrote in
message news:%2****************@TK2MSFTNGP02.phx.gbl...
>

<da*********@googlemail.comwrote in message
news:11*********************@v45g2000cwv.googlegro ups.com...
>>
In SQL Server Configuration Manager I apparantly have a server named
SQL Server(SQL Express) running - however, in VS 2005 when I try to
'add conection' (right click in server explorer) I cant see it- I
would like to see it so I can create a new SQL server database.

Any help much appreciated- trying to learn web programming using
vb.net, asp, html, vbscript and SQL server.

Type

(local)\sqlexpress

in the "Server name" box on the "Add Connection" dialog.

David
Feb 9 '07 #3
sorry bud

Microsoft killed VB so you WON'T be using VbScript to say the least :)

I do not know why your SQL Server won't work.
my laptop won't install SQL 2005 Express because those dipshits didn't
think that it was important to include support for transmeta

kinda laughable in my opinion

I mean; the Xbox portable is built using Transmeta chips.. right??

Feb 10 '07 #4
sorry bud
did you really name your server 'sql server'?

I would really avoid putting a space in the machine name; I would try
127.0.0.1\sqlexpress instead

Microsoft killed VB so you WON'T be using VbScript to say the least :)

I do not know why your SQL Server won't work.
my laptop won't install SQL 2005 Express because those dipshits didn't
think that it was important to include support for transmeta

kinda laughable in my opinion

I mean; the Xbox portable is built using Transmeta chips.. right??

Feb 10 '07 #5
So MS is supposed to support YOUR laptop? And you are??? Oh, yeah, Aaron
Kempf... that's right.... I've heard of you... ain't you the fellow that
programs in Access, but can't stand using a standard Access database format?

Bruce

"punjab_tom" <pu********@hotmail.comwrote in message
news:11**********************@m58g2000cwm.googlegr oups.com...
sorry bud

Microsoft killed VB so you WON'T be using VbScript to say the least :)

I do not know why your SQL Server won't work.
my laptop won't install SQL 2005 Express because those dipshits didn't
think that it was important to include support for transmeta

kinda laughable in my opinion

I mean; the Xbox portable is built using Transmeta chips.. right??

Feb 10 '07 #6
Hmmm...
Microsoft killed VB so you WON'T be using VbScript to say the least :)
When did they kill it Aaron???? When they fired you??? Or was it when you
figured out that you can't tell the difference between VB Classic and
VB.Net?
Feb 10 '07 #7
Bruce,

I don't want to be critical, but you actually think he *programs* in
Access? All he does is link up datatables and tell his users to write their
own queries. Have you started drinking yet? ;-)

Robin S.
King of Russia
---------------------------------------------------
"Bruce W. Darby" <kr******@atcomcast.netwrote in message
news:F6******************************@comcast.com. ..
So MS is supposed to support YOUR laptop? And you are??? Oh, yeah, Aaron
Kempf... that's right.... I've heard of you... ain't you the fellow that
programs in Access, but can't stand using a standard Access database
format?

Bruce

"punjab_tom" <pu********@hotmail.comwrote in message
news:11**********************@m58g2000cwm.googlegr oups.com...
>sorry bud

Microsoft killed VB so you WON'T be using VbScript to say the least :)

I do not know why your SQL Server won't work.
my laptop won't install SQL 2005 Express because those dipshits didn't
think that it was important to include support for transmeta

kinda laughable in my opinion

I mean; the Xbox portable is built using Transmeta chips.. right??


Feb 10 '07 #8

"Bruce W. Darby" <kr******@atcomcast.netwrote in message
news:fM******************************@comcast.com. ..
Hmmm...
>Microsoft killed VB so you WON'T be using VbScript to say the least :)

When did they kill it Aaron???? When they fired you??? Or was it when you
figured out that you can't tell the difference between VB Classic and
VB.Net?

It was when they figured out he couldn't tell the difference between VB6,
VBA, and VBScript!

ROFL.

Robin S.
(King of Russia)
Feb 10 '07 #9
His words, not mine. :)
And I'm thinking seriously of doing so. LOL

"RobinS" <Ro****@NoSpam.yah.nonewrote in message
news:F_******************************@comcast.com. ..
Bruce,

I don't want to be critical, but you actually think he *programs* in
Access? All he does is link up datatables and tell his users to write
their own queries. Have you started drinking yet? ;-)

Robin S.
King of Russia
---------------------------------------------------
"Bruce W. Darby" <kr******@atcomcast.netwrote in message
news:F6******************************@comcast.com. ..
>So MS is supposed to support YOUR laptop? And you are??? Oh, yeah, Aaron
Kempf... that's right.... I've heard of you... ain't you the fellow that
programs in Access, but can't stand using a standard Access database
format?

Bruce

"punjab_tom" <pu********@hotmail.comwrote in message
news:11**********************@m58g2000cwm.googleg roups.com...
>>sorry bud

Microsoft killed VB so you WON'T be using VbScript to say the least :)

I do not know why your SQL Server won't work.
my laptop won't install SQL 2005 Express because those dipshits didn't
think that it was important to include support for transmeta

kinda laughable in my opinion

I mean; the Xbox portable is built using Transmeta chips.. right??



Feb 10 '07 #10
On Feb 9, 2:11 pm, "David Browne" <davidbaxterbrowne no potted
m...@hotmail.comwrote:
<danofwea...@googlemail.comwrote in message

news:11*********************@v45g2000cwv.googlegro ups.com...
In SQL Server Configuration Manager I apparantly have a server named
SQL Server(SQL Express) running - however, in VS 2005 when I try to
'add conection' (right click in server explorer) I cant see it- I
would like to see it so I can create a new SQL server database.
Any help much appreciated- trying to learn web programming using
vb.net, asp, html, vbscript and SQL server.

Type

(local)\sqlexpress

in the "Server name" box on the "Add Connection" dialog.

David

Thanks all for an entertaining and (sometimes informative!-)
discussion.
..\SQLEXPRESS in add data (after right clicking server explorer for new
connection) worked a treat.

Thanks again,

Dan

Feb 11 '07 #11

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Chris | last post: by
6 posts views Thread by Grey Alien | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.