Hi all
The title says it, I searched the net but not even in the microsoft technet they mention what features I must activate for SQLServer 2005. Can someone help me out?
I am trying to query IP addresses from Forefront Firewall logs, and I am a little stuck on the IP formatting
C0A8E008-FFFF-0000-0000-000000000000
Can anyone give me the MSSQL command to turn this into standard human redable?
UPDATE, I now see that I kust need to convert the first 8 charecters from hex to decimal....which I can then convert to IP. the trick is to parse those first charecters from the field with SQL
Any recomendations on what services are out there to host an ASP.NET MVC application using .NET 3.5, IIS 7, SQLServer 2008? Any recommendation on shared? VPS? Dedicated?
I have installed Ubuntu 13.04 server in my x86 based laptop and then added the desktop packages on top of it. I have downloaded all the packages using apt-get. I have MySQL, PostgreSQL, Python 3.3, etc. But I am unable to locate Grizzly-specific Nova, Swift, and Glance packages (OpenStack). I am using this command:
dpkg -l | grep Nova
dpkg -l | grep Glance
etc.
Isn't Ubuntu 13.04 Server supposed to come with Grizzly automatically?
I have a SQL 2008 developer edition with SSRS and the report manager is only available from the local machine. If I try to access it from any other machine I get challenged for my domain u/name and pwd 3 times and then the screen stays blank.
I have made changes to some config files (originals copied out) in order to get a 3rd party application to run but that is now uninstalled and the config files are all back to vanilla (originals copied back in)
I feel its something to do with authentication but am stuck ...
any suggestions welcomed
Jonathan
Hi all
The title says it, I searched the net but not even in the microsoft technet they mention what features I must activate for SQLServer 2005. Can someone help me out?
Hi,
I was asked to drop some tables on a Company SQL 2005 Server and provide proof of deletion because of these tables contains sensitive data. Is it possible?
Thank you all for help
Due to some security problems, My boss has asked me to store all sensitive data in external/removable storages like USB stick or external HDD and this specially includes the MDF/NDF/LDF files of SQLServer 2008 we're running.
I've been reading for these last three days with no luck to find a solution. Is there any solution at all? Has ever anybody done such thing?
Hey guys i am facing a problem installing sqlserver 2008 on Windows 7 x64. it gives some wow64 error. can some one tell me is it possible to install 32bit version on 64bit OS. if yes, then please explain how to do that.
Hi All,
I've been tasked with comparing the monitoring capabilities in SCOM 2007 with the established SQL products such as Spotlight, SQLSentry, etc.
I'm pretty sure that SCOM can't do some of the more in-depth stuff that those products do, but can it be configured/programmed to alert on the most often encountered problems via VBScript and TSQL. Does anyone have an idea of what type of development effort would be needed for this? Thanks for any and all help.
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.
i have made columns in some of the tables encrypted in sqlserver 2008. Now as i am a db owner i have the access to encode and decode the data using the symmetric key and certificate. But some other users have only currently datareader and datawriter rights ,and when they execute any SP referring the logic which uses the key and certificate "User does has not right on the certificate to execute". What rights / exact permission should i grant them just to solve this problem
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 think I screwed myself on the setup of SQL 2005. I installed Database Services, but forgot to install replication. I then installed SP3. Is it possible to install replication after sp3? Or do I need to start from scratch?
If you have SQLServer 2008 Trial edition installed, how can you find out how many days are left?
It doesn't seem to be in the Help-About dialog, or anywhere obvious.
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'.
I want to create a sequence of numbers in sqlserver it will have the minimum value and maximum value, I want to cycle if the number reaches the maximum limit. ?
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
Has anyone ever ran across a program that in a generic manner will execute a sql query and then based on criteria email out alerts. Going to create such a framework but don't want to re create the wheel if I don't have to. It could be used to check various things like if things are setup correctly inside our ERP etc...
Thanks for any thoughts.
Michael
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?
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?
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
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)