SQL Server Express SA connection

[Closet Exchange]

Has anyone had any luck connecting their database after upgrading to SQL Server Express 2005? When we run the RWDBUtil, it tells us login failed for user SA. SA has a blank password on the SQL side of things. Suggestions?

[DXS]

I would also like to know as well before I update. Let me know if you fix the problem.

[Support Team]

Logging in via "sa" isn't actually an issue. "sa" is the default/admin login for a SQL RDBMS. All installs of MSDE (including Express) SP3a and above, require you to set the database name and login during the install. One of the benefits to Express is, you now have a GUI when installing. In MSDE 2000, you have to configure these preferences via command line or "switches" during the install.

When you are installing Express, you can set things such as the Mode, sa password, etc. When an application - any application; Liberty, Access, Crystal, etc. - attempts to connect to this RDBMS, is will ask for a username and password. Since the sa password is set via the user during the install, then that password is something that only the user installing Express would have access to.

Once Express is installed, you will need to "attach" Liberty to it via RWDBattach.exe (for L4C) or RWScript.exe (for L2K2). This will prompt for the login to the database.

I will try and put together a "white paper" on installing Express a.s.a.p. Ultimately, the same rules apply for Express as for SQL Standard - logins are configured during the installation and in order to connect a 3rd party app. to SQL, you will need to know this login info.

I'll get started on that "white paper" right away. Let us know if this helps at all or if you need anything else!

[Closet Exchange]

First, I want to personally thank Marty, Nelson, David and Dean for their assistance when our DB hit the 2 GIG ceiling. We were dead in the water, until the aforementioned crew bailed us out.

We were back online in no time and without any loss of data. One of the primary reasons we chose Resaleworld was for its support team. Their patience and professionalism with us and our IT group are further testimony to why Resaleworld and its support team are Number 1 in the industry.

Dean, I look forward to your white paper.

Again, thank you from the Closet Exchange.