• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6111
  • Last Modified:

How to create "sa" user and solve connection problem to SQL server

I have installed MS SQL 2005 Express edition also downloaded SQL express manager but when i try to connect to SQL server on port 1433 it doesn't connect.Also i need to create "sa" account i've done that through computer management added user and assigned to SQLExpressusers group.But doesn't seam to work either.Can some one guide me here with some links or wirte what exectly what i need to do?
0
olivest
Asked:
olivest
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>Also i need to create "sa" account
no. sa login is ALWAYS present.

I guess your express edition got installed with "windows authentication" only, so you can, by default, only connect with windows security.
http://msdn.microsoft.com/en-us/library/ms143705(SQL.90).aspx

or maybe your sa account is not enabled?
http://msdn.microsoft.com/en-us/library/ms188670(SQL.90).aspx
0
 
ppauloCommented:
The sa user is a part of sqlexpress, so when you install sql, the sa is created automatically. You login with sql management, choose windows authentication and connect. Then go to security\logins, go to properties of sa user and change the password, or create a new user.

I hope that this help you.
0
 
olivestAuthor Commented:
Apparently i'm using SQL Server and Windows Authentication Mode.I've found sa user and changed password.But still can't get connection through to SQL server.Is on port 1433?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
ppauloCommented:
If you try to logon with the sql authentication instead of windows authentication, donĀ“t work?
0
 
olivestAuthor Commented:
Have figure it out my self.Actually TCP/IP connection was not enabled thats why couldn't connect to SQL server using asp script or any other application.
0
 
Computer101Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now