Chatter Of The Squirrel

Creating ODBC for MS SQL Server 2005 Express

July 22, 2008 on 3:48 pm | In Tech | No Comments

Stupid buggery that wasted a good 20min of my life. Installed SQL Server Express, but when creating the ODBC, it can’t open a connection to the local server.

Found the solution here,

“It turns out you must specify the instance after the server name, so in the server name in the dialog box for creating the ODBC Data Source, you must enter it as either: MyServer\SQLEXPRESS or .\SQLEXPRESS”

Wonderful. Why that level of un-intuitiveness ??

Also, to change sa password:

osql -U sa -S servername\instancename

sp_password @old = null, @new = ‘complexpwd’, @loginame =’sa’

go

OR

EXEC sp_password ‘old’, ‘New’, ’sa’