08-06-2009, 02:08 PM | #1 |
pmagnvs
Join Date: Mar 2007
Location: East Texas
Class/Position: Engineer - D Gametype: Free for all CTF - no stupid clan rules Posts Rated Helpful 0 Times
|
microsoft sql server
Does anyone here know anything about microsoft sql server? I need some help on a project.
The company I work for, we are migrating over to some new accounting software that uses sql server. We have a windows 2000 active directory server that has sql on it. But I can not find the management console to add users to the sql server. We have a windows xp pro computer that is being used as a fax application server. It has a version of sql server on it. But the person who set it up, their no longer here and nobody knows what the SA password is. I'am a domain admin, but sql server on the xp pro machine is not accepting my log in information. |
|
08-06-2009, 02:58 PM | #2 |
older than dirt
Join Date: Mar 2007
Location: just east of the jug handle
Posts Rated Helpful 9 Times
|
Login to the SQL Server computer as the Administrator of that computer. Open Query Analyzer and connect to SQL Server using Windows NT authentication. Run sp_password as show below to reset the sa password:
sp_password @new = 'will_never_forget_again', @loginame = 'sa' After that go to section Security –> Logins –> double click “sa” or choose properties. Go to “Status” and check to see if “Login:” is enabled. If not, enable it. Last edited by SomeOldGuy; 08-06-2009 at 03:01 PM. |
|
08-06-2009, 05:13 PM | #3 |
pmagnvs
Join Date: Mar 2007
Location: East Texas
Class/Position: Engineer - D Gametype: Free for all CTF - no stupid clan rules Posts Rated Helpful 0 Times
|
Thank you, but for some reason the command to open the Query Analyzer just returns an error.
So I'am downloading a management console from microsoft. I keep reading about a SQL Server Enterprise Manager, but I can not find it in the add/remove snapins in the MMC. ---- EDIT ---- We bought this application server from a company to do a very specific job. Its got windows XP pro and ms sql server installed on it. Well, its over powered for what its doing and we are migrating to some new accounting software. The plans are by the end of the month the accounting department is going to be fully migrated to the new software. But first I have to get it installed. The person that set the new server up was a contractor we bought the system from. And that was 2 years ago. Last edited by ~kev~; 08-06-2009 at 05:17 PM. |
|
08-06-2009, 05:59 PM | #4 |
older than dirt
Join Date: Mar 2007
Location: just east of the jug handle
Posts Rated Helpful 9 Times
|
Just for curiosity... what was the error?
|
|
08-06-2009, 06:10 PM | #5 | |
pmagnvs
Join Date: Mar 2007
Location: East Texas
Class/Position: Engineer - D Gametype: Free for all CTF - no stupid clan rules Posts Rated Helpful 0 Times
|
From the command prompt, I'm testing the account log in with path>osql -Uusername -Ppassword
Quote:
A new database was created, a local user that is part of the administrators group was assigned to the database and set as owner. ------- I have never messed with ms sql server, so all of this is new to me. Last edited by ~kev~; 08-06-2009 at 06:10 PM. |
|
|
08-06-2009, 10:23 PM | #6 |
pmagnvs
Join Date: Mar 2007
Location: East Texas
Class/Position: Engineer - D Gametype: Free for all CTF - no stupid clan rules Posts Rated Helpful 0 Times
|
Thank you for the help SomeOldGuy. Everything is working and the accounting software is installing.
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
Display Modes | |
|
|