SQL Server 2005 Managment Studio Express - MS SQL Server

[TheZenift]

hi bagul i have installed windows sql server 2005 but it installed successfully and i cant able to see any key and pls tell me how to create a server i tried to chec the services section under control panel but i could not able to locat any name with (MSSQLSERVER) pls guide me i am totally new to this platform thanks a lot in advance

[baghul]

@TheZenift here are some ideas: 1. Start - Run - Type this "services.msc" 2. Ctrl Panel - Admin Tools - Services Browse for the following Actual services should read SQL Server (MSSQLSERVER) Good luck -Another option is to goto Programs SQL server - configuration tools - sql server config manager After you get there, select SQL server services go to right window and select Start The computer name can be just . (period) or local host Good luck

[eeezb]

i can't find MSSQLServer in the Services. I don't have Configuration Manager! HELP!

[baghul]

@eeezb Two ways to get to the Services tab:

1. Start - Run - services.msc

2. Ctrl Panel - Admin Tools - Services

Actual services should read SQL Server (MSSQLSERVER)

Good luck

[Halwsa911]

i created new server , but i cannot sww the green icon and it doesn't connect :( why ? what should i do ? i use 2005

[baghul]

@Halwsa911 Its possible that you do not have SQL Services running.Here is what I would suggest

Goto Configuration tools, then Configuration Manager

Next locate the MSSQLServer, right click and Start

Lmk how that goes!! ;-)

[kristjan505]

WOOW U ARE LEGEND MAN TNX VERY MUCH ILL SUBSCRIBE YA!!

[baghul]

@kristjan505 You mean a legend like Clint Eastwood!! lol thx

[dipubd3]

great vids



[cloudstrife5623]

hey i doesn't show the green thing its just white.

[VigilianceAurelious]

I have a problem...

[Microsoft SQL Management Studio Express]

This version of Microsoft SQL Server Management Express can be only used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Expres.Co­nnectionDlg)

[baghul]

@VigilianceAurelious Hi, are u trying to connect to sql 2005 and sql 2008?

[VigilianceAurelious]

@baghul Oh, I forgot to let you know, hmmm I've already fixed it

What I've done is that when you're going to register instead of putting " computername\SQLEXPRESS "

I jus registered " computername " then it worked out xD

Thanks anyways :)

[baghul]

@VigilianceAurelious Sounds good. You r welcome!

[xxelocinxx]

@baghul im having this problem too. help pls

[baghul]

@xxelocinxx Use this from the other guy:

I jus registered " computername " then it worked out xD

[SmartGirl27]

Which way do you prefer to create databases?? method 1 or 2?

[baghul]

@SmartGirl27 Method 1 of course!! ;-))

[yen831]

cannot connect to server name

[baghul]

@yen831 Did you try connecting with . or localhost?

[ellie3637]

Oh my god! I don't have mssqlserver under services in the Admin Tool Wha does that mean? My sql 2005 express is running and i have win xp.

[baghul]

@ellie3637 ok so try to Google this and u shall find what you are looking for!

;-))

"MSSQL$SQLEXPRESS service"

[ellie3637]

Hi all. When I follow these instructions and register a database, it doesn't find a connection, the little circle doesn' turn green. What am i missing? Can anyone help?

[baghul]

@ellie3637 ok here are some ideas

-Under Admin tools - Services. Make sure MSSQLSERVER service is running

-U can also get to the above by using services.msc from Run Menu

-Try connecting with . (just period) or the word localhost

lmk if this helps

;-))

[JSuavinson]

Nice video, thanks

[baghul]

@JSuavinson You are very welcome!

[Ukokws]

I don't understand english... speak spanish man!!... =D gracias u.U

[baghul]

@Ukokws Estudiante Espaneol Senior!! ;-)

[cfhasib]

Indian Accent.... No good ...skipping video

[baghul]

@cfhasib Thank you for the positive feedback and btw wrong country!! So try again.

;-)

[nishajudy]

thk u sir . it was very useful

[baghul]

@nishajudy Kool, Check out more sql info at slackerdba dot blogspot dot com

;-)

[ankitanshu11]

Nice Tutorial.. " Not the fastest machine" :-)

[baghul]

@ankitanshu11 Yeah no doubt I needed to upgrade! ;-)

[jwahh]

Thanks to you, Baghul. Good job.

[baghul]

@jwahh Thank you Sir!

[baghul]

@jwahh Thx buddy, sorry for the late comment

[luckyvidoes]

Wonderful man! It reminds me of my own videos! :o)

[baghul]

@luckyvidoes Thank you sir, glad you like

[ggbustatube]

Wonderful. Thanks a million. I am a brand new SQL Server DBA after having been a DB2 z/OS DBA for years.

FYI, I am using Vista 64 bit and had no problems.

[baghul]

@ggbustatube Welcome to SQL Server, we have more FREE videos at our site so feel free to check them out. Thx for the comments

[ilovcleavageverymuch]

for those who got problems....

in vista or window7

just do this.....

right click on the icon and select run as admin...

that's it...

chao.....!!!

[baghul]

@ilovcleavageverymuch Thank you for tthe suggestion.

[RichinGunz]

lol i got a problem >.> i cant connect to the server

[baghul]

Is the SQL Service running. You can check that under Services (Ctrl Panel). If so use . (period) or machine name to connect to it. Cheers

[RichinGunz]

TITLE: Connect to Server

Cannot connect to ..

ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

[RichinGunz]

o and im running on windows vista i have gotten the sql to work before

but i uninstalled it then re installed it

[baghul]

Hmm, not sure. check all the sql services, accounts assigned to them, also check for remote connection under configuration manager.

[RichinGunz]

@baghul

nvm i fixed it i had to fully remove it and reinstalled

[mccathal2008]

How can i create a server in the first place?

[baghul]

Not sure what you mean. SQL server actually is a service that runs on a physical box. You will need to have a machine with the right OS on it b4 you can run SQL. Hope that helps.

[bboova]

Thanks for the help.

That was great.

[baghul]

Thank you for all your wonderful comment

Here are two of my sites where I have videos on other topics:

learningcomputer dot

sqlserver2008tutorial dot

Kash

[Ap2dayDOTnet]

Hey Bhagul,

Its awesome! Can you create videos like these for trigers, Keys and etc.. so that it ll be very help full to all

[baghul]

server name is usually the name of the machine or try typind just . (period) or localhost.

Kash

[alcione1984]

Thank you!

Muito Obrigado MESMO!!!

seu video me ajudou muito!

Thank u very much, that was really helpfull!

[LDaltonIT]

This was a very good video.

I would advise cutting out bits when you are waiting for it to load on this video.

Im used to sql 2003 and taking a look at 2005 to see what its like.

[baghul]

you are very welcome, more videos at our link next to the description

[ZEBBI9]

Man !! This is awsome! Thank you. I have just installed VS2008 SP1 it came with SQLEE2005 without SQL Server 2005 Managment Studio Express, so I went ahead and downloaded it from Microsoft website. Do I need to uninstall SQLEE2005 to install SQLEE2008 with tool, or will it just upgrade it automatically? Thank you! How do I go about that , thank you!

[Ugandangirl]

Very helpful

[baghul]

If you launch Surface Area Configuration, there is an option for turning on remote connections.

[punxz18]

I have an error how do i fix this?

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

need your reply ASAP Thanks

[wolfwingx1]

I got the same problem :s

[jcb871]

very useful... Thanx :)

[baghul]

Thank you for your response

[citistar369]

This video was helpful for me.The explanation is clear baghul.

[zifikos]

That was very helpful, thank you!

[helenBeaton]

Thankyou for video,

Iv been looking for a quick learner vid.

Im keeping this to my fav's as I will need to look up again.

Thankyou baghul

[baghul]

Thank you for your response

[imranzama]

Thanx, it was very helpful for a beginner like me, nice explanation. great job,

[baghul]

Thank you Imran!

[NajanJan]

thanks, you explained well but when i make my screen full, it's not that clear so I have to watch it in the small screen which is not that clear but thanks I hope you have more videos..

[baghul]

Thank you for your response