I can connect with mixed auth and my friends from their pc can connect to my sql server too.I dunno what is wrong.I have done everything.If someone can help me with teamviewer or something...
I dont wanna be dev, just wanna make a server for me and my friends as i said.Also i am hosting it from my PC without vmware.Errors when i start the DB server:
14/10/20 16:26:50> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 01000 000004d4 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:52> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:52> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
I dont wanna be dev, just wanna make a server for me and my friends as i said.Also i am hosting it from my PC without vmware.Errors when i start the DB server:
14/10/20 16:26:50> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 01000 000004d4 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:26:50> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:27:42> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:30:06> 01000 00000043 [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:52> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:52> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 08001 00000011 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
14/10/20 16:37:54> 01000 00000035 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
Ehm, do you have SQL Server 2008 + Management Studio ?
Disable Windows Firewall or Open the Ports for it.
Firewall is off, i dont have antivirus, but i have never heard of opening ports for sql server.Should i open them ?Gonna search which ports are for sql server and yes i have microsoft sql server 2008 r2 + management studio xD, thanks buddy
Edit:I opened:
22500 - Rohan port
135 – Transact SQL Debugger
1433 – SQL Traffic
1434 – SQL Browser Traffic
2383 – SQL Analytics Traffic
4022 – SQL Broker Traffic
and still cant connect
Quote:
Originally Posted by maroki
I this guy againn but he is a trash talker, he didn't even say sorry. Poor thing..
Ignore for you.Btw you edited your post after i posted this, nice try
this not advisable but just for testing purposes, try to open all the ports from 80-xxxx. if still not working that means your still doing something wrong and not the ports problem.