Home Dashboard Directory Help
Search

Create SQL Database by BobbyBB


Status: 

Closed
 as By Design Help for as By Design


0
0
Sign in
to vote
Type: Bug
ID: 427760
Opened: 3/27/2009 2:03:13 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

I am using Visual Basic 2008 Express and SQL Server 2008 Express. In Visual Basic I cannot create a SQL Server Database in Database Explorer, it is not enabled. Please Help
Details
Sign in to post a comment.
Posted by Microsoft on 4/29/2009 at 11:21 AM
The reported issue is actually by design, but Express users do have a way to create local databases.

The "Create New SQL Server Database" context menu option is intended for creating a new database on a remote database server. On Express SKUs (except for Visual Web Developer), remote database connections are not suppored, and thus this option is disabled.

On Express as well as other SKUs, users can create a local database by:
1. In Database/Server Explorer, right click Data Connections node, and choose Add Connection
2. Choose or Change Data Source: Microsoft SQL Server Database File
3. On the Add Connection dialog, specify a new database file name, and click OK.

Thanks,
Visual Studio Professional Tooling Team
Posted by Microsoft on 4/29/2009 at 11:19 AM
The reported issue is actually by design, but Express users do have a way to create local databases.

The "Create New SQL Server Database" context menu option is intended for creating a new database on a remote database server. On Express SKUs (except for Visual Web Developer), remote database connections are not suppored, and thus this option is disabled.

On Express as well as other SKUs, users can create a local database by:
1. In Database/Server Explorer, right click Data Connections node, and choose Add Connection
2. Choose or Change Data Source: Microsoft SQL Server Database File
3. On the Add Connection dialog, specify a new database file name, and click OK.

Thanks,
Visual Studio Professional Tooling Team
Posted by Microsoft on 3/29/2009 at 11:55 PM
Thanks for reporting this issue. Could you take a screenshot of this issue to better illustrate this issue.

How to create a screenshot
1. When the problem occurred, please press PrtScr key on the keyboard(the key right of F12).
2. Then click start and then click run, type mspaint and then press Enter.
3. In the Microsoft Paint program, please click edit and then click paste.
4. Save this file to .jpeg format
Sign in to post a workaround.