How costly (CPU or memory wise) is it to have multiple instances of SQLserver 2005 instead of only one instance with prefixed databases?
A company have three application providers. They each will install one application and they each require two or three databases. Should they all use the same instance or should every provider use it's own named instance?
Is there any strong reason for one or other setup?
I've installed SQL Express on my PC hoping to do some practice creating tables and then modifying them. I coded a webpage in Visual Studio to, basically, SELECT * from a table in the SQLEXPRESS, but I can never get the connection string to work. Please help
My connection string
"Data
Source=localhost\SQLEXPRESS;Initial
Catalog=test;User
Id=xaa9-PC\xaa9;Password=abcd;"
Error Message:
Query is select * from tblCustomers
where username='johndoe' error is
Login failed for user 'xaa9-PC\xaa9'.
Where do I find this drivers on my .iso image for the server software, or what is the ftp: location to download these files as those are the two options i am given on how to solve this issue.
ubuntu-server 11.10, hardware: dell r210 what I am reading is that I am possibly missing 'mpt2sas' driver somewhere in this boot disc. I'm attempting to download a different version in the hopes that the mistake I made was downloading software meant for an AMD architecture.
Hello,
I run into the same issue as someone who posted this question on experts-exchange.com (couldn't read the answer though as I don't have an account there):
{Quote Begin}
I noticed that the 180-day Evaluation version of SQLServer 2008 is the
Enterprise version. Is there going to be any problem "upgrading" the Evaluation Enterprise
version to a licensed STANDARD version (and how much additional stuff is going to be
left inactive on my disk and, more importantly, in my registry, etc. if I do
so)?
{Quote End}
Any advice is appreciated.
I have my RADIUS server up and running and a custom external captive portal. But I'm not sure:
what information should I send to the Open-Mesh AP with my login form (it is necessary to encrypt the password?, because if I don't use a secret word to encrypt in my network configuration the RADIUS server complaints about it and in the log shows me some strange characters in the password)
I don't know what to do with the "challenge" and "md" parameters in my login splash page.
Thank you very much for your help.
I have 8 SQLServer installations (on 8 separate servers).
I want a way in which I can estimate future disk space requirements. Can anyone list down the parameters which can be helpful in making such reports?
Hi
I currently loook after 20 odd databases in SQLserver 2005 and need a tool for monitoring the performance and keep me informed if a database is running slow. Is there anything I can run within Managment studio of any other good third party tool (Pref free) that can do the job.
Thanks
Hi,
On a SQLserver, why do we need a weekly update stats job (with full scan) when we have AUTO_UPDATE_STATISTICS=ON for all databases?
Doesn't this option update statistics all the time?
Regards
I've been tasked with taking over the administration of a MySQL installation (running on Red Hat Linux) that will become fairly critical to our business in the near future.
I was wondering if anyone could recommend some resources in regards to administering MySQL for DBAs already experienced with other relational database (SQL Server and some Oracle in my case). Specifically I'm looking for information around disaster recovery as well as high availability to start with, but I do want to get well rounded with the entire system.
Thanks in advance,
Dan
What is a little bit of snow-covered server between friends, right? From YouTube: This is an experimental Free Air Cooling setup called a Helsinki Chamber. You can learn more about this experimental server cooling technology here. Snow is not a problem for servers in Finland [via Fail Desk] Our Geek Trivia App for Windows 8 is Now Available Everywhere How To Boot Your Android Phone or Tablet Into Safe Mode HTG Explains: Does Your Android Phone Need an Antivirus?
Hi i have installed and configured ftp server on ubuntu 12.04.
vsftpd.Config
#anonymous_enable=YES
write_enable=YES.
when i drag and drops files to the Sever with filezilla, it fails:
****550 Permission denied.
Error: Critical file transfer error.****
but when i try to do the same thing to another server on the Internet, it works just fine.
I even tried severe times to changes settings in the vsftpd.config file but it had the same problems respectively
Help Thnks
I use Windows 7 & SqlServer 2008.
If I run Management Studio as normal user and try to connect to database 'MyDatabase', I get this error message 'The database MyDatabase is not accessible'.
I I run Management Studio per right click 'Run as administrator', then 'MyDatabase' is accessible.
Where & what should I set, to be able to access MyDatabase as normal user?
Hi,
I was asked to drop some tables on a Company SQL 2005 Server and provide proof of deletion because of these tables contains sensible data. Is it possible?
Thank you all for help
I have a SqlServer database that has a few tables with zero row count but take up a combined 10 GB of space. I can see this by doing right-click/properties on the tables in question (data space is huge, between 1 and 6 GB, and row count is zero on these tables). I have no clue what could be causing this as I would assume zero rows would mean nearly zero space taken.
Any ideas?
Waited to deploy SQLServer 2012 until Service Pack 1 was released? Then held off because Service Pack 1 did not include important updates from Cumulative Update #3 and Cumulative Update #4 ? You're running out of reasons to procrastinate! The SQLServer team has released CU #1 for Service Pack 1, which should include all of the fixes from CU #3 & CU #4, as well as some others. KB article: KB #2765331 Build # is 11.0.3321 I count a whopping 44 fixes! Relevant for builds 11.0.3000 -> 11.0.3320....(read more)
I have a VPS running Ubuntu server 12.04. A while ago, my host installed an alternative kernel (one of Amazon's EC2 kernels) to fix a boot issue I was having. Now, 2 Ubuntu releases later, this kernel (2.6.31-302-ec2) is still being used even though later (3.2.xx) kernels have been installed.
How can I make the server use the most recent installed kernel, preferably without just uninstalling the EC2 kernel just in case doing so causes issues?
Recently we completed a new MSSQL cluster that we are planning on migrating all existing SQL databases to. This includes our Sharepoint databases, while looking into moving the databases I found the Microsoft documentation for moving Sharepoint 2007, however have not been able to find anything similar for Sharepoint 2003. Can anyone point me to a guide for moving the databases, or provide some tips, instructions or warnings? Thanks
I'm having a strange problem with a SQLServer Maintenance Plan. It's set up to run a Reorganise Indexes and Rebuild Indexes, the history shows it has succeeded, but the fragmentation is still bad and requires me to manually intervene to fix them.
Has anyone seen this before?
We are switching from a SQL cluster to a mirrored solution. The problem is that we have a bunch of programs that would have to switch connection strings to handle the failover. Is there any way the we can set up a redirect or proxy that would take any legacy requests and forward them to the mirrored solution?
Client asked if we can host our application for them on Amazon Cloud. The app has database running on MS SQLServer which is approximately 20 Gb in size.
We need to update the database almost every night and approximately 75% of all data is overwritten each time.
Any idea whether Amazon EC2 can reliably handle a load like that?
In Windows Server 2003/IIS6 land we typically create an app pool that runs as the identity of an AD account created with minimal privileges simply for that purpose. This same domain user would also be granted access to SQLServer so that any ASP.NET application in that app pool would be able to connect to SQLServer with Integrated Security=SSPI.
We are making a brave move to the world of Windows Server 2008 R2/IIS7.5 and are looking to replicate this model, but I am struggling with how to make the application pool in IIS7.5 run as the identity of an AD account? I know this sounds simple and hopefully it is, but my attempts so far have been fruitless.
Should the application pool identity be a 'Custom account' for a domain account?
Does the domain account need to be added to any groups?
I've just installed SQLServer 2008 Developer edition and I'm trying to connect using SQLCMD.exe, but I get the following error:
H:\>sqlcmd.exe -S ".\SQL2008"
Msg 18452, Level 14, State 1, Server DEVBOX\SQL2008, Line 1
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
Has anyone seen this before? Any idea what it means??
I've used Flash Media Server to create multiplayer flash games, but the cost of deploying a FMS application seems rather high. Are there good alternatives, open source or not, that I should look into to mimic the same functionality? I'm specifically looking at using FMS for the aspect of synching game-play state between users running the same swf.