[solved] plz assigning TCP/IP port SQL2008

[myk12]

ccc.JPG

how can i assign Ms-SQL2008 TCP/IP port?

i tried windows vista cmd "netstat -ano" but ,can't find 1433 port..

[MentaL]

[myk12]

---------- Post added at 09:37 PM ---------- Previous post was at 07:56 PM ----------

[/COLOR]i solved this problem.
start -Microsoft SQL Server 2008 R2 - SQL Server Configuration Manager - protocols mssqlserver -tcp/ip properties , in IPAll menu "dynamic port set 0" , next view a sql native client 10.0 menu -aliases - new aliases
name :any wany name.
servername: your intance(def.name:MSSQLSERVER)
port.no:1433
done.
run the sql server manager studio
edit Database properties
select "option"
set "compability level" ->sql 2008
make to same
Account,Gamedb and others...

and read this and setting firewalls
[url=http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/]SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )