Using MSSQL Server + MySQL On One Server

Jan 27, 2006

How do I get MSSQL Server and MySQL working on the same server?

I have MySQL running but in PHP.INI when I uncomment the extension=php_mssql.dll line MySQL stops working.

Why is this?

View 2 Replies


ADVERTISEMENT

MSSQL Server + MSSQL Express

Aug 4, 2008

I already have MSSQL 2005 on my server, one my the client requested us to install MSSQL express and they want to use the FOC version.

Can I run MSSQL server + MSSQL server express concurrently? Anybody can give me guidelines how to install it?

Do I need to uninstall MSSQL or it would be as easy as installing MSSQL express on top of MSSQL server.

View 5 Replies View Related

MSSQL Server Attacks

Oct 11, 2009

I can see lot of MSSQL Server attacks. In event viewer "Login failed for user 'sa'. [CLIENT: Some IP]"

Most of the attack coming from Chaina. Tipically what I'm doing manually is get that entire IP range and block from Windows Firewall level.

Now I have plenty of blocked IP ranges all over the world.

What would be the best way to avoid from those kind of attacks ?

View 6 Replies View Related

SQL Server Express And MSSQL

Nov 1, 2007

I have MSSQL 2005 running on the W2k server, can i install SQL Server Express on top of it w/o causing any disruption to other services including MSSQL.

View 2 Replies View Related

Asp.net 2.0 + Mssql Server 2005 + Ajaxtoolkit Support

Nov 26, 2008

asp.net 2.0 + mssql server 2005 + ajaxtoolkit support

I need windows hosting with asp.net 2.0 + mssql server 2005 + ajaxtoolkit support for a website project that is being developed. It can probably be launched on shared hosting, but I would prefer at least a VPS. With any success this site would eventually need to be hosted on a dedicated server.

I have been offered a 1U Dell server for free with Windows Server 2003, Dual Xenon Processors, 2 GB ram and 2 x 80gb hard drives. It would probably serve the site well for a long time, but I would need to set it up (or get it setup $) for the above requirements and get it colocated somewhere. BTW, I'm not too familiar with Windows hosting.

To launch the site, I don't really want to spend more than $100 per month. And I'd prefer to stay in the $50 per month range if possible.

Open to any and all suggestions, comments, questions at this point? I've searched and see a lot of suggestions for shared hosting, but I'd really like your opinions on colocating the dedicated server.

View 4 Replies View Related

MSSQL Database's Backed Up And Then Moved To A New Server

Jan 5, 2007

one of my servers currently died (it was a 1u System) Dual Xeon, 3GB RAM. I need the DATA off my SCSI harddrives.. i have a 2U system only, but when i try and put the SCSI harddrive into the Machine, windows crashes on the "Windows 2003 " starting screen. Windows, ugh, horrible. I need to get into windows to get my MSSQL database's backed up and then moved to a new server.

View 11 Replies View Related

Convert A MSSQL To A MySQL Db

Jul 22, 2007

I am currently using phpdotnuke for a site, and have a forum linked to it supplied by activemodules.com. I would like to move to a non-cms site and something like vbulletin, so want to convert the forum db from MSSQL to MySQL - and hopefully keep all the posts and login data!

As a complete novice to that process, is there any pointers out there in terms of reading material, non-command line software etc I can use? Has anyone done this conversion, and what are the dangers?

View 7 Replies View Related

Plesk 11.x / Windows :: Delete Inactive MSSQL Remote Server

May 13, 2014

I have an account which used a remote MSSQL server which I have since deactivated, but before deactivating I forgot to remove the DB and Server from plesk.

So now I can't remove the remote MSSQL server from plesk as there is a DB associated with it, and I can't remove the DB because it obviously can't find the remote server! I'm now stuck in a loop!

How I can force remove the DB/User from plesk and then the remote server ? I'm now receiving errors whilst backing up the account, so needs to be done.

View 1 Replies View Related

Plesk 12.x / Windows :: Unable To Add MSSQL 2014 Express Server

Aug 9, 2014

I have Plesk 12 on Windows Server 2012 and SQL 2014 Express, and I am unable to add the SQL server to Plesk. It looks like it is waiting for a long time for something, then I get this error:

