Question Sql Server 2005 Remote Connection Problem

[FluidOne]

** Remote Server machine Settiings**
Computer Name :KAY_NET
Instance ID :MSSQL.1
Insatnce name :SQLEXPRESS
IP Address :192.168.1.118

**Surface Area Config for services and Connections**
--DataBase Engine--
Startup Type :Automatic
Service Status :Running
Server Name :SQLEXPRESS
Remote Conn Local and Remote)+(TCP/IP Only)

--I want to connect through TCP/IP Only so i disabled the SQLbrowser
--SQL Server Browser--
Service Name :SQLBrowser
Startup Type :Manual
Service Status :Stopped

**Surface Area Config for features**
All feature disabled

**SQL Server Config Manager**
Network Config rotocols (Shared Memory,TCP/IP) Enabled :VIA,Named Pipes=Disabled
Client Config :Client Protocols(Shared Memory,TCP/IP) Enabled :VIA,Named Pipes=Disabled
Aliases :No Items Listed


**Firewall Exception**
sqlserver.exe
TCP port 1444
TCP port 2303 (Choosen Port for listening)

(
TCP/IP is listening on Port 2303
Dynamic Port=""
Information confirmed through remote server log file
)

** Client Connection String with errors

'Dim CnnStr As String = "Data Source=192.168.1.118,2303;Network Library=DBMSSOCN;Initial Catalog=MySample;User ID=sa;PWD=sa"

'*Error* Login Failed for user 'sa'. User not associated with trusted sql server connection.
'There are no Passwords associated with sql server, it uses windows authentification.
'Should I be using my windows UserName & Paswword?
'Tried that didnt work!


'Dim CnnStr As String = "Data Source=192.168.1.118,2303;Network Library=DBMSSOCN;Initial Catalog=MySample;Integrated Security=True"

'*Error* Login Failed for user 'KAY_NET\Guest'

I feel that im connecting but not permitted access.
Both machines are on the same network.
Im able to ping 192.168.1.118 from 192.168.1.134 without a problem.

Any help would be greatly appreciated. Thanks

 

[Wild Bill]

--SQL Server Browser--
Service Name :SQLBrowser
Startup Type :Manual
Service Status :Stopped


If SQLBrowser stopped you can not connect to SQL Server from remote machine.