I figured it out. Apparently I can order sub-queries as long as I provide a alias.

Well this works:

SELECT *

FROM

(

SELECT TOP 100 *

...

See post by AlexS. I'm trying to get LAST rows while preserving order.

https://ask.sqlservercentral.com/questions/2013/how-to-select-bottom-n-rows-in-a-table-through-sin.html

Thanks Jeff. I went a little single quote happy.

I created 2 other dollar sign ($) logins with no problems. Any other ways of adding login without doing a Active Directory check?

Jack:

What would be the correct syntax using 'localhost'?

I've tried the following connection strings:

Application("dbdsn")="data source=localhost;integrated security=true;Database=TestDB"

Error:

Server Error in '/' Application.

Cannot open database "TestDB" requested by the login. The login failed.

Login failed...

Jack:

My connection string is already using 'localhost'

Receiving this error:

Server Error in '/' Application.

Cannot open database "TESTSERVER.TestDB" requested by the login. The login failed.

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Could there...

Jack:

In Sql Server 2005, I ran the below Query:

EXEC sp_addlinkedserver

'TESTSERVER',

N'SQL Server'

GO

Replace TESTSERVER with your server you want to link.

I've created a domain account called MYDOMAIN\SQLTEST1

(?) What areas in Sql Server 2005 do I need to grant this domain account permission to?

I am assuming permission rights must be granted...