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.
   

- Advertisement -