How to create a SQL Server database in Visual Studio.NET ?

Question

Guys:

I've had difficulties creating a SQL Server database in Visual Studio.

Under "Server Explorer", I right-clicked on "Data Connections" and chose "Add Connection".

In the wizard that appeared, I selected Microsoft SQL Server and clicked continue.

In the Add Connection wizard that follows, should I enter "localhost" for Server name because I'm connecting to my local machine and IIS is already part of my Visual Studio.NET ?

Any idea ?

Thanks.

Sam Hobbs · Answer

Is it SQL Server Expresss? If so then the server name is not obvious. I think you can use .\sqlexpress for the server name for a SQL Server Express server. The . indicates the local system. For the Provider property tab try SQL Server Native Client. There are many articles in this web site that can help. Look at my Database Table Update in a DataGridView without Writing Code ; it shows one way to easily work with a table.

Senthilkumar · Answer

Hi Click on Server explorer Right click on the Data Connections Click on Create new sql server database The server name may not display in the drop down list enter manually (Try to get the sql server name from the origianl sql server connection window) Select authentication Enter the database name Click on Ok