Get database server version failed: mssqlmng failed: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Error code 1)Click to expand...

View 4 Replies View Related

Plesk Automation :: Remote MSSQL Server Webadmin Link

May 22, 2013

When using a remote MSSQL server, the Webadmin link fails to load in a redirect loop.

Is there any way to change this link or disable it?

View 13 Replies View Related

Webhosting With Php, Java, Dotnet, Mssql, Mysql

May 6, 2008

is there any hosting company/service available in this world that it allows to host websites developed in

php, java, dotnet, mssql, mysql

all in one account ?

if so please let me know that hosting provider details. (or) if anyone already using any hosting service and hosted your websites with the above said langauges.

View 14 Replies View Related

Plesk 11.x / Windows :: Change Database From MySQL To MSSQL

Apr 22, 2013

I have read about people wanting to change their database from MSSQL to MySQL. I however am wanting to change from MySQL to Microsoft SQL in our Plesk panel.

View 7 Replies View Related

Plesk 11.x / Linux :: Upload Backup MSSQL Server File - Filemng Cp Failed

Mar 19, 2014

I'm trying to upload backup ms sql server file. But the Control panel tells me error: "Error: copy_file failed: filemng cp failed:"

View 4 Replies View Related

MySQL Error : MySQL Server Has Gone Away

Dec 18, 2007

I keep getting this error :
MySQL Error : MySQL server has gone away

How do I fix it?

my.cnf contents

Quote:

[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_user_connections = 500

[mysqld_safe]
nice = -5
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout

View 5 Replies View Related

MSSQL Express 2005 Instead Of MSSQL 2005 ?

Dec 27, 2007

I`ve just got a new Windows 2003 Web Edition box and now I`m going to install a database server on that.

MSSQL 2005 license would costs 270$/mo for me, So thats not possible to use it because of its price.

I`m not sure if MSSQL Express 2005 or MSDE (which are free) can handle all requirements of ASP.NET programmers or not.

Is there any limitations for major scripts on those? or will those make any doubts for programmers?

Please share your experiences and suggestions.

* I`m going to install "Hosting Controller" on that box.

View 8 Replies View Related

Your PHP MySQL Library Version 5.0.75 Differs From Your MySQL Server Version

Jun 27, 2009

I have recently upgraded mysql server from 5.0.75 to 5.1.31 on my Ubuntu server 9.04 32 bit. After that when I am running phpmyadmin it is printing a warning :

Your PHP MySQL library version 5.0.75 differs from your MySQL server version 5.1.31.

View 2 Replies View Related

Which Server For Mysql Only

Jul 7, 2009

Which server for mysql only?

This is sort of a continuation to this thread here

Based upon the screenshots I provided below. What server would best suit my needs. I need this server to be able to handle the mysql usage and server load.

This server will be only for mysql. The rest of the site (html, videos) will be hosted on a different server.

If you think these servers are not enough for this please let me know any suggestions you have pertaining to server specifications.

Server 1:

Dual Core
Core 2 Duo E4500 2.2Ghz 2MB Cache
500 GB SATA II Hard Drive
2 GB DDR2 SDRAM

Server 2:

Dual Core
Core 2 Duo E8400 3.0Ghz 6MB Cache
500 GB SATA II Hard Drive
4 GB DDR2 SDRAM

Server 3:

Quad Core
Core 2 Quad Q9300 2.5Ghz 6MB Cache
500 GB SATA II Hard Drive
4 GB DDR2 SDRAM

View 3 Replies View Related

MySQL Server Has Gone Away

May 9, 2009

i have install a durpal on my centos server(php5,mysql5,suphp),

for some feature,

i get a lof of error like
---------
Warning: MySQL server has gone away query
---------

i try to google to find some solution,

but the issue is still here,

do you know any problem make this?

View 9 Replies View Related

Server With MySQL 4.1.2

Jun 23, 2008

I have an older script that works well on the config below. Can anybody know where I find such boxes?

PHP version 4.4.7
MySQL version 4.1.22-standard-log

View 1 Replies View Related

How To Go About A MySQL Server

Sep 29, 2007

My site is getting big and my server can barely hold all the mysql processes.

Once I had a similar problem with bandwidth because my media files were eating quite a big chunk of it. So, I just bought a media server and changed some HTML to hotlink all the media from the media server. I would like to do something like that with my MySQL databases, to get some load off my main server.

Should I get my current host to cluster another server for mysql? Or can I use a completely different server (from a different webhost) for mysql?

View 7 Replies View Related

Server To Mysql

Sep 19, 2007

I have A and B server, i linked a cross cable in both server second ethernet port.

I have A as 10.0.0.1 (eth02) and B as 10.0.0.2 (eth02).

Both can ping to each other.

Now how could i setup 10.0.0.2 mysql to accept connections from 10.0.0.2?

The idea is to setup in A server to be able to backup mysql or write to B server.

View 10 Replies View Related

Mysql 4 And 5 On The Same Server

Jun 7, 2007

I have an issue with one of my scripts,it wont run on mysql 5.x
if its possible to run mysql 4.x and 5.x on the same server?

View 11 Replies View Related

Mysql Server

Feb 15, 2007

as you know most of servers use utf8 for mysql charset

1- i use following command to backup as utf8

PHP Code:

mysqldump -u root -p123 --default-character-set=utf8 forum > /db.sql 

But it is latin1 as you see following

PHP Code:

CREATE TABLE `access` (  `userid` int(10) unsigned NOT NULL default '0',  `forumid` smallint(5) unsigned NOT NULL default '0',  `accessmask` smallint(5) unsigned NOT NULL default '0',  PRIMARY KEY  (`userid`,`forumid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

why?

View 4 Replies View Related

MySQL 4.1.x And 5 On The Same Server

Jan 25, 2007

How would you offer MySQL 4.1.x and 5 on the same server for your customers?

Would you just change the port of MySQL 5, for instance 3307 so that both versions can coexist?

View 0 Replies View Related

MySQL Server Has Gone Away

May 31, 2007

we got this error on mysql db after that we have change the my.cnf value

Description : MySQL server has gone away. Please contact with your host provider, the connection time should be increased a little.

It's the reason of the session issue (I see that sometimes it's caused on the session table update). It seems like there are some problems with search.

here's my.cnf how can we fix this prpblem?

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
#skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=128M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=512M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1800 ## era a 1024
record_buffer=1M
sort_buffer_size=4M ## 1MB for every 1GB of RAM
read_buffer_size=4M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM
thread_concurrency=4 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
log_slow_queries=/var/log/mysql-slow-queries.log
long_query_time=2
collation-server=latin1_general_ci

[mysql.server]
user=mysql
#basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

View 4 Replies View Related

How To Have MySQL 4 And 5 On The Same Server

Mar 28, 2007

I didn't find a way to do it. How to have MySQL 4 and 5 on the same server?

View 5 Replies View Related

Dedicated Server For Mysql Alone

Mar 25, 2009

telling me that mysql is hitting loads of 25, which he says is very high and i don't quite know what it means. He is strongly recommending that i shld get another dedicated server for mysql alone.

So can i get some advice on how I can assess the validity of his recommendations? I see that my CPU is load is hitting 125-150% daily. So i suppose there is some truth?

He is recommending that i get a raid-5 which is best. How can i know a suitable configuration of a new server to get? Of course, if i got all the money in the world i shld buy the best. But with constraints on budget, i want to get one (if i really need a new server) that is good for current loads with some projected margins for growth.

View 14 Replies View Related

Dedicated Server For MYSQL

Nov 1, 2009

I've a huge site that runs on PHP and MYSQL, I'm going to get a dedicated server and make it for MYSQL so I need to know what server should I get for MYSQL ?

does it need to have lots of ram or should I get high CPU ?

View 7 Replies View Related

Do You Put Httpd And Mysql On The Server Or Different Ones

Jun 5, 2009

as default,we may install all the feature on the server,

but i find some shared hosting server provider install web httpd on the front,

and mysql on another one,

could you share your experience about how do you do now?

View 9 Replies View Related

It Possible To Run Mysql On Differnet Server

Jul 25, 2009

It possible to run mysql on differnet server

iam haveing cpanel server

so it possible to run mysql for only one account on different server

i know about remote sql,but i think it wont work for only one account

please advise me for this

View 11 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved