How can I disable the windows authentication mode of SQl Server and restrict it to ask for user and Password every time and no windows authentication. for security purposes
We recently upgraded a WIMP server from Windows Server 2003 (32 bit) to Windows Server 2008 R2 (64 bit).
The new server has significantly better hardware than the old server, yet many processes take much longer than the old box. We have a rather complex web application process that normally takes about 7 seconds on the old box, but on the new one…
I wrote an application a few months ago, and was hosting it out of our offices on a workstation with an Intel Core 2 Quad Q8200 @ 2.33GHz, 8 GB RAM, Windows Server 2008 Enterprise and SQL Server 2008 Enterprise. Both the webserver and database server were run on the same machine.
We had a huge influx in traffic, and moved ClubUptime.com, and got 2…
Hi all,
I using the SQL Server 2008 FTS feature in a project. When searching for a phone number like CONTAINSTABLE(table, *, '"01739470869"'), this query also returns records containing the number '01739468996', which is similar. Does anyone know how I can get an exact match from a number?
I have a standalone Win 2003 server with Windows Sharepoint Services (WSS3) running on it. I had to rename the server and I had bunch of problems resulting from this. Note that the server is not in AD environment.
Most obvious problems were with Sharepoint, which didn't work. I was somewhat naive to think it will work in the first place, but OK -…
Hi! I try to import sql script, generated with Server Management Studio, into SQL Compact 3.5 and get a lot of error. What I am doing wrong?
I generate script with "Task/Generate Script" context menu. Part of my script:
CREATE TABLE [LogMagazines](
[IdUser] [int] NOT NULL,
[Text] [nvarchar](500) NULL,
[TypeLog] [int] NOT NULL,
[DateAndTime]…
I am trying to create a maintenance plan that will run automatically and back up my SQL Server 2005 databases automatically. I create a new maintenance plan and add a "Back Up Database Task", select all databases, and choose a path to back up to. When I save and try to execute this plan, I get the following error message:
…
Hello,
I'm trying to crunch some numbers to see what the software costs involved are for hosting an application we are developing. Users will not be anonymous - they will need to log in.
SQL Server 2008:
SQL Server licensing is easy - it will be licensed per-processor. No real fuss there. The cost of CALs would be much…
I have configured DirectAccess on my Server 2012 Essentials box and most of it works great - I can remotely access the server via RDP and the default IIS website on port 80.
However, I can't access anything that uses other ports. For this example, the Team Foundation Server website. The only way to access it is by…
When users login to a Windows Server 2003 R2 running Terminal Services they have a blank desktop. Upon inspection, explorer.exe is not running. When I login as administrator, using either RDP or to the console, I am having the same issue. I can pull up the taskman and start explorer.exe manually. I have another…
I have a (clean) server running Windows Server 2008 R2 standard. I would just like to use it for serving a website and a FTP server through IIS. IIS is installed and serves my website propery. I have now added a FTP site but when I try to logon using my user/pass i get the following error:
530 User cannot login…
I have Windows 2008 Server R2, and I am trying to install FTP services.
My problem is I can't connect from outside, FileZilla complains with:
Error: Connection timed out
Error: Could not connect to server
Here is what I did.
With the Server Manager, I've installed the Roles FTP Server, FTP Service and FTP…
Introduction
Dynamic Host Configuration Protocol (DHCP) is a core infrastructure service on any network that provides IP addressing and DNS server information to PC clients and any other device. DHCP is used so that you do not have to statically assign IP addresses to every device on your network and manage the…
Java EE 6?Java SE 7?????????200??????????/???????WebLogic Server 12c??????????????????????????????????????????????????????????????? ?????2??????WebLogic Server 12c???/??????????????????????????????????????????????????????????(???)
Eclipse?NetBeans?JDeveloper????IDE??????????
WebLogic Server…
We have installed windows 2008 R2 enterprise on a Dell server. This server is placed remotely in data center and only administrator is going to access it for maintenance purpose. No multiple users or client remote access is needed
Now during 'remote desktop services' role installation network admin…
Possible Duplicate:
Install GUI on Windows Server 2008 Core
As I've seen there is not really a topic about this here... My question:
Is there any means to upgrade from windows 2008 server CORE to full windows 2008 server?
The server is used as Hyper-V Host machine.
On the internet mostly I…
When trying to turn on Remote Access on my Windows Home Server (HP MediaSmart Ex485, MediaSmart Server 3.0, Power Pack 3), I am not able to continue through the wizard as this first check fails:
"Verifying that your remote Web site is available locally"
Everything else on the server works…
I'm using HP DL360p Gen8 + Windows Server 2008 R2 for HFT trading.
That means that every 10 microseconds is important for me. I do understand that if I need everything to be so fast I probably should consider using Linux. But in this post I want to compare only Windows Server 2008 R2 and…
See Also - Small (Business) Server - Microsoft Windows Search or Microsoft Search Server 2008 Express
Can anyone tell me if they have Search Server Express 2010 Beta working on Small Business Server 2010, or indeed if it is supported. The only reference I can find is here, but given…
Hi there.
When I connect a Windows XP laptop via PPTP vpn to our Windows 2003 Server, the DNS Server order is correct:
192.168.8.3
208.67.222.222
208.67.220.220
But when I connect a Windows 7 laptop via PPTP VPN to our Windows 2003 Server, the DNS order is incorrect:
…
Hello everyone,
I am using SharePoint Server Enterprise 2007 with Windows Server 2008 Enterprise. I have a site collection which is using 3 types of sites publishing portal/wiki/blog. I want to move the template (e.g. master pages) and data from one server to another.…
We have recently replaced all of our 2003 server domain controllers to 2008 r2 and have tried to implement PSO's but have found that the domain functional level must be raised to 2008. We have a mac server in our environment that runs open directory and it is…
I tried to create a full-text index and got this error:
Msg 9967, Level 16, State 1, Line 1
A default full-text catalog does not exist in database 'foo' or user does not have permission to perform this action.
FYI--I connected to the target sql server with…
Hi,
I install SQL SERVER 2005 on my Windows 7 machine. Now, when connecting to the server there is nothing being displayed in the Server Name. Am I missing something?
Same happens with SQL SERVER 2000!