i believe you will need to specify both ports

MSSQLSvc/ServerName.domain.com:1433 domain\account
MSSQLSvc/ServerName.domain.com:48000 domain\account

talk to your arch. use reverse proxy

make sure port 25 is open between smtp server and sql server. , you may use following script to setup mail (change values as required)

try this

begin
DECLARE @Domain NVARCHAR(100)
EXEC master.dbo.xp_regread 'HKEY_LOCAL_MACHINE', 'SYSTEM\CurrentControlSet\services\Tcpip\Parameters', N'Domain',@Domain OUTPUT
--SELECT Cast(SERVERPROPERTY('MachineName') as nvarchar) + '.' + @Domain AS FQDN
declare @port nvarchar(100)
declare...

yes, by adjusting HostRecordTTL and RegisterAllProvidersIP values, as I said if you are having issues with linked server I fail to understand why you are not having connectivity issues...

I have implemented Microsoft recommendation in my environment, and that has resolved my timeout problems, I am however not using linked servers, but if you create a linked server using...

disk Que length should not be more than 2 per spindle..  may be its time to add disk to SAN aggregate(s)

Current Disk Queue Length
This counter will...

thanks for the explanation, now i understand the cause

omg, it worked

yes, pointing to the correct database

result of grant is 'command completed successfully'

I can select from table as testuser

Thanks Jones

not really, let me rephrase my question, is there a way to find suggested indexes using extended events?

The below query says so, I don't need lecture on indexes/plan cache, what I need to know is if ' is there a way to identify missing indexes via extended...

did you configure max memory for sql server.. ?