olivest
asked on
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?
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.
I hope that this help you.
ASKER
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?
If you try to logon with the sql authentication instead of windows authentication, don´t work?
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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