Member Avatar for GLT

Hi guys!

I've never used SQL Server before and I don't want to fall at the first hurdle. SQL Server is installed and connected to the server but how do I go about actually creating the database? I am developing a web based database using dreamweaver and asp.net. Do I use visual studio to enter the sql to create the tables? or do I enter the code into SQL Server? I'm a bit confused.

I know this question is a bit simple, I just need a nudge in the right direction!

Any suggestions would be greatly appreiciated!


Thanks
GLT

  • 2 Contributors
  • 2 Replies
  • 107 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by GLT

Dani AI

Generated

As observed, SQL Server Management Studio (SSMS) is the right tool to create and manage your database; Visual Studio can help during development (Server Explorer) but SSMS is the full administrative UI. was pointing you in the right direction with the New Database option — that wizard is one easy route, and you can also create databases and tables with T-SQL if you prefer scripting.

A compact workflow to get you up and running:

  • Open SSMS and connect to the correct server instance (host or host\INSTANCE).
  • Create a database (use the GUI wizard or run a CREATE DATABASE statement).
  • Add tables either with the Table Designer or by running CREATE TABLE scripts.
  • Create a SQL login or map a Windows account to the database and grant only the permissions the web app needs (avoid using sa).
  • Put the connection string into your ASP.NET web.config and test the connection from Visual Studio or a tiny test page.

A typical web.config connectionStrings snippet:

<connectionStrings>
  <add name="MyDb" connectionString="Server=SERVERNAME;Database=MyDatabase;Integrated Security=True;" providerName="System.Data.SqlClient" />
  <add name="MyDbSqlAuth" connectionString="Server=SERVERNAME;Database=MyDatabase;User Id=myuser;Password=mypassword;" providerName="System.Data.SqlClient" />
</connectionStrings>

If SSMS cannot see the instance or you can’t connect, check that the SQL Server service is running, enable TCP/IP for the instance and open port 1433 if remote access is needed, and start SQL Server Browser for named instances. For step-by-step Microsoft guidance see Create a database and ADO.NET connection strings (link). For hosting, follow your host’s control panel instructions rather than exposing the server directly.

Recommended Answers

All 2 Replies

Member Avatar for greeny_1984

hi,
u said u have installed sql in u r computer.so go to
start->programs->sql sever->enterprise -> server group-> local->click on +->right click on data bases u will get new database-.a wizard will open->create a data base.
if u still have google it .

Member Avatar for GLT

yeah i thought a wizard or something would come up but i have nothing!

when i go start > programs > Microsoft SQL Server 2005, my options are:

>Analysis Services
>Configuration Tools
>Documentation and Tutorials
>Performance Tools
>SQL Server Business Intelligence Development Studio (which brings up Visual Studio)
>SQL Server Management Studio

I know this may be a really simple question but I really dont know how to get started!

Im probably being stumped by something silly!!!

GLT

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.