• You can create it remotely, but you can't test it unless you are local on the server. If using the GUI, just ignore the errors and tell it to create it or just use T-SQL to create it.

    If you want to be able to use it remotely, you either need to configure kerberos and constrained delegation (preferred) or use SQL authenticated logins (not preferred).


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]