** 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
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
--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
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