|
Posted by Jason on September 11, 2006, 7:05 pm
Please log in for more thread options I'm an idiot. I admit it :)
For the sake of anyone else who may be somewhat challenged, I had connected
to the correct database, but had not selected said database in the
configuration in HQ Administrator. It was trying to connect to a Store Ops
database.
When you run SQL queries, it uses the connected database, but Manager uses
the database referenced in the configuration.
Sorry for the stupid question...
Jason
> Caze,
>
> To create a database, go into SO Admin
>
> File | Connect | put in your password when you installed RMS | OK |
> Database | Create | give it a name | Next | Next | click on the magnifying
> glass and point to your backup file | Next | Finish
>
> File | Connect | put you password again | change the database name to what
> you just created
>
> File | Configure | put in your password | check the database name, change
> it if necessary | Test
>
> File | Exit
>
> --
> =
>
> Get Secure! - www.microsoft.com/security
>
> You must be using Outlook Express or some other type of newsgroup reader
> to see and download the file attachment. If you are not using a reader,
> follow the link below to setup Outlook Express. Click on "Open with
> newsreader"
> under the MS Retail Management System on the right.
>
> http://tinyurl.com/75bgz
>
> ==========
>
>>I had a virus on my computer, so a tech re install window and Retail
>> Management,
>> now I cant connect to my dadabase.
>>
>> I know that you have to first create a database with SQL, but I cant find
>> the way to restore backup and even less create a new dababase from SQL.
>>
>> Please, Please HELP. Going Crazy!
>>
>>
>> "Jeff" wrote:
>>
>>> Terry,
>>>
>>> My suggestion is that you contact the SQL Server/MSDE newsgroups for a
>>> possible fix. You should be able to use SO Admin queries or TSQL
>>> statements
>>> to fix it.
>>>
>>>
>>> For starters, try;
>>>
>>> microsoft.public.sqlserver.server
>>> microsoft.public.sqlserver.msde
>>>
>>> --
>>> *
>>> Get Secure! - www.microsoft.com/security
>>>
>>> You must be using Outlook Express or some other type of newsgroup reader
>>> to
>>> see and download the file attachment. If you are not using a reader,
>>> follow
>>> the link below to setup Outlook Express. Click on "Open with
>>> newsreader"
>>> under the MS Retail Management System on the right.
>>>
>>> http://tinyurl.com/75bgz
>>>
>>> **********
>>>
>>> this is happening several month's after an upgrade from QS2000. the
>>> database
>>> was picked up by RMS and was in use until 2 -3 days ago. Yes I am sure
>>> about
>>> ht password
>>> --
>>> Terry
>>>
>>>
>>> "Jeff" wrote:
>>>
>>> > Terry,
>>> >
>>> > Are you sure you are using the correct SQL SA password?
>>> >
>>> > How did you copy/install/place the database onto the computer's hard
>>> > drive?
>>> >
>>> > --
>>> > *
>>> > Get Secure! - www.microsoft.com/security
>>> >
>>> > You must be using Outlook Express or some other type of newsgroup
>>> > reader
>>> > to
>>> > see and download the file attachment. If you are not using a reader,
>>> > follow
>>> > the link below to setup Outlook Express. Click on "Open with
>>> > newsreader"
>>> > under the MS Retail Management System on the right.
>>> >
>>> > http://tinyurl.com/75bgz
>>> >
>>> > **********
>>> >
>>> > I am a computr Tech, I installed RMS for a friend and explained that
>>> > they
>>> > need to back it up every night, which i discovered has not been done.
>>> > Now
>>> > when I try to use store Ops, I get "login failed" If I go to Ops
>>> > Admin, I
>>> > can
>>> > connect to the DB, but when I test the connection, it tells me "login
>>> > failed"
>>> > at one point i even get "the database has been marked suspect by
>>> > recovery"
>>> >
>>> > I cannot ever use Operrations manager
>>> >
>>> > Help me PLEASE
>>> > --
>>> > Terry
>>> >
>>> >
>>> >
>>>
>>>
>>>
>
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap