MsSQL Server

Sharky Forums


Results 1 to 4 of 4

Thread: MsSQL Server

  1. 06-09-2005, 12:31 AM #1
    UmneyDurak
    UmneyDurak is offline
    Tiger Shark UmneyDurak's Avatar
    Join Date
    Apr 2004
    Location
    Escaped from 2nd floor of Soda Hall.
    Posts
    671

    MsSQL Server

    Hi.
    Maybe someone here can help me. I'm running a MsSQL server on my computer. Everytime I restart the computer the tables I create and users I add disapear, but the database I create remains. I'm creating tables with Enterpise Manager. After I add columns I click on save specify the name and click ok.
    Any idea what's going on?

    Thx.
    Last edited by UmneyDurak; 06-09-2005 at 12:55 AM.
    01+01=10
    Reply With Quote Reply With Quote
  2. 06-09-2005, 11:02 AM #2
    Gary K
    Gary K is offline
    Catfish
    Join Date
    Jan 2004
    Posts
    174
    What OS are you using this on? What type of authentication are you using to log into Sql Server? What account are you using to create tables? Same account you used to create the database?

    I have never run across this problem but it sounds like a permissions problem of some type.
    Reply With Quote Reply With Quote
  3. 06-09-2005, 08:44 PM #3
    UmneyDurak
    UmneyDurak is offline
    Tiger Shark UmneyDurak's Avatar
    Join Date
    Apr 2004
    Location
    Escaped from 2nd floor of Soda Hall.
    Posts
    671
    Lets see I tried on XP Pro, 2000 Pro. When Creating tables with Enterprise manager it doesn't ask for the password.
    Ok. Just for the heck of it yesterday I ran the database creation wizard and for that DB it did save the tables. Will try the same thing on my laptop see what will happen.
    Before I just right clicked on the instance of a server and selected New database.
    Last edited by UmneyDurak; 06-09-2005 at 08:48 PM.
    01+01=10
    Reply With Quote Reply With Quote
  4. 06-13-2005, 06:47 PM #4
    Gary K
    Gary K is offline
    Catfish
    Join Date
    Jan 2004
    Posts
    174
    Well, that would explain quite a bit. Tables can only be created inside existing databases. And, depending on the version of Sql Server you are using, it may not be possible to install it correctly on a non-server OS. SQL Server 2000 Enterprise Edition and Standard Edition will only install on server OS's.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules