CRM Installation Error : Sql instance name must be the same as computer name

When the Sql server instance is differ from the machine name, this error will be given as a result of verification tasks under the system check of CRM installation. Most of the time this happens if the Sql server instance changes after the first installation and reinstallations. Anyhow this can be fixed easily as we …

Create a Proxy in SQL Server Management Studio

Microsoft SQL Server Agent proxy accounts define a security context in which a job step can run. To create a proxy account1.In Object Explorer, expand a server.2.Expand SQL Server Agent.3.Right-click Proxies and select New Proxy.4.On the General page of the New Proxy Account dialog, specify the proxy name, credential name, and description for the new …

Create Log file and attach Data file in SQL Server

You can attach a SQL Server data file(.mdf) which has no log file(.ldf) associate with the data file. Use the following SQL Query with the correct path of the data file.  CREATE DATABASE MyDB ON (FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\MyDB_Data.mdf')  -- change the drive and file path FOR ATTACH_REBUILD_LOG ;

Access to a SQL Server in some other Domain from SQL Server Management Studio

Senario in brief: My normal working domain is DomainA. But i have to connect to a sql server in DomainB. Administrators have given me remote desktop connection to the server which has sql server in DomainB but not to direct access from my SQL Server management studio.Following is the solution. runas /netonly /user:DomainB\sqladmin "C:\Program Files (x86)\Microsoft …