sa account - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

sa account

Author

Topic

nagikozman
Starting Member

6 Posts

Posted - 2007-11-05 : 14:43:38

This is my first time to install the SQL 2005 on my VPC for testing purpose, I don't recall that I did configure the sa account during the instalation.
Is their is any way after the installation to configure the sa account with a password? Please advice

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-05 : 14:49:01

Just double click on it in Security..Logins and change the password.

If you want to use SQL authentication (not recommended) now, then you'll need to switch to mixed mode authentication (right click on server in SSMS, go to properties).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

nagikozman
Starting Member

6 Posts

Posted - 2007-11-05 : 15:20:45

Thank you so much for your reply, i did find the sa and I did change the password when I try to establish connection with the sql server from a different machine using the sa account user name I get the following error " Connection failed for user sa account , the user is not assosiate with a trusted SQL server connection " how do I estable this connection ? By the way I can ping the sql server from the other server so the network connection is their

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-05 : 15:25:54

Please see my last post.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

nagikozman
Starting Member

6 Posts

Posted - 2007-11-05 : 15:42:41

Sorry for my question , witch last post you do you mean ? in this topic or some where else ? could you guide me please

I did change the access to mix mode and still same problem when I am trying to access the sql remote using the sa account

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-05 : 15:46:21

In the same topic, my first post.

If you switched to mixed mode authentication already, then what parameters are you using when you get the error?

Does the sa account work locally on the database server?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

nagikozman
Starting Member

6 Posts

Posted - 2007-11-05 : 16:15:48

I think I am doing something wrong , when I right click on the server name and change the from windows authentication to SQL server authetication , it accept the change, but when I go to security login tab and double click on sa account and click to view connection I still see it that it is using the windows authentication so what i am doing wrong?
When I try to log on local on the sql server itself using the sql authetication using sa account I get the same error

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-05 : 16:36:30

I don't understand what you are doing. When SSMS prompts you for credentials, specify SQL authentication, then userid and password. There is no right clicking involved.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-05 : 21:47:49

Logon as local admin and connect to sql server in ssms with windows authentication, right click the server then open properties. Go to security page, click on mixed authentication. Then try connect to sql with sa again.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-06 : 00:00:06

He already did that.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

nagikozman
Starting Member

6 Posts

Posted - 2007-11-06 : 00:54:16

ok let me try to explain what I am doing in few steps:
1- I log on to my SQL 2005 using windows authentication
2- RightClick the server name and open properties and go to security tab , change the setting to Mix mode " SQL server & Windows Authentication mode"
3- I reset the password for sa , and creat a new Admin account
4- Log off and try to log on again local to the server using the SQL server & Windows authetication mode using the sa or eithr the admin user account I get the following error :

TITLE: Connect to Server
------------------------------

Cannot connect to DC.

------------------------------
ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

As per Microsoft web site for thei error I have to use the SQl surface connection to configure the connection type to use local and remotly and i did do that and still the same problem any help please

Thank you so much

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-06 : 01:00:07

That is a network/config issue and not an account/access issue.

Try connecting via IP address or IP address,Port Number.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

nagikozman
Starting Member

6 Posts

Posted - 2007-11-06 : 01:50:17

Ok I got it to work, when I search on Microsoft web site, it recomend to restart the server after configure the SQL surface connection and it work fine after reboot - thank you all for your help

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources