SQL (need help of EXperts ^^)

shawwwa · 07/26/2011, 09:53

Hi every one i haved follow the guide of step by step exacly and i get those errores (it's happen when i enabled (TCP\IP) i can't log into (SQL Server Mangment Studio ) and dont tell me i have made somthing wrong i follow every step exacly and i have try the both of verson 64x and 32x here is the pic :

as you see all stoped i dont know why i think that happen when i turn TCP\IP)

(that's the error when i try to log into SQL Server mangment studio)

(and this the error when i open PrincessAuroraServer)

any help or tip well be greet and ty.

korrex · 07/26/2011, 13:12

Reboot computer then try again, exactly as it says in the tutorial.

shawwwa · 07/26/2011, 13:32

i allredy reboot my computr and did every thing in the tutorial

VladimirR · 07/26/2011, 16:12

Hi,

seems like the "SQL Server (SQLEXPRESS)" service did not start when the system started up (it's set to start automatically, so it should have)

try to start it by hand (either from the sql server configuration manager, or from services.msc), and check if there's an error message (either shown to you, or in the system's event log)

until you solve this, nothing (nor princessauroraserver neither the ssms) will be able to connect to the database

also make sure, you're only running one database instance on port 1433, and nothing else
run "netstat -nap tcp" to see if anything already using tcp port 1433
if so, use some other port (both in your sql config, and in the server's opt files)
this is important, because only one service can listen on a single port, and if you assigned tcp port 1433 to multiple services, the first one takes it, and the other services won't be able to function (or even start in some cases) properly

regards,
VladimirR

p.s.: can someone tell me, why do people think restarting the computer magically solves everything?

shawwwa · 07/26/2011, 18:51

when i disable TCP\IP the SQL server mangment studio work and when enable it nothing work ?!!!

i'm using win7 64x labtop does it work on it blus i tryed the both of v 64x and 32x SQL

or do i need to use win xp sp2 32x ?

VladimirR · 07/26/2011, 19:32

Quote:

Originally Posted by shawwwa

when i disable TCP\IP the SQL server mangment studio work and when enable it nothing work ?!!!

i'm using win7 64x labtop does it work on it blus i tryed the both of v 64x and 32x SQL

or do i need to use win xp sp2 32x ?

Hi,

from my previous post

Quote:

Originally Posted by VladimirR

also make sure, you're only running one database instance on port 1433, and nothing else
run "netstat -nap tcp" to see if anything already using tcp port 1433
if so, use some other port (both in your sql config, and in the server's opt files)
this is important, because only one service can listen on a single port, and if you assigned tcp port 1433 to multiple services, the first one takes it, and the other services won't be able to function (or even start in some cases) properly

copy and paste here the output of the "netstat -nabp tcp" command, and/or try setting the tcp port (for example) to 1435 in the SSMS, and also in your .opt files

regards,
VladimirR

shawwwa · 07/26/2011, 20:13

ok i well try 1st on win xp i hop it's work then if it's not i well post every thing i do and what you ask so you knwo where is the problome

diaa yousef · 07/26/2011, 23:18

according to this image

sql server (SQLExpress)
isn't enabled so you have to right click on it and press start

I hope that helps you

shawwwa · 07/27/2011, 00:49

thx all for ur help i and yes VladimirR you were right the port was allredy in use i have change it and work perfect and i opend my p.server ^^