Tag: sql

Microsoft Sql Server Administration…

Useful commands I’ve found from various sources for Microsoft Sql Server 2005/2008 include: EXEC sp_configure GO –Instance level principals. SELECT * FROM sys.asymmetric_keys SELECT * FROM sys.certificates SELECT * FROM sys.credentials SELECT * FROM sys.linked_logins SELECT * FROM sys.remote_logins SELECT * FROM sys.server_principals SELECT * FROM sys.server_role_members SELECT * FROM sys.sql_logins SELECT * FROM sys.endpoints …

Start reading Microsoft Sql Server Administration…

Unable to connect to remote server – error

If you get this message say from Visual Studio when trying to deploy SSRS reports to a SQL Server 2008 database instance, heres how this can be resolved. This is usually caused by kerberos security authentication. Navigate to: C:Program FilesMicrosoft SQL ServerMSRS10.MSSQLSERVERReporting ServicesReportServer Edit the file rsreportserver.config Make the change below: <!–<Add Key=”SecureConnectionLevel” Value=”2″/>–> <Add …

Start reading Unable to connect to remote server – error