microsoft sql server

~kev~ · 08-06-2009, 02:08 PM

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.

SomeOldGuy · 08-06-2009, 02:58 PM

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.

~kev~ · 08-06-2009, 05:13 PM

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.

SomeOldGuy · 08-06-2009, 05:59 PM

Just for curiosity... what was the error?

~kev~ · 08-06-2009, 06:10 PM

Quote:

Originally Posted by SomeOldGuy

Just for curiosity... what was the error?

From the command prompt, I'm testing the account log in with path>osql -Uusername -Ppassword

Quote:

Login failed for user 'username'. Reason: Not associated with a trusted SQL Server connection.

I installed Microsoft SQL Server Management Studio Express, and was able to gain access to the databases and user accounts through there.

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.

~kev~ · 08-06-2009, 10:23 PM

Thank you for the help SomeOldGuy. Everything is working and the accounting software is installing.

08-06-2009, 02:08 PM	#1
~kev~ 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
SomeOldGuy 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
~kev~ 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
SomeOldGuy 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, 10:23 PM	#6
~kev~ 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)