YeYeJuice 3 Report post Posted May 12, 2020 (edited) Whats up yall? I am trying to set up my website with xampp. I've been already setting up simple websites before, but now i am getting this Errors (depending if i use the IP directly or the SQL id name): If i use ./SQLEXPRESS, this pops up (it is the same i am using for gameserver, and gameserver has no problem when connecting to database): If i use the ip directly, i get this: Some additional information: I am using SQL server 2014. The xampp version i am using ia 1.6.8. Tried this also with 5 different websites from the public archive. Already opened ports 80 and 1433 and made sure no other application was using them. Enabled all protocols in sql server configuration manager Tried turning firewall off and it didn't work as wel. Reinstalled xampp and tried different versions but it didn't work. In the /SQLEXPRESS host, i also tried adding ,1433 and it didn't work Is there anything i am missing? A few weeks before i made another website and had no problems with it. Now that i am using a new vps i am getting thsi problem, kinda weird. THANKS Edited May 12, 2020 by YeYeJuice Quote Share this post Link to post Share on other sites
Dan 184 Report post Posted May 13, 2020 Turn on mssql. Quote Share this post Link to post Share on other sites
YeYeJuice 3 Report post Posted May 13, 2020 42 minutes ago, FruitJuice said: Turn on mssql. Hi, mssql is on. Server files are able to connect properly to database. But web still not. Quote Share this post Link to post Share on other sites
YeYeJuice 3 Report post Posted May 15, 2020 BUMP Quote Share this post Link to post Share on other sites
Backpack 4 Report post Posted May 15, 2020 The website is running on the same host as server? Have you tried putting 127.0.0.1 instead of the direct IP? Quote Share this post Link to post Share on other sites
YeYeJuice 3 Report post Posted May 15, 2020 @BackpackYeah, website is running on the same host. I've tried 127.0.0.1 but sql 2014 only works with its own name ./SQLEXPRESS Quote Share this post Link to post Share on other sites
Perseus 98 Report post Posted May 16, 2020 In SQL Configuration Manager, check the `SQL Server Network Configuration` Tab. Is TCP/IP Enabled there? If not, enable it. If it is enabled, double click the TCP/IP protocol and go to the "IP Addresses" tab. Look for the entry which has IP Address as your local IP (127.0.0.1) and make sure that's enabled as well. Quote Share this post Link to post Share on other sites
YeYeJuice 3 Report post Posted May 16, 2020 46 minutes ago, Perseus said: In SQL Configuration Manager, check the `SQL Server Network Configuration` Tab. Is TCP/IP Enabled there? If not, enable it. If it is enabled, double click the TCP/IP protocol and go to the "IP Addresses" tab. Look for the entry which has IP Address as your local IP (127.0.0.1) and make sure that's enabled as well. Hi!, yeah, all that was enabled already, but still getting the error Quote Share this post Link to post Share on other sites
cpworkerz 24 Report post Posted May 16, 2020 (edited) On 5/12/2020 at 4:49 PM, YeYeJuice said: Whats up yall? I am trying to set up my website with xampp. I've been already setting up simple websites before, but now i am getting this Errors (depending if i use the IP directly or the SQL id name): If i use ./SQLEXPRESS, this pops up (it is the same i am using for gameserver, and gameserver has no problem when connecting to database): If i use the ip directly, i get this: Some additional information: I am using SQL server 2014. The xampp version i am using ia 1.6.8. Tried this also with 5 different websites from the public archive. Already opened ports 80 and 1433 and made sure no other application was using them. Enabled all protocols in sql server configuration manager Tried turning firewall off and it didn't work as wel. Reinstalled xampp and tried different versions but it didn't work. In the /SQLEXPRESS host, i also tried adding ,1433 and it didn't work Is there anything i am missing? A few weeks before i made another website and had no problems with it. Now that i am using a new vps i am getting thsi problem, kinda weird. THANKS .\SQLEXPRESS try this. suggestion if this won't work., use zendserver you will find a guide here on the forum Edited May 16, 2020 by cpworkerz Quote Share this post Link to post Share on other sites
YeYeJuice 3 Report post Posted May 17, 2020 On 5/16/2020 at 4:52 AM, cpworkerz said: .\SQLEXPRESS try this. suggestion if this won't work., use zendserver you will find a guide here on the forum Tried but still not working. I've read the Zend guide but zend isn't free right?,or at least that what i saw when i researched it. Quote Share this post Link to post Share on other sites
cpworkerz 24 Report post Posted May 18, 2020 6 hours ago, YeYeJuice said: Tried but still not working. I've read the Zend guide but zend isn't free right?,or at least that what i saw when i researched it. it's free, they give you 30 days trail for their admin control panel, but you may stay using it forever. Quote Share this post Link to post Share on other sites
V3ct0r 2,117 Report post Posted June 3, 2020 Hello @YeYeJuice! You can specify in config.php the full name of the instance of your MSSQL Server. You can see it in MSSQL Manager Studio program. On 5/17/2020 at 11:21 PM, YeYeJuice said: I've read the Zend guide but zend isn't free right?,or at least that what i saw when i researched it. You can configure Apache + PHP. They are free and there are many guides in Google. No need to use heavy stacks like Zend or XAMPP. 1 Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites
YeYeJuice 3 Report post Posted June 9, 2020 On 6/3/2020 at 6:16 AM, V3ct0r said: Hello @YeYeJuice! You can specify in config.php the full name of the instance of your MSSQL Server. You can see it in MSSQL Manager Studio program. You can configure Apache + PHP. They are free and there are many guides in Google. No need to use heavy stacks like Zend or XAMPP. Hiya @V3ct0r, i triple checked that sql host + user + password were correct but i still get the error. It is rare because my server exes connect without any problem but php still can't connect. Also, i have all the sqlsrv drivers installed. Might there be a specific config inside sql management studio that i need to edit? Quote Share this post Link to post Share on other sites
MonkeyCode 453 Report post Posted June 9, 2020 Why? SQL management studio is only a client for the DB Server. If your SSMS and exes can connect to SQL, then it is likely a configuration issue in your php files. Some common configurations I see: (localhost) . .\SQLEXPRESS 127.0.0.1 <User>\SQLEXPRESS AND WATCH OUT FOR THOSE BACK-SLASH Quote Share this post Link to post Share on other sites
YeYeJuice 3 Report post Posted June 9, 2020 1 hour ago, MonkeyCode said: Why? SQL management studio is only a client for the DB Server. If your SSMS and exes can connect to SQL, then it is likely a configuration issue in your php files. Some common configurations I see: (localhost) . .\SQLEXPRESS 127.0.0.1 <User>\SQLEXPRESS AND WATCH OUT FOR THOSE BACK-SLASH Tried all of those but still won't connect. I also tried Perseus Web and it isn't connecting to the db as well, also some other extensions that use php aren't connecting. Somehow mssql is blocking the php connections but idk how. Quote Share this post Link to post Share on other sites
V3ct0r 2,117 Report post Posted June 10, 2020 Hello @YeYeJuice! Make sure that mixed authentication is enabled in MSSQL Server settings: Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites
hendersongvc 0 Report post Posted July 29, 2020 Solution? same problem. the bug start in windows server 2012 R2. i'm using same programs. I am using SQL server 2014. The xampp version i am using is 1.6.8. Tried this also with 5 different websites from the public archive. Already opened ports 80 and 1433 and made sure no other application was using them. Enabled all protocols in sql server configuration manager Tried turning firewall off and it didn't work as wel. Reinstalled xampp and tried different versions but it didn't work. In the .\SQLEXPRESS host, i also tried adding ,1433 and it didn't work Quote Share this post Link to post Share on other sites
Rogue 19 Report post Posted July 29, 2020 Hello @hendersongvc! Check this thread, it might help you. Also, if you are not using .\SQLEXPRESS, check whatever you use as an instance to connect to your SQL Database Engine. Quote Share this post Link to post Share on other sites
hendersongvc 0 Report post Posted July 29, 2020 @neve I've done everything, but on older windows it open normal, on windows server 2012 the site doesn't connect to the sqlserver. I installed the php drivers on xampp and even then it won't. Quote Share this post Link to post Share on other sites