Basic SQL Setup Question - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Basic SQL Setup Question

Author

Topic

Peter_APIIT
Starting Member

11 Posts

Posted - 2008-02-26 : 21:02:35

Hello all expert databse administrator, i truly new to MS SQL server.

I have installed MS SQL Server 2005 and SQL Server Management Studio express edition.

An error occurred mentioned i cannot connect the sql server.
I wonder can i install Full edition of sql server and express edition of management studio.

TITLE: Connect to Server
------------------------------

Cannot connect to HOME-C5CCA7A162\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10061&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Server Name = HOME-C5CCA7A162\SQLEXPRESS

This is my error when i try connecting to the server.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-26 : 21:11:33

Why don't install sql client tools if you installed sql2k5 server? SSMS express is for sql2k5 express. By the way, ensure sql service is running.

Peter_APIIT
Starting Member

11 Posts

Posted - 2008-02-28 : 01:19:57

How to ensure SQL server is running ?

As you said, SSMS express is for SQL Express 2005.

The, SQL client tool is for SQL 2005 full edition.

Am i correct ?

A billion thanks for your help. You all are really a kind man.

ratheeshknair
Posting Yak Master

129 Posts

Posted - 2008-02-28 : 03:34:23

check your services for that ...take the RUN type services.msc and check whether the sql server service is started.

RKNAIR

Peter_APIIT
Starting Member

11 Posts

Posted - 2008-02-28 : 08:46:29

I have check that the sql server service is running.

Where can i download SQL client tool for my SQL Server 2005 ?

After downloading, i need to create databse from that and connect to it using vb.net.

Thanks for oyur help

Peter_APIIT
Starting Member

11 Posts

Posted - 2008-02-28 : 08:55:23

I have installed the SSMS but someone say this is not for MS SQL 2005. THen which tools is for SQL server 2005.

Peter_APIIT
Starting Member

11 Posts

Posted - 2008-02-28 : 09:06:39

I can connect to SQL but it is a HOME-C5CCA7A162\SQLEXPRESS.
Is this correct ?

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2008-02-28 : 11:40:22

Thats the computer name where you have sql server installed.. and where you are connecting to.

Peter_APIIT
Starting Member

11 Posts

Posted - 2008-02-29 : 05:32:04

How can i check my connect string in my computer ?

How to create table ? Right click new databse is it ?

I would like to create a databse, then insert, update, delete record from the databse.

Thanks for your help.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-02-29 : 06:51:46

first go through the basic websites for learning basic SQL
like
www.w3schools.com

Vinod
Even you learn 1%, Learn it with 100% confidence.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-01 : 21:15:20

>> it is a HOME-C5CCA7A162\SQLEXPRESS

Igt soiunds like sql2k5 express.

Peter_APIIT
Starting Member

11 Posts

Posted - 2008-03-05 : 20:41:27

Please show some example.
Thanks.

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2008-03-05 : 21:05:38

Examples of what?

Poor planning on your part does not constitute an emergency on my part.

Peter_APIIT
Starting Member

11 Posts

Posted - 2008-03-10 : 04:58:34

I have this code but cannot connect to the databse.

Imports System
Imports System.Data
Imports System.Data.SqlClient

Public Class Admin_Login

Private Sub Admin_Login_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim mysqlconnection As SqlConnection
Dim myfirstsqlcommand As SqlCommand
Dim mysecondsqlcommand As SqlCommand

Dim mysqlreaqder As SqlDataReader

'Dim mysqlconnectionDataAdapter As SqlDataAdapter

mysqlconnection = New SqlConnection("server=HOME-C5CCA7A162\SQLEXPRESS;Trusted_Connection=yes;database=VCD")

If mysqlconnection.State = ConnectionState.Closed Then
Try
mysqlconnection.Open()

myfirstsqlcommand = New SqlCommand("Insert into Admin Table values peter, 1234, _mysqlconnection")

mysecondsqlcommand = New SqlCommand("select * from Admin Table")

mysqlreaqder = mysecondsqlcommand.ExecuteReader()

While mysqlreaqder.Read
MessageBox.Show("New Row Inserted")

End While

Me.Hide()
Main_Menu.Show()

Catch ex As Exception
MessageBox.Show("Cannot connect to database")
End Try

If mysqlconnection.State = ConnectionState.Connecting Then
mysqlconnection.Close()
End If
Else
Me.Close()
End If
End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Me.Close()
End Sub

Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
Dim userName As String

userName = TextBox1.Text

End Sub

Private Sub TextBox2_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox2.TextChanged
Dim password As String

password = TextBox2.Text

End Sub
End Class

The exception is been throw and i have a messagebox to indicate a connection fail.

Peter_APIIT
Starting Member

11 Posts

Posted - 2008-03-10 : 05:03:15

Where to download sql clien tool.

Thats mean if i using sql sevrer 2005, i must use sql client tool
and if i sue sql server 2005 express, then i must use ssms.

Is it true ?

Peter_APIIT
Starting Member

11 Posts

Posted - 2008-03-10 : 05:17:57

Do i need this SQLServer2005_ADOMD application since i use ado.net

Peter_APIIT
Starting Member

11 Posts

Posted - 2008-03-10 : 05:20:22

or some other ADO.NET provider software install ?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-10 : 22:46:22

Sql2k5 comes with client tools, sql2k5 express needs ssmse from Microsoft.

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2008-03-11 : 15:31:46

quote:
Originally posted by Peter_APIIT

Where to download sql clien tool.

Thats mean if i using sql sevrer 2005, i must use sql client tool
and if i sue sql server 2005 express, then i must use ssms.

Is it true ?

Install SQL Server 2005 Client Tools from the same CD/DVD that you installed SQL Server 2005 from; it's not a download.

If you're not going to read and respond to the answers, please stop asking questions.

Please re-read the answers you have already gotten, and answer the questions that people have asked you. You keep ignoring them and asking more questions, instead of providing the answers to people who have asked trying to help you.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources