>>>This would require that the database in question be added to SSMS. Note my earlier comment that when I did this I could no longer access it from the designer. Um. . . maybe the connection string then needs to be modified to include the user and password?
>>
>>Yep. ;->
>>
>>Is there an instance for the server as well?
>>
>>\\MyServer\Prod
>>\\Myserver\QA
>>\\Myserver\devHell
>>
>>if so you will need to include that in your connection string.
>>
>>HTH
>
>There are 2 that look like this:
>TPD284\SQLServer2005MSSQLUser$TPD284$SQLEXPRESS
>They appear to be identical.

\\TPD284\SQLServer2005MSSQL // Server and instance?

User $TPD284$SQLEXPRESS // User?

If you log into the server with AD creds instead of userid/pw you should see users on the server. This is in SSMS and not from your app for now.

If you go to the properties of that SERVER that top line is the server\instance.

so for one of my connection strings:

Data Source=FTSQLDEV22\SQLDEV22; Initial Catalog=FHN_CMDB_DEV; User ID=CMDBA9876; Password=@rocketscience1!