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

No comments:

Post a Comment