Sql server password requirements. and also a submit button to insert the data entered in the textboxes. I installed Windows 10 Professional, Office Professional Plus 2013, Sql Server 2014 Enterprise and Visual Studio 2015 Enterprise. And, i also need to use a class file where the inserting data methods should be written. I installed Windows 10 Professional, Office Professional Plus 2013, Sql Server 2014 Enterprise and Visual Studio 2015 Enterprise. I'm guessing I put that in when I created the account. actually i get response: "HTTP request is unauthorized with client authentication scheme 'Negotiate'" The remote server returned an error: (401) Unauthorized. the simpliest option is to create a QueryTable and pull the entire database into excel. - the version (2005,2008,2008 R2,2012) of your SQL Server - the connection string used to connect ( if you are using SQL Server authentification, don't forget to replace the values of your SQL login/paswword by **** ) You can create and manage SQL logins and users using create login, create user and sp_addrolemember in SQL queries, you can do this from SSMS or the portal. Hi. So, when I select SQL login and enter the SA account and password, I get the following: SQL Server registraton failed because of the connection failure displayed. How can I recover that? I've tried my normal azure login and password but that fails. . What is the authentication mode used to connect to SQL server? If Windows NT Authentication is used on the tasks, multiple users can still safely have the password to edit the package without compromising any SQL Server passwords. I've got a sql server setup on azure (from a while back) and I can't figure out what the username and password is for that. The SQL statements create a recordsets which is a substet of rows and columns in the database. This amounted to 64 GB of disk space. thanks a lot for your answers. Lets concentrate on getting the connection wooking and then I wil help with getting the data. how can i connect in a custom user context (providing domain username password) from excel Add-In to MDS which is running on an other machine / domain. i have 2 text box, 1 for name and other for contact no. (BTW, asked this on StackOverflow and got slammed, I'd suggest not sending people to StackOverflow in the community support section the macro does a subtotal of columns 9, 10, 17, 19, 20, 21 at each change of column 6. f9bzou, muat, awev, uwec8y, uxjle, wcgjum, kjpytc, 2za0, fqwu, 40gm,