|
|||||
|
1. Login to your Dynamic Dedicated Server through Remote Desktop. 2. Open Microsoft SQL Server Management Studio. This is found under the Start Menu, All Programs, Microsoft SQL Server, SQL Server Management Studio. 3. When prompted to login use Windows Authentication. Make sure the Server Name is the name of your Dynamic Dedicated Server. Click on connect. 4. Once . . . → Read More: SQL 2008 Hosting :: How to Add Users to MSSQL Using SQL Management Studio So, yesterday I was trying to resolve one issue that led to another, pretty much a daily occurrence right? This SQL issue was littering the application logs every minute with Event ID 18456, as you can see in the screenshot. Opening up the individual error showed the following (note my spray paint skills): Login failed for user . . . → Read More: SQL 2008 Hosting :: Cleaning up the Error Logs – SQL Error 18456 In this article, I am going to explain how to create a Recursive Hierarchy Group in SSRS 2008 to display hierarchical levels. This is helpful when we want to display hierarchical data in a report e.g. employees in an organizational chart as shown below: Pre-requisites for this article: SQL Server 2008 along with SSRS installed Today in this article I’m going to explain yet another new tool in Visual Studio 2010 which is nothing but the DATA COMPARISION tool. This tool is of extreme use for the developers to compare data in 2 tables in different environment (in real time say a reference table data should be compared from Development to . . . → Read More: SQL Server Hosting :: SQL Server Data Comparison Tool in Visual Studio 2010 Recently I had faced very interesting situation. Due to some reason we were not able to login into the production server for one of client. The reason for the same was that server was very busy, we had to login into the system and bring server to normal situation. When all the attempts failed, I decided . . . → Read More: SQL 2008 Hosting :: How to Fix – An error occurred while obtaining the dedicated administrator connection (DAC) port. Starting from 7th Nov 2011, ASPHostCentral.com starts to offer a hosting service located in our prestigious Amsterdam (Netherland) Data Center. For further information, please click here. For all our new customers who wish to have their sites activated on our Amsterdam (Netherland) data center, you must indicate your request on our order form at https://secure.asphostcentral.com. For our . . . → Read More: MSSQL 2008 R2 Hosting on our European Data Center Physical Address Extension (PAE) allows you to use up to 64 GB of physical memory depending on operating system you use. All existing 32 bit processors supports this extension of memory. PAE mode requires an Intel Architecture processor and more than 4GB . . . → Read More: SQL 2008 Hosting :: Using Memory Beyond 4GB in SQL Server When a domain expires, domain owners are given 40-day grace period to renew their domains. However, if the domain is not renewed, it will then enter the Redemption Period. This period will last for 30 days. During the Redemption Period, the domain owners can still renew the domain, but they are required to pay the $100 . . . → Read More: ASPHostCentral.com :: Understanding “Domain Name in Redemption Period” and all its related RISKS! If you have been using the SQL Azure Portal for creating SQL Databases and connecting to them from your SQL Server Management Studio, you would have realized the ability to query the Azure Cloud Databases from within the management studio. While this provides great opportunities in terms of relation capabilities and accessibility over the Cloud, there . . . → Read More: SQL Hosting :: How to Fix “Cannot connect to |
|
|
|||
|
Copyright © 2012 SQL 2008 Hosting News (SuperBlogAds Network) - All Rights Reserved |
|||||
