[sims] Configure SIMS.net system

[sammcleod99]

Hi

 

We are setting up our SIMS SQL Server, and have reached the stage of the SQL server login to the SIMS database. Just wondering what the 'You will need to have been given the permission to 'Configure database' part means - do we need to change permissions in order for login? Can supply pictures if needed. Please shed some light on this..!

 

Sam

[Edu-IT]

I believe it basically means that the SQL user you are using needs to have sufficient permissions on the SQL server to be able to setup the database.

 

https://msdn.microsoft.com/en-us/library/ms188659.aspx

Edited August 4, 2015 by Edu-IT

[sammcleod99]

I believe it basically means that the SQL user you are using needs to have sufficient permissions on the SQL server to be able to setup the database.

 

Thanks for the reply,

 

Using 'sa' account and still no use...

[Edu-IT]

You should be fine with the sa account. What's the error you're getting, screenshots perhaps?

[sammcleod99]

You should be fine with the sa account. What's the error you're getting, screenshots perhaps?

 

When I put details into the Login screen, it just says 'Invalid Login details' even though I know they are valid...

[Edu-IT]

Correct server name / instance you're trying to login to? The same details work for logging in to the SQL Management Studio?

[sammcleod99]

Logs into SQL Management Studio fine... definitely has correct permissions. I'll attach screenshots if they will help...

 

 

[matt40k]

Why are you configuring a new database? If you already have SIMS you'll want to restore\attach your existing database, not create a new one. If you are a new school needing a new database it'll be worth getting some consultancy to help set it up - a mistake early on can cause you problems down the line. Some things you can't change mid way through the year, so you really do commit yourself.

 

And you need the sysman password

[Edu-IT]

And you need the sysman password

Oh. My mistake. I thought Sysman was a SIMS account and it came across as though these were creating a new DB from scratch so the account wouldn't exist.

[sammcleod99]

We are creating a db from scratch and pretty sure sysman account doesn't exist..

[Edu-IT]

So just to be clear. Is this a new school that doesn't have a current SIMS DB?

[sammcleod99]

So just to be clear. Is this a new school that doesn't have a current SIMS DB?

 

Yeah, setting up full SIMS SQL database.

 

[matt40k]

@sammcleod99 - contact your support provider (LA\Capita\whoever you pay the money to for support\license etc). Very few people on here have ever or will ever setup a new SIMS database from scratch and it really is a blank, blank.

 

Oh. My mistake. I thought Sysman was a SIMS account and it came across as though these were creating a new DB from scratch so the account wouldn't exist.

 

You mean SA

 

SA is a SQL login, SYSMAN is a SIMS SQL Login, it's basically a SQL login but they've salted the password and a few other bits that makes it a bit special.

[ITGURU]

Whenever I've had to re-install SIMS onto a new server, I have ALWAYS installed a BLANK new SIMS database to ensure it was successful.

 

Only then, I re-attach the current working database to restore the data access.

[matt40k]

??? All that would test is that you've installed SQL correctly. You'll be better restoring a backup, then you could test EVERYTHING before you switch over. Just seems like a pointless step IMHO.

[Edu-IT]

@sammcleod99 - contact your support provider (LA\Capita\whoever you pay the money to for support\license etc). Very few people on here have ever or will ever setup a new SIMS database from scratch and it really is a blank, blank.

 

 

 

You mean SA

 

SA is a SQL login, SYSMAN is a SIMS SQL Login, it's basically a SQL login but they've salted the password and a few other bits that makes it a bit special.

No I mean Sysman. Sysman won't exist on an SQL install? Which is all they have?