MSDE Sysadmin account

[bmcgrathPIX]

I know nothing about SQL, and we have a program that requires MSDE. We had a problem with th esoftware, so we reinstalled, but uninstalled MSDE and the software first. We are now trying to create a new database, but it is asking for our sysadmin username/password. We have no clue if we ever had a sysadmin password, but i know it wont take null for a password, and i have tried every username on the system. any ideas?

 

[mrdenny]

the sa account will be set to what ever the software company set the password to. Any account in the Administrators group will also have sysadmin rights on the SQL Server.

If you reinstalled the MSDE database, and didn't give it a password when you installed it's probally still blank.

If it is open a command prompt and run osql -S ServerName -U sa -P -Q "sp_password @new='new_password'" that should change the password to what ever you put for new_password. Then you can use the sa account to login.

If the password is set and you don't know it then log into the server as a member of the Administrators Group, open a command prompt and run osql -S ServerName -E -Q "sp_password @new='new_password'". That will reset the sa password.

Denny

 

[bmcgrathPIX]

I have now reformatted at reinstalled everything, but it wants a user name as still. It will not let me hit ok without a username and password. the specific message box is "please enter a username and password with sysadmin rights on [sqlserver]" I addeded this server to the domain before i installed SQL (now trying the actual SQL server 2000 SP3a), set up the domain admin account as the windows auth only account, and also set up a password for the sysadmin (it reccomended changing from blank, and only asked for a password, no username, and i used the same password as the domain accounts).

ahhhh!!!!

help please!

 

[SQLBill]

It's looking for the username and password for someone who has System Admin privilege on the server you are installing this on. NOT SQL Server SYSADMIN.

Let's say I'm the only system admin for all your computers. You want to install SQL Server on a server. At one point during the install it's going to need me to enter my username and password.

Do you have sysadmin privileges? If so, just use your login and password. If not, you need to get the sysadmin involved.

-SQLBill