RE: List of SQL Server Express gotchas?

Lowell

SSC Guru

Points: 323504

November 11, 2013 at 6:19 am

#1665457

i can think of only a couple offthe top of my head:

TCP/IP / remote connections are not enabled by default.

no Dedicated Admin Connection is available by default.

depending on the version of installed, you might not have SSMS.

it's really easy to not add yourself as an administrator during instalation + leave sa account disabled, so you don't have access after installation.

hopefully others will chime in as well.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!