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  SQL Server 2005 Forums  Express Edition and Compact Edition (2005)  Remote Connection Issue Please Help

Author  Topic  FluidOne Starting Member 1 Post Posted - 2011-12-02 : 13:17:21 I can't connect remotely to SQL Server These are the remote setting and the client connection string used to attempt connection. **Remote Server** Computer Name :KAY_NET Instance ID :MSSQL.1 IP Address :192.168.1.118 **Remote Server Firewall Exception** sqlserver.exe sqlbrowser.exe TCP port 1444 TCP port 2303 (Choosen Port for listening) UDP port 1434 **(SQL) 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 and Named Pipes) --SQL Server Browser-- Service Name :SQLBrowser Startup Type :Automatic Service Status :Running **(SQL) Surface Area Config for features** All feature disabled **(SQL) Server Config Manager** Network Config :Protocols (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 **Application Client Connection String** Dim CnnStr1 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' Dim CnnStr As String = "Data Source=192.168.1.118,2303;Network Library=DBMSSOCN;Initial Catalog=MySample;User ID=sa;PWD=password" 'Error Login Failed for user 'sa' **Note: I do feel that im connecting, but am not allowed access to the sql server. **Note: PING 192.168.1.118 works fine. **Note: Remote Port 2303 in listed in the sql server log file as being listened to. **Note: SSMS List The Remote Server When browsing for server Please Help, Thank you much.