Showing posts with label apparently. Show all posts
Showing posts with label apparently. Show all posts

Friday, February 24, 2012

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

In SQL Server Configuration Manager I apparently have a server named
SQL Server(SQL Express) running - however, in VS 2005 when I try to
'add connection' (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.

DDanWeaver (danofweaver@.googlemail.com) writes:

Quote:

Originally Posted by

In SQL Server Configuration Manager I apparently have a server named
SQL Server(SQL Express) running - however, in VS 2005 when I try to
'add connection' (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.


Try using .\SQLEXPRESS for the server name.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Feb 9, 6:16 pm, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

DanWeaver (danofwea...@.googlemail.com) writes:

Quote:

Originally Posted by

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


>

Quote:

Originally Posted by

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


>
Try using .\SQLEXPRESS for the server name.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


I tried it- It worked- you rock! Thanks so much.

Dan