I want to set up a new Hyper-V-Server and secure it, so access to the server itself is only possible with physical FIDO2 keys (like YubiKey).
Access using remote desktop should also only be possible with the right Fido2 Keys.
How can I setup a windows server so only certain users with fido2 as 2nd auth can access them?
Is there a way to see which files are cached in a windows server 2008R2?
I'd like to see/analyse which files are being used most to make choices how to optimize data on a server and for this it would help to see wich files are being cached most or use most cache memory.
I've got a customer with intermittent System hangs. The System in case is a Windows Terminal Server 2008R2 SP1. Sometimes one session in the Server will freeze. Everyone else can work as usual, but this one user can't log in again, the session can not be closed even a Server shutdown will not work.
I obtained Memory.dmp files using the ctrl+scroll lock method but of course These just tell me "the user manually initiated this Crash dump".
So how would I continue to debug? Is there a way to get the most actives processes from the dump or anything else which might be useful? I tried DebugDiag 2.0 but it crashes on the dump, so it is of no help to me :(
I've got a SQL Server 2008 and want to make a copy of a database so I've got a 2nd Version of the database for testing on the same server.
The database copy wizard is not able to copy the database, it always sends funny error Messages about missing objects (using SMO copy).
When I try to make a backup and restore it under a different database name it still keeps the file names of the original database and overrides this (crashing the original database).
So how do I copy a SQL database? Shutdown SQL Server, copy the physical files and attach them? Maybe a command line tool for database copy? Shouldn't there be an easy way to make a copy?
On a freshly installed Windows Server 2008 R2 Standard SP1 I am installing SQL Server 2008 R2.
After configuring setup, install starts, but then it will hang on: Install_sqlSupport_KatmaiRTM_Cpu64_Action: InstallFiles. Copying new files.
What happens here? Why does the installation hang?
I've got two windows PCs connected by gigabit ethernet.
When I use iperf to measure throughput it maxes out at a good 100MBit/s.
When I run iperf using two or three parallel connections, each will get the full 100MBit/s, too.
If I add all the parallel connections there should be a maximum speed of nearly 400MBit/s possible, so I gather that the 100MBit/s per connection is some kind of throttling.
I need maximum speed between these two computers, is there any way to disable this throttling so the full throughput can be used by one single connection instead of being shared between more of them?
In the SQL Server Management Studio in Management I can view the SQL Server Logs.
I "inherited" a server where this Log is always empty. I'd guess my predecessor somehow disabled the SQL Server Log.
How do I enable this Log again?
I've got an exchange server behind behind a port to address translation firewall. The server is reachable from the internet using a dyndns-url.
Now I want to sync windows phones to exchange mailboxes. To achieve this, I need to install the exchange certificate on the windows phone (send it to the phone by mail, double click). So far so good.
But, as far as I can see this does only work if the certificate on my exchange server matches the dyndns-url?
So I'd like to know: how do I create a self signed certificate for my dyndns-url and install it on exchange?
I've made a Backup from a SQL Server 9.0.4053, copied the bak file to a different computer running SQL Server 10.0.2531 and tried to restore using
RESTORE DATABASE [MyDatabase] FROM DISK = N'C:\Temp\MyDatabase.bak' WITH FILE = 1, NORECOVERY, REPLACE, STATS = 10
This finishes quite quickly (the database is rather small), shortened output is something like this:
11 Prozent verarbeitet.
[...]
100 Prozent verarbeitet.
208 Seiten wurden für die 'MyDatabase'-Datenbank, Datei 'MyDatabase' für Datei 1, verarbeitet.
4 Seiten wurden für die 'MyDatabase'-Datenbank, Datei 'MyDatabase_log' für Datei 1, verarbeitet.
RESTORE DATABASE hat erfolgreich 212 Seiten in 1.014 Sekunden verarbeitet (1.631 MB/s).
After this is finished, the database shows up in SQL Server Management Studio as "being restored". And it keeps showing up like this for hours, without any progress.
The event log contains three information messages (roughly translated here):
1) "MyDatabase" is getting started.
2) "MyDatabase" is marked as RESTORING and has a status in which execution of restoration is not possible.
3) "MyDatabase" was restored successfully.
What is happening here? From all messages it seems the database was restored, but I can't access it, it keeps being marked as "Restoring".
I want to import a csv file into a sql server 2008 R2 database table using bcp using a command like this:
bcp Database..TableName in TableName.csv -n -T -E -S localhost
My problem: the table contains one row which is also in the csv file (default row inserted on creation of the database).
Can I somehow instruct bcp to ignore this line? I tried -m for max error count, but bcp still aborts when it hits the already existing record (primary key).
I can't just delete this record, since it contains installation-dependend information I'll need later on.
I installed SQL Server 2008 R2 Standard on a server, without knowing there was an installation of MSDE (Microsoft SQL Server 2000 Desktop Engine).
After I installed SQL Server 2008 R2 the client software of the MSDE won't start anymore, instead they show the error (translated) "Connection to policy mananger component failed".
(strange, though, on the server itself the client software seems still to work).
Any ideas what I might have broken with the side-by-side installation of SQL Server 2008R2?
And (hopyfully) how to repair it?
I'm installing SQL Server 2008 R2 on a customer Windows Server 2003. Setup started ok, installed .NET framework and some Setup files, rebootet.
After that I ran setup for a new single-server standalone installation of SQL Server 2008 R2, which checked the prerequisites without any problem and went on to install setup support files.
Well, and it still tries to install. The progress bar is down 2/3rds and it shows "ExecuteStandardTimingsWorkflow" above.
What can I do now? Abort the installation and try again? Wait for an error to occur?
And if I cancel, how do I install SQL Server then?
When I installed the SQL Server 2008R2 on the windows server, the computer was not in a domain.
After I installed it, now someone moved the server into a domain.
Problem is: the server can not be accessed anymore, since it is set to windows authentication, the former accounts do not exist anymore, sa is disabled (not set).
Is there any way to change which windows accounts have admin rights to the SQL Server somehow, or do I need to reinstall it?
Possible Duplicate:
Can you help me with my software licensing question?
Running a SQL Server, as far as I understand it, you need one CAL for every user who connects to the database server.
But what happens if the only computer which is accessing the SQL Server is the server running your business layer?
If, for example, you got 1 SQL Server and 1 Business logic server, and 100 Clients who all just query and use the business logic server. No client is using the SQL Server directly, no one is even allowed to contact it.
So, since there is only one computer using the SQL server, do I need only 1 CAL???
I somehow can't believe this would count as only 1 CAL needed for the SQL Server, but I would like to know why not.
I got a problem with my DC configuration: most computers can access the GP just as they should, just one Windows Server 2003 R2 (SP2) is unable to read the policy information.
I get the following error in the event log: "Windows cannot access the file gpt.ini for GPO CN={31B2F340-016D-11D2-945F-00C04FB984F9},CN=Policies,CN=System,DC=Domain,DC=lan. The file must be present at the location <\Domain.lan\sysvol\Domain.lan\Policies{31B2F340-016D-11D2-945F-00C04FB984F9}\gpt.ini>. (The format of the specified network name is invalid. ). Group Policy processing aborted." (Source: Userenv, Event ID: 1058)
From this computer I can't access the share \Domain.lan\sysvol, while other computers can access it without problems.
I ran DCDiag and NetDiag on the DC, both without any errors.
What else can I do to find the source of this problem?
I've got a Windows Server 2003 R2 Standard SP2 running. When I try to connect to this server using Remote Desktop I get the following error popup:
"The system cannot log you on due to the following error: The RPC server is unavailable."
In the event log of the server I get the following event: "Logon rejected for Domain\administrator. Unable to obtain Terminal Server User Configuration. Error: The RPC server is unavailable." (Source: Winlogon, Event ID: 1219)
What can I do to fix this problem? I got no clue which RPC server this refers to.
I need to set up a windows server 2008 in a virtual machine as demo system to show some apps which are only running on ws2008 with Active Directory.
Since this demo is run infrequently, first the one showing the system always needs to remember the logon password, and quite often is greeted with "your password has expired, pick a new one now" dialog.
Both is cumbersome, especially so since the VM is not connected to anything - how can I switch off the required password for windows server 2008 AD?
I changed the security in the AD group policy to no avail, and the local security policy is readonly, I can't change the values there.
We've got an Exchange 2007 server running on Windows Server 2008 in our small domain for internal use only, installed one year ago.
Today the outlook clients started to show a security warning: "the certificate is expired or not yet valid".
As I can see from the details, the certificate was valid from installation for one year only. It is an automatically generated certificate, there is no need for a official, since this server is only used internal.
Is there an easy way to extend the certificate, or replace it without much work?
Thanks,
Sam
I've got a funny problem connecting to an AOS server.
I got a domain network containing a (VM) Server running the Application Object Server (AOS).
Client computer A) can connect to the AOS without problems and work.
When client computer B) tries to connect, all I get is this error message:
Logon Error
Connection with the Application Object Server could not be established.
The event log of Client B) does not contain any messages about this.
Firewalls are off on all three computers (by GP).
Tcp/ip from cliebt B) to the AOS server does run fine.
Both clients run the same OS (win 7 RC), sit on the same subnet, next to each other.
Yesterday it all worked, today just one computer can connect.
Any ideas what might cause this problem, how to resolve it, or how to debug it?