Connecting 3rd party program to SQL Server Express 2008

I have MS SQL Server Management Studio 2008 Express installed on my desktop. It works fine.
MS SQL 2008 Express on my desktopI want to test this DbSchema program which I also installed a couple days ago.
DbSchema (14-day Evaluation)I'm trying to get DbSchema to connect to my MS SQL database. That's what I need help with.

Following their instructions I went into SQL Server Configuration Manager enabled TCP/IP:
Enabled TCP/IPand set the port to 1433
TCP-port-1433.giftcpip-properties.gifI restarted the service (I did both since I'm not sure which one to restart):
restart.gifI went into my MS SQL Server Management Studio Express and set Authentication to mixed mode:
server-properties.gifConnection PropertiesI go into DbSchema and open the Connection Dialog:
DbSchema programI can ping OK with "Server Location" set either to "This computer" or "Remote computer or custom port"
ping.gifHere the DbSchema help now says I should use "Standard user sa." I've never heard of such a username and have no idea what the password is. Am I supposed to create a user "sa"?

That's all the DbSchema help says. At home and at Work I use "Windows Authentication" in MS SQL and it just works.

What do I do from here to get this to connect?
deleydAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
Under database server seurity, there is an as user, you need to set its password. Or you can create another SQL user sa (system admin)
0
Deepak ChauhanSQL Server DBACommented:
Two instance installed on this server. Which one you want to connect with. SA is the sysadmin login created by default at the time of installation.

In above database connection image you have select local host it mens default instance and default instance seems MSSQLSERVER not SQLEXPRESS. Select remote computer or custom port and write the instance name in 'HostName or IP" >> SUE\SQLEXPRESS if you want to use this.

You have configured SQLEXPRESS instance, so you SQLEXPRESS services needs to be restarted.
0
Deepak ChauhanSQL Server DBACommented:
You can see SA login in SQL server security folder.
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

arnoldCommented:
Note, your TCP/ip, none of the IPs are actually enabled.
Or is this picture was taken before you enabled TCP/ip in the SQL server configuration?
0
deleydAuthor Commented:
Where do I find "database server security"?
0
arnoldCommented:
Using SSMS, listing the contents, you have databases, there is security where the logins are defined.

Sa is one of those.
Since you did not during install select the mixed mode, when enabled, it might be with empty password.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
deleydAuthor Commented:
Oh my gosh it worked!

Thank you for explaining that.

sql-login-sa.gif
sql-login-2.gif
sql-login-3.gif
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.