Forgive me as I am new to SP Dev.
I have a DB server that I use RDP to connect to via VPN from a local laptop.
I know the name of the DB server. The DB (SQL Server 2008) is set up to use Windows Authentication. Yet, when I try to connect via SharePoint Designer, I get an error stating that my credentials are incorrect. I have admin permissions to both servers.
- Domain\Servername + WindowsAdminPasswordForComputer doesn't work
- IP + Uname and Pass doesn't work
Am I missing something here? I also get the same kinds of issues trying to use Visual Studio to connect to the SharePoint Server.
I have read lots of articles on how to do this.
Add a database as a data source:
SharePoint 2010: Connecting to SQL Server Using the External Content Type Feature:
Sql Server 2008 Connection String:
Any help is appreciated. Thank You!