Make changes to an SQL Server Table without table re-creation
26-May-1313 Leave a comment
Advertisements
Cannot generate SSPI context when connecting to SQL Server when a VPN is connected
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:
- Locate the .pbk file that contains the entry that you dial. Is either: C:\Users\<USERNAME>\AppData\Roaming\Microsoft\Network\Connections\Pbk or if connection is visible to all users: C:\ProgramData\Microsoft\Network\Connections\Pbk (hidden files may need to be disabled first through Organize -> Folder and search options)
- Open the file in Notepad using Open with…
- Locate the following entry: UseRasCredentials=1 Each VPN connection you have has a section marked with [<VPN connection name>]
- Modify the entry to the following: UseRasCredentials=0 Needs to be done for each VPN section for the connections having problems.
- On the File menu, click Save, and the click Exit.
“
Add external access for Lync
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
- Lync Admin Center
- Organisation
- External communications must turn this on
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.
Restart results in reseed of identity by +1000
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
Are you experiencing an identity problem with your SQL Server 2012? Do the identity seeds of your records get increased by 1000 or 10000(in my case it was 10000)? Do you wonder why this is happening and how you can solve this? Then keep reading…
Seems like Microsoft has changed the way they deal with identity values in SQL Server 2012 and as a result of this you can see identity gaps between your records after rebooting your SQL server instance or your server machine. There might be some other reasons for this id gaps, but in my case it was an automatic server restart after installing an update.
There are several ways to overcome this issue but here I will explain how I did it, which seemed to be the best way of overcoming this problem.
Below is a quote from a Microsoft post replying to this id crisis issue on “connect”:
If you require the same identity generation semantics as previous versions of SQL Server there are two options available:
• Use trace flag 272
o This will cause a log record to be generated for each generated identity value. The performance of identity generation may be impacted by turning on this trace flag.
• Use a sequence generator with the NO CACHE setting(http://msdn.microsoft.com/en-us/library/ff878091.aspx)
o This will cause a log record to be generated for each generated sequence value. Note that the performance of sequence value generation may be impacted by using NO CACHE.
• Use trace flag 272
o This will cause a log record to be generated for each generated identity value. The performance of identity generation may be impacted by turning on this trace flag.
• Use a sequence generator with the NO CACHE setting(http://msdn.microsoft.com/en-us/library/ff878091.aspx)
o This will cause a log record to be generated for each generated sequence value. Note that the performance of sequence value generation may be impacted by using NO CACHE.
What I did: Setting Trace Flag 272 on SQL Server 2012
- Open “SQL Server Configuration Manager”
- Click “SQL Server Services” on the left pane
- Right-click on your SQL Server instance name on the right pane ->Default: SQL Server(MSSQLSERVER)
- Click “Properties”
- Click “Startup Parameters”
- On the “specify a startup parameter” textbox type “-T272”
- Click “Add”
- Confirm the changes
Now you should be free of this annoying identity gap problem.
Hope this helps someone.
Good luck, Serdar.
VB.Net Get FTP list of files
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
SSRS Login failed for unattended execution account
08-May-1313 Leave a comment
SOLVED
> Start > All Programs > Reporting Services Configuration Manager
> Connect
> Execution Account
> Put in new Account + Password
How to copy an ASP.Net web form .aspx
08-May-1313 Leave a comment
The original page hook up can break
- Copy main file
- Rename file to remove “Copy of “
- View code
- Change Public Class name to the new name
- Show All Files
- Open the <file>.aspx.designer.vb
- Rename the class to the new name
This may clear all errors. If not then continue - If there is code behind then the controls will say “is already declared as..” or “Handle clause requires a WithEvents
- View Markup
- Change AutoEventWireup=”false” to “true”
ASP.Net publish troubleshooting
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.
SSIS Troubleshooting
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.
WinForms Designer fails – warning …My.Resources.Resources has no property named … image
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.
