well...im tired...of finding...i searched for clan server agent fixed...tried a lot..but still i get 999 pings in either of server...how to fix that any 1 help...plzz dont give useless answers..plzz help me.. im in trouble
well...im tired...of finding...i searched for clan server agent fixed...tried a lot..but still i get 999 pings in either of server...how to fix that any 1 help...plzz dont give useless answers..plzz help me.. im in trouble
becouse you need MatchAgent.exe online :roflOriginally Posted by pavan33
dude i said na i keep all online..but still get 999 ping only 1 server works..
noobs just dont try 2 servers at once for now unless you have a dedicated server. Too many bugs in the released ones.
wesmann atlest can u tell me how to use remote sql...i tried but its showing sum error..and i also enabled remote connections in sql....
idk how to do remote sql, never have tried, and probably never will have to.
How to Setup Remote Sql Server
Configure MS SQL Server 2005 Remote Access ( mixed mode )
MS SQL Server 2005 remote access configuration is different from MS SQL Server 2000. Remote access to MS SQL Server 2005 with user and password is required and necessary for any database applications. If MS SQL Server 2005 is originally configured for windows authentication, configuration for remote access ( mixed mode or SQL Server authentication ) needs a little more extra work to get it done.
Here is how to get this done.
1. Configuration in SQL Server Management Studio
Click “All Programs” -> Click “Microsoft SQL Server 2005” -> click “Microsoft SQL Server Management Studio”
Log in to SQL Server 2005 with windows authentication or sa user;
Highlight the server and right click “Properties”;
Highlight “Security” -> Under “Server authentication”, choose “SQL Server and Windows authentication mode”;
Highlight “Connections” -> Under “Remote server connections”, choose “Allow remote connections to this server”;
Click OK to save the settings.
2. Configuration in SQL Server Surface Area Configuration
Click “All Programs” -> Click “Microsoft SQL Server 2005” -> click “Configuration Tools” -> click “SQL Server 2005 Surface Area Configuration”
Click “Surface Area Configuration for Services and Connections” -> click “MSSQLSERVER” -> click “Database engine” -> click “Remote connections ” -> Under “Local and remote connections”, choose “Using TCP/IP only” or other protocols.
Click “Apply” to save the settings.
3. Seting Tcp/ip
Click “All Programs” -> Click “Microsoft SQL Server 2005” -> click “Configuration Tools” -> click “ SQL Server Configuration Manager
When Opened go to SQL Server 2005 Network Configurations Then Protocols For SQLEXPRESS
Make Sure Tcp/ip Is Enable And Shared Memory Which Should Always Be Enable Then Open Tcp Ip Look At This Picture
4. Stop SQL server and restart SQL server
Use “SQL Server Management Studio” or Services in Control Panel to stop SQL Server and then restart the SQL Server. This process is used to initialize the change settings.
5. Do Not Forget To Portforward 1433 Have Nice Day
7. log in with Sa And ur Password when “Authentication” is “SQL Server authentication” under local SQL server or under remote SQL server.
[quote=lighter123;4832586]How to Setup Remote Sql Server
Configure MS SQL Server 2005 Remote Access ( mixed mode )
MS SQL Server 2005 remote access configuration is different from MS SQL Server 2000. Remote access to MS SQL Server 2005 with user and password is required and necessary for any database applications. If MS SQL Server 2005 is originally configured for windows authentication, configuration for remote access ( mixed mode or SQL Server authentication ) needs a little more extra work to get it done.
Here is how to get this done.
1. Configuration in SQL Server Management Studio
[FONT=Times New Roman][SIZE=3]Click
Reply With Quote
