tag:blogger.com,1999:blog-7089758558438671730.post5044055555778568678..comments2024-03-19T23:45:16.375+11:00Comments on The Baretta: Push & Pull data to SQL via SharePoint Online and BCSThe Barettahttp://www.blogger.com/profile/07061523688390358464noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7089758558438671730.post-9277785114278549082018-05-26T14:59:43.045+10:002018-05-26T14:59:43.045+10:00Can you help me out. I was in step 4, I already fi...Can you help me out. I was in step 4, I already filled out servername,database name and the Application ID in SPD but when I press ok I was ask for a username password so I entered my O365 credentials but I got an error<br />"Cannot connect to the LOBSystem (External System) Reason: 'Cannot open server "server.com" requested by the login. The login failed"<br /><br />Note I am using SharePoint online and connecting to Azure SQL Paas<br />TechMagichttps://www.blogger.com/profile/17955595441980740014noreply@blogger.comtag:blogger.com,1999:blog-7089758558438671730.post-79848826167737339412016-10-11T09:06:17.277+11:002016-10-11T09:06:17.277+11:00Hi Alex,
from memory if you are connecting to an...Hi Alex, <br /><br />from memory if you are connecting to an Azure SQL Database, then you won't need to enter a port number. If you are connecting to a SQL Server VM it might be a different story.<br /><br />When creating the Secure Store, just enter the Login Name & Password you created when you first built the Azure SQL Database. No need to add the @server. <br /><br />In step 4 after you've added the secure store app id, I believe when you click OK you'll need to input your Office 365 username and password.<br /><br />Is there a specific error message? Could attempt to log into the Azure SQL DB via SQL Management Studio on your PC with the same login details to see if you can connect directly first?The Barettahttps://www.blogger.com/profile/07061523688390358464noreply@blogger.comtag:blogger.com,1999:blog-7089758558438671730.post-19670329797113328352016-10-11T08:43:57.870+11:002016-10-11T08:43:57.870+11:00I am trying this with Office 365 sharepoint with a...I am trying this with Office 365 sharepoint with an Enterprise e3 account. It has all the components that you listed but I still get a BCS connection error. I am not quite sure if the SQL server address should end ,1433 or not. Does the port matter? And the username for Azure. Should it end @{theserver} or not?<br />Thanks in advance<br />Alex@stanier.co.ukAlex Stanierhttps://www.blogger.com/profile/04593646718751904440noreply@blogger.comtag:blogger.com,1999:blog-7089758558438671730.post-8898061055385514382015-08-26T06:17:47.264+10:002015-08-26T06:17:47.264+10:00Cheers Christine, great to get some positive feedb...Cheers Christine, great to get some positive feedback!The Barettahttps://www.blogger.com/profile/07061523688390358464noreply@blogger.comtag:blogger.com,1999:blog-7089758558438671730.post-73285547183164662262015-08-26T06:08:06.579+10:002015-08-26T06:08:06.579+10:00Super helpful post, thanks!Super helpful post, thanks!Christinehttps://www.blogger.com/profile/01268074854104995377noreply@blogger.com