Make changes to an SQL Server Table without table re-creation
26-May-1313 Leave a comment
IT and business subjects
23-May-1313 Leave a comment
We setup a VPN connection to another site, but then programs would not connect to SQL Server using Windows Authentication. We spent a fair bit of time trying to resolve this. Then found the solution, thanks to the following post:
After a lot of searching i found a good solution to the problem when using Windows login to a SQL server while on Win VPN giving the error: Cannot generate SSPI context.
Wanted to share it:
“
18-May-1313 Leave a comment
When trying to make a Lync IM
When contacting your support team, reference error ID 1002 (source ID 243). Troubleshooting information is available online, including best practices for using Lync.
In Office 365 Plan E3
The other organisation must also have this setting on:
This message wasn’t sent because <recipient>doesn’t have permissions on your organization’s network, or because the address is incorrect. Please contact your support team.
15-May-1313 Leave a comment
Copied from
http://i.ll.do/2013/01/how-to-solve-sql-server-2012-identity.htm
How to – Solve SQL Server 2012 Identity Problem. Identity increased by 1000 or 10000
Hope this helps someone.
Good luck, Serdar.
09-May-1313 Leave a comment
Code:
Imports System.Net Public Class FTP1 Private host As String Private username As String Private password As String Sub New(hostValue As String, usernameValue As String, passwordValue As String) host = hostValue username = usernameValue password = passwordValue End Sub Function GetFileList() As List(Of String) Dim ftp As System.Net.FtpWebRequest = CType(FtpWebRequest.Create(host), System.Net.FtpWebRequest) ftp.Credentials = New System.Net.NetworkCredential(username, password) ftp.KeepAlive = False ftp.UseBinary = True ftp.Method = WebRequestMethods.Ftp.ListDirectory Dim streamReader As New IO.StreamReader(ftp.GetResponse.GetResponseStream) Dim result As New List(Of String) Dim line = streamReader.ReadLine While Not String.IsNullOrEmpty(line) result.Add(line) line = streamReader.ReadLine End While Return result End Function End Class
08-May-1313 Leave a comment
SOLVED
> Start > All Programs > Reporting Services Configuration Manager
> Connect
> Execution Account
> Put in new Account + Password
08-May-1313 Leave a comment
The original page hook up can break
08-May-1313 Leave a comment
Was trying to publish to Azure Websites, but it was hanging on “Publish Started”
The Start-up project was another project, so switched it to the website and then published ok. Deliberately switched it back to see if the problem was this and the error returned.
07-May-1313 Leave a comment
SSIS is case-sensitive and will remember the old column name even if it no longer exists. So say you have a column “CHANGE” and map it through. Then next time you use “Change” then SSIS will try to map “CHANGE” and throw errors. Try changing the column name to something completely different and then map through.
02-May-1313 Leave a comment
SOLUTION from Dave Anson C comment
In the project References folder ensure there isn’t a reference to itself. (E.g. You have a project named WindowsApplication1. In the References folder you have a reference to WindowsApplication1)
This worked for me